How to Prevent Duplicate Payments in Accounts Payable

Duplicate payments come from resent PDFs, invoice number variants and two people entering the same bill. The seven root causes, how to find duplicates you already paid, how to get the money back and the controls that stop them.

To prevent duplicate payments in accounts payable, you need four controls working together: one clean vendor record per vendor (no "ABC Foods" and "ABC Foods Inc."), one invoice-number rule enforced by your accounting system (in QuickBooks Online, switch on the duplicate bill number warning), one intake channel for invoices, and matching each invoice to a purchase order and a receipt before it's paid. Most duplicates aren't fraud. They come from the same invoice arriving twice through different routes, or under slightly different vendor names, and nobody comparing them before payment.

Below: the seven ways duplicates happen, how to find the ones you've already paid, a script for getting the money back, and the controls that stop it.

How Foxpedite does it: the second payment has nothing to match

The cheapest place to stop a duplicate is before it's paid. Foxpedite is built around that, for the company still running purchasing on spreadsheets, email and QuickBooks.

Every purchase starts as a request and a PO. Gate 1 reserves it against the location or department budget the moment it's drafted; Gate 2 routes it for approval by amount and location, approvable from the email.
Receiving logs what arrived against the PO, at each location.
Gate 3: an invoice pays only when it matches the PO and the receipt. Once a PO is fully invoiced, a second invoice for the same goods has no open quantity left to match, so it's held as an exception instead of paid. That covers the resent PDF, the "reminder" copy, the corrected invoice with a new number, and the second location entering the same bill.
One vendor record per supplier. Vendors come in through an onboarding portal, which cuts down on the name variants that make duplicate warnings miss.
Bills sync to QuickBooks Online once they've matched (Advanced plan).

Three-way match: an invoice is paid only when it matches an open PO and a receipt; anything else is held

Pricing, published: Regular $390/month (10 users included) covers POs, budgets and three-way match. Advanced $740/month (20 users included) adds approval workflows, approve-from-email, QuickBooks Online sync and AI document scanning. Extra users are $39/month. The 14-day trial includes every Advanced feature and needs no credit card. We make Foxpedite, so treat this as a description of the mechanism, not a guarantee: run last month's invoices through the trial and see what it holds.

Try Foxpedite free for 14 days
Run last month's invoices through it and see which ones it would have held. Every Advanced feature, no credit card.
Start your free trial → · Prefer to start by hand? Get the free Duplicate Payment Audit Checklist

How common are duplicate payments?

Reliable public numbers are scarce, and most come from vendors that sell AP audit or automation tools, so treat them as directional.

In an SAP Concur analysis of more than 2.8 million SMB invoices processed through Concur Invoice from September 2015 to August 2016, 1.29% of invoices were flagged as duplicates, with an average duplicate value of $2,034 (SAP Concur). That's old data from one vendor's platform.
AP audit vendor OpenEnvoy reported that in a review of about $500 million of its customers' invoices over 12 months, 8.5% of invoices received were duplicates, concentrated among companies using logistics providers and contract manufacturers (Resourceful Finance Pro, reporting OpenEnvoy).

Those are duplicate invoices received, not duplicate payments made. Plenty get caught. The ones that aren't caught are the subject of this article.

Two vendor studies of duplicate invoices: 1.29% flagged (SAP Concur, SMB invoices, 2015-16) and 8.5% received (OpenEnvoy review of about $500 million)

How duplicate payments actually happen: 7 root causes

Seven root causes of duplicate payments in accounts payable

The same invoice arrives twice. Emailed PDF, then a paper copy by mail. Or the vendor's "reminder" is a fresh copy of the original. Both get entered.
Vendor name variants. "Example Foods," "Example Foods Inc." and "Example Foods – Downtown" exist as three vendors in QuickBooks. Duplicate warnings check per vendor, so they never fire.
Invoice number typed differently. INV-4471, 4471 and INV4471 are three different strings to software.
Paid on the card, then paid on the bill. A manager pays a supplier by company card at delivery; AP later pays the invoice by check or ACH.
Statements treated as invoices. A monthly statement lists invoices already paid; someone pays the statement total.
Multiple locations, one vendor. Two locations each receive and enter the same consolidated invoice.
Re-issued invoices after a dispute. The vendor sends a corrected invoice with a new number; the original was never voided in your system.

None of these need bad intent. They need two people, two channels, or two records, and no step that compares them.

The workaround: finding duplicates you've already paid (and where it breaks)

Method 1: QuickBooks Online reports

