Report - Paid Totals

What is the paid totals report

The paid totals report displays paid hours and costs which can be run for any period of time, split by day and week, scoped to groups, users and custom entities (e.g clients, activities or funding schemes) and be grouped by site, area, role, user and custom entities (e.g clients, activities or funding schemes).

What data is included in the paid totals report

The paid totals report includes the following data: 

  • Public holiday non-worked hours and costs
  • Public holiday worked hours and costs
  • Worked paid hours and costs
  • All payroll costs (penalty rates, allowances etc) relating to the above.

What data is not included in the paid totals report

The paid totals report does not include the following data:

  • Roster hours and costs
  • Makeup hours and costs (e.g. salary employee working under their hours)
  • Unpaid and paid leave hours and costs.

Loading the paid totals report

  1. Click reports
  2. Click Paid totals report located under Workforce
  3. Choose the data to be reported on.

Exporting the report to Excel

  1. Load the report by following the instructions above
  2. Choose the data to be reported on or load a preset
  3. Click the Export button.

Saved presets

The paid totals report provides preset functionality where you can define custom reports to be easily loaded

To save a preset: 

  1. Load the report following the instructions above
  2. Choose the data to be assigned to the preset
  3. Enter the name of the preset under "save current selection as a preset"
  4. Click Save preset.

Loading a saved preset

Once presets have been saved, they can be used to quickly generate the report in your custom format

To load a saved preset:

  1. Load the report following the instructions above
  2. Choose the data to be assigned to the preset
  3. Enter the name of the preset under "save current selection as a preset"
  4. Click Save preset.

Additional payroll costs percentage

The paid totals report can include an on cost percentage by selecting Exclude or Include next to Payroll costs.  

The additional percentage is set on the payroll entity and applies to each user with that payroll entity assigned as their home payroll entity

To set the on cost percentage

  1. Click organisation
  2. Click organisation structure
  3. Click the payroll entity
  4. Click settings
  5. Edit the field Payroll on cost percentage
  6. Enter the on cost percentage and save.

Scoping the Report

Scoping can be adjusted at the top of this report.

All of the headings are able to be adjusted by clicking on the drop down boxes or the edit buttons.

Once a data selection has been loaded, users have the ability to save their selection as a preset. A preset can be loaded to save time when the same scopes need to be used again. To save a preset enter the name and click save preset.

Loading a preset can be done by selecting the saved preset from the drop down list and clicking load preset.

Example reports (not exhaustive)

Site, are and role scoped to only sites Canberra and Melbourne

2016-08-11_18h11_29.png

Funding scheme

2016-08-11_18h36_59.png

Funding scheme and activity scoped to only NDIA and specific activities

2016-08-11_18h38_24.png

Client, Funding scheme and Activity scoped to NDIA and specific activities

2016-08-11_18h39_02.png

 

Have more questions? Submit a request

Comments

Powered by Zendesk