HomeMoneyHow to Reconcile a Balance Sheet

How to Reconcile a Balance Sheet

A balance sheet can balance perfectly and still be wrong. The totals agree because double entry forces them to agree, not because anyone has checked the individual balances against the outside world. Reconciliation is the checking. Account by account, it compares what the ledger says with what independent records say: the bank statement against the cash account, the customer ledger against the receivables balance, the loan statement against the debt figure, the stock count against the inventory line. Where the two disagree, the difference gets a name, a reason, and a fix, or it gets carried forward openly as a timed item that will clear. This guide covers that process and nothing else: not hunting for the error that stops a sheet balancing, which is a different job we link to below, but proving, account by account, that a sheet which does balance deserves to.

In short: To reconcile a balance sheet, work through every balance sheet account in turn and compare its ledger balance with an independent source: bank statements for cash, the aged receivables and payables ledgers for control accounts, lender statements for loans, stock counts for inventory, and payroll and tax records for amounts owed. List every difference as a reconciling item, classify it as timing or error, correct errors with journals in the current period, and have the finished reconciliation reviewed and signed off. Monthly, risk first, is the cadence that works.

What Reconciliation Proves That Balancing Does Not

Start by separating two jobs that are often confused. Making a balance sheet balance is an arithmetic property of double entry; our guide to balance sheet vs trial balance explains why equal debits and credits prove only that the posting mechanics held. Reconciliation is an evidence exercise. It asks of each balance: can you show me, from a record that did not come out of this ledger, that this figure is right? A bank statement is evidence because the bank produced it. An aged receivables listing is evidence of composition, because it names every customer inside the total. A balance copied from last month’s working papers is not evidence at all, and a reconciliation built from the ledger’s own reports, checked against themselves, is circular. That independence test is the whole discipline in one sentence, and the Sage guide to balance sheet reconciliation is built on the same principle: compare the balances with the supporting documentation, investigate the mismatches, adjust where required, and document what was done.

The output of a proper reconciliation is not merely agreement. It is an explanation: this account agrees exactly; this account differs by these listed items, each dated, each understood, each either clearing next period or corrected now. An unexplained difference is the only true failure state. A difference with a name and a date is normal business, because payments in transit, deposits not yet cleared, and invoices in the post are the ordinary friction of accounting dates.

The Reconciliation Process, Step by Step

The method is the same for every account, and the repetition is the point. First, fix the period and lock it: reconcile against a trial balance drawn at the period end, and make sure late postings stop, or you will chase a moving target all month. Second, take the ledger balance for the account as at that date. Third, obtain the independent source balance for the same date: statement, subledger report, schedule, or count. Fourth, compare the two and list every item that explains the gap, transaction by transaction where the account is detailed, in total where it is not. Fifth, classify each item. Timing items will clear on their own: the cheque written on the 30th that the bank processes on the 3rd needs no correction, only a note. Errors need journals: the receipt posted twice, the payment coded to the wrong account, the fee the bank took that nobody recorded. Sixth, post the correcting journals in the current period, never by editing the closed period and never by plugging the difference into a suspense account to make it vanish. Seventh, write the reconciliation up on a standard format, ledger balance, source balance, items, preparer, date, and have someone other than the preparer review and sign it. The step by step guides from Synder describe the same seven step shape used in practice, ending with reviewer sign off, because a reconciliation nobody checks decays quickly into a copying exercise.

Account by Account: What Each Balance Is Checked Against

Cash and Bank Accounts

The bank reconciliation is the model all others copy. Compare the cash book balance with the bank statement balance at the period end. The reconciling items are the classics: deposits recorded in the books not yet credited by the bank, payments issued not yet presented, bank charges and interest appearing on the statement first, and direct debits the business learns about from the statement. Work through the statement against the ledger line by line at least monthly, daily or weekly if transaction volume is high, and treat any item older than a month with suspicion: uncleared payments that never clear are usually errors wearing a timing costume. When the bank agrees, cash, the most relied upon number in the business, is proven, which is why this reconciliation is never the one to skip.

Receivables and Payables Control Accounts

