The Timesheet Reconciliation Report is designed to ensure accuracy between what was scheduled (mobilisation) and what was logged (timesheets). It allows you to detect differences in start/end times, shift hours, and shift types β helping you prevent overpayments, missed billing, or data entry errors.
Key Columns Explained
Date β The date of the shift or workday.
Staff β Name of the staff member.
Department β Their assigned department.
Job ID / Client / Job Location β Job details for cross-referencing.
Mobilisation Start / End β Planned shift times based on the mobilisation schedule.
Shift Hrs β Total shift hours expected.
Timesheet β Shift Type β The shift type submitted via timesheet.
Timesheet Start / End β Actual times recorded by the staff member.
Timesheet Hrs β Total hours logged on the timesheet.
Reconciliation β Shows whether the timesheet aligns with mobilisation (e.g., matched, over, under, missing).
How to Use This Report
Navigate to the Report
Go to the Reports tab and select Timesheet Reconciliation Report.
Compare Mobilisation vs. Timesheet
Look for differences in start/end times or total hours.
Use the Reconciliation column to quickly identify mismatches.
Follow Up
Investigate any discrepancies with staff or supervisors before approving hours for payroll or invoicing.
Export & Filter
Export to CSV for easier sorting, filtering, or follow-up.
Why Use This Report?
Reduce payroll errors
Validate client invoicing
Identify missed or incorrect timesheets
Ensure mobilisation schedules are adhered to