Xero tells you the account is reconciled and the balance still does not agree with the statement. Or the Reconciliation Report shows a difference you cannot place. Either way the instinct is to start unpicking the month, and that is almost always the wrong first move.
A Xero reconciliation difference nearly always comes from one of five things: a manually added or edited bank statement line, a transaction deleted or voided after reconciling, duplicates from an imported statement, a payment allocated to the wrong account, or an opening balance that was never right. Find the cause before changing anything.
Reconciliation out and month-end waiting? WhatsApp us the difference and the period and we will help you place it.
Quick Summary — Where to Look
| Symptom | Likely cause | Where to check |
| Small odd amount | Duplicate or part-allocated payment | Bank Reconciliation Summary |
| Difference appears suddenly | Something edited after reconciling | Account Transactions, edited items |
| Difference from day one | Opening balance wrong | Conversion balances |
| Statement lines missing | Import gap or feed downtime | Statement line dates |
| Two similar lines | Imported over a feed | Duplicate statement lines |
💡 TaxKitab Tip: Run the Bank Reconciliation Summary before you touch a single transaction. It separates the difference into statement lines not in Xero and Xero transactions not on the statement, which tells you immediately which side the problem is on. Most people skip it and start opening individual transactions, which is how a two-hour job becomes a two-day one. The report takes thirty seconds and usually points straight at the cause.
Start With the Reconciliation Report
Xero’s Bank Reconciliation Summary splits the difference for you. It shows the statement balance, the balance in Xero, and what sits between them — statement lines that have not been accounted for, and transactions in Xero that do not appear on any statement line.
Read which side the difference sits on before doing anything else. A difference made of unreconciled statement lines is a completely different problem from one made of unpresented payments.
If the report balances but your own statement does not, the problem is in the statement lines themselves rather than in the reconciliation.
Something Was Edited After Reconciling
The most common cause, and the least obvious.
A reconciled transaction that is later edited, voided or deleted breaks the reconciliation retrospectively. The reconciliation still shows as complete, but the underlying figures have moved.
This happens routinely when someone corrects a coding error weeks later, or voids an invoice that was already matched to a payment.
Xero records who changed what and when. Check the Account Transactions report for the period, sorted by date modified rather than transaction date, and look for anything touched after the reconciliation date.
Duplicate Statement Lines
If a statement was imported while the bank feed was also running, the same transactions can appear twice.
They are easy to spot once you look: two identical lines, same date, same amount, one reconciled and one sitting unreconciled.
Delete the duplicate statement line rather than the transaction it was matched to. Deleting the wrong one removes a legitimate entry and moves the problem rather than fixing it.
Manually Added Statement Lines
Xero allows a statement line to be added by hand. It is occasionally necessary and frequently misused — someone adds a line to make a reconciliation balance rather than finding the real cause.
A manually added line that does not correspond to anything on the actual bank statement will make the reconciliation agree and the bank balance wrong. Since it looks identical to a fed line, it goes unnoticed for months.
If a difference appeared without explanation, check for manually added statement lines in the period.
Payments Allocated to the Wrong Account
A payment recorded against the wrong bank account leaves one account short and another over by the same amount.
The signal is two accounts out by identical figures in opposite directions. If you are reconciling one account and ignoring another, you will only see half of it.
Opening Balances
If the difference has existed since the account was set up, no amount of work on this month will fix it.
Conversion balances entered when Xero was first configured are a common source. So is an account added later with an opening balance taken from the wrong date.
Check the balance as at the conversion date against the actual statement for that date. If they disagree, that is your difference, and it needs correcting at source rather than in the current period.
What Not to Do
Do not un-reconcile a whole period to start again. You lose the audit trail and usually recreate the same problem.
Do not create a balancing journal to make the difference disappear. It will sit in suspense, surface at year end, and by then nobody will remember what it was.
And do not delete statement lines you cannot identify. Investigate first — an unidentified line is information, not noise.
When a Xero Reconciliation Difference Becomes a Bookkeeping Problem
A one-off reconciliation difference can often be traced by reviewing the affected statement period. When differences recur, span several months or involve multiple bank accounts, the issue may be part of a wider bookkeeping problem. Missing transactions, incorrect allocations, duplicate entries and opening-balance errors can affect month-end reporting even after the bank account appears reconciled.
In these cases, the priority is not simply to make the reconciliation agree. The underlying bookkeeping records should also be reviewed and corrected.
Frequently Asked Questions
Xero says reconciled but the balance is wrong. How?
Something was edited, voided or deleted after the reconciliation was completed. The reconciliation flag does not update retrospectively.
Where do I see the actual difference?
The Bank Reconciliation Summary. It separates unreconciled statement lines from transactions not on the statement.
Can I just post a journal to clear it?
You can, and you should not. An unexplained balancing journal becomes a year-end problem with no context attached.
We imported a statement and now everything is doubled?
Duplicate statement lines from importing over a live feed. Delete the duplicate statement line, not the underlying transaction.
The difference has been there since we started using Xero?
Check the conversion balances. An opening balance entered incorrectly will never resolve through current-period work.
Should I un-reconcile the month and redo it?
Rarely. Identify the cause first — un-reconciling loses the audit trail and usually reproduces the same difference.
What causes a difference in Xero bank reconciliation?
A Xero bank reconciliation difference can come from missing or duplicated statement lines, transactions that were changed or removed, incorrect opening or conversion balances, payments recorded against the wrong bank account, or differences between the bank statement and the data imported into Xero. Start with the Bank Reconciliation Summary to identify where the difference sits.
How do I find a reconciliation difference in Xero?
Start with the Bank Reconciliation Summary and compare the statement balance with the balance in Xero. Check for missing or duplicated statement lines, transactions that were changed or removed, and differences in the opening or conversion balance. Once you identify the period and side of the difference, investigate individual transactions.
Why does my Xero bank balance not match my bank statement?
our Xero bank balance may not match the bank statement because transactions are missing, duplicated, changed, removed or recorded against the wrong account. An incorrect opening balance can also create a difference that continues from the start of the account. Compare the statement balance and Xero balance before changing current-period transactions.
Should I create a journal to fix a Xero reconciliation difference?
Do not create a balancing journal simply to make the difference disappear. First identify why the bank statement and Xero balance disagree. A journal may be appropriate for a genuine accounting adjustment, but using one to hide an unexplained reconciliation difference can leave the underlying error unresolved.
References
- Xero documentation on bank reconciliation, the Bank Reconciliation Summary and conversion balances
- Xero guidance on editing and removing reconciled transactions
⚠️ Report names, screen layouts and available actions change with platform releases and differ by plan. Check current Xero guidance for your own version.
Related Reading: QuickBooks Bank Feed Not Updating: Why It Stops and How to Fix It · Month-End Close Checklist for a Small Business · Catch-Up Bookkeeping: What Happens When You Are a Year Behind
Call or WhatsApp: +91 7448200422 Email: info@taxkitab.com See our Accounting & Bookkeeping service, or explore Global Desk if your business sits outside India.