The receivables balance on the balance sheet is a control total: it must equal the sum of the individual customer balances in the aged receivables listing at the same date. Reconcile by running both figures and investigating any gap, which usually traces to a journal posted directly to the control account, a receipt allocated in one record and not the other, or a credit note raised after the listing was run. Then read the listing itself with the total proven: old balances, credit balances sitting where a customer has overpaid or been refunded twice, and round sum balances that never move are the items that turn a proven total into a doubtful asset. Payables mirror the process against the aged payables listing, with one extra source small businesses underuse: supplier statements. A supplier’s own statement of what you owe them is genuinely independent evidence, and reconciling the largest suppliers against their statements monthly catches the invoices that never reached your books at all, which no internal comparison can find.

Inventory, Prepayments, and Accruals

Inventory is reconciled to a count, not to another report. The ledger figure should agree with the valued stock listing, and the listing should agree with what is physically there at the count date, adjusted for goods received or despatched between the count and the period end. Differences here are shrinkage, damage, miscounts, and cut off errors, and they are corrected to the count, because stock that does not exist cannot stay on the balance sheet at value. Prepayments are reconciled to a schedule: each amount listed with what it covers and the period it runs to, releasing a slice to expenses each month, so the balance at any date is simply the unexpired remainder and any item whose period has passed should already have left the account. Accruals work the same way in reverse, a schedule of costs incurred but not yet invoiced, each cleared when the actual invoice arrives and replaced by the real figure, with the difference explained rather than buried.

Debt, Tax, Payroll, Fixed Assets, and Equity

Loans are reconciled to lender statements or amortisation schedules: opening balance, plus drawdowns, less repayments, plus interest charged, equals the closing balance, split correctly between the portion due within a year and the rest. A loan figure that is simply last year’s balance minus twelve payments is an estimate, and it drifts from the lender’s figure through fees, rate changes, and payment date shifts until a statement comparison resets it. Tax and payroll balances are reconciled to filings and authority statements: the VAT or sales tax control account should be explainable as returns filed, payments made, and the current period’s amount, and payroll liabilities should clear to nil or near it shortly after each pay run, because wages and deductions held for employees and authorities are not balances that should age. Fixed assets are reconciled to the asset register, additions agreed to purchase invoices, disposals removed with their depreciation, and the depreciation charge for the period posted from the register rather than invented at year end. Equity is reconciled as a movement statement: opening equity, plus capital introduced, plus the period’s profit from the income statement, less drawings or dividends, equals closing equity, and if it does not, the difference is a posting to find, because equity is where unexplained journals most often end up. If the layout these accounts sit in is still new to you, our guide on how to read a balance sheet covers what each line is before you start proving it.

Timing Difference or Error: The Judgement That Matters

Every reconciling item gets sorted into one of two boxes, and the sorting is where reconciliation succeeds or fails. Timing items are the accounting date cutting through live business: money genuinely in transit, invoices genuinely in the post. They share three traits: they are recent, they are specific, and they clear themselves within the next period without anyone posting anything. Errors are everything else, and they share the opposite traits: they do not clear, they need a journal, and left alone they repeat. The discipline is to refuse a third box. Items labelled unexplained, miscellaneous, or old and carried are errors that have not been investigated yet, and a reconciliation that tolerates them is worse than none, because it certifies a balance nobody has proved. Set two working rules and enforce them without exception: every item is dated when it first appears, and any item still open after sixty to ninety days is escalated and resolved, corrected, written off properly, or explained in writing by someone senior enough to own it.

Materiality keeps the process proportionate. Fix a threshold, an amount or a small percentage of the account balance, above which every difference is investigated the month it appears, and below which items are still listed but may be cleared in batches. What the threshold must never do is license a plug: posting the difference to a miscellaneous expense to force agreement. A plug destroys the evidence the reconciliation exists to create, and it converts a findable error into a permanent fiction inside the profit figure. Correct the transaction that caused the difference, or carry the difference openly. Those are the only two honest outcomes, and they are also, not coincidentally, the boundary between this guide and the other job: if your problem is that the sheet does not balance at all, stop reconciling and go to our guide to the reasons a balance sheet does not balance, because no amount of account by account proof fixes a sheet whose arithmetic is broken.

A Short Worked Example: One Account, Start to Finish

Watch the method work on the account that causes the most arguments, trade receivables, for a small design studio at the end of September. The ledger balance, the control account on the trial balance, says customers owe 38,450. The aged receivables listing, run for the same date, totals 37,900. There is a difference of 550 to explain before anything else in the close proceeds. The reconciler lists what could cause it and checks in order: a receipt banked on the 29th was posted to the ledger but the customer’s account was not updated, no, the receipt appears in both. A credit note for 550 was raised on the 30th for a pricing error, entered in the customer’s account, and the journal to the control account was never posted: there it is. The classification is error, not timing, because nothing about a credit note clears by itself. The fix is a journal in the current period, debit sales returns, credit receivables control, with the credit note number in the reference, and the reconciliation is written up showing the ledger balance, the listing balance, the single reconciling item, and the correction made.

