All Collections
Reports
Cost Reports and Cost Timelines
Cost Reports and Cost Timelines

Report on total hours worked and costs.

Bridget O'Hare avatar
Written by Bridget O'Hare
Updated over a week ago

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

  1. 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.

  2. Select whether you want to include on-costs

  3. Select how you want to compare costs by either:

    1. Comparing timesheet costs to roster costs, or;

    2. Comparing timesheet costs between two different date ranges

  4. 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:

  1. Create a + New config with the blue button

  2. Copy any details from the existing on-cost into the new configuration

  3. Make any required changes to the new configuration and click the Create on-cost config button

  4. 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.


Keywords: total hours worked

Did this answer your question?