Duplicate invoices
How do I find duplicate invoices before paying?
Last updated
To find duplicate invoices, compare supplier and invoice number in Excel, use QuickBooks Online’s same-vendor bill-number warning, or upload bills to an InvoiceParser Pro workspace. IPP checks the prior 400 days and shows why a possible duplicate matched; a person decides what to keep. Free includes a monthly invoice allowance; the anonymous converter has no history and cannot check duplicates.
Duplicate checks need invoice history in a workspace. The trial includes 50 invoices for 14 days, then the Free plan includes 25 a month. A flag asks you to compare the source and history; it does not establish that the bill was already paid.
18,926.20 − 18,338.80 = 587.40. The stated total does not reconcile with the extracted subtotal and tax. Check it against the source.
Winter blend surcharge appears in a line item and the summary. A reviewer needs to check whether it was counted twice; this is a flag, not a deletion.
Without IPP
Check for duplicates in Excel
- 1
List the bills
Export your unpaid and recent bills, or type the new batch, with one row per invoice: supplier in column A, invoice number in B, date in C, total in D.
- 2
Count supplier and number together
In E2 enter =COUNTIFS(A:A,A2,B:B,B2) and fill it down. Any row showing 2 or more has the same supplier and invoice number as another row.
- 3
Highlight exact repeats
In F2 enter =A2&"|"&B2, fill it down, select column F and choose Home, Conditional Formatting, Highlight Cells Rules, Duplicate Values.
- 4
Look for near-duplicates
Sort by supplier, then total, then date. The same total from the same supplier a few days apart, or invoice numbers that differ only by a dash or a leading zero (INV-1001 and INV1001), deserve a second look.
- 5
Check before you pay
Compare each suspect pair with the paper. A re-sent copy, a statement entered as an invoice, or the same bill entered under two spellings of the supplier are the usual causes.
Checked against Microsoft: COUNTIFS function and Microsoft: Find and remove duplicates, read 4 October 2026. Menus change; the vendor's page is the authority.
Without IPP
Turn on QuickBooks Online’s duplicate bill number warning
- 1
Open the settings
Select the gear icon, then Account and settings, then Advanced.
- 2
Turn the warning on
Under Other preferences, turn on the option to warn when a bill number has already been used for that vendor, then Save and Done.
- 3
Enter bills as usual
QuickBooks now warns when you type a bill number already used for the same vendor.
- It compares the bill number for the same vendor only. A bill entered under a second spelling of the supplier, or a number typed slightly differently, gets no warning.
Checked against QuickBooks community: duplicate bill number warning, read 4 October 2026. Menus change; the vendor's page is the authority.
In InvoiceParser Pro
Let InvoiceParser Pro check every upload
- 1
Open a free workspace
Sign up with no card. The free plan reads 25 invoices a month, and every one is checked for duplicates. A new workspace starts on a 14-day trial with 50.
- 2
Upload or forward invoices
Each new invoice is compared with the prior 400 days of invoices in the workspace: the same supplier, number, total and date; the supplier’s name written a little differently; and similar amounts on nearby dates. Statements are not treated as invoices.
- 3
See why it matched
A possible duplicate is flagged with the invoice it matched and the reason. Invoices that state different invoice numbers are never grouped as duplicates, so a batch of real bills with sequential numbers is not flagged as one.
- 4
Decide which copies to keep
In the Duplicates tab, tick the copies to keep. Removed copies go to Trash for 30 days; “Not a duplicate” is remembered and the pair does not come back. Nothing is ever deleted automatically.
- A possible duplicate is held out of auto-approve when you switch it on, and pushing one to QuickBooks, Xero or Zoho Books (paid plans) asks you to confirm first.
In InvoiceParser Pro
Repeat a fictional duplicate check in your workspace
We ran these three fictional PDFs through a live IPP workspace on October 12, 2026. The original and resend contain the same bytes. The third changes only the invoice number; its supplier, date, currency, line and USD 300.00 total stay the same. Download the files and compare your reading with the recorded results.
- 1
Read the original first
Upload original.pdf into your workspace and wait for its reading. Compare EXAMPLE-004, Example Supplier D, four service hours at USD 75.00 and total USD 300.00 with the PDF. Our reading required a source check for invoice number and customer name; we reviewed it before approving.
- 2
Upload the unchanged resend
Upload resent-copy.pdf after the original has finished. In our test IPP flagged one high-confidence possible duplicate and linked the original. The reason was the same supplier, invoice number, total and date. Both copies stayed in the workspace for a person to review.
- 3
Compare the different-number control
Upload different-number.pdf and check that the reading says EXAMPLE-004B. In our test it stayed outside the two-copy duplicate group, despite the same supplier, date and total. A different number does not establish that a bill is legitimate or unpaid.
- 4
Review the choice and the exported lines
Open Duplicates, compare the copies and choose which to keep. Our captured screen shows that choice before removal. We downloaded Excel from the reviewed original and verified its separate Line Items sheet: quantity 4, unit price 75 and line total 300. The downloads below contain that workbook and the recorded observations.
- This records one test using fictional documents. Check the extracted fields against your source when you repeat it. Duplicate matching depends on those fields.
- The original was approved manually. Removal, restoration and an accounting push were not exercised in this test. A duplicate flag compares invoice history; it does not establish prior payment.

Where duplicate invoices come from
Most duplicates are not fraud. They are the same bill arriving twice:
- emailed and then posted, or sent again as a reminder with “copy” stamped on it;
- a supplier statement entered as if it were an invoice;
- the same invoice entered under two spellings of a supplier name;
- a scan of a scan, uploaded by two people in the same team.
What IPP does not do
- It checks invoices in your workspace, not payments in your bank or bills keyed straight into your accounting system.
- The free no-signup tool on /invoice-to-excel keeps no history, so it cannot check for duplicates; a workspace can.
- The free plan is one user and 25 invoices a month, and the push to QuickBooks, Xero or Zoho Books is on paid plans and the trial.
- It flags and asks; it never removes an invoice on its own.
Questions
Is there a free duplicate invoice checker?
Yes. InvoiceParser Pro’s free plan checks every invoice you upload against the prior 400 days of invoices in your workspace, for 25 invoices a month with no card. Excel and QuickBooks Online’s duplicate bill number warning are free too, with the limits described above.
How do I find duplicate invoices in Excel?
Put supplier and invoice number in two columns and use =COUNTIFS(A:A,A2,B:B,B2); a result of 2 or more is a repeat. Then sort by supplier, total and date to spot near-duplicates the formula misses.
Will two different invoices with the same amount be flagged?
They may be flagged as possible duplicates if they come from the same supplier on nearby dates, with the reason shown. If they state different invoice numbers, IPP never groups them as duplicates, and “Not a duplicate” is remembered.
Does QuickBooks Online warn about duplicate bills?
It has a setting under Account and settings, Advanced, to warn when a bill number is reused for the same vendor. It does not catch a different spelling of the supplier or a slightly different number.
What happens to a duplicate I remove in IPP?
It goes to Trash for 30 days, then it and its file are permanently deleted. Until then it can be restored.
Start a workspace for duplicate checks
Upload the supplier invoices you want to compare into the same workspace. Review each possible match before choosing which copies to keep. The no-account converter cannot compare invoices with history. See plans for allowances and paid accounting pushes.
