If generating the Accrual Balance Report on Dec. 31, it will reflect the current rates, but may not included final December accrual balances. If the Accrual Balance Report is run later in the following year, the report may be impacted by rate changes and employees that have been made inactive.
Go to Basic Payroll > Reports > Accrual Report
- Select the Date to 12/31/YYYY of reporting year.
- Check Buyout Only
- Click Settings and verify the items checked are paid out at separation and the rate for each item paid
- Click Excel to generate the report.
- In the Export to Excel window, check Name, Accrual Type, Ending Hours, Hourly Rate and Line Cost.
- Click Excel to export report.
- Enter File Name
- Click Open to save in desired folder location.
- Launch Excel and open the exported file.
Go to Advanced Payroll > Reports > Accrual Balances
- Enter the Date to 12/31/YYYY of the reporting year.
- Click Factors to verify the items checked are paid out at separation and the rate each item is paid.
- Click the Payout Items Only box.
- Click Excel to generate report.
- Depending on the date payroll is run and how accruals are earned, check the Use Whole Month to capture all accrual items.
- In the Export to Excel window, check: mt.BalancesEmployeeName, mt.BalancesPosition, mt.BalancesStatus, mt.BalancesAccrualType, mt.BalancesEnding, mt.BalanceHourly Rate, mt.BalancesFactor, mt.BalancesCost
- Click Excel to export report
- Enter File Name
- Click Open to save in desired folder location.
- Launch Excel and open the exported file.