How to fix duplicate invoices in Xero
Duplicate invoices are one of the quietest ways a Xero file drifts — they inflate your income, your debtors and the GST you report. Here’s how to find them and fix them without breaking your bank reconciliation.
Why duplicates appear
The usual causes: an import or integration that ran twice, a manual invoice raised alongside one auto-created by a connected app, or the same job billed out of two systems that both sync to Xero. None of it is dramatic — which is exactly why it goes unnoticed until the numbers look off.
Find them first
Sort invoices by contact, amount and date and look for same-customer, same-amount pairs close together. Cross-check against the bank: a real sale has one matching deposit. If two invoices map to a single payment, one is almost certainly a duplicate. Work from a copy of your data so you can investigate freely without changing anything live.
Fix them safely
Don’t bulk-delete. If an invoice is unpaid and unreconciled, voiding it is clean. If it’s been paid or reconciled, deleting it breaks the bank rec — instead, credit or void it and reverse the linked payment by name, referencing the original, so the audit trail stays intact and the period stays accurate. Then confirm the bank still reconciles to the cent.
Mind the GST
A duplicated sale overstates income and the GST collected on it, so clearing duplicates can change a BAS you’ve already lodged. Any BAS amendment is your accountant’s call — fix the books correctly first, then let them handle the lodgement side.
Too many to chase by hand?
Extrua Reconcile finds and reverses duplicates by name on a read-only copy, with evidence for each.
FAQ
Can I just delete a duplicate invoice in Xero?
Only if it's unpaid and not reconciled. Once an invoice is paid or the payment is reconciled, deleting it breaks the bank rec — you void or credit it instead, and reverse the linked payment by name, so the audit trail stays intact.
How do duplicate invoices even happen?
Usually an import run twice, a manual invoice plus an auto-created one from an integration, or the same job billed from two systems. They're easy to create and easy to miss.
Do duplicates affect my GST?
Yes — a duplicated sale overstates income and the GST collected on it, which can push your BAS too high. That's why finding them matters beyond just a tidy ledger.