How to reconcile the balance sheet in Xero

Written by an ACA-qualified finance manager · about the author · Last reviewed 1 July 2026

If the balance sheet is right, the P&L usually follows. So reconciling it, line by line, is the real work of a month-end close. Here’s how.

The principle: explain every line

Reconciling the balance sheet isn’t about ticking that a number exists - it’s being able to answer, for every line, “what is this balance, and why is it this number?” The textbook lines have a schedule. The ones that catch people out are the odd balances - a one-off deposit, a bespoke accrual, something in “other debtors” booked months ago. Write the explanation down the first time and carry it forward each month; that institutional memory saves you (and your auditor) hours.

Two kinds of reconciliation

A proof reconciles the ledger balance to an independent list - debtors to the aged receivables report, the bank to the statement. A movement schedule rolls a balance forward: opening + additions − releases = closing, for prepayments, accruals and fixed assets. Almost every balance-sheet line is one or the other.

Line by line in Xero

• Bank & cash: reconcile each account to the actual statement balance (including PayPal/Stripe/Wise). A proof. (See bank reconciliation.)
• Debtors (AR): tie the control account to the aged receivables report; review old debt for provisions. A proof. Revenue timing lives in accrued & deferred income.
• Creditors (AP): tie the control account to the aged payables report. A proof.
• Prepayments & accruals: roll the schedule forward and tie the total to the GL. Movement schedules. (See prepayments & accruals.)
• Fixed assets: reconcile the register (cost, accumulated depreciation, NBV) and post the month’s depreciation. A movement schedule. (See fixed assets & depreciation.)
• VAT & tax control: reconcile to the return position; it should clear back towards nil after filing. A proof. (See reconciling VAT.)
• Everything else: the catch-all accounts (directors’ loan, suspense, other debtors/creditors). These need a written explanation more than a schedule.

When a line won’t reconcile

The usual suspects: something’s been posted directly to a control account instead of through an invoice or bill; a transaction booked with the wrong tax rate; a duplicate; or a timing difference between the GL and the supporting list. Work from the difference - its size and sign usually point straight at the cause.

Frequently asked questions

Why reconcile the balance sheet rather than the P&L?

Because the P&L flows from the balance sheet. If every balance-sheet line is right and explained, the profit and loss almost always falls out correctly. The balance sheet is where errors hide.

How often should I reconcile each account?

Every balance-sheet line, every month. It’s far easier to explain a small monthly movement than to unpick a year of drift later.

What’s the difference between a proof and a movement schedule?

A proof ties the ledger balance to an independent list (bank to statement, debtors to aged report). A movement schedule rolls a balance forward - opening plus additions less releases equals closing.