Exporting Time Entries in T3's Time Cards Web App

T3's Time Cards can compile your employee's time entries and export them to a file that is compatible with your HR's payroll system.

  • The AccountLinx, Spectrum, Kronos, and Paycor files can be used for HR purposes like auditing regular, personal, and overtime hours for paying their employees. These files can be directly uploaded to their payroll system name (i.e., the AccountLinx file can upload to an AccountLinx system).

  • The EquipmentShare file and Entry Summary files provide data for analytics purposes, like understanding how employees use their time for specific jobs or work orders.

Note: Some fields in the file will display without data due to the system not capturing specific information.

Exporting a File

  • Open the app drawer from the top navigation bar in T3 and select Time Cards.

  • Select the dropdown arrow underneath Export data to locate the file you'd like to export.

  • Select the file and then click the Send icon.

  • Enter the recipient’s email address and click Send.

  • A Success Confirmation message will display. Check your inbox for the export file. It must be downloaded within 24 hours before the link expires.

Paycor File Overview

The Paycor file will include a single file with each row indicating an employee for the pay period.

Example file

File Attributes

Field Name

Description

Origination

Employee Number

The ID for the employee

The employee number is within the User Profile by selecting Company > Users > Edit.

Social Security Number

Not provided

Not provided

Regular Hours

The regular, non-overtime hours for an employee

The regular hours are from the employee’s time card in Track as logged from the Link app or manual entries.

Overtime Hours

The overtime hours accrued for an employee.

The overtime hours are from the employee’s time card in Track as logged from the Link app or manual entries.

Hours Code

Not provided

Not provided

Coded Hours

Not provided

Not provided

Amount Code

Not provided

Not provided

Coded Amount

Not provided

Not provided

Deduction Code

Not provided

Not provided

Deduction Amount

Not provided

Not provided

Deduction Exception Rule

Not provided

Not provided

Branch Abbreviation

The branch abbreviation for the assigned employee branch.

The branch abbreviation is created in Company > Branches.

Exception Rate

Not provided

Not provided

Rate Sequence

Not provided

Not provided

Shift Premium

Not provided

Not provided

Pay Number

Not provided

Not provided

Pay Week

Not provided

Not provided

Tax Frequency

Not provided

Not provided

Gross Receipts

Not provided

Not provided

Labor Codes Category1

Not provided

Not provided

Labor Codes Code1

Not provided

Not provided

AccountLinx File Overview

The AccountLinx file will provide a single file with each row indicating a time entry (for example, Work Orders, Unassigned hours, or Job).

Example file

File Attributes

Field Name

Description

Origination

Batch Code

Not provided

Not provided

Employee Code

The ID of the employee

The employee code can be found in User Profile by selecting Company > Users > Edit > Employee ID.

Branch Abbreviation

The branch abbreviation for the assigned employee branch.

The branch abbreviation is created in Company > Branches.

Pay Type

The pay type for the employee, either regular, OT, sick, or PTO.

The pay type is from the employee’s time card in Track as logged from the Link app or manual entries.

Hours Employee

The total number of hours logged for an employee for the pay period

The total number of hours is from the employee’s time card in Track as logged from the Link app or manual entries.

Job Number

The ID for the job

The job number is created Company > Work tab > Jobs table.

Branch Abbreviation

The branch abbreviation for the assigned employee branch.

The branch abbreviation is created in Company > Branches.

Cost Type

Not provided

Not provided

Work Date

The work date of the entry line

The work date is found in Time Cards > Employee’s Time Card.

Message

Any notes entered for the time entry.

The message can be found on the employee’s time card in the Notes field.

Spectrum File Overview

The Spectrum file will provide a single file with each row indicating a time entry (for example, Work Orders, Unassigned entry, or Job).

Example file

File Attributes

Field Name

Description

Origination

Company Code

Not provided

Not provided

Batch Code

The date and time of file generation.

It is generated on the backend.

Branch Abbreviation

The branch abbreviation for the assigned employee branch.

The branch abbreviation is created in Company > Branches.

Pay Type

The pay type for the employee, either regular or OT.

The pay type reflected on the employee’s time card (only regular or OT for now).

Hours Employee

The total number of hours logged for an employee for the pay period

The total number of hours is from the employee’s time card as logged from the Link app or manual entries.

Job Number

The job or phase ID associated with the time entry.

The job number is created Company > Work tab > Jobs table.

Joined Code

The branch abbreviation and cost code combined to create a joined code.

The branch abbreviation is created in Company > Branches and Cost Code created in Company > Work. Select the Joined Codes flag in Time Cards.

Cost Type

Not provided

Not provided

Work Date

The calendar work date of the entry line.

The work date is found in Time Cards > Employee’s Time Card.

Message

Any notes entered for the time entry.

The message can be found on the employee’s time card in the Notes field.

Pay Rate Code

Not provided

Not provided

Wage Code

Not provided

Not provided

Union Code

Not provided

Not provided

Worker Comp Code

Not provided

Not provided

State

Not provided

Not provided

Work County

Not provided

Not provided

Work Locality

Not provided

Not provided

Equipment Code

The asset ID is associated with a Work Order time entry.

The asset ID assigned to a Work Order is located in Track under the Service dashboard in the Work Orders table.

