How to clean up a messy Xero file

Duplicate invoices, income counted twice, a clearing account nobody understands, a bank reconciliation that never quite balances. If your Xero file has drifted from reality, here’s how to bring it back — calmly, and without touching your live books.

Rule one: work on a copy, never the live file

The fastest way to turn a messy Xero file into a disaster is to start “fixing” it live. Delete the wrong payment, force a reconciliation, or bulk-edit a clearing account and you can make the numbers worse in ways that are painful to unwind. So before you change anything: export your data — or take a clone — and do all the investigation on that copy. Your live file keeps running. You only apply changes once you know exactly what each one does and why.

Rule two: the bank is the truth

Your accounting software can be wrong. Your bank statement can’t — money either came in or it didn’t. Every cleanup should work backwards from the bank: for each real deposit, which invoice (or invoices) did it actually pay? Anything in Xero that doesn’t tie back to a real bank movement is a candidate problem. Use the downloaded bank statement (the PDF, not just the live feed — feeds have gaps and timing quirks) as your source of truth.

The five things that quietly break a Xero file

• 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 or years.
• 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.
• Blanket write-offs. The variance gets dumped into a single adjustment so the balance “matches” — but now nobody can see what was actually wrong.

A safe order to fix it in

1. 1. Pull everything. Bank statement, the full Xero export, and every payment-processor history. Put them side by side.
2. 2. Cross-reference. Match each entry against every other source. The unmatched items on each side are your investigation list.
3. 3. Classify before you touch anything. Tag each entry: keep, duplicate, phantom, migrate, or investigate. Don’t action anything you’re unsure of.
4. 4. Reverse by name, not in bulk (see below).
5. 5. Verify against the bank. When you’re done, the file should match the real bank balance to the cent.

Reverse problems by name, not with a blanket write-off

This is the difference between a cleanup that survives an accountant’s review and one that doesn’t. Xero blocks deleting a reconciled transaction, so the safe pattern is an offsetting entry that references the original — same amount, same account, backdated to the original period — so the problem is cancelled with a complete audit trail and your P&L stays accurate for each period. A single blanket adjustment hides the problem; named reversals show your working.

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, a previous fix that made things worse — is where Extrua Reconcile helps: the whole cleanup on a read-only copy, every change evidenced.

FAQ