Xero Reconciliation Best Practices

In Xero, the word reconciled means less than most people think. It means a statement line has been matched or coded to something — not that it was coded to the right place, and not that the account actually balances. A file can be fully reconciled on screen and still be wrong everywhere it matters.

What clicking OK actually does

The reconciliation screen gives each statement line a few paths. Match links the line to a transaction that already exists in Xero, such as an outstanding invoice or bill. Create makes a brand new spend or receive money transaction on the spot. Transfer moves money between your own bank accounts.

The most common mistake we fix is Create used where Match belonged. If a customer pays an invoice and the payment is created as fresh income instead of being matched, the sale is counted twice and the invoice sits open forever, overstating both revenue and debtors. The reverse happens with supplier bills. A scan of aged receivables and payables for invoices that should have cleared long ago usually reveals it.

Bank rules and cash coding, carefully

Bank rules let Xero suggest coding automatically when a statement line meets conditions you define, and cash coding lets you reconcile in bulk. Both are genuinely useful, and both scale mistakes beautifully. A rule with a loose condition — any line containing a common word — will happily code things it was never meant for, and the tax rate baked into the rule goes along for the ride. Keep rule conditions tight, review what a rule has caught rather than trusting it, and treat cash coding as a power tool that deserves a second look afterwards.

Reconciled is not reviewed

A monthly habit worth building: confirm the statement balance in Xero agrees with the closing balance on your actual bank statement, then run Xero's reconciliation report and look at anything outstanding. Unpresented payments that never clear, deleted statement lines, and manually entered transactions that never matched a bank line all hide here. If the balances do not agree, the books are not reconciled, no matter how green the screen looks.

Lock the past

Once a period is finalised — the BAS lodged, the year signed off — set a lock date in the financial settings. Without one, an accidental edit to a reconciled transaction quietly changes figures that have already been reported, and nobody is told. With one, Xero simply refuses the change, and the correction happens in the current period, where it belongs.

Why does my balance in Xero differ from my actual bank balance?

Usually unreconciled statement lines, duplicated or deleted lines from a feed problem, or transactions entered manually that never matched a bank line. The reconciliation report narrows it down.

Are bank rules safe to use?

Yes, for genuinely repetitive transactions. Keep the conditions specific, check the tax rate inside the rule, and review what it catches from time to time.

What does a lock date do?

It stops anyone editing transactions dated on or before that date. Setting one after each BAS and at year-end protects figures that have already been lodged.