Xero flags a possible duplicate bill only when the contact, reference and amount all line up. Change one of them and the warning stays silent.
Xero warns about a possible duplicate bill when the contact, reference and amount all match an existing bill, but it doesn't block it. Export your bills and test for references typed differently, same amount and date, repeats within 30 days and two contacts for one supplier.
Xero checks a new bill against existing bills and credit notes and shows a possible duplicate warning. The match needs three things to line up: the contact, the reference and the amount.
It flags the bill for you to look at. It doesn't stop the bill from being approved and paid.
Export a list of your bills for at least the last 12 months, with the contact, reference, date and total for each bill. You can export from the bills list or run a payables report that lists each bill, then save it as Excel or CSV.
Include paid bills as well as bills awaiting payment, and check dates arrive as dates and totals as numbers.
Your system's own check compares fields exactly. Real duplicates usually differ in one small way, so test the export four ways:
The free Online Duplicate Invoice Checker runs all four on up to 1,000 lines in your browser, shows the value at risk and lists each flagged line next to the line it matches. Nothing is uploaded. If you prefer formulas, How to find duplicate invoices in Excel shows how to build the same tests yourself.
Xero's warning can't be made stricter, so the control has to be a process. Make the supplier's own invoice number mandatory in your team's procedure, typed exactly as printed. Treat every duplicate warning as a stop: someone other than the person who keyed the bill compares both documents before it is approved.
Merge or archive duplicate contacts so each supplier has one record.
Hold every HIGH flag that is still unpaid until someone has compared the two documents. For REVIEW flags, confirm whether it is a genuine repeat charge and note why. If a duplicate has already been paid, ask the supplier for a refund or a credit note straight away and track it until the money is back: the duplicate payment audit guide covers the recovery steps.
Run the check before every payment run, not once a year. Duplicates are usually keyed weeks apart, so always include at least the previous 12 months of bills, not just the invoices in this run.
Xero calls supplier invoices "bills" and suppliers "contacts" in every region. The tests are the same in the UK, US, Australia and New Zealand.
Supplier statement to AP ledger. Finds invoices you haven't posted, credit notes still to come, price differences, duplicate postings and payments in transit, and builds the supplier reconciliation. Runs in your browser on your own computer: nothing is uploaded.
Paste or upload your invoice list and see likely duplicates in seconds. Runs in your browser; nothing is uploaded.
The Accounts Payable Control System runs four duplicate-invoice tests, supplier master fraud checks and a three-way match on every invoice, with a payment run release gate that blocks release while exceptions are open. Excel, no macros, one-time price.
No. It shows a possible duplicate warning when the contact, reference and amount match an existing bill. The bill can still be approved.
Usually because the reference was typed differently, the bill had no reference, the amount differed slightly, or it was keyed against a second contact for the same supplier.
Yes. Export paid bills too and run the four tests. Then ask the supplier for a refund or credit for any confirmed duplicate.
Last updated 03 November 2026. General guidance for finance teams; check it against your own policies, systems and local rules.