What’s Actually Happening
You close the file for the day and everything is reconciled. The bank account matches, the dashboard is clean, and you move on. The next morning you open Xero and suddenly the reconciliation is out. A small difference appears, or previously matched transactions no longer line up.
When people search “reconciliation not balancing in Xero” or “why did my reconciliation change,” it’s usually because nothing obvious was edited. That’s what makes it frustrating. It balanced yesterday. So what changed overnight?
In most cases, the answer is simple but hidden. Something new entered the system or something old was altered after reconciliation was completed.
Where It Breaks
The most common cause is delayed bank feed transactions. A feed reconnects or updates overnight and imports transactions dated earlier in the period. Those new entries sit unreconciled and shift the balance.
Another common issue is duplicate bank transactions after a CSV import. If you manually uploaded transactions during a bank feed disruption and the feed later catches up, you can end up with duplicates that weren’t visible the day before.
Backdated edits are another trigger. Someone unreconciles and redoes a transaction, changes the account code, or adjusts GST coding. Even small changes affect the running balance. In some cases, currency rounding differences or split allocations also alter totals without being immediately obvious.
Reconciliation in Xero is dynamic. It reflects the current state of the ledger, not the state it was in yesterday.
The Takeaway
If reconciliation was balanced yesterday but is wrong today, assume something was added, duplicated, or edited. Check recent bank feed activity, review any CSV imports, look for unreconcile and redo actions, and confirm no backdated journals were posted.
Reconciliation doesn’t break randomly. It changes because the transaction layer changed. Once you identify what moved, the balance usually falls back into place without guesswork.
