Most balance sheet accounts can be reconciled with the same one-page layout. Use one template, and reviews get faster.
An account reconciliation template compares the general ledger balance with an independent source: a statement, subledger, schedule or calculation. List each reconciling item with a description, amount, date, evidence reference and owner, so the unexplained difference is zero. Age the reconciling items and require preparer and reviewer sign-off before the reconciliation is complete.
| Line | Item |
|---|---|
| 1 | Balance per general ledger |
| 2 | Balance per supporting source |
| 3 | Difference (1 minus 2) |
| 4 | Reconciling items (listed below) |
| 5 | Unexplained difference (3 minus 4) |
One row per item: description, amount, date arose, category (timing, error, other), evidence reference, owner, action and target date. Add an age column:
=PeriodEnd-C12
and a flag for anything older than your limit:
=IF(H12>MaxAgeDays,"ESCALATE","")
Errors should be corrected with a journal in the same period where possible, not carried as reconciling items.
A cell that shows COMPLETE only when everything is in place:
=IF(AND(ROUND(UnexplainedDiff,2)=0,COUNTIF(EvidenceRange,"")=0,PreparedBy<>"",ReviewedBy<>"",PreparedBy<>ReviewedBy),"COMPLETE","NOT COMPLETE")
Put it at the top in large text. A reviewer can see in one glance whether the reconciliation is finished.
Use the same layout for every account, saved in one folder per period with a consistent file name. A reconciliation index listing every account, owner, status and reviewer gives the controller a single view of where the close stands. See the balance sheet reconciliation process.
A reviewer should do more than check that the unexplained difference is zero. They should trace the ledger balance to the trial balance, trace the supporting balance to the source document, and test a sample of reconciling items against evidence. They should also challenge any item that appeared last month and hasn't cleared, and confirm that errors were corrected rather than carried forward. A short reviewer comment on what was checked makes the review evidence much stronger.
The template works the same in both countries and any currency. For foreign currency accounts, reconcile in the account currency first, then check the revaluation.
Reviews every balance sheet reconciliation with an on-device AI and 20 review tests, flags vague and wrong-account reconciling items, and builds a risk-ranked review queue. Runs in your browser on your own computer: nothing is uploaded.
12 questions on how strong your close controls are. Free to use online.
The Balance Sheet Reconciliation Library covers the balance sheet with nine working papers: a known error blocks sign-off, every supported balance needs an evidence reference and every aged item needs an owner and a next action. Excel, no macros, one-time price.
For most balance sheet accounts, yes. Some accounts, such as bank or fixed assets, benefit from extra detail, but the header, reconciling items and sign-off gate stay the same.
Set a limit in your policy, often 60 or 90 days. Anything older should be escalated and resolved, not carried forward.
A comparison of a general ledger balance with an independent source, with every difference explained, to prove the balance is right.
High-risk and high-value accounts, such as bank, receivables, payables and suspense, every month. Lower-risk accounts can be reconciled less often if your policy allows it.
Only briefly. Correct errors with a journal in the same period where possible, so the reconciliation shows timing items rather than mistakes.
Last updated 21 October 2026. General guidance for finance teams; check it against your own policies, systems and local rules.