How to find duplicate payments in QuickBooks
By Shiva Dhali · Updated
QuickBooks can warn you when you enter a bill number that already exists for the same vendor. That catches the obvious case. It doesn't catch the duplicates that actually cost money: the same invoice keyed as INV-1042 and 1042, a vendor set up twice under slightly different names, or a reissued invoice paid alongside the original. Here's how to look for those.
Why duplicates get past QuickBooks
Exact-match checks miss duplicates that look different on paper:
- Reformatted invoice numbers: INV-0042, 0042 and 42 are the same invoice.
- Typos: one digit off in the invoice number or amount.
- Duplicate vendor records: "Acme Supplies" and "Acme Supplies Pvt Ltd" are two vendors to QuickBooks.
- Reissued invoices: the vendor sends a corrected copy and both get paid.
- Missing invoice numbers: bills entered without a reference can't be matched at all.
Step 1: Export your payments
In QuickBooks Online, open Reports and run a vendor payment report, for example Bill Payment List or Transaction List by Vendor. Set the date range to the period you want to check (a full year is a good start), make sure the vendor, date, amount and reference or invoice number columns are included, and export to Excel or CSV.
In QuickBooks Desktop, the Vendor reports (such as Transaction List by Vendor or Unpaid Bills Detail) export the same way. Report names vary slightly between versions; what matters is one row per bill or payment with vendor, date, amount and invoice number.
Step 2: The manual check in a spreadsheet
If you want to check by hand:
- Clean the invoice numbers into a new column: strip prefixes like INV-, spaces, dashes and leading zeros.
- Sort by vendor, then by cleaned invoice number, and look for repeats.
- Sort by amount, then date, and look for the same amount paid to similar vendor names within a few weeks.
- Search the vendor list for near-duplicate names.
This works for a few hundred rows. Beyond that, the lookalike-name and one-digit-typo checks become slow and easy to get wrong.
Step 3: Recover what you find
For each confirmed duplicate, email the vendor with both payment dates, the amounts and the invoice reference, and ask for a credit note or refund. Then merge the duplicate vendor records in QuickBooks so it doesn't happen again.
Common questions
- Does QuickBooks detect duplicate payments automatically?
- It warns about a repeated bill number for the same vendor. It doesn't flag reformatted numbers, typos, duplicate vendor records or reissued invoices.
- Is it safe to scan my QuickBooks export online?
- With PaidTwice the file is processed inside your browser tab and never sent to a server. Closing the tab clears it.
- How far back should I check?
- Start with the last 12 months. Vendors are more likely to issue credits for recent payments.