Resource
How to Find Duplicate Payments in QuickBooks
To find duplicate payments in QuickBooks, run a Transaction List by Vendor report, sort it by amount and date, and compare reference numbers on anything that repeats; then check the bank register for payments matched twice, and turn on QuickBooks' duplicate bill-number warning. That catches the obvious cases. This guide covers the full manual review — and the duplicate patterns that slip past it.
Where QuickBooks' native warnings help — and stop
QuickBooks Online warns you when a bill number or check number you've already used for that vendor appears again. That guard is genuinely useful, and you should have it on.
But most real duplicates never repeat a reference. The same invoice keyed twice with different numbers, a bill paid by check and then matched again to an ACH withdrawal in the bank feed, or a vendor that exists twice in your vendor list — none of those trip the warning. Finding them is a comparison job.
The manual review, step by step
Run this weekly at minimum — daily if payment volume is meaningful:
- Run Transaction List by Vendor; sort by amount, then date
- Flag any same-vendor, same-amount pairs within a ~14-day window
- Compare reference numbers on flagged pairs against the vendor's original invoice
- Review the bank register for bills settled by two methods (check + bank-feed match)
- Scan the vendor list for near-duplicate vendor records, each carrying its own bills
- Check recurring transaction templates against manually keyed entries for the same vendor
- Review payments that exceed the open bill — overpayments and unapplied vendor credits
The records to compare
Duplicates hide in the joins between records, so the review needs all of them: bills and bill payments, checks and expenses, vendor records and vendor credits, invoice and reference numbers, payment dates, amounts, and payment methods.
Where manual review breaks down
The method above works at low volume. Past a few hundred transactions a month, it depends on someone remembering yesterday's postings while scanning today's — every day, including the busy ones. That's exactly the review that gets skipped, and skipped reviews are how a duplicate ages three weeks into the AP report before anyone notices.
How Flash automates the daily version of this review
Flash Daily Insights runs these same comparisons every night against your full QuickBooks activity through a read-only connection. Possible duplicates — same vendor and amount in a short window, near-duplicate references, two-method payments, duplicate vendor records, overpayment signals — are flagged as candidates in the next morning's brief, ranked by exposure, with the underlying records attached so verification takes minutes.
Flash flags candidates for your review. It does not delete or change transactions, does not prove fraud, and does not guarantee every duplicate will be found — keep your AP approval controls in place.
Frequently asked
- Can QuickBooks find duplicate payments automatically?
- QuickBooks warns when a bill number or check number repeats for a vendor. Duplicates under different references, bank-feed/manual overlaps, and duplicate vendor records don't trigger warnings — those require a comparison review, done manually or with a tool like Flash.
- What report shows duplicate payments in QuickBooks?
- There's no dedicated duplicates report. The closest workflow is Transaction List by Vendor sorted by amount and date, plus a bank-register review for double-settled bills.
- What should I do when I confirm a duplicate payment?
- Verify both records against the vendor's original invoice, then void or merge the duplicate entry in QuickBooks and request a vendor credit or refund for money already sent. Confirm the fix on the next bank reconciliation.
- How does Flash help with duplicate payments?
- Flash reviews bills, bill payments, checks, and expenses daily through a read-only QuickBooks connection and flags possible duplicates as candidates, ranked by exposure, with a recommended next action. Your team verifies and decides — Flash never changes your books.
See QuickBooks duplicate payment detection
Flash Daily Insights turns QuickBooks activity into a daily Accounting/CFO brief.
See QuickBooks duplicate payment detection