The Schedule, timesheet and sales comparison report is one of the reports available for free as part of Deputy Analytics.

• How can this report help my organization?
• What questions can this report help me answer?
• What is in the Schedule, timesheet and sales comparison report?
  • Filters
  • Stats of hours and costs
  • Table of Hours, Costs and Sales Analysis
  • Chart of Sales and Cost analysis
• FAQs on using sales data
• FAQs on using this report

How can this report help my organization?

Lower labor costs and understand business performance against the plan.

What questions can this report help me answer?

• Are my actual costs tracking to my scheduled costs?
• Are my actual hours tracking to my scheduled hours?
• Is my labor percentage on target?

What is in the Schedule, timesheet and sales comparison audit report?

Filters

The  stats and table in this report will be acted upon using the built-in drop-down menus to select specific:

• Date range (This defaults to the last 30 days but you can select to filter a specific date range if required) Note: the asterisk indicates this filter is required to be set to run the report.
• Location
• Location Status (active or archived)
• Area
• Exclude (Filled shifts, Empty shifts, Leave, Open shifts)
• Assigned to (Team member)
• Location Status (Active or Archived)
• Team member Status (Employed, Archived) 

Stats of hours and costs

The first section of the report shows a summary based on the filter selection set above:

• Scheduled hours - The sum of hours scheduled including leave (unless excluded in the filter)
• Actual hours - The sum of hours  captured in timesheets including leave (unless excluded in the filter)
• Hour variance - Percentage difference between Scheduled hours and Actual hours
• Scheduled costs - The total cost of wages scheduled including hourly paid wages, salary allocation, leave cost, open/empty shift cost and any hourly on-costs you have applied.
• Actual costs - The total cost of wages captured in timesheets including hourly-paid wages, salary allocation, leave cost and any hourly on-costs you have applied.
• Cost variance - Percentage difference between Scheduled costs and Actual costs
• Sales - Actual sales data as entered manually or imported from a sales integration 
• Sales per hour - Actual sales data divided by Actual hours worked
• Labor percentage - The ratio of your actual wage cost as a percentage of your actual sales, indicating how much of the sales revenue is spent on labour or percentage 

Note: On-costs will only be considered for business planning and reporting purposes and will not be used for payroll or timesheet calculations. When you create new schedules in the Schedule tab, the on-cost figures will automatically be included in the estimated cost and this report, which may result in variances between this report and payroll or timesheet calculations.

Table of Hours, Costs and Sales Analysis

A table listing all total hours, costs and sales statistics by Location, Area and team member based on the criteria selected using the filters above.

Click on the + next to each Location or Area name to expand the rows of data. Click - to collapse the rows again. Clicking the + and - in the header row will expand and collapse all rows.

The table contains the following data fields:

• Location / Area / Team member
• Scheduled hours
• Actual hours
• Hour Variance
• Scheduled costs
• Timesheets costs
• Salary costs
• Cost Variance
• Sales
• Labor Percentage
• Sales per hour

Chart of Sales and cost analysis

A line and column chart displaying the scheduled hours, actual hours, scheduled costs, actual costs and sales per week over the date range and other criteria selected in the filter.

Interested in finding out more about the data that produced the chart?

• Drill down on an aspect of the chart
• Show or download the underlying data

FAQs on using sales data

FAQs on using this report

• How do I filter this report to find the information I need?
• Can I save my filtered view for next time so I don't need to set up the same filters each time I view the report?
• How do I print, export or email this report?
• Can I schedule this report to export or email regularly? (requires Analytics+)
• How do I create a report with this information but other data included? (requires Analytics+)