What is balance sheet account reconciliation?

It is the substantiation of a closing balance sheet balance: showing what the balance consists of item by item, and evidencing each item. For accounts with an external counterparty it compares against a statement; for accruals, prepayments and provisions the supporting schedule is itself the evidence.

Which balance sheet accounts need reconciling every month?

Cash, receivables, payables, intercompany, payroll control and every clearing or suspense account. These carry volume, an external counterparty, or a target of zero — any of which makes a month of drift expensive to unwind later.

Is an Excel template good enough?

For low-volume accounts, yes, provided it records an evidence reference and an owner per line rather than a free-text comment. The limitation is not the tool; it is that a spreadsheet has no memory of what an item looked like last month, so ageing an unresolved balance depends on somebody noticing.

Balance sheet account reconciliation

Last reviewed 2026-09-18

A balance sheet account reconciliation substantiates a closing balance: it shows what the balance is made of, item by item, and demonstrates that each piece is real. Unlike a bank reconciliation there is often no external statement to compare against, and the composition is the evidence.

What independent support means, by account type

Account	Supported by	The failure it catches
Cash at bank	Bank statement at the same date	Unrecorded or duplicated payments
Accounts receivable	Aged subledger tied to the control, plus subsequent receipts	Balances that are uncollectable rather than merely outstanding
Accounts payable	Supplier statements and a search for unrecorded liabilities	Invoices received and never posted
Prepayments	A schedule of each contract, its term and its unamortised balance	Amortisation that stopped when somebody left
Accruals	An item-by-item listing with the basis for each estimate	Accruals that outlive the thing accrued for
Fixed assets	The asset register, reconciled to cost and accumulated depreciation separately	Disposals recorded in one place only
Intercompany	The counterparty's balance at the same date, in both currencies	Differences that consolidate into a plug
Suspense and clearing	Nothing. The target balance is zero	A clearing account used as a resting place

A worked example: an accruals account

Closing balance in the ledger at 30 September: 186,500.00. A reconciliation of this account is a listing, and the listing is the substantiation.

Accrued for	Amount	Basis	Status
Audit fee, year to 31 Dec	72,000.00	Engagement letter, 9/12 of annual fee	Supported
Electricity, Sep	18,400.00	Aug invoice, no meter read yet	Estimate
Contractor, Sep timesheets	41,300.00	Approved timesheets, unbilled	Supported
Legal, corporate matter	32,000.00	Counsel's estimate, Aug email	Estimate
Brought forward, origin unknown	22,800.00	First appears Mar; no schedule	Unexplained
Total per reconciliation	186,500.00

The reconciliation ties exactly, and it is not finished. 22,800.00 has no basis, and a balance whose composition includes an item nobody can source is not substantiated regardless of whether the column adds up. Note also the distinction the last column draws between supported and estimate: both are legitimate, but an estimate is a figure that rests on an assumption, and an assertion is never stronger than what it rests on. Adding a supported number to an estimated one does not produce a supported total.

What a template needs, and what most templates leave out

Spreadsheet templates for this job are easy to find and mostly carry the same four columns: description, amount, date, comment. Four things they generally omit turn out to be the ones that matter.

An evidence reference per line, not a comment. “Per schedule” is not a reference; a document name and date is.
The basis of each figure — observed, calculated from observed inputs, or estimated. A total made of both kinds inherits the weaker one.
An owner and an expected date on anything unresolved. Without them an open item is a note rather than a task.
Age. When did this item first appear in this account? An accrual appearing for the seventh month is a different conversation from one appearing for the first.

The clearing account exception

Suspense, clearing and payroll control accounts reconcile to zero, not to a statement. A non-zero balance in one of them is not a reconciling item to explain; it is an unposted transaction to find. Treating a clearing account balance as something to substantiate rather than something to clear is how a 40,000 balance survives four closes with a comment against it.

Common questions

What is balance sheet account reconciliation?: It is the substantiation of a closing balance sheet balance: showing what the balance consists of item by item, and evidencing each item. For accounts with an external counterparty it compares against a statement; for accruals, prepayments and provisions the supporting schedule is itself the evidence.
Which balance sheet accounts need reconciling every month?: Cash, receivables, payables, intercompany, payroll control and every clearing or suspense account. These carry volume, an external counterparty, or a target of zero — any of which makes a month of drift expensive to unwind later.
Is an Excel template good enough?: For low-volume accounts, yes, provided it records an evidence reference and an owner per line rather than a free-text comment. The limitation is not the tool; it is that a spreadsheet has no memory of what an item looked like last month, so ageing an unresolved balance depends on somebody noticing.

About Valcenra

Valcenra decomposes a financial movement into drivers that tie to the underlying records, keeps rounding, unmatched and unexplained residuals apart rather than summing them, and refuses to state a conclusion it cannot support — naming the field it needs and the conclusion that field decides. It is read-only: it drafts and computes, and it does not post journals, move money or approve anything. Talk to us.