QuickBooks Online can warn you about a repeated bill number, but only if the setting is on and only if the number matches exactly.
QuickBooks Online can warn when a bill number has been used before, but only if the setting is switched on, and it only catches exact matches. Export your bills, then test for the same number typed differently, same amount and date, repeats within 30 days and duplicate vendor records.
QuickBooks Online has a setting called Warn if duplicate bill number is used. When it is on, QuickBooks shows a warning as you save a bill whose bill number has already been used. You find it under Settings > Account and settings > Advanced > Other preferences.
It is a warning, not a block. Whoever is keying the bill can read it, dismiss it and save the bill anyway.
Run a report that lists every bill with the vendor, bill number, bill date and amount, such as a transaction list filtered to bills, and set the date range to at least the last 12 months. Use the report's export option to export it to Excel, then keep just those four columns. Make sure dates come through as dates and amounts as numbers.
Include bills that are already paid. The original of a duplicate is very often in an earlier, paid batch.
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.
Turn on Warn if duplicate bill number is used if it is off. Then make it a rule that nobody enters a bill without the supplier's own invoice number, typed exactly as printed, and that a duplicate warning is always escalated rather than dismissed.
Clean up duplicate vendor records too: merge or make inactive the second record so new bills can only go to one.
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.
QuickBooks Online uses "bills" and "vendors" in both its UK and US editions. UK teams often call them purchase invoices and suppliers; the check is the same.
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. Its duplicate bill number setting warns when a bill number has been used before, but the person entering the bill can still save it.
Usually because the setting was off, the bill number was typed differently, or the bill was entered against a second record for the same vendor.
At least 12 months of bills, including paid ones. Duplicates are often keyed weeks or months after the original.
Last updated 03 November 2026. General guidance for finance teams; check it against your own policies, systems and local rules.