Xero bank balance doesn't match your bank statement? How to find the gap

Short answer: Xero shows two balances for each bank account, and they mean different things. The statement balance is the total of the bank feed lines Xero has received. The balance in Xero is what your books say, built from the transactions you have entered and reconciled. A gap between them is almost always unreconciled lines, a duplicate, or a transaction entered in Xero that never went through the bank. Reconcile everything in the account first, then compare again. If the statement balance itself does not match your real bank statement, the bank feed is behind, missing lines, or has duplicates, and the Reconciliation Report will show you where.

Menu names move between Xero releases and differ slightly by region. If a label below does not match your screen, search Xero Central for “reconciliation report”.

The three balances to compare

Balance	Where you see it	What it is
Your bank’s closing balance	Your bank statement for a given date	The real money, as at that date
Statement balance in Xero	The bank account on the Xero dashboard, with an “as at” date	The sum of every statement line the feed (or your imports) brought in
Balance in Xero	The same dashboard widget, and the Balance Sheet	Your books: what has been entered and coded in Xero

Work in that order. First make sure Xero’s statement balance matches the bank on the same date. Then make sure the balance in Xero matches the statement balance. Mixing the two up is why so many people go round in circles.

Compare against a closing balance on a statement date, not the live balance in your banking app. The app usually includes pending card payments that have not reached the feed yet, so it will rarely match on any given afternoon.

Six usual causes

1. Lines waiting to be reconciled. The statement balance includes them; the balance in Xero does not, until you reconcile them. The dashboard shows how many are waiting. This is the cause most of the time.
2. Transactions entered in Xero that never hit the bank. A payment recorded against an invoice when a customer said “it’s on its way”, a bill marked paid from the wrong account, a cheque never banked. They sit in the books, unreconciled, and inflate (or deflate) the balance in Xero.
3. Duplicates. The same money recorded twice: an invoice payment entered by hand, and then a new Receive Money transaction created when the deposit was reconciled. Everything looks reconciled, and the balance is still wrong.
4. Duplicate or missing statement lines. A bank statement imported by file over dates the feed already covered, or a feed that dropped a day. This puts Xero’s statement balance out from the real bank.
5. A wrong starting point. If the feed started partway through a month, or the opening balance was entered wrongly when the account was set up, every later balance is out by the same amount.
6. Reconciled lines that were later removed. Unreconciling or deleting a transaction after the fact sends the line back to the queue and changes the balance in Xero.

Card takings recorded straight into the bank account cause a version of cause 2: the sales are in Xero days before the payout lands, and the payout arrives net of fees. A clearing account fixes it; the cash float guide shows the entries, and how to record a till float and the daily cash-up.

How to find the gap, step by step

1. Reconcile the account. Clear every line in the reconcile tab, coding new spending and matching deposits to invoices. Then compare the two balances again; often the gap is gone.
2. Open the Reconciliation Report for that bank account (in Reports, sometimes called Bank Reconciliation), dated at the end of the last bank statement. It starts from the balance in Xero, lists outstanding payments and receipts that are in your books but not matched to a statement line, and lands on the statement balance. The bank reconciliation report guide explains each line and which outstanding items are normal timing.
3. Read the outstanding items. Anything old in the outstanding list is a suspect: a payment that never happened, or the second half of a duplicate. Open it, check it against the bank statement, and remove or correct it.
4. Check the statement balance against the real bank, month by month. Run the report at each month end and compare its statement balance with the closing balance on that month’s bank statement. The first month that disagrees is where the problem started.
5. Look at the statement exceptions (a tab on the report in newer versions of Xero). It lists lines that were imported more than once, deleted, or reconciled by hand, which is where duplicate and missing feed lines show up.
6. Fix the feed, not the books, for feed problems. Delete a duplicate statement line, or import the missing days from a bank file, instead of adding a balancing transaction. A made-up adjustment hides the problem and makes the next gap harder to find.

If you have a bookkeeper, send them the Reconciliation Report and the bank statement for the month where it first went wrong. That saves them most of the work.

A worked example: a $2,730 gap

A café owner sees this on the Xero dashboard for the business account:

• Statement balance: $18,420, which matches the bank statement closing balance for the same date. So the feed is fine.
• Balance in Xero: $21,150, with 13 items to reconcile.

The books show $2,730 more than the bank. Step by step:

1. Reconciling the 13 lines. Twelve are card spending and bank fees that nobody had coded yet, $2,180 out. One is a customer deposit of $600, matched to their open invoice. Reconciling them moves the balance in Xero by $2,180 − $600 = $1,580, to $19,570. Still $1,150 too high.
2. The Reconciliation Report. It lists one outstanding receipt: a $1,150 payment against an invoice, entered by hand three weeks ago when the customer said they had paid. Their deposit did arrive, but when it came through the feed it was reconciled as a new Receive Money transaction coded to sales, instead of being matched to that invoice payment. Same money, recorded twice.
3. The fix. Remove the duplicate Receive Money transaction, then match the deposit to the existing invoice payment. The balance in Xero drops by $1,150 to $18,420. Both balances agree.

What it meant for the numbers the owner had been reading: the Profit and Loss was missing $2,180 of costs and counting $1,150 of sales twice, so profit for the month was $3,330 too high. If the business is registered for GST or VAT, that duplicate sale also overstated the tax on sales. And the cash figure they were planning around was $2,730 higher than the money that existed.

Why it matters beyond tidiness

Every report you rely on reads from the balance in Xero, not the bank. If it is out:

• Cash looks better (or worse) than it is. The cash runway calculator and Xero’s own short-term cash flow projection start from that balance.
• Profit is wrong. Uncoded spending and duplicates go straight into the Profit and Loss. If profit looks healthy and the bank does not, check the reconciliation before anything else in the profit but no cash guide. Lines reconciled to Suspense to get them off the list are left out of profit altogether until they are recoded (suspense account in Xero).
• The Balance Sheet does not tie up. Checking that the bank figure matches the statement is the first of the monthly checks in the Balance Sheet guide.
• Debtors look wrong. An invoice payment entered for money that never arrived makes a customer look paid. The who owes me money guide covers getting that list right.
• Year-end figures start from it. Your accountant works from the trial balance, and an unreconciled bank account is one of the first things they flag. The Xero trial balance guide has eight checks to run before you send it, with the bank first.

A short weekly reconcile, a few lines at a time, is far easier than a month of lines at once, and it means a gap like the one above gets caught while you still remember what each payment was.

Common questions

Why does Xero say the account is reconciled but the balance is still wrong? Reconciled only means every statement line was matched or coded. A duplicate (one copy reconciled, one left outstanding) or a wrong opening balance survives a full reconcile. The outstanding items on the Reconciliation Report show it.

Can I just add an adjustment to make it match? You can, but it puts an unexplained number into your books and usually into your profit. Find the cause first; if a small difference is left after a real search, agree with your accountant how to post it.

My statement balance in Xero is behind my bank. Is something broken? Feeds usually arrive a day or so behind, so check the “as at” date first. If lines are missing for longer than a few days, check the feed connection in Xero, and import the missing days from a bank file if needed.

Knowing your cash every Monday

ReportPilot reads your Xero figures and sends a short plain-English email every Monday, starting with cash in the bank and how it has moved since the end of last month. Because it reads your books, the number is only as good as your reconciliation, which is one more reason to keep it current: a reconciled account means Monday’s figure is the real one. If the bank accounts in Xero add up to zero or less, the email says so and asks whether you are using an overdraft or the bank feeds are behind. It asks Xero for read-only access, so it can read your accounts but never change them, and there is a 14-day free trial with no card.