Xero Balance Sheet Reconciliation: A Practical Process for Finance Teams

A balance sheet reconciliation confirms that every account balance in Xero can be fully explained and substantiated. It is the cornerstone of a reliable month-end close. For many finance teams, Xero makes this harder than it should be — the reports are there, but the workflow for reconciling, documenting, and signing off each account is entirely manual.

Which Accounts Need Reconciling?

Every balance sheet account should be reconciled, but not all carry the same risk. Prioritise in this order: bank accounts (reconcile via Xero's bank reconciliation feature), prepaid expenses (reconcile to your amortization schedule), accrued liabilities (reconcile to your accruals list), accounts payable (reconcile to supplier statements), accounts receivable (reconcile to aged debtors), and fixed assets (reconcile to the fixed asset register).

The Reconciliation Process in Xero

Step 1: Run the Balance Sheet Report

In Xero, run Accounting > Reports > Balance Sheet as of the last day of the period. Export it to PDF or Excel. This is your starting point — the balance for each account that you need to explain.

Step 2: Drill into Each Account

Click on any account balance in the Xero balance sheet to see the underlying transactions. For prepaid accounts, you are looking for the original payment transactions plus the monthly amortization journals. For accrued liabilities, you are looking for the accrual journals and their corresponding reversals.

Step 3: Compare to Your Supporting Schedule

For each balance sheet account, you should have a supporting schedule — a spreadsheet or dedicated tool that shows the expected balance. The Xero balance should match your schedule exactly. If there is a difference, you have a reconciling item to investigate.

Step 4: Document and Sign Off

Save a copy of the Xero balance sheet report and your supporting schedule for each account. Note any differences and how they were resolved. Someone senior should review and sign off the reconciliation before the period is closed.

Common Reconciling Items in Xero

• Bank transactions not yet coded — Xero shows them in the reconciliation queue but they may not appear in account balances correctly
• Timing differences on bank feeds — some banks have a 1-2 day lag
• Unapplied prepayments in Accounts Payable — Xero has a separate "Prepayments" concept in AP which can cause confusion
• Intercompany transactions not yet matched
• Foreign currency revaluation gains/losses not yet posted

Making the Process Repeatable

The goal is a documented, repeatable process that any team member can follow. Write down which accounts are reconciled, in what order, what the supporting evidence is for each, and who reviews it. When you have that, the reconciliation becomes a checklist rather than a judgement call.