Bank Reconciliation in Xero: Find & Match, and Where It Breaks

Xero reconciles differently from most accounting software: instead of a single end-of-month reconcile screen, it asks you to clear the bank feed continuously through "Find & Match" on the Bank Reconciliation tab. That is a genuinely good habit when it works, and a genuine headache when the feed drops transactions or duplicates them.

How Xero's reconciliation screen works

Open an account's Bank Reconciliation tab and Xero shows a running list of bank statement lines down the left, each waiting to be matched, and lets you either accept a suggested match against an existing invoice or bill, create a new transaction from the line directly, or split it. There is no single "ending balance" you type in the way QuickBooks asks for one; instead the statement balance and Xero balance are shown side by side at the top and should read the same when every line is cleared.

Find & Match, in order

1. Xero suggests matches automatically when a bank line's amount and rough date line up with an unreconciled invoice, bill, or existing spend/receive money transaction.
2. For anything without a suggestion, use Find & Match to search open invoices and bills manually by amount, contact or reference.
3. For genuinely new transactions (bank fees, one-off purchases with no bill on file), create the transaction directly from the bank line rather than entering it separately and hoping Xero matches the two later.
4. Use bank rules for recurring, predictable lines (payroll processor debits, a fixed monthly subscription) so they code themselves correctly every time, but audit those rules periodically. A stale rule silently miscoding a changed subscription price is a common, quiet source of drift.

The Xero-specific problems worth knowing about

Unreconciled statement lines pile up silently

Because Xero's model is continuous rather than a monthly event, it is easy for a handful of odd lines to sit unmatched for months without anyone noticing, since nothing forces a formal close. The Xero balance and statement balance can drift further and further apart if nobody checks the Bank Reconciliation Summary report on a fixed schedule.

Bank feed gaps and duplicate feeds

Direct bank feeds occasionally miss a few days of transactions, most often around a bank's own system maintenance windows, and Xero has no way to know a gap exists unless you compare against the actual statement. Reconnecting a feed after an outage can also, in some cases, re-import transactions that were already entered manually, creating duplicates that inflate both sides of the account.

Multi-currency accounts

For accounts in a foreign currency, Xero converts using its own daily exchange rate, which will not exactly match the rate your bank used for a given transaction. Small differences from this are normal and get posted to a realized currency gain/loss account; treat these as expected variance, not reconciliation errors, but keep the two separate in your review so a real error is not written off as an FX rounding difference.

A periodic sanity check, even with continuous reconciliation

Continuous matching is not a substitute for a monthly checkpoint. At month end, export the account's full transaction list from Xero and the actual bank statement for the same period, and run them independently through the free bank reconciliation tool. Because the tool works from the raw CSVs rather than trusting the running Xero balance, it will surface a feed gap or a duplicate immediately as an unmatched line, with the reason shown, rather than as a residual difference you have to go hunting for.

Bank rules are a lever, not a set-and-forget

• Review bank rules quarterly; a vendor changing its billing descriptor breaks a rule silently.
• Never let a rule auto-code a bank fee or NSF-type line as ordinary revenue or expense without review the first time it appears.
• Keep rules narrow (specific payee text) rather than broad (any debit over a round number).

The underlying discipline is the same regardless of which software runs the day-to-day matching: see how to do a bank reconciliation for the mechanics, and common reconciliation mistakes for the errors that show up across every platform, Xero included.