Articles

How do you find duplicate payments in accounts payable?

Normalize invoice numbers, run exact and fuzzy tests on paid invoices, look at the documents behind every flag, then recover the money and fix the cause.

Duplicate payments are found by testing paid invoices in pairs: same vendor, normalized invoice number and amount, then fuzzier tests on amounts and dates. In the worked case, a review of 97,400 invoices and $221,800,000 paid flagged 612 pairs, confirmed 38 duplicates worth $286,450 (0.129% of the amount paid) and recovered $241,300.

Worked in full in The Accounts Payable Handbook by Julian R. Sterling, with every figure reproduced in a free workbook.Get the PDF, $19.99 →or the paperback

The review

The case is a fictional manufacturer, Marlow Precision Products. In September 2026 its AP manager reviewed every invoice paid in the 24 months to 31 August 2026: 97,400 invoices and $221,800,000. No review had been done in years.

Step 1: normalize invoice numbers

Before comparing, apply the same cleanup to every invoice number: upper case, no spaces or punctuation, no prefixes such as INV, no leading zeros. "INV-20871", "inv 20871" and "20871" all become "20871". At Marlow, invoice numbers keyed differently caused 17 of the 38 duplicates.

Step 2: run the tests

The tests flagged 612 pairs: 41 exact and 571 from the fuzzy tests. Most fuzzy flags were recurring charges such as rent and maintenance contracts. Every pair was checked against the invoice images and payment records.

Step 3: read the causes

Confirmed duplicates by cause
CauseDuplicates
Invoice number keyed differently17
Paid from a statement and from the invoice9
Same vendor under 2 vendor records7
Manual check plus the scheduled ACH5
Total38

The largest, $48,960, was a heat-treating invoice paid once by ACH and once by a manual check cut during a rush order.

Step 4: recover the money

For each duplicate: request the supplier's statement, ask for a refund or agree an offset recorded in the ERP, escalate after two weeks without an answer, and carry the amount as a receivable until it is back. Marlow recovered $241,300; $45,150 remained open with suppliers who had applied the overpayments elsewhere.

Each cause has a cheap preventive control: normalized duplicate checks at entry, statements reconciled but never paid, a clean vendor master, and manual payments recorded against the invoice before release.

Takeaway

Free Excel template: Accounts Payable Workbook (three-way match, discounts, DPO, accruals, duplicates, Form 1099 and the automation case).

Also on this site: DPO, calculated three ways · the three-way match, worked.

Questions readers ask

How common are duplicate payments?

It depends on the controls. In the worked case, confirmed duplicates were 0.129% of the amount paid over two years. Strong entry checks and a clean vendor master reduce the rate; external benchmarks vary widely.

Should I use a recovery audit firm?

They work on contingency and cost nothing unless they find money, but they keep a share of it and contact suppliers directly. Many companies run their own review regularly and use an external firm every few years as an independent check.

How often should duplicate reviews be run?

A quarterly review of payments, plus a duplicate test on every payment proposal before release, is a sound routine for a mid-sized company.

What if the supplier cannot refund the duplicate?

Offset it against the next invoice if the supplier will be paid again, documented in the ERP. If it cannot be recovered after reasonable effort, write it off to expense with the controller's approval.

Sources: IRS instructions for Forms 1099, Nacha Operating Rules, FASB ASU 2022-04 (as cited in the text). Figures computed by the author's model and checked on 18 November 2026. Education only, not accounting, legal or tax advice.

Read the whole case

This article is one calculation from The Accounts Payable Handbook. The book follows one AP team through a year, from the purchase order to the 1099 season, and every figure it prints is a live formula in the free workbook.

Get the PDF edition, $19.99 Paperback · Free companion files