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
Access the T3 Time Cares web app.
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.
Type the user's name in the search bar or select a recent recipient.
Click Send when ready.
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.