Xero Bank Reconciliation Not Balancing
Quick answer
A mismatch is nearly always a missing, duplicated, misdated or unrecorded item. Compare the reconciliation report with your statement to find it.
Most likely fix: Run the reconciliation reports
How to fix it
Try these in order — the most common fix is first.
1. Run the reconciliation reports
- Run Bank Reconciliation Summary and Bank Reconciliation Detail
- Compare against your bank statement line by line
Did this fix it?2. List unreconciled items
- Go to Accounting > Bank Accounts > Account Transactions
- Filter Status to Unreconciled
Did this fix it?3. Check dates and fees
- Make sure the date matches the statement end date
- Record bank fees, interest and charges
- Check for misdated transactions
Did this fix it?4. Verify opening balance
- Confirm it equals the previous reconciled closing balance
Did this fix it?5. Park unclear items
- Use Reconcile Later for disputed lines and finish the rest
Did this fix it?
Symptoms
Statement balance and Xero balance differ after reconciling, or the Bank Reconciliation Summary shows unexplained differences.
Why it happens
- Missing or duplicate statement lines
- Reconciliation date not matching the statement end date
- Unrecorded bank fees or interest
- Foreign exchange differences on multicurrency accounts
- Wrong opening balance
This guide also covers
- xero reconciliation not balancing
- xero reconciliation difference
- xero bank reconciliation problems
Still not working?
If Xero keeps failing, you're not alone. See every Xero problem users report or the alternatives people switch to.
Done fighting Xero? Our small team builds your own Xero alternative, or any software you need: web, mobile, games, desktop. Price agreed together.
Talk to us