Balance sheet reconciliation: proving the number, not just agreeing with it

Balance sheet reconciliation is the monthly discipline of proving that each balance sheet account holds what it claims to hold: the ledger balance on one side, the supporting detail on the other, and a documented explanation of anything between them. It is the control that stops errors from living in the accounts for years.

The distinction that matters is between reconciled and explained. An account is explained when someone can say why the balance is what it is. It is reconciled when the balance is supported by an independent list of items that add up to it — a bank statement, an aged debtors listing, a fixed asset register, a schedule of accruals with dates and amounts.

What a balance sheet reconciliation contains

• The ledger balance at the period end, taken from the trial balance rather than typed.
• The supporting detail: the independent source that evidences the balance.
• Reconciling items, each with an amount, a date and a reason.
• An ageing of those items — anything old is a problem regardless of its size.
• The action and owner for each item that should not be there.
• Preparer and reviewer, with dates. A reconciliation nobody reviewed is a working paper, not a control.

The categories that hide problems

Suspense and clearing accounts are meant to be temporary; a clearing account with a stable non-zero balance is holding something that was never resolved. Intercompany balances that do not eliminate mean two entities disagree about a real transaction. Accruals that roll forward unchanged month after month are usually either a liability that no longer exists or a cost nobody wants to release.

Prepayments and deferred income deserve their own schedules with release profiles, because they are the accounts most likely to be right in total and wrong by period.

Ageing the reconciling items is what turns the exercise from paperwork into control. A reconciliation with three unexplained items from last month is healthy. The same reconciliation with items dated eighteen months ago is telling you the account has not been reconciled at all — it has been carried forward.

A workable monthly routine

1. Rank accounts by risk and value, and set a frequency for each: high-risk monthly, low-risk quarterly.
2. Fix a template so every reconciliation shows balance, support, difference and ageing in the same shape.
3. Reconcile after the ledger is closed for the period, not during posting.
4. Require a reviewer other than the preparer, and record both names.
5. Track clearance of reconciling items as a list with owners, rather than hoping they resolve themselves.
6. Report the ageing of open items to the finance lead each month.

This is a spreadsheet job with a control obligation attached: dozens of schedules, refreshed every period, reviewed by someone else, and needed again at audit. Ettex Sheets keeps each reconciliation with its history and its review trail, so the version the auditor asks for in March is the version that was signed in January rather than a file that has been edited since. The bank reconciliation is only the most familiar member of the family — the same structure applies to every account on the sheet.

What good looks like

A finance function with reconciliations under control can answer three questions immediately: which accounts were reconciled this period, what is unexplained, and how old it is. Where those answers require a week of work, the month end close is producing numbers nobody has actually proved.