How to Find Duplicate Bills and Invoices in QuickBooks Online

A bill entered twice is one of the most common and most expensive small mistakes in a set of books. QuickBooks has a warning for it, but the warning is narrower than most people assume.

A vendor emails an invoice. Someone forwards it to the bill inbox, someone else keys it in by hand, and a bill-pay import grabs it a third time. Weeks later you pay it twice, and the P&L has been overstating that expense the whole time.

Here's how to find the duplicates already in your QuickBooks Online file, and how to make the next one harder to create.

Step 1: Turn on the duplicate bill warning

Go to Settings → Account and settings → Advanced, scroll to Other preferences, and turn on Warn if duplicate bill number is used. Know what it covers: QuickBooks checks whether the same vendor already has that bill number. It does not warn you when a number matches another vendor's bill, and it does nothing about a duplicate that was typed with a slightly different number, like "INV-1042" and "1042".

Customer invoices are different. Intuit's support staff have said there's no equivalent warning for customer invoice numbers. Turning off Custom transaction numbers in your sales settings makes QuickBooks assign the next number itself, which reduces duplicates, though some users report still seeing them.

Step 2: Find exact duplicates already in the file

1. Run the Transaction List by Vendor report and filter it to bills. (Intuit's own suggested starting point.) For invoices, use Transaction List by Customer.
2. Set the date range to the period you want to check, then export to Excel.
3. Add a helper column that joins the fields that should be unique, for example =A2&"|"&D2&"|"&F2 for vendor, number and amount.
4. Next to it, count how many times each combination appears: =COUNTIF(H:H,H2). Anything greater than 1 is a candidate.
5. Filter on the count and look at each pair.

Step 3: Look for near-duplicates

The expensive ones often don't match exactly. Check for:

• Same vendor, same amount, dates a few days apart, with different or missing bill numbers.
• Number variations: leading zeros, a prefix added or dropped, spaces, or a typo.
• Two vendor records for one company, for example "Northstar Supply" and "Northstar Supply Co." The same-vendor warning can't fire across them, so the second bill sails through. Sort your vendor list alphabetically and merge look-alikes.

Step 4: Decide what to do with each one

If a duplicate bill is unpaid, remove it or void it so it doesn't get paid. If both were paid, contact the vendor, ask for a refund or credit, and record it properly (a vendor credit or refund deposit, so your books and your bank both tell the truth). Ask your bookkeeper or CPA before you delete a paid bill, because it affects your bank reconciliation and possibly year-end reporting.

Step 5: Make the next one harder

• Give bills one way in. Decide whether bills come from a forwarding inbox, a bill-pay tool or manual entry, and don't run two of them on the same vendors.
• Standardize how invoice numbers are typed, exactly as printed on the vendor's invoice.
• Keep the vendor list clean, with one record per company.
• Run the Step 2 report once a month, not once a year.

Where a checkup comes in

Doing this by hand every month is real work, which is why it tends not to happen. DrillFi's Financial Check Up runs this check automatically, flagging the same vendor, invoice number, amount and date appearing twice, and also catches near-duplicate vendor names that split your spend and let double payments through. You get the findings ranked by dollars, with the exact transactions, so you can fix them in minutes. See what that looks like on a sample company.

DrillFi Financial Check Up is an advisory service. It is not an audit, review or compilation, and it is not tax preparation or legal advice. QuickBooks menus and plan features change over time, so check each step against your version.