Excel workbook previewBalance Sheet Reconciliation Template
3 free downloads per account. Just your email and a 6-digit code.
About this template
A balance sheet reconciliation proves that the balance of each general ledger account agrees to something independent: a bank statement, a subledger, a schedule or a third-party confirmation. Every difference is either explained by a listed reconciling item or investigated. External auditors, lenders and incoming CFOs expect a reconciliation for every account, every month, with evidence of review. This workbook gives you that structure in one file.
The Reconciliation Index lists each account with its risk rating, preparer, reviewer, GL balance and supporting balance. Reconciling items sit on their own sheet with type, owner, clear-by date and age, and the index adds them up per account. A result formula compares the unexplained amount with a threshold per risk rating. It rests on general accounting practice, with no paid standard quoted.
Who it is for
The controller or senior accountant who must show the auditor or a new CFO that every balance sheet account is reconciled and reviewed each month.
What is inside
- Reconciliation Index with 13 worked accounts and 20 blank formatted rows
- Difference, explained items, unexplained amount and a Reconciled, Awaiting review or Investigate result per account
- Reconciling Items log with 7 worked items, item type and Cleared dropdowns, age in days and age bands with Over 90 in red
- Overdue clear-by dates turn red until the item is cleared
- Settings sheet with period end and an unexplained-difference threshold per risk rating (High, Medium, Low)
- Summary sheet with counts by result, total unexplained, open items, items over 90 days, and results per risk rating
- Sign convention and step-by-step instructions on a How to use sheet
How to use it
Set the period end and the threshold per risk rating on the Settings sheet, then list your balance sheet accounts on the index.
Files
- XLSXbalance-sheet-reconciliation-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 a balance sheet reconciliation?
It is a check that the balance of a general ledger account agrees to independent support at the period end, such as a bank statement, a subledger or a schedule. Any difference is listed as a reconciling item with an explanation and an owner, or investigated. A reviewer then signs off. This template records all of that per account.
Which accounts need a monthly reconciliation?
A common approach is to reconcile every balance sheet account on a set cycle and the high-risk ones every month: cash, receivables, inventory, payables, accruals, deferred revenue, payroll liabilities and intercompany. The risk column in this template lets you set a tighter threshold for those accounts and report results per risk rating.
What is an acceptable unexplained difference?
That is your decision, agreed with your reviewer and often your external auditor. Many teams set a small amount for cash and high-risk accounts and a larger one for small, stable balances. Enter your own amounts per risk rating on the Settings sheet. The examples in the file are illustrations, not a recommendation.




