The timesheet detail report includes contract hours, worked hours and specified hours, but also the clock times, schedule times and specified costs per employee.
User id – User id created by the system.
Employee nr – Employee's personal number.
Name – Name of the employee.
Date – Date of the timesheet registration.
Day - The day of the week
Starttime – Starttime of the shift.
Clocked in at – Clock in time of the shift.
Endtime – Endtime of the shift.
Clocked out at – Clock out time of the shift.
Break – Break registered in the timesheet.
Clocked Break – Clocked break.
Shift – Abbreviated name of the shift.
Location – Name of the location.
Department – Name of the department.
Team – Name of the team.
Contract type – Name of the contract used with the timesheet.
Worked – The worked hours in the timesheet.
Surcharge hours (paid) – The number of surcharge hours paid in the timesheet.
Total incl. surcharge – The worked hours and surcharged hours combined.
Meals – The occasionally listed meals.
Kilometers – The occasionally listed kilometers.
Surcharge "%" - All hours made under a surcharge, surgarge settings can be found under, Settings > Rate cards.
Status - The status of the timesheet (aproved, pending or declined)
Wage – The employee's wage costs. Salary including all surcharges.
Coc – Cost of company during this period.
Contract hours p/w – The number of fixed hours per week included contract of the employee.
Schedule Starttime – Scheduled starttime of the shift.
Schedule Endtime – Scheduled endtime of the shift.
Schedule Break – The scheduled break of the shift.
Schedule Total – Total of all the scheduled hours.
Schedule Difference – Difference between the scheduled hours and the timesheet. For example, if there is a difference of -0,5 than there is a shortage in the schedule of half an hour.
Note – Note added to the timesheet.
Clocked - If there has been clock action.
Clocked breaks – Break time in minutes, clock in and clock out time.
Clockin ip - The IP address where there has been clocked in.
Clockin type - The device used for clocking in (browser, mobile app or clock terminal)
Clockin verified by - If the clock action is authorised.
Clockin latitude - The GPS latitude of the clock in action.
Clockin longitude - The GPS longitude of the clock in action.
Clockin accuracy - The accuracy of the GPS determination when clocking in.
Clockout ip - The IP address where there has been clocked out.
Clockout type - The device used for clocking out (browser, mobile app or clock terminal)
Clockout verified by - If the clock action is authorised.
Clockout latitude - The GPS latitude of the clock out action.
Clockout longitude - The GPS longitude of the clock out action.
Clockout accuracy - The accuracy of the GPS determination when clocking in.
Created by – Who added the worked hours into the timesheet.
Updated - The date of the latest adjustment of the timesheet.
Modified by - The person that made the last adjustment to the timesheet.
Modified by – Who modified the timesheet. Who initially added the worked hours or lastly modified the timesheet.
Reviewed - When the timesheet has been reviewed.
Reviewed by – Who approved the hours in the timesheet.
Timesheet id - Timesheet id created by the system.
Roster id - Roster id created by the system.
Shift id - Shift id created by the system.
Team id - Shift id created by the system.
Department id - Department id created by the system.
Location id - Location id created by the system.
Rate card id - Rate card id created by the system.
Contract type id - Contract type id created by the system.
Hourly wage - The hourly wage of the employee.