How to reconcile a balance sheet correctly, step by step

To reconcile a balance sheet, confirm that total assets equal total liabilities plus equity, then trace every line item back to a supporting schedule or source document, investigate and clear each discrepancy, and sign off with a dated record. The process runs in six ordered steps and should be repeated every reporting period. This guide gives you the exact sequence, a checklist, and a clear view of where errors tend to hide.

Balance sheet reconciliation is a distinct, periodic task. It sits on top of bookkeeping, not inside it. Knowing what a balance sheet contains is not the same as knowing how to verify one. That gap is what this article closes.

What does it mean to reconcile a balance sheet?#

Reconciling a balance sheet means verifying that every figure on it is correct, supported, and consistent with the period it covers. It is not the same as preparing a balance sheet. Preparation assembles the numbers; reconciliation proves them.

The Balance sheet shows a snapshot of what the business owns, what it owes, and what remains for shareholders at a specific date. Reconciliation asks whether every figure can be traced to an independent source: bank statements, loan schedules, payroll records, sub-ledgers for debtors and creditors. If a number cannot be traced, it has not been reconciled.

Reconciliation means those schedules already exist and agree with every figure on the sheet. Investors and auditors will ask for them.

What do you need before you start?#

Gather everything before you open the balance sheet. Stopping mid-process to hunt for a bank statement or a loan agreement breaks concentration and introduces errors.

You need the following:

The signed or locked balance sheet for the period you are reconciling, showing every line item.
The prior-period balance sheet, so you can check opening balances and trace movements.
Bank statements for every account the business holds, covering the full reporting period.
A debtors (accounts receivable) sub-ledger or aged debtor report, reconciled to the period-end date.
A creditors (accounts payable) sub-ledger or aged creditor report, also period-end dated.
Loan and finance schedules showing the opening balance, drawdowns, repayments, and closing balance for each facility.
Payroll records confirming wages paid, PAYE and National Insurance liabilities outstanding, and any accrued holiday pay.
Fixed asset registers with additions, disposals, and depreciation for the period.
Equity records: the share register, any dividend resolutions, and the retained earnings calculation.
Any accruals and prepayments schedules prepared at the period end.

Agree the reporting date and currency before you start. If the business operates in more than one currency, confirm which exchange rates apply to period-end balances. A mismatch in rates is a common source of unexplained differences that waste time to trace.

Keep all source documents in one place, physical or digital, before you begin.

How to reconcile a balance sheet: the six steps#

Work through these steps in order. Do not skip ahead because a line looks straightforward. The most common reconciliation errors come from assuming a figure is correct rather than checking it.

Confirm the accounting equation holds.Open the balance sheet and check that total assets equal total liabilities plus equity. If they do not, stop. Something is missing or double-counted, and proceeding line by line before fixing this will waste time. Identify which side is out and by how much. A round-number difference often points to a missing entry. An odd figure usually points to a posting error or a currency rounding issue. Fix the imbalance first, then move to step two.
Reconcile each asset line to its supporting schedule.Take each asset line in turn. Cash and bank balances should agree to the closing balance on each bank statement after completing a bank reconciliation for the period. Trade receivables should agree to the closing balance on the aged debtor report. Fixed assets should agree to the fixed asset register after accounting for depreciation and any disposals. Prepayments should agree to the prepayments schedule. For each line, write down the figure on the balance sheet, the figure on the supporting document, and the difference. If the difference is zero, the line is reconciled. If not, it needs investigation.
Reconcile each liability line to its supporting schedule.Apply the same method to liabilities. Trade payables should agree to the aged creditor report. Loans and borrowings should agree to the loan schedule, showing the correct closing principal balance after repayments. Tax liabilities, including Corporation Tax, VAT, and PAYE, should agree to the relevant returns or payroll records. Accruals should agree to the accruals schedule, with each item supported by an invoice, a contract, or a calculation. Again, record the balance sheet figure, the supporting figure, and the difference for every line.
Reconcile equity movements.Equity is the section most often left until last and checked least carefully. Start with share capital: confirm it agrees to the share register and that any new shares issued in the period are properly reflected. Then reconcile retained earnings. The closing retained earnings balance should equal the opening balance, plus the net profit for the period per the P&L, less any dividends paid or declared. If the retained earnings roll-forward does not agree, the P&L and balance sheet are not in sync, which is a significant error.
Investigate and resolve every discrepancy.Do not round down small differences or leave them in a suspense account. Every unexplained difference is either an error or a missing entry, and both need fixing. For each discrepancy, identify the source: a timing difference, a posting error, a missing accrual, or a currency rounding. Timing differences, where a transaction appears in one period's records but not another's, are the most common cause. Correct the entry, update the supporting schedule, and recheck the affected line.
Document, date, and sign off the reconciliation.Once every line is reconciled and every discrepancy resolved, create a reconciliation pack. This contains the balance sheet, each supporting schedule, a note of any adjustments made, and confirmation that the accounting equation holds. Date it, record who prepared it, and have it reviewed and signed off by a second person where possible. File the pack so it can be retrieved for audit or investor due diligence. A reconciliation with no sign-off record is difficult to rely on later.

