Leave Balances & Liabilities Report

Form ID: (MP.PP.62.40)

This report shows employee leave balances for different entitlements, as well as the rate at which leave is paid to each employee, so you can asses the total liabilities for an employee. It's helpful in many situations, from auditing to end-of-financial-year reporting.

Note: If you need to export and integrate leave balances into other software, like (MYOB Acumatica — Workforce Management), we recommend that you use the Entitlement Balances Data report (MPPP4071).

See below for a description of each parameter on the Report Parameters tab. For details about using other elements on the report form, see Reports.

Report Parameters

On the Report Parameters tab, use the following parameters to select the information to be displayed on the report:

  • Date: The report shows how employee balances and liabilities looked as of the date you select. Only employees who were active at that date are included in the report.
  • Employee: If you select an employee, the report only includes that employee's balances and liabilities. If you leave this field blank, the report includes all employees.
  • Entitlement: If you select an entitlement, the report only includes employee balances and liabilities for that entitlement. If you leave this field blank, the report includes all entitlements.
  • Branch: If you select a branch, the report only includes employees from that branch. If you leave this field blank, the report includes employees from all branches.
  • Department: If you select a department, the report only includes employees from that department. If you leave the field blank, the report includes employees from all departments.
  • Show Totals: If selected, the report includes leave balance totals.

Understanding the Report

  • Balances include pay and leave adjustments, reversals and any other ad hoc pay details.
  • The report only includes balances for leave entitlements that hold balances and use rates for their calculations. For example: annual leave, sick leave, family violence leave etc.
  • The rates are rounded to four decimal places. Other values are rounded to two decimal places.
  • The descriptions below explain where information for some report columns comes from:
    • As At: This field shows the date selected in the Date field on the Report Parameters tab.
    • Net Accrual: The difference between total leave accrued and total leave taken in advance. This value is the same as the accrual value on the Entitlement Balances screen (MPPP6036).
    • Closing Balance: The sum of the Net Accrual and Earned columns.
    • Rate Effective Date: For annual leave, this is the same as the end date of the pay period for the date you selected in the Date field on the Report Parameters tab. For all other leave types, the Rate Effective Date is the same as the date the report was run.