SB Express Help Center

How do I generate an Accrual Balance Report? (Article)

Updated on

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.  

How to generate an Accrual Report in Basic Payroll?

Go to Basic Payroll > Reports > Accrual Report

  1. Select the Date to 12/31/YYYY  of reporting year.
  2. Check Buyout Only
  3. Click Settings and verify the items checked are paid out at separation and the rate for each item paid
  4. 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.
How do I generate Accrual Balances Report from Advanced Payroll?

 

Go to Advanced Payroll > Reports > Accrual Balances

  1. Enter the Date to 12/31/YYYY  of the reporting year.
  2. Click Factors to verify the items checked are paid out at separation and the rate each item is paid.
  3. Click the Payout Items Only box.
  4. Click Excel to generate report.
  1. Depending on the date payroll is run and how accruals are earned, check the Use Whole Month to capture all accrual items.  
  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.
Previous Article How do I generate a Payroll Cost Report? Article
Next Article How do I review pay changes?
Still Need Help? Contact Us