Equipment Hours

Not provided

Not provided

Additional JTD Quarterly

Not provided

Not provided

International Company Code

Not provided

Not provided

Pay Rate

Not provided

Not provided

Joined Code

The branch abbreviation and cost code combined to create a joined code.

The branch abbreviation is created in Company > Branches and Cost Code created in Company > Work. Select the Joined Codes flag in Time Cards.

Crew Number

Not provided

Not provided

Work Order Number

The Work Order ID is associated with the time entry.

The Work Order ID is located in Track under the Service dashboard in the Work Orders table.

Work Order Equipment

Not provided

Not provided

Work Order Component

Not provided

Not provided

SC Contract

Not provided

Not provided

PM Work Order

Not provided

Not provided

Cost Center

Not provided

Not provided

Kronos File Overview

The Kronos file will provide a single file with each row indicating a time entry (for example, Work Orders, Unassigned entry, or Job).

Example file

File Attributes

Field Name

Description

Origination

Company Name

Not provided

Not provided

Username

Not provided

Not provided

Badge ID

Not provided

Not provided

Employee ID

The employee ID in the system.

The employee ID is entered in Company > Users profile.

EIN Tax ID

Not provided

Not provided

EIN Name

Not provided

Not provided

Local Time

Time stamp of employee’s time entry.

The employee’s time entry as created in Link app or Time Cards browser app.

TimeZone Name

The employee’s time zone.

The employee’s time zone is entered in Company > Users profile.

GMT Offset

The offset Greenwich Mean Time (GMT) from employee’s set time zone.

N/A

Timestamp

Unique identifier

Type

Clocking in or out status.

The employee’s time entry as created in Link app.

IP

Not provided

Not provided

Branch Abbreviation or Joined Code

The branch abbreviation for the assigned employee’s branch.

The employee’s branch is assigned in Company > Branches.

Cost Center 2

Not provided

Not provided

Cost Center 3

Not provided

Not provided

Cost Center 4

Not provided

Not provided

Cost Center 5

Not provided

Not provided

Jobs

Not provided

Not provided

EquipmentShare File Overview

The EquipmentShare File, used by internal Equipmentshare employees, will provide a CSV download of data for all employees or individual employees on the screen for the pay period.

Example file

File Attributes

Field Name

Description

Origination

Employee ID

The ID of the employee.

The employee ID is located Company > Users > Edit.

Name

The name of the employee.

The name is located in Company > Users > Edit.

Role

Employee's role within T3 system.

The employee role located Company > Users > Edit.

Total Hours

The total hours the employee worked in the pay period.

The total number of hours from the employee’s time card as logged from the Link app or manual entries.

Assigned Hours

The employee’s hours assigned to a Work Order, Job, Phase, or Work Code.

The assigned hours from the employee’s time card as logged from the Link app or manual entries.

Unassigned Hours

The employee’s hours have NOT been assigned to a Work Order, Job, Phase, or Work Code.

The unassigned hours are from the employee’s time card as logged from the Link app or manual entries.

Regular Hours

The regular, non-overtime hours an employee worked.

The regular hours are from the employee's time card as logged from the Link app or manual entries.

Overtime Hours

The employee’s overtime hours.

The total number of hours is from the employee’s time card as logged from the Link app or manual entries.

Approval Status

The approved or unapproved status of the employee’s time card.

The approval status is located in the employee’s Time Card in the Status column.

Notifications

Changes made to entries by employee or supervisor.

Edits and changes to time entries as made in the Link mobile app or T3's Time Cards.

Terminated Entries

Terminated entries are when the system forces an employee off the clock after they've been logging time for over 24 hours with no activity.

Terminated entries are when the system forces an employee off the clock after they've been logging time for over 24 hours with no activity.

Entry Summary File Overview

The Entry Summary File will include all employees and their accumulated hours for a single task.

Example file

File Attributes

Field Name

Description

Origination

Employee ID

The ID of the employee.

The employee ID is located under Company > Users > Edit.

Employee Name

The name of the employee.

The name is located under Company > Users > Edit.

Date

The calendar work date of the entry line.

The work date is found in Time Cards > Employee’s Time Card.

Hours

The total hours the employee worked in the pay period.

Total hours are logged when an employee clocks in/out from the Link app in the Time Cards menu option. Also, any manually added time entries from Time Cards will be reflected.

Time Type

The pay type for the employee, either regular or OT.

The pay type reflected on the employee’s time card.

Job/Phase

The job or phase ID is associated with the time entry.

The job number is created in Company > Work tab > Jobs table.

Work Order

The Work Order ID is associated with the time entry.

The Work Order ID is located under the Service dashboard in the Work Orders table.

Cost Code

The cost code is related to the time entry.

The cost code is created in Company > Work tab > Cost Codes table.

Asset ID

The asset ID is associated with a Work Order time entry.

The asset ID assigned to a Work Order is located under the Service dashboard in the Work Orders table.

Notes

Any notes entered for the time entry.

The notes can be found on the employee’s time card in the Notes field.

Branch

The branch abbreviation that is assigned to employee.

The branch abbreviation is created in Company > Branches.

Interested in getting started with T3's time tracking solution? Find out more and request a demo.

Did this answer your question?