Open navigation

Balance Your Entitlements

As part of the year-end process, we recommend balancing your entitlements to ensure:

  • Each entitlement code matches the liabilities

  • Entitlements match liabilities when paying out the entitlement

  • There are no G/L discrepancies.

We have provided three reports as a final check to help you balance your entitlements. The import files for the reports can be found as links at the bottom of this article. Please download the files:

  • Leave Balances vs Rates

  • Leave Dollars/Units Accrued over time

  • Leave G/L Accrual Comparison

You can run these report each year during year-end. If you ran this report last year, skip to the Update the Leave Balances and Rate Report section below. If you haven’t run the report before, you can find an attachment at the bottom of this article. Please see the Import the Report section for more information.

Report Overview

Leave Balances and Rate - This is the ideal report to run prior to paying out your entitlements to ensure your liability will be correct. This report checks whether paying out the remaining entitlement at the employee’s current rate will match the remaining dollar amount on their entitlement.

Leave Dollars/Units Accrued Over Time - This will display the accrued dollars and units for each entitlement code, and includes details of the accrual for each employee. You can compare this to the total change in the liability over the year in your financial records to ensure accuracy.

Leave G/L Accrual Comparison - Provides the G/L history for leave entitlements. A list of the G/L accounts from the accrued leave. Compare these to ensure the total amount matches your financial records for the expected G/L accounts.

How to Import the Reports

If you’ve imported this report for a previous year-end, there’s no need to import it again. You can rerun this report every year.

Step 1: Open Report Definitions.
By default, this can be found in Report Designer.

Step 2: Select File, then Import in Report Definitions.

Step 3: Browse to the location the import file was saved. Select the file, then select Open

Step 4: Enter a Definition Name, then update the Report Title, if desired.

Step 5: Select OK to save the Report. Once OK is selected, the Definition Name cannot be modified. 

Step 6: Repeat Steps 2 to 5 for the other reports.

How to Update the Leave Balances and Rate Report

Once the report is imported, please update it with the entitlement codes you're paying out. You don’t need to include banked time in this report.

Step 1: Open Report Definitions if it’s not already open.
By default, this can be found in Report Designer.

Step 2: Select the imported Leave Balances and Rate Report, then select Modify.

Step 3: Select Column 5 to 8.

Step 4: Select the column beside Criteria in Column Settings, then select … to open the criteria.

Step 5: Select each leave taken code, leave payout code, and leave accrued code on the Available column. This will move them to the Selected column.

Additional Information
You don’t need to include banked time in the entitlements selected.

Step 6: Ensure everything in the Selected column is a leave taken code, leave payout code and leave accrued code.

  • If any codes are not leave entitlement, select them to move them to the Available column.

Step 7: Once only leave entitlements are in the Selected column, select OK.

Step 8: Select OK to save your changes to the report. 

How to Update the Leave Dollars/Units Accrued Over Time Report

Once the report is imported, please update with your leave entitlement codes.

Step 1: Open Report Definitions if it is not already open.
By default, this can be found in Report Designer.

Step 2: Select the imported Leave Dollars/Units Accrued Over Time Report, then select Modify.

Step 3: Select Column 4 and 5.

Step 4: Select the column beside Criteria in Column Settings, then select … to open the criteria.

Step 5: Select each entitlement you're paying out on the Available column. This will move them to the Selected column.

Step 6: Ensure everything in the Selected column is a leave entitlement that you’re paying out.

  • If any codes are not leave entitlement, select them to move them back to the Available column.

Step 7: Once only leave entitlements are in the Selected column, select OK.

Step 8: Select Column 6 and repeat Steps 4 to 7.

Step 9: Select Column 7 and repeat Steps 4 to 7.

Step 10: Select OK to save your changes to the report. 

How to Update the Leave G/L Accrual Comparison Report

Once the report is imported, please update it with your leave entitlements.

Step 1: Open Report Definitions if it’s not already open.
By default, this can be found in Report Designer.

Step 2: Select the imported Leave G/L Accrual Comparison Report, then select Modify.

Step 3: Select Column 4 to 8.

Step 4: Select the column beside Criteria in Column Settings, then select … to open the criteria.

Step 5: Select each leave entitlement on the Available column. This will move them to the Selected column.

Step 6: Ensure everything in the Selected column is a leave entitlement.

  • If any codes are not leave entitlement, select them to move them to the Available column.

Step 7: Once only leave entitlements are in the Selected column, select OK.

Step 8: Select OK to save your changes to the report. 

How to Run the Reports

Step 1: Open Print Reports. 
By default, this can be found in Report Designer.

Step 2: Select the report in Report Definition.

  • Leave Balances vs Rate

  • Leave Dollars/Units Accrued over time

  • Leave G/L Accrual Comparison

Step 3: Select correct dates in Date Selection.

  • If you’re printing the Leave Balances vs Rate Report, select All.

  • If you're printing the Leave Dollars/Units Accrued Over Time or Leave G/L Accrual Comparison Report, choose a selection, then enter January 1, 2023, to December 31, 2023.

Step 4: Select All in Pay Group Selection.

Step 5: Select All in Location Selection.

Step 7: Select Save As on the Printer Setup tab, then select the location to save the report.

Step 8: Select Open file after saving if you wish to view the report immediately.

Step 9: Select Save to create the report.

Step 10: Repeat Steps 1 to 10 for each report.

Now that you’ve run the reports, they can be used for balancing.

Balancing Overview

  • Leave Balances and Rate - Compare the Dollars per a leave unit to either the employee base hour rate or the base day rate to ensure the payout amount will match the accrued amount.

  • Leave Dollars/Units Accrued Over Time - Compare the accrued dollars and units for each entitlement code to the total change in the liability over the year from your financial records.

  • Leave G/L Accrual Comparison - Compare the G/L accounts for leave entitlements to your financial records to ensure there are no unexpected G/L accounts.

Did you find any unexpected results? We're here to help! Please contact Client Care for assistance.

If your reports balanced, congratulations! Need more information on balancing your year-end? Go to Balance Your Year-End.


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.