The Employee timesheets report shows employees' working hours for a selected period. You can review daily and total hours without opening individual timesheets.
The report requires an overtime policy filter. If employees belong to different overtime policies, run a separate report for each policy.
Access the Employee timesheets report
Select Reports.
Select Timesheets.
Select Employee timesheets.
Select a reporting period, such as Weekly or Monthly.
Select the required dates.
If you select Custom dates, choose a date range of 60 days or fewer.
Select an overtime policy.
Select a timesheet group if required.
Select a location if required.
Open Advanced Criteria if you want to show only employees who worked over a specified number of hours.
Enter the number of hours if required.
Select Generate.
📎NOTE: If you select a custom date range longer than 60 days, Sage HR displays the message Please select shorter range.
'No results found. Try different report criteria'
This message appears when no employees match the selected report criteria.
A common cause is selecting an overtime policy that has no assigned timesheet groups.
To resolve this:
Select a different overtime policy or check that the required timesheet groups are assigned to the selected overtime policy.
Run the report again.
Available report filters
You can filter the report by:
Overtime policy
Timesheet group
Team
Location
Information shown in the report
The report displays:
Daily and total timesheet hours
Contract hours
Difference between worked and contract hours
Overtime hours
Approved overtime to pay out
Approved overtime allocated to time off
Timesheet status
📌TIP: Select Export to download the report as an Excel file.
Show all employees in one report
You must filter the report by overtime policy.
To include all employees in a single report, you would have to assign all relevant timesheet groups to the same overtime policy.
If employees need to use different overtime policies, you'll have to run a separate report for each policy.
📎NOTE: If you have duplicate overtime policies from a previous overtime update, review and consolidate them before running reports.