What we do
Tools
Industries
Department
How we workLet's talk →
Home/Xero/How Xero Bank Reconciliation Works, Line by Line
Xero

Xero Bank Reconciliation: How to Clear the Reconcile Tab, and What to Do With Stubborn Lines

Every line your bank feed sends waits in that account's Reconcile tab until you match it to something already in Xero, create a transaction for it, or let a bank rule code it. Most lines take one click. The ones that don't are usually hiding a payment that covers several invoices, a part payment, a fee taken off the top, or the same line brought in twice.

How to reconcile in Xero

Open the account's unreconciled lines. On the bank accounts screen, click the reconcile link on the account.

Accounting Bank accounts Reconcile items

Xero's suggestion is right? Click OK on the line.

Nothing suggested, or the wrong thing? Use Find & match to pick one or more transactions, or the Create tab to code a new one.

Same charge every month? Set up a bank rule, and the line shows up already coded.

Manage Account Bank Rules

Working through one Xero bank account

  1. 1

    Confirm the feed is up to date

    On the bank accounts screen, compare the statement balance with the balance in Xero. A feed that stopped a week ago makes everything after it look wrong.

    Watch for: a missing day or a duplicated batch of lines. If the feed itself is the problem, the Xero bank feeds page covers it.

  2. 2

    OK the suggestions that are clearly right

    Xero proposes a match from the amount, contact and reference. Read the contact and invoice number before clicking OK, not just the amount.

    Watch for: two open invoices for the same amount. Xero can suggest the wrong one, and the right one then stays overdue.

  3. 3

    Use Find & match for the rest

    Find & match

    Tick every invoice or bill that one bank line covers. If the total doesn't land exactly, you can split a transaction to take a part payment, or add an adjustment for a bank fee the bank kept.

  4. 4

    Create or cash-code the one-offs

    Create

    For a line with nothing behind it, such as a card fee or a small purchase, pick the contact, account and tax rate on the Create tab. With many uncoded lines, cash coding lets you code them in a grid, if your user role allows it.

  5. 5

    Turn the repeats into bank rules

    Manage Account Bank Rules

    Rent, a software subscription, the monthly bank fee: set the conditions once (payee or reference contains a word, for example) and the coding to apply. Next month the line arrives coded, and you just OK it.

    Watch for: rules that are too broad. A rule on a common word can code the wrong payment just as confidently.

When the answer is sitting in someone's inbox

Xero matches well when the bank line and the invoice share an amount or a reference. It can't see a remittance advice that arrived as a PDF in the accounts inbox, listing six invoice numbers, or a customer reference that only exists in your CRM or job system. That's when reconciling turns into detective work: open the email, find the invoices, then come back and tick them.

n-frames builds the piece that does the reading. Remittances are pulled from the inbox, the invoice numbers are matched, and the payment is recorded against those invoices through the Xero API, so the bank line arrives to a ready-made match you only have to OK. The same lookup works for wires whose payer is only identifiable from another system.

Four reasons a Xero bank line has nothing to match

A deposit that pays several invoices at once

How you'll know: The deposit doesn't equal any single open invoice, but it does equal three of them added together.

Fix: In Find & match, tick each invoice the customer's remittance lists. With no remittance, ask the customer before you guess.

A part payment or a short payment

How you'll know: The deposit is a little less than the invoice, or a round number below it.

Fix: Split the transaction in Find & match so the payment covers what was paid and the rest stays open on the invoice.

A fee taken before the money arrived

How you'll know: An overseas wire or card settlement lands a few dollars under the invoice total.

Fix: Add the fee as an adjustment when you match, coded to bank fees, so the invoice closes in full.

The same lines twice

How you'll know: Lines appear in pairs after someone imported a statement file on top of a working feed.

Fix: Delete the imported duplicates from the account's bank statements list rather than matching them, so the statement balance stays right.

Reconciling in Xero, the details

What is a reconciliation rule in Xero?

Xero calls them bank rules. A rule is a saved set of conditions, such as the payee or reference containing a word, plus the coding to apply. When a bank line meets the conditions, it appears already coded, and you OK it instead of coding the same charge every month.

Can I undo a bank reconciliation in Xero?

Yes. Open the reconciled transaction from the account's transactions list. Under Options, Unreconcile puts the bank line back without touching the transaction, and Remove & Redo unmatches it so you can reconcile it again correctly.

Does Xero support automatic bank reconciliation?

Xero is rolling out automatic reconciliation powered by JAX, its AI assistant. It's opt-in, on Standard, Grow or Growing plans and above depending on your region, and it reconciles lines it's confident about by match, rule, memory or prediction, leaving the rest for you. Without it, suggested matches and bank rules still need your OK.

How do I reconcile multiple transactions at once in Xero?

For one bank line that covers several transactions, use Find & match and tick them all. For many uncoded lines, cash coding lets you code them together in one grid if your user role has access to it. Bank rules cut down the repeats from then on.

What's a bank statement line versus a bank transaction in Xero?

A statement line is the raw entry your bank feed or imported file sends. A bank transaction is the record in Xero that the line is matched to or created as once you reconcile it.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.