Balance Sheet Reconciliation Template: Excel Workbook for Prepayments & Accruals

Balance sheet reconciliations are the backbone of a clean close. But building reconciliation workpapers in Excel is tedious — lots of manual formulas, inconsistent layouts, and high error risk.

What the Template Includes

• Prepayment Schedule sheet with GL balance, detail lines, calculations, and variance column
• Accrual Schedule sheet with similar structure — allowing you to list individual accruals and roll up to the GL balance
• Bank Reconciliation sheet with outstanding cheques, deposits, and timing differences
• Summary sheet that pulls in key balances from each schedule and flags variances > £500
• Audit Trail sheet to document who reviewed and signed off on the reconciliation

How to Use It

For each account on your balance sheet (cash, prepaid assets, accruals), create a tab in the workbook or use the template as a guide. Fill in the GL balance at the top, list the supporting details (each prepayment, each accrual), and verify that the totals match. Add a notes column to explain any variances or pending items.

Why This Matters

Auditors expect to see reconciliations. If you have a clean, standardised reconciliation workbook, they can quickly verify your work. If you are cobbling together ad-hoc schedules in separate files, you waste time and they waste time.