Short answer: To find duplicate payments, sweep your payment history for exact invoice matches, look-alike invoice numbers, look-alike vendor names, the same amount to the same vendor within 30 days, two vendors sharing one bank account, and payments made soon after a vendor's bank details changed. Clear the false positives, such as monthly rent. An AI agent can run these checks for you.
Duplicate payments rarely look like duplicates. They hide behind an invoice number with a missing dash, a vendor set up twice with a slightly different name, or a payment made by check and again by ACH.
This post lists the checks from a recent Excel tutorial, then has an AI agent run them on two years of payments.
The tutorial this is based on
Free Duplicate Payment Checker in Excel: It Found $62,073 by Excel For Freelancers (Randy Austin), published 12 November 2026. A walkthrough of a free Excel template. This post uses the checks it runs, not the template's buttons.
How do you check accounts payable for duplicate payments?
- Export your payment history: payment ID, date, vendor ID and name, invoice number, amount, bank account and who entered it.
- Look for exact duplicates: the same vendor and invoice number paid more than once.
- Look for look-alike invoices: the same vendor and amount with invoice numbers that differ only by a dash, space or letter.
- Look for look-alike vendors: names that differ slightly, especially if they share a bank account.
- Check the vendor bank-detail change log and review any payment made soon after a change.
- Add up the money at risk, clear the false positives, and request refunds or credits.
Where it usually goes wrong
- Monthly payments of the same amount, such as rent, flagged as duplicates when they are not.
- The same invoice paid once by check and once electronically.
- A vendor set up twice with different IDs.
- A bank-detail change requested by email with no call-back to a known number.
- Two vendor records paying into the same account, which can mean a fictitious vendor.
How an AI agent does it from Slack
We gave the agent two files for a made-up distributor, Northfield Supply Co.: every AP payment over two years, and the vendor master with its bank-detail change log. Every company, name, tax number and amount in these files is made up. The agent works in Slack, where it shows up as Mnemio AI, because Accountant AI is built on Mnemio AI.
What the agent did
- Read all 371 payments and the vendor master, including the bank-detail change log.
- Found the payment made five days after a bank change requested by email, an exact duplicate paid by check and ACH, look-alike invoice numbers and a vendor set up twice.
- Cleared the false positives with a reason for each: monthly rent, monthly cleaning and a bank change that had a signed form and a call-back.
- Its first summary missed two vendor names paid into the same bank account, and gave the wrong payment method or clerk on two duplicate pairs. Asked in a follow-up, it found the shared account and corrected the details against the payments file.
- Saved the working paper as an Excel workbook.
What it found
| Check | Vendor | Amount ($) | Next step |
|---|---|---|---|
| Exact duplicate (check and ACH) | Pinecrest IT Services, PIT-771 | 3,960.00 | Ask for a refund or credit |
| Look-alike invoice numbers | Harlow Industrial Parts, INV-457 / INV457 | 8,642.10 | Ask for a refund or credit |
| Look-alike vendors, same bank account | Keystone Supply / Keystone Supplies LLC | 6,115.00 | Merge the vendors and recover |
| Two vendor names share one bank account (found on the follow-up) | Brightline Staffing / B. Line Consulting | 15,600.00 | Verify the vendor before the next payment |
| Wire paid five days after a bank change requested by email | Metro Freight Lines | 18,400.00 | Call the bank and the vendor on a known number |
| False positives cleared | Rent, cleaning, one verified bank change | Same amount every month on different invoices; signed form and call-back |
What you still check
- Every finding before anyone contacts a vendor. A flag is a reason to look, not proof.
- The two high-risk items (the shared account and the bank change) with someone outside AP. All three B. Line Consulting payments were entered by the same clerk.
- Which control fixes to adopt.
Questions accountants ask
What is the most common cause of duplicate payments?
The same invoice entered twice with a small difference in the invoice number or vendor record, so the system does not block it.
How far back should I check?
Two years is common, and you can go further where recovery is still possible. The agent can sweep any period you give it.
Can it check payments before they go out?
Yes. It can run the same checks on the next payment run and flag anything risky before you approve it.
Hand this job to an agent
Bring one of your own files to a 30-minute call and watch an agent do it.
Book a 30-min demo