How ClickTime Tracks Job Sites and Timesheets for Payroll Integration

How ClickTime Tracks Job Sites and Timesheets for Payroll Integration

To make sure timesheets go to the right place in payroll software, ClickTime uses special ID numbers for both employees and job sites:

1. Employee ID (External Payroll ID)

  • Every employee in ClickTime has a unique ID called the External Payroll ID.

  • This ID helps match the employee’s timesheet with their record in your payroll system (like MYOB, Xero, or KeyPay).

  • Think of it like a fingerprint—no two employees have the same one.

2. Site ID (Site External ID)

  • Each job site in ClickTime also has its own unique ID called the Site External ID.

  • This ID connects the location where someone worked to the matching job number or site code in other payroll systems.

  • It’s especially useful if you want to track hours by location or job number.

3. Why These IDs Matter

  • They make sure the right person gets paid for the right shift at the right place.

  • They help payroll teams avoid mix-ups and make reporting easier.

  • You can choose to include or leave out the Site ID in your export—depending on how your payroll system is set up.

4. What a "Site" Represents in Client Time

A "Site" is a unique work location with detailed operational data. 

ClickTime uses the Site External ID to match these locations with job numbers or site codes in external payroll systems.

5. Export Options for Payroll Processing

ClickTime supports flexible export formats to suit different payroll workflows:

Export Format #1: With Site Data

Includes both employee and job site identifiers

Employee Payroll -ID
Site Payroll-ID
Shift Start Date
Start Time
Finish Time
Break Time
11200
SYD101
25/05/2025
10:30
15:30
30


Export Format #2: Without Site Data

Focuses solely on employee timesheet records

Employee Payroll -IDSite Payroll-IDShift Start DateStart TimeFinish TimeBreak Time
11200SYD10125/05/202510:3015:3030