Reports | Profitability

1) Overview
2) Requirements to access the report
3) Data included in the profitability report
4) Data not included in the profitability report
5) Access the profitability report
6) Save presets
7) Load / delete a saved preset
8) Export the report to Excel
9) Revenue overhead percentage per shift
10) Payroll on costs percentage
11) Example reports (not exhaustive)


🔍 RELATED ARTICLES

Reports | Paid Totals


 

1) Overview

The profitability report displays revenue, roster paid costs and gross profit 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).

 

2) Requirements to access the report

The profitability report is limited to clients that have access to the billing module.

 

3) Data included in the profitability report

The profitability report includes the following data:

  • Roster costs
  • All roster costs (penalty rates, allowances etc) relating to the above
  • Billing rates associated with custom entities assigned to each shift (in the example below, the custom entity that defines the billing rate is the activity).

 

4) Data not included in the profitability report

The profitability report does not include the following data:

  • Public holiday worked hours and costs.
  • Worked paid hours.
  • Unpaid and paid leave hours and costs.

 

5) Access the profitability report

  1. Click Reports.
  2. Under Workforce, click Profitability report.
  3. Choose the data to be reported on.

 

6) Save presets

The profitability 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.

 

7) Load / delete a saved preset

Once presets have been saved, they can be used to quickly generate the report in your custom format. Presets can be selected through a drop-down menu on the Load presets section (only visible if any presets have been saved).

  1. Load the report following the instructions above.
  2. Select the saved preset from the drop-down list.
  3. Click Load preset / Delete preset.

 

8) Export 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.

 

9) Revenue overhead percentage per shift

The profitability report includes revenue overhead percentage per shift which increases the cost on the report.

The revenue overhead 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 Revenue overhead percentage.
  6. Enter the percentage and save.

 

10) Payroll on costs percentage

The paid totals report includes payroll on cost percentage.

The payroll on costs 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.

 

11) Example reports (not exhaustive)

 


NOTE: Example data shown below might not represent real world revenue against things like activities.


 

Funding scheme and activity scoped only to NDIA and specific activities

2016-08-11_19h05_18.png

Site, funding scheme and activity scoped only to NDIA and specific activities

2016-08-11_19h09_39.png

User, funding scheme, and activity scoped only to NDIA and specific activities

2016-08-11_19h11_04.png

Have more questions? Submit a request
Powered by Zendesk