Report - Profitability

What is the profitability report

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

 

Requirements to access the report

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

 

What data is 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). 

 

What data is 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.

 

Loading the profitability report

1. Click reports
2. Click Profitability 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 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.

 

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.

 

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 on percentage and save.

 

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.

 

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

 

 

 

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

 

 

 

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