SB Express Help Center

How do I generate an Accrual Balance Report?

Updated on

Workflows are not supported in your browser.
Please use a recent version of Chrome, Edge, Firefox or Safari to display this page.

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.  

Are you using Advanced Payroll or Basic Payroll?

Go to Advanced Payroll > Reports > Accrual Balances

  1. Enter the Date to 12/31/YYYY  of the reporting year.

  1. Click Factors to verify the items checked are paid out at separation and the rate each item is paid.

  1. Click the Payout Items Only box.

  1. Depending on the date payroll is run and how accruals are earned, check the Use Whole Month to capture all accrual items.  

  1. Click Excel to generate report.

  1. In the Export to Excel window, check: mt.BalancesEmployeeName, mt.BalancesPosition, mt.BalancesStatus, mt.BalancesAccrualType, mt.BalancesEnding, mt.BalanceHourly Rate, mt.BalancesFactor, mt.BalancesCost
  2. Click Excel to export report

  1. Enter File Name
  2. Click Open to save in desired folder location.
  1. Launch Excel and open the exported file.

Go to Basic Payroll > Reports > Accrual Report

  1. Select the Date to 12/31/YYYY  of reporting year

  1. Check Buyout Only

  1. Click Settings and verify the items checked are paid out at separation and the rate for each item paid

  1. Click Excel to generate the report.

  1. In the Export to Excel window, check Name, Accrual Type, Ending Hours, Hourly Rate and Line Cost.
  2. Click Excel to export report.

  1. Enter File Name
  2. Click Open to save in desired folder location.
  1. Launch Excel and open the exported file.
Congratulations, you are done!
Previous Article How do I generate Quarterly Tax Reports?
Still Need Help? Contact Us