Why your bank balance doesn’t match Xero
Your bank account says one thing and Xero says another. It’s one of the most common signs a file has drifted — and it’s almost always a handful of causes. Here’s what’s usually behind it, and how to bring the two back into line.
The usual culprits
- Income counted twice. A payment recorded against the invoice, then again when the bank deposit (or a processor payout) lands.
- A clearing account that never clears. An “undeposited funds” or clearing account that’s collected entries for months.
- Force-matched reconciliations. Statement lines matched to whatever had the same amount, not the actual transaction.
- Payments deleted in a previous fix. Leaving invoices falsely showing as unpaid.
- Plain feed gaps. The live bank feed missed or duplicated a line.
Find the truth: start from the bank
Download the actual bank statement (the PDF) for the period — that’s your source of truth. Money came in or it didn’t; there’s no opinion in it. For every real deposit, ask: which invoice did this actually pay? Anything in Xero with no matching bank movement is a candidate problem; any bank line with nothing behind it in Xero is a gap to explain.
Fix it safely
Work on a copy or export, never the live file. Reverse each problem by name — an offsetting entry that references the original and is backdated to the right period — rather than a single blanket adjustment that hides what was wrong. When you’re done, the file should match the bank to the cent. If it doesn’t, something’s still off.
When to get help
A few months of drift you can usually work through yourself. Years of it — a clearing account in the tens of thousands, a BAS you suspect is overstated — is where Extrua Reconcile helps: the whole cleanup on a read-only copy, every change evidenced.
Bank and books miles apart?
We’ll find why on a read-only copy — and tell you honestly what it’ll take.
FAQ
Why is my Xero balance higher than my actual bank balance?
Usually because income has been recorded more than once — a payment booked against the invoice and again when the bank deposit or a card-processor payout landed. Tracing each real deposit to the invoice it paid surfaces the duplicates.
Should I just post an adjustment to make it match?
Avoid a single blanket adjustment — it makes the balance match but hides what was actually wrong, and it won't survive an accountant's review. Reverse each problem by name instead, referencing the original entry.
Is the live bank feed reliable for this?
Use the downloaded bank statement (PDF) as the source of truth. Live feeds have gaps, duplicates and timing quirks — fine day to day, not for proving what really happened.