Cost Reports in Tanda help you to report on wage costs and total hours worked.
Cost Reports are visible to managers under Reports > Cost Reports:
How to filter reports
Select your report: Each report is based off the same data and contains the same filters - the difference between each cost report is how the data is aggregated.
Select whether you want to include on-costs
Select how you want to compare costs by either:
Comparing timesheet costs to roster costs, or;
Comparing timesheet costs between two different date ranges
Select any relevant filters. The table below provides a summary of each filter
Filter | Description |
Qualifications | Filters by employees who's qualification status is 'current' for the selected qualification |
Locations | Filters by the location associated to the 'default payroll team' located on the employee profile |
Teams | Filters by 'default payroll team' located on the employee profile |
Award tags | Filters by the award tags contained on the employee profile |
Roles | Filters by permission level. E.g. 'Employee' or 'Admin' |
Award templates | Filters by the award template selected on the employee profile |
Shift location | Filters by the team selected on the timesheet to identify the locations of each shift |
Shift team | Filters by the team selected on the timesheet |
FAQ's and Troubleshooting
How do you edit on-cost percentages?
On-costs can be edited in Settings > All Settings > On-cost Config.
Three on-costs are automatically setup when your account is created - Workcover, Cost of Leave Accrued, and Superannuation.
To make any changes to these preset fields:
Create a + New config with the blue button
Copy any details from the existing on-cost into the new configuration
Make any required changes to the new configuration and click the Create on-cost config button
Navigate to the old on-cost configuration and use the red Delete on-cost config button to remove it
Updating on-costs here will update the on-cost values in all other reports and your roster.
How does the real wage cost report work?
The Real Wage Cost Report includes and displays the breakdown of on-costs such as Superannuation, Workcover and Leave Accrual.
As Tanda won't know your true on-costs, this figure is only an estimate for the purpose of reporting. You can enter a percentage of on-cost that represents a best estimate of the true costs of employment.
The real wage cost adds the percentage cost of Superannuation and Workcover onto your base timesheet and roster costs. If you have set the 'Leave Accrual Percentage' to higher than 0, then it will use this as an estimate for leave costs, instead of the leave taken cost. If your leave accrual rate is 0, it will simply use the leave taken cost.
Timesheet Cost (with oncosts) = Timesheet Base Cost (worked hours & leave cost) + Superannuation + Workcover + Leave Accrual - Leave Taken
Roster Cost (with oncosts) = Roster Base Cost (Worked hours) + Superannuation + Workcover + Leave Accrual
This means that from the base timesheet cost, it adds the cost of leave accrual hours as hours are worked (reflecting that there is a future leave liability increasing) and subtracts the cost of leave taken.
Why does Tanda use the default cost of leave of 19% in the on-costs?
Tanda's default cost of leave is a rounded estimate based on the below assumptions:
Full-time employment
260 week days in the year, minus entitled paid days off which include:
20 days of paid annual leave
10 days of paid personal leave
11-13 public holidays that fall on working days
This leaves around 218 productive days per year. There is therefore around a 19% additional cost of employment in non productive time per permanent employee depending on the number of public holidays in your state and how much personal leave is used in the year.
Note: editing the cost of leave on-cost percentage won't impact your actual leave accrual settings in your Tanda account.
Do cost reports include only approved shifts or published rosters?
Roster costs on cost reports in Tanda include both published and unpublished rostered shifts. Timesheet costs on reports in Tanda include both approved an unapproved shifts on timesheets.
Keywords: total hours worked