Which balance sheet lines cause the most reconciliation problems?#

Some lines on a balance sheet are straightforward to verify. Others consistently cause problems, either because the underlying data is complex or because transaction timing creates gaps between what the ledger shows and what the source documents say.

These are the lines worth spending extra time on:

Accounts receivable. The aged debtor report and the balance sheet figure rarely disagree by accident. Common causes are invoices raised after the period-end date that were posted early, credit notes not yet processed, and receipts that arrived on the last day of the period but were banked the next. Check the cut-off carefully.

Accruals and prepayments. These exist precisely because a cost or income item does not fall neatly within the period. The risk is that last period's accrual was reversed but a new one was never raised, leaving the liability understated. Always compare this period's schedule to last period's and confirm every reversal has a corresponding new entry.

Deferred revenue. If the business receives payment before delivering a product or service, that cash is a liability until the work is done. Founders often treat it as income too early. The deferred revenue balance should agree to a schedule showing each customer, the amount received, and the amount earned to date.

Loan and interest balances. The principal balance on the balance sheet must agree to the lender's own statement, not just your internal schedule. Interest accrued but not yet paid is a separate liability. Both need their own supporting figures.

Retained earnings. This is the line people are least careful with. The roll-forward from opening balance to closing balance must agree exactly to the net profit figure on the P&L. If it does not, the two statements are inconsistent, and no amount of line-by-line checking elsewhere will fix that.

Intercompany balances. For businesses with more than one entity, intercompany receivables and payables must cancel out at group level. If one entity records a loan to a related company, the other must record the corresponding liability at the same figure.

How often should you reconcile your balance sheet?#

Reconcile monthly if you report to investors or a board. Monthly reconciliation means errors are caught within weeks of being made, when the transactions are fresh and the people involved can still explain them. Leave it longer and errors compound, becoming harder to trace.

For smaller businesses with no external reporting obligations, quarterly is a workable minimum. You will still catch most errors before they become serious, and the process will take less time because the volume of transactions is lower.

Reconcile before any fundraise or audit, regardless of your usual cadence. An investor doing due diligence will ask for reconciled balance sheets. An auditor will not accept unreconciled figures. Trying to reconcile twelve months of transactions in a hurry, under pressure, is the scenario most likely to produce mistakes.

Errors that sit undetected for several periods affect every subsequent period's opening balances. A misposted entry in January can distort every month through to December. By the time it surfaces, the correction may require restating multiple periods.

Set a fixed date in the calendar for reconciliation, tied to your period-end close. Treat it as a non-negotiable part of the close process, not something to do when time allows.

Balance sheet reconciliation checklist#

Use this checklist at each stage of the process. Tick each item only when you have verified it against a source document, not when it looks approximately right.

Before you start:

Prior-period balance sheet retrieved and opening balances confirmed.
Bank statements for all accounts, covering the full period, in hand.
Aged debtor and aged creditor reports run to the period-end date.
Loan schedules obtained from each lender or finance provider.
Fixed asset register updated for additions, disposals, and depreciation.
Accruals and prepayments schedules prepared.
Payroll records confirmed, including outstanding PAYE and National Insurance.
Equity records checked: share register, dividend resolutions, retained earnings calculation.
Reporting date and currency confirmed.

