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 organisation?
- What questions can this report help me answer?
- What is in the Schedule, timesheet and sales comparison report?
- FAQs on using this report
How can this report help my organisation?
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, Emploty 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
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?
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+)