Reporting on your employee's leave
You're able to use the leave liability and leave paid reports to review your employee's leave.
These reports can be used for:
- Viewing your employee's leave balances at a specific date (including past or future dates).
- Reviewing the leave paid to your employees during a given time period.
Please note: It is recommended that you use the new Leave Reports for leave liability instead of this one. The new leave report will provide you with a better breakdown of your leave liability but will only provide you with data since 1 January 2024.
Leave paid is not currently handled by the new Leave Report.
The Leave Liability report will display leave entitlements in hours and dollar value.
This report allows you to:
- View leave balances at the present time.
- View leave balances as they were at a specific date in the past.
- Project future leave balances.
To generate the Leave Liability report:
- Navigate to Reports > Financial > Leave Liability.
-
Select the Date you wish to report on. See the below for guidelines.
- Retrospective (past dates) - Leave liabilities will be reported as at the date the pay cycle was processed.
- Current (this pay period) - Leave liabilities will be reported as at the date the pay cycle was processed.
- Prospective (future dates) - Allows you to enter a future date for the purposes of forecasting leave liability.
-
Select your groupings. You can group by:
- Employee
- Operation
- Office Code
- Cost Code / Purchase Order
- Leave Type
- Select any additional Filters to narrow down your results by employee, operation, office code, or leave type.
- Optionally enable additional reporting options
- Exclude nil value balances - Does not display results with a zero balance.
- Include approved leave - Considers leave applications from the last period end date to the projected future date.
- Use retrospective rate - Calculates the liability amounts based on the pay rate applicable at the specified date (retrospective only). This only applies to the base rate, loading will always be reported based on the current loading rates.
-
Exclude totals in export - With this disabled, all appropriate columns will be totalled in the export. With this enabled, the total row will be omitted.
- Click submit to view your report.
- Export to CSV, PDF, or Print if required.
The report will detail the following information:
- Employee: Employee’s name and ID number.
- Leave Type: The type of leave (e.g. Annual Leave, Long Service Leave, etc).
- Hours: The total available hours including approved leave hours. Where a future date is specified, the employees' work pattern will be used to determine the predicted leave balances.
- Approved Hours: Future-dated approved leave hours. Only displayed where a prospective date is specified and ‘Include approved leave’ is selected.
- Projected hours: Balance of hours minus Approved Hours. Only appears if 'include approved leave' is selected.
- Amount: The monetary value calculated based on the employee’s current base pay rate. If ‘Use retrospective rate’ is selected, the pay rate applicable at the specified date will be used to calculate the base rate. If ‘Include approved leave’ is selected, the Hours less the Approved Hours will be the balance used to determine the liability amount.
- Loading: The monetary value of the loading calculated where applicable.
- Total: Combines the Amount and Loading values to display the total liability.
Notes:
- Only leave types that have been configured as ‘Reportable Leave Liability' will be considered in this
report. You can read more about the leave entitlement setup here.
-
Forecasting liabilities will calculate leave accruals on an hourly basis from theemployees work pattern.
-
'Include approved leave’ (forecast only) will only display on a week-ending basis (i.e.leave applications up to the last Sunday prior to the specified date will be included.)
-
Currently, TOIL and RDOs are not available in this report.
The Leave Paid report allows you to view leave paid once payroll has been processed.
To generate the Leave Paid Report:
- Navigate to Report > Financial > Leave Paid.
- Select your desired Duration.
-
Select your groupings. You can group by:
- Month
- Employee ID
- Payslips
- Period Ending
- Cost Code / Purchase Order
- Office Code
- Operation
- Leave Type
- Payment Type
- Select any additional Filters to narrow down your results by employee, operation, office code, leave or payment type.
- Optionally enable additional reporting options
- Cash Basis - With this disabled, the period end date will be used. With this enabled, the payment date will be used.
- Show leave loading separately - With this disabled, any loading will be included in the amount paid. With this enabled, all loadings are separated.
- Exclude totals in export - With this disabled, all appropriate columns will be totalled in the export. With this enabled, the total row will be omitted.
- Click submit to view your report.
- Export to CSV, PDF, or Print if required.