Roster Timesheet Variance Report

Compare your estimated roster costs with approved hours

The Roster Timesheet Variance Report allows you to compare rostered hours with the timesheet hours (approved hours) and analyse the cost difference. It helps identify whether you've under- or over-rostered in a particular week.

This insight can inform your rostering strategies, indicating where you might require more labour or where you can reduce labour in upcoming weeks.

In this article, we will cover:

• How to run the Roster Timesheet Variance Report

  Please note: This report is available for generated payslips. If you are looking to see time differences pre-payroll, please refer to the Roster Summary Report or the Approve Shifts export. 

Using the Roster Timesheet Variance Report

The Roster Timesheet Variance Report compares the total hours rostered to the hours that have been approved. It presents this information as both a percentage difference and a dollar amount variance. 

This report can be helpful for these use cases: 

• • To highlight which departments are underperforming.
  • To determine which rosters need to reduce labour costs for their upcoming rosters. 
  • To determine the amount of labour costs saved post-payroll. 

Before using this report, here are a few important considerations to keep in mind:

• • This is a post-payroll report, which means it uses data from generated payslips to compare against the roster. 
  • Salaried employees will not appear on this report, even if they have been rostered. 
  • Timesheet edits are not reflected when running this report.
  • This report compiles data for 1 week at a time based on your pay cycle. 
    
    

To run this report:

1. From the quick menu, navigate to Reports > Workforce and then select Roster Timesheet Variance.
2. Select how you would like to group your report, this can either be by:
   • Employee - This option displays data by individual employee, then breaks down the data further by operation and roster. 
   • Roster - This will display the data by operation and roster. This option may be favoured by single-site businesses, allowing them to view a comprehensive breakdown of all their rosters. 
   • Operation - This option displays data by operation only. This can be beneficial for a broader view, particularly for businesses with multiple stores or locations. 
     
       Please note: You can only use one grouping at a time. To view a report with all 3 options, select the Employee grouping, which automatically breaks down for all 3 options.  
3. Set your filters. First, select your desired Week Ending date for generating this report. Optionally, you can customise your report further by selecting from the options below:
   
   • Operation
   • Manager
   • Cost Code/ Purchase Order
   • Employees
   • Roster
   • State
   • Office Code
4. To generate the report, select Submit.
   
     Hot tip: Any positive variances will appear green, and negative variances will appear red.
   
   

   

5. The report can also be exported or printed.  To do so, select either the Export CSV, Export PDF or Print buttons.