During reconciliation:

Accounting equation verified: total assets equal total liabilities plus equity.
Each asset line agreed to its supporting schedule, difference noted.
Each liability line agreed to its supporting schedule, difference noted.
Retained earnings roll-forward agreed to the P&L net profit figure.
Share capital agreed to the share register.
Every discrepancy investigated and either corrected or formally explained.
No items left in a suspense account without a resolution date.

Sign-off:

Reconciliation pack assembled: balance sheet, all supporting schedules, adjustment notes.
Date of reconciliation recorded.
Preparer's name recorded.
Reviewer sign-off obtained.
Pack filed and accessible for audit or investor review.

When does a financial model replace manual balance sheet reconciliation?#

The short answer: it does not replace it, but it can make it unnecessary at an early stage.

A ledger-based balance sheet is built from actual transactions posted in an accounting system. Reconciliation exists to verify that those postings are correct and complete. A model-derived balance sheet is built from projections: revenue assumptions, cost structures, financing lines, and headcount. There are no ledger entries to verify because there is no ledger.

For founders who are still pre-revenue or pre-accounting system, a model is often the only balance sheet they have. In that context, reconciliation in the traditional sense does not apply. What matters instead is internal consistency: does the balance sheet follow logically from the inputs?

bluprnts is a financial modelling tool that derives the full balance sheet automatically from the inputs a founder enters: products and pricing, headcount, costs, and financing lines. Once a business has a live accounting system and real transactions, ledger-based reconciliation becomes necessary.

If you want to understand how a three-way model connects the P&L, cash flow, and balance sheet, the startup financial modelling resources on bluprnts cover that in detail.

FAQs#

What is the difference between a bank reconciliation and a balance sheet reconciliation?#

A bank reconciliation checks that the cash balance in your accounting records matches the closing balance on your bank statement for the same period. It covers one line on the balance sheet. A balance sheet reconciliation covers every line: cash, debtors, creditors, fixed assets, loans, equity, and all other items. Bank reconciliation is one input into a full balance sheet reconciliation, not a substitute for it.

What happens if a balance sheet does not balance after reconciliation?#

Stop and find the source of the imbalance before doing anything else. A balance sheet that does not satisfy the accounting equation contains either a missing entry, a duplicated entry, or a posting on one side without a corresponding entry on the other. Check the most recent adjustments first, since errors tend to be recent. A round-number difference usually points to a missing transaction. An odd figure usually points to a posting error or a rounding issue in a currency conversion.

Can I reconcile a balance sheet in a spreadsheet?#

Yes. A spreadsheet works well for balance sheet reconciliation, provided you are disciplined about structure. Create one tab per balance sheet line, with columns for the balance sheet figure, the supporting document figure, and the difference. Keep the source documents linked or filed alongside. The risk with spreadsheets is version control: make sure you are always working on the current period's file and that previous periods are locked. Many small businesses reconcile entirely in spreadsheets without difficulty.

How long does a balance sheet reconciliation take?#

It depends on the number of transactions in the period and how well the bookkeeping has been maintained. A small business with clean records and a low transaction volume might complete a monthly reconciliation in two to three hours. A business with multiple bank accounts, intercompany balances, and complex accruals might take a full day or more. The first reconciliation you do for a given business almost always takes longer than subsequent ones, because you are building the supporting schedules from scratch.

Who is responsible for signing off a balance sheet reconciliation?#

The person who prepared the reconciliation should not be the same person who signs it off. Preparation and review need to be separate to catch errors the preparer missed. In a small business where only one person handles finance, the founder or a director should review and sign off the reconciliation pack, even if they did not prepare it. For investor-reporting businesses, the sign-off should sit with the finance lead or CFO. The sign-off record should include a name and a date.

Conclusion#

The most practical next step is to set a fixed reconciliation date in your calendar tied to your period-end close, then gather the source documents listed in the pre-reconciliation checklist before you start. Having everything in hand before you begin is the single change that makes the process faster and less likely to produce errors.