Excel workbook previewAccrual Schedule Template
3 free downloads per account. Just your email and a 6-digit code.
About this template
An accrual schedule lists every expense that was incurred in the month but not yet invoiced, such as utilities, freight, professional fees, commissions and bonuses. It shows how each amount was estimated and whether it reverses next month. Auditors test accrued liabilities by comparing estimates with the invoices that came in later, so a schedule that tracks those true-ups answers their questions before they ask.
The main sheet holds each accrual with its expense and liability account, basis of estimate, prior and current amount and the true-up against the invoice. A flag marks estimates that missed by more than your tolerance. The Journal Entry sheet builds the accrual and the reversal per account, and a run-rate calculator supports recurring bills. It rests on general accounting practice, with no paid standard quoted.
Who it is for
The accountant who has to support the accrued liabilities balance for the auditor and show how each month-end estimate was made and trued up.
What is inside
- 12 worked accrual lines and 20 blank formatted rows
- Basis of estimate dropdown with 6 methods and an Auto-reverse Yes or No flag
- Change against the prior month, true-up against the invoice that arrived and true-up %
- Review estimate flag when a true-up is above both tolerances you set on the Summary sheet
- Summary sheet with totals, net true-up, flagged lines and accruals by basis of estimate
- Journal Entry sheet with the period-end accrual and the day 1 reversal per account, each with a debits equal credits check
- Run-Rate Calculator: average of three invoices times an adjustment, against the amount booked
How to use it
Set your true-up tolerance on the Summary sheet, then enter each accrued expense with its basis of estimate and amount.
Files
- XLSXaccrual-schedule-template.xlsx17 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Based on general finance practice, not on one published standard. A template to adapt, not legal, tax or accounting advice.
Questions about this template
What is an accrual schedule?
It is a working paper that lists the expenses recognized at month end without an invoice, with the amount, the account, the method used to estimate it and whether it reverses next month. It supports the accrued liabilities balance on the balance sheet and gives the reviewer and the auditor one place to see how each estimate was made.
Should month-end accruals reverse automatically?
Many teams reverse routine accruals on the first day of the next month and then post the invoice in full when it arrives, which keeps the ledger clean. Balances built up over time, such as an annual bonus pool or an audit fee, are often kept and released by hand instead. The Auto-reverse column records which method applies to each line.
How do I know if my accrual estimates are good?
Compare last month's estimate with the invoice that arrived. This template calculates the true-up in amount and percent for each line and flags it when both pass the tolerance you set. A line flagged two months running usually needs a better estimating method, such as usage reports instead of a flat run rate.