Notice what did not happen. Nobody adjusted the listing to match the ledger, nobody parked the 550 in a suspense account, and nobody carried it forward to see whether October sorted it out. The difference had a documentary cause, the cause had a correction, and the file now shows a reviewer exactly how the proven figure was reached. Multiply that one page by every balance sheet account and you have the reconciliation file, which is also, when a lender or buyer asks how reliable the numbers are, the most persuasive document in the building.

Cadence, Ownership, and Sign Off

Reconciliation works as a rhythm, not a rescue. Bank, receivables, payables, and tax and payroll accounts are monthly at minimum, because they move constantly and their errors compound. Inventory follows the count cycle, monthly for fast moving stock, quarterly at worst. Debt, fixed assets, prepayments, and accruals can be quarterly in a small business if the schedules are maintained monthly, and equity is proven at every close through the movement check. Build the rhythm into the close itself rather than bolting it on afterwards: our quarterly finance close checklist sequences reconciliation and the trial balance scan ahead of producing any reports, which is the right order, proof first, reporting second. Assign every account a named owner, keep one register listing each account, its source document, its frequency, and its status, and use the same template for every reconciliation so a reviewer can read any of them in two minutes.

Sign off is the step small teams resist and the step that makes the rest real. The reviewer is not reperforming the work; they are asking three questions. Does the source document genuinely come from outside the ledger? Does every reconciling item have a date and a plausible story? Is anything old being carried, and if so, why? A reviewer who asks those three questions monthly will catch more than any software. When all of it is in place, the effect compounds quietly: the year end becomes a formality, a lender’s questions get answered from a file instead of a scramble, and the balance sheet turns into what it was supposed to be in the full set of statements, the position you can defend line by line, as our comparison of the balance sheet vs income statement vs cash flow statement sets out.

Frequently Asked Questions

Why reconcile a balance sheet if it already balances?

Balancing only proves the arithmetic of double entry holds. Reconciliation proves the individual balances are right by comparing each one with an independent record, such as a bank statement or a supplier statement. A sheet can balance around a wrong figure for months, for example a loan balance that was never agreed with the lender, and only reconciliation exposes it.

Which balance sheet accounts should be reconciled every month?

Cash and bank accounts, receivables and payables control accounts, tax and payroll balances, and any loan accounts. These move constantly and their errors compound. Inventory, fixed assets, prepayments, and accruals can run quarterly in a small business, provided the underlying schedules and registers are kept up to date monthly.

How do you tell a timing difference from an error?

A timing difference is a genuine item in transit, such as a deposit banked on the last day of the month that the bank credits two days later. It is recent, specific, and clears by itself next period. An error, such as a receipt posted twice, never clears and needs a correcting journal. If an item does not clear, treat it as an error and investigate it.

What should you do with reconciling items that never clear?

Age it, then escalate it. Date every reconciling item when it first appears and review the oldest items at every close. Anything still open after sixty to ninety days should be corrected, written off properly, or explained in writing by the owner or accountant. Carrying old items forward month after month is how small errors become large write offs.

Should you ever plug a difference to make a reconciliation agree?

No. Never post a difference to a miscellaneous or suspense account just to force agreement. A plug hides the error, falsifies the figures it lands in, and destroys the evidence needed to find the real cause. Either correct the transaction that caused the difference, or carry the difference openly on the reconciliation until it is understood.

What should a balance sheet reconciliation include?

Use one standard page: the account name and period, the ledger balance, the independent source balance, each reconciling item with its date and explanation, the preparer’s name and date, and a reviewer’s sign off. Keep the source document, such as the bank statement or supplier statement, attached or filed with it so the proof can be re-performed later.

- Advertisement -
Explore Insiders
Explore Insidershttps://www.exploreinsiders.com/
Explore Insiders is an authentic and trusted business news platform helping SMEs and entrepreneurs with creative business ideas, the latest technology news, and state-of-the-art marketing strategies.
RELATED ARTICLES
- Advertisement -

RECENT POST

- Advertisement -