Go to Reports and run Transaction List by Vendor (or a bill payment report) for the last 12 months.
Customize the report to show amount, date, reference/bill number and memo.
Export to Excel or Google Sheets.
Sort by amount, then by vendor. Look for same-amount payments within 60 days of each other.
Then sort by reference number with the vendor column hidden. That surfaces the same invoice number under two vendor names (root cause #2).

Report names and menu paths in QBO change periodically; check against your version.

Method 2: the spreadsheet fuzzy match

In your export, add three helper columns:

Clean vendor: lowercase, strip "inc", "llc", "corp", punctuation and location suffixes.
Clean invoice #: strip letters, spaces, dashes and leading zeros (INV-04471 → 4471).
Match key: clean vendor & "|" & clean invoice #, and separately clean vendor & "|" & amount.

Then use COUNTIF on each key. Anything with a count above 1 is a candidate. Check each by hand: some vendors legitimately bill the same amount every month.

Also cross-check card statements against bills: filter card transactions over $500 and look for a bill from the same vendor for the same amount (root cause #4).

Where it breaks: this is an after-the-fact search. It finds money that already left, depends on someone running it every quarter, and misses duplicates that differ by more than your cleanup rules catch. Foxpedite moves the check to before payment: no open PO and receipt to match, no payment.

Prefer to start by hand? Free: Duplicate Payment Audit Checklist (15-minute self-check)
A one-page checklist for the reports to run, the helper formulas to add, and the seven root causes to check, plus a vendor recovery email you can copy.
Get the checklist →
Or skip the manual version: try Foxpedite free for 14 days

Example scenario: a three-location restaurant group (illustrative)

Example scenario. A restaurant group with three locations and about 120 staff buys produce, protein and dry goods from 14 regular suppliers. Each location's kitchen manager receives deliveries and drops invoices in a tray. The bookkeeper also gets emailed PDFs. AP processes about 600 vendor invoices a month.

Applying the SAP Concur duplicate-flag rate of 1.29% as a rough guide:

600 × 1.29% ≈ 7.7 duplicate invoices received per month
Suppose the bookkeeper catches most by eye, and 1 in 4 gets paid: ≈ 1.9 duplicate payments a month
At an average restaurant supplier invoice of, say, $1,150 (assumption): ≈ $2,200 a month paid twice, or about $26,500 a year before recovery

Most of that can be recovered if you find it. Vendors usually credit or refund a proven duplicate. The real costs are the cash tied up for months, the time spent chasing, and the duplicates nobody ever finds. If the same group checked for duplicates only at year-end, the average duplicate would sit unrecovered for about six months.

Example scenario math: 600 invoices a month at a 1.29% duplicate rate, 1 in 4 paid, at $1,150 each is about $2,200 a month or $26,500 a year

The math depends heavily on your own rates. Run the 15-minute audit before trusting anyone's estimate, including this one.

Recovering a duplicate payment from a vendor

Most vendors will fix a clear duplicate quickly if you make it easy for them. Send the evidence and give them two options.

Email script (copy and edit):

Subject: Duplicate payment — invoice [#] — [your company]

Hi [name],

We paid invoice [#] dated [date] twice: [payment 1: method, date, amount] and [payment 2: method, date, amount]. Remittance details for both are attached.

Could you either (a) refund [amount] to [ACH details / address], or (b) apply it as a credit against our next invoice? Please confirm which by [date] and send a statement showing the adjustment.

Thanks,
[name, title, phone]

Recording it in QuickBooks Online: if the vendor issues a credit, record a vendor credit and apply it to the next bill. If they refund, record the deposit against the vendor and Accounts Payable rather than the original expense account. Intuit's community answers describe this AP-based approach, but the exact steps vary by situation, so have your bookkeeper or accountant confirm the entries.

Then fix the root cause. If the duplicate came from a vendor name variant, merge the vendor records. If it came from two intake channels, close one.

Controls that prevent duplicate payments

Control	What to do	Catches root cause #	Effort
Vendor master hygiene	One record per vendor; merge variants; require a W-9 before the first payment	2, 6	One afternoon, then monthly review
Duplicate bill number warning (QBO)	Settings → Account and settings → Advanced → Other preferences → turn on the warning for bill numbers already used for that vendor	1, 3 (partly)	1 minute
Invoice-number format rule	Enter invoice numbers exactly as printed, no prefixes added, no zeros dropped	3	Training
Single intake channel	All invoices to one AP inbox; paper scanned to it; kitchen trays go away	1, 6	One email to vendors
No-pay-from-statement rule	Pay invoices only, never statement totals	5	Policy line
Card vs bill rule	If it was paid on a card, the bill is marked paid by card, not re-paid	4	Policy + monthly check
Void the original on dispute	When a corrected invoice arrives, void the original in AP the same day	7	Process step
Three-way match	Pay only when invoice matches an open PO and a receipt; a second invoice for the same PO has nothing left to match	1–7	Needs POs

The duplicate bill number warning path comes from an Intuit staff answer on the QuickBooks Community (QuickBooks Community, Apr 2024). Note its limit: it checks per vendor, so it won't fire if the same invoice is entered under two vendor names.

The last row matters most. Every other control depends on someone noticing. Three-way match changes the question from "have we seen this invoice before?" to "is there an open PO with a receipt for this?" The second invoice for a fully billed PO has nothing to match against, so it stops. Our three-way matching guide explains the mechanics; the vendor onboarding checklist covers the vendor-master side.

Duplicates and fraud are cousins

Most duplicates are honest mistakes, but the same gaps that let a duplicate through let a fake invoice through. The ACFE's 2024 study found billing schemes in 31% of fraud cases at organizations with fewer than 100 employees (ACFE, Occupational Fraud 2024). And the AFP's 2026 survey found 76% of US organizations experienced attempted or actual payments fraud in 2025 (AFP, 2026 Payments Fraud and Control Survey); that sample skews toward larger companies. Clean vendor records and matching protect against both.

In Foxpedite, the last row of that table is the default: every invoice is matched to an open PO and a receipt before payment, so the other controls become backups instead of the whole defense.

Stop paying invoices twice: start your 14-day Foxpedite trial
Every invoice matched to an approved PO and a receipt before it's paid, one vendor record per supplier, and bills synced to QuickBooks Online. Every Advanced feature, no credit card.
Start free, no card →
Not ready yet? The free Duplicate Payment Audit Checklist is the manual version: download it. Or take the 1-minute fit check, or book a demo.

Common questions

What causes duplicate payments in accounts payable?

Usually the same invoice arriving through two channels, vendor name variants in the accounting system, invoice numbers typed inconsistently, paying by card and then by bill, paying from statements, and re-issued invoices after disputes.

How do I find duplicate payments in QuickBooks Online?

Export a vendor transaction or bill payment report for the last 12 months. Sort by amount and vendor, then by reference number with vendors hidden. Add cleaned vendor-name and invoice-number columns and use COUNTIF to flag matches.

Does QuickBooks Online warn about duplicate bills?

It can. Turn on the warning for bill numbers already used for a vendor under Account and settings → Advanced → Other preferences. It checks per vendor, so it won't catch the same invoice entered under two vendor names.

How do I get a duplicate payment back from a vendor?

Email the vendor with both payment records and ask for a refund or a credit against the next invoice, with a deadline. Record a vendor credit or a refund deposit against Accounts Payable, and have your accountant confirm the entries.

What's the best control against duplicate payments?

Three-way matching: pay an invoice only when it matches an open purchase order and a receipt. A second invoice for a fully billed PO has nothing to match, so it stops. Pair it with clean vendor records.

Can software stop duplicate payments before they happen?

Yes, if it pays invoices only against an approved PO and a receipt. In Foxpedite, once a PO is fully invoiced, a second invoice for the same goods has nothing left to match and is held for review instead of paid. Regular ($390/month) includes three-way match; the 14-day trial includes every Advanced feature with no card.

Sources

SAP Concur, "How much money is your business throwing away in duplicate invoices?" (data Sep 2015–Aug 2016). https://concur.com/newsroom/article/how-much-money-is-your-business-throwing-away-in-duplicate-invoice
Resourceful Finance Pro, reporting an OpenEnvoy invoice review (published Jun 10, 2022; updated Oct 25, 2023). https://www.resourcefulfinancepro.com/news/invoices-double-paid
QuickBooks Community, "How can I avoid accidentally paying invoices twice" (Intuit staff reply, Apr 11, 2024). https://quickbooks.intuit.com/community/reports-and-accounting-5/how-can-i-avoid-accidentally-paying-invoices-twice-56358
ACFE, Occupational Fraud 2024: A Report to the Nations. https://www.ivey.uwo.ca/media/kjljj5cy/2024-report-to-the-nations.pdf
AFP, 2026 Payments Fraud and Control Survey Report press release (Apr 14, 2026). https://www.financialprofessionals.org/about/learn-more/press-releases/Details/over-75-percent-of-us-firms-experienced-payments-fraud-in-2025-while-ai-adoption-for-fraud-mitigation-lags

All resources