Exporting Time Cards for HR Payroll

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.