Bookkeeping
Xero bank reconciliation: how it works and how to fix it
November 19, 2026 · 10 min read

Quick answer
In Xero, reconciling means pairing each bank statement line (what the bank says happened) with an account transaction (what you recorded), by matching an existing invoice, bill or payment, or creating a new spend, receive or transfer transaction. You're done when every line is reconciled and the Bank Reconciliation Summary ties to your real bank balance. Most mistakes come from creating a transaction you should have matched, and are fixed with Unreconcile or Remove & Redo.
You open Xero and the bank panel says 14 items to reconcile. The statement balance doesn't match the balance in Xero, neither matches your bank's app, and you're fairly sure you reconciled last month.
That's a normal Xero morning. The software is good at reconciliation, but a couple of its buttons are easy to press for the wrong reason, and a wrong click doesn't throw an error. It just quietly doubles your revenue or hides a bank fee.
This post covers how reconciliation works inside Xero, the report that proves it's right, and how to fix the common mistakes. For the general idea (deposits in transit, outstanding checks, why it matters), start with our bank and credit card reconciliation guide.
How does bank reconciliation work in Xero?
Xero keeps two lists for every bank account, and reconciling means pairing them up.
- Bank statement lines come from the bank, through a bank feed or a file you import. They show on the left of the Reconcile tab.
- Account transactions are what you (or Xero) recorded: invoice and bill payments, spend money and receive money transactions, transfers. They show on the right.
So the bank panel shows two balances. The Statement Balance is your opening balance plus every statement line imported. The Balance in Xero is your opening balance plus every account transaction, and it's the number on your balance sheet. Once everything is paired, they agree apart from timing items like an uncleared check.
For each statement line you do one of three things:
- Match it to something already in Xero, like a customer's payment against an open invoice. Xero suggests the closest match and you click OK. If it's wrong, Find & Match lets you search, pair one deposit with several invoices, or add a line for a bank fee.
- Create a new transaction on the Create tab when nothing exists yet. Bank fees, a software subscription, interest earned.
- Transfer when money moved between two of your own accounts, like paying the company card from checking. Create it in one account; Xero adds the other side, so in the second account you just click OK.
No idea what a line is? The Discuss tab lets you leave a note for your bookkeeper instead of guessing.
When should you use bank rules?
Bank rules tell Xero how to code repeat lines you'll never raise a bill or invoice for: the monthly bank fee, parking, a recurring transfer to savings. When a new line fits a rule's conditions (payee, description, amount, reference), Xero suggests a filled-in spend, receive or transfer transaction. You still click OK.
Xero checks rules in the order they're listed, so a broad rule near the top can grab lines meant for a narrower one. And never write a rule for something you invoice: a rule that books a client's payments straight to sales leaves the invoice open forever and counts the revenue twice. Xero's own guidance is to use Find & Match for anything tied to an existing transaction.
On some plans Xero now reconciles lines automatically when it's highly confident. Handy, but you still check what it did and prove the balance.
How do you know the reconciliation is actually right?
Clearing the Reconcile tab feels like the finish line. It isn't. The proof is the Bank Reconciliation Summary, which lives in the Bank Reconciliation report pack under Reporting, All reports. The pack also holds the Bank Statement and Statement Exceptions reports.
The summary walks from the Balance in Xero, through outstanding payments and receipts (recorded but not yet reconciled) and unreconciled statement lines, to the Statement balance (calculated). At the top you can type your actual bank balance under Bank statement ending balance, and Xero shows any gap as Calculated balance out by.
You want the out-by figure at zero, few or no unreconciled lines, and outstanding items that are real timing differences (a check that hasn't cleared), not something from six months ago.
If the out-by figure isn't zero, the problem is in the statement lines (a duplicate, deleted or missing line). If it's zero but the Balance in Xero is off, the problem is in your account transactions.
A worked example: one month in Xero
Say you run a hypothetical 10-person marketing agency, and you're reconciling the business checking account for October in Xero. Your bank's app shows $36,420 at October 31. Xero's Bank Reconciliation Summary, before any fixes, says this:
| Line on the report | Amount | What's behind it |
|---|---|---|
| Balance in Xero | $36,475 | Every account transaction recorded so far |
| Plus outstanding payments | +$2,300 | A $1,760 supplier check that hasn't cleared, and a $540 software charge entered twice |
| Plus unreconciled statement lines | −$855 | A $45 bank fee, a $2,310 credit card payment, and a $1,500 client deposit that appears twice |
| Statement balance (calculated) | $37,920 | |
| Bank statement ending balance (typed in) | $36,420 | From the bank's app |
| Calculated balance out by | $1,500 | Xero's statement is $1,500 too high |
Step 1: fix the statement lines. The Statement Exceptions report flags the $1,500 deposit as a potential duplicate: someone imported an October CSV after the feed had already brought that week in. Delete the duplicate line and the Statement balance drops to $36,420, matching the bank.
Step 2: fix the account transactions. The $540 subscription was typed in as a spend money transaction and created again from the statement line. The extra copy will never clear, so delete it. Balance in Xero goes up $540.
Step 3: clear what's left. Create the $45 bank fee (a good candidate for a bank rule). Record the $2,310 card payment as a transfer, not an expense. The $1,760 check is genuine and stays outstanding until November's statement.
From Balance in Xero to the real bank balance
Hypothetical marketing agency, business checking, October 31
- Raises balance
- Lowers balance
- Total
Hypothetical example. 36,475 + 540 − 45 − 2,310 = 34,660. Add back the $1,760 check that hasn't cleared and you get 36,420, the balance in the bank's app.
Show the numbers
| Balance in Xero | $36,475 |
| Duplicate deleted | +$540 |
| Bank fee | −$45 |
| Card payment | −$2,310 |
| Xero after fixes | $34,660 |
| Uncleared check | +$1,760 |
| Bank balance | $36,420 |
One thing the report can't show you: a $4,200 client payment from mid-October was reconciled with Create, coded straight to Sales, instead of matched to the open invoice. The bank balance is fine, but October revenue is overstated by $4,200 and the invoice still shows as unpaid. You use Remove & Redo on the receive money transaction, then match the line to the invoice.
That's the lesson in one example: a reconciliation can balance to the penny and still be wrong. The report proves cash. It doesn't prove coding.
Unreconcile, Remove & Redo or delete: which fix do you need?
Pick the wrong one and you either leave a duplicate behind or delete something you needed.
Keep the transaction
Unreconcile
- Removes the link between the statement line and the account transaction
- Both stay in Xero, ready to pair again
- Use it when the transaction is correct but matched to the wrong line
- Open the transaction, then Options, Unreconcile
Delete the transaction
Remove & Redo
- Deletes the account transaction (spend, receive, transfer or payment)
- The statement line goes back to the Reconcile tab
- Use it when the transaction itself is wrong, like a receive money that should have matched an invoice
- Open the transaction, then Options, Remove & Redo
Duplicates only
Delete statement line
- Removes the bank's line, which changes the Statement Balance
- Only for a line imported twice
- Deleted lines can be restored from Bank Statements
- On the Reconcile tab, Options, Delete statement line
You'll need the administrator role, or standard with bank account access, to unreconcile, delete or restore lines.
What if statement lines are missing, or the opening balance is wrong?
Missing lines. Feeds only bring in cleared transactions, so the last day or two may not be there yet. Refresh the feed first. If a stretch is missing (often between your Xero start date and the day the feed connected), compare the Bank Statement report with your bank, then export those dates from online banking and import them as a file.
Mark as Reconciled creates a statement line for you. Use it only when you truly can't import the bank's data, because if the real line arrives later you'll have a duplicate.
Opening balance. If the Statement Balance has been off since day one, check the opening figure. For an account you had before Xero, the conversion balance should be the bank's closing balance for the day before your conversion date, not your old trial balance figure, which may include uncleared checks. If a gap appeared later, find the last month-end where Xero and the bank agreed and work forward month by month.
How do lock dates protect a reconciled month?
Once a month is reconciled and reviewed, lock it. In Xero that's Accounting, Accounting settings, Financial settings, then a date under Lock Dates. After that, nobody can add or edit transactions dated on or before it. You can lock all users, or everyone except administrators.
Unreconciling or deleting an old line changes reports you've already sent to your CPA or lender. A lock date stops that happening by accident. It's the Xero version of the closing date we cover in the month-end close checklist.
Common Xero reconciliation mistakes
On the Reconcile tab
- Using Create for a customer payment instead of matching the invoice
- Coding a credit card payment as an expense instead of a transfer
- Writing a bank rule for income you invoice
With the statement lines
- Importing a CSV over dates the feed already covered, creating duplicate lines
- Using Mark as Reconciled, then the real line arrives later
When should you get help?
With one checking account, one card, a few dozen lines a month and the summary run monthly, doing this yourself is completely reasonable. It's an hour, not a day.
Get help when the balances haven't matched for a while and you don't know when it went wrong, when months are unreconciled (see our plan for catching up), or when you suspect revenue is double counted. Untangling a year of duplicates is slow work.
Fintrix Consulting works in your own accounting software, in your name, and QuickBooks Online and Xero are the systems we see most. Every bank and card account is reconciled monthly and closed by the 10th; here's how our bookkeeping works. Still deciding between the two platforms? Our QuickBooks Online vs Xero comparison covers that.
Frequently asked questions
What's the difference between Statement Balance and Balance in Xero?
Statement Balance is Xero's copy of the bank, built from imported statement lines. Balance in Xero is built from the transactions you recorded and is what your balance sheet shows. Once everything is reconciled they match, apart from items that haven't cleared.
Why does a customer's invoice still show as unpaid after I reconciled the payment?
The statement line was probably reconciled with a new receive money transaction instead of being matched to the invoice. Open the reconciled transaction, use Remove & Redo to delete it, then match the statement line to the invoice.
Should I use Mark as Reconciled for missing transactions?
Only if you can't get the data from the bank at all. Importing the missing dates as a file is better. Mark as Reconciled creates its own statement line, and if the real line is imported later you'll have a duplicate.
How often should I reconcile in Xero?
At least monthly, with the Bank Reconciliation Summary at month end. Weekly is easier, because you can still remember what each line was.
The bottom line
Reconciling in Xero is mostly matching: pair every bank line with the right transaction and create new ones only when nothing exists. An empty Reconcile tab isn't the proof; the Bank Reconciliation Summary tied to your real bank balance is. Know which undo button does what, and lock each month once it's reviewed.
Sources
- Reconcile your bank account (Xero Central)
- Find transactions to match to bank statement lines (Xero Central)
- About bank rules (Xero Central)
- Bank Reconciliation reports (Xero Central)
- Why are the Statement Balance and Balance in Xero different? (Xero Central)
- Compare the statement balance in Xero to your actual bank balance (Xero Central)
- Fix an incorrectly reconciled bank statement line (Xero Central)
- Unreconcile an account transaction (Xero Central)
- Find and remove duplicate bank statement lines (Xero Central)
- Delete or restore a bank statement line (Xero Central)
- Identify and fix missing bank transactions (Xero Central)
- Manually mark a transaction as reconciled (Xero Central)
- Enter opening bank account balances (Xero Central)
- Set up or remove lock dates, US (Xero Central)
- Bank reconciliation software (Xero US)
This article is general information, not advice for your situation. Rules change and details matter, so talk to us or your CPA before acting on it.
More articles
- Who should have access to your accounting system?
November 20, 2026
- 25 bookkeeping terms every business owner should know
November 20, 2026
- The most expensive bookkeeping mistakes, ranked by cost
November 20, 2026
Have a question about this article?
Ask us. A real person will reply by email within one business day. Your question isn’t published.
Ready for books you can trust?
Book a free 30-minute consultation. We'll review where your finances stand today and show you exactly how we'd help.