Finding duplicate payments in accounts payable, with an AI agent

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?

  1. Export your payment history: payment ID, date, vendor ID and name, invoice number, amount, bank account and who entered it.
  2. Look for exact duplicates: the same vendor and invoice number paid more than once.
  3. Look for look-alike invoices: the same vendor and amount with invoice numbers that differ only by a dash, space or letter.
  4. Look for look-alike vendors: names that differ slightly, especially if they share a bank account.
  5. Check the vendor bank-detail change log and review any payment made soon after a change.
  6. Add up the money at risk, clear the false positives, and request refunds or credits.

Where it usually goes wrong

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.

The message in SlackNorthfield Supply: scan these two years of AP payments for duplicate payments and anything paid after a vendor bank change. Use the vendor master and change log. Group the findings, total the money at risk, and clear any false positives with a reason.
Slack request to sweep two years of AP payments for duplicates with two files attached, and the agent's first summary of money at risk
The request and the agent's first summary: four findings, $37,117.10 at risk.

What the agent did

  1. Read all 371 payments and the vendor master, including the bank-detail change log.
  2. 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.
  3. 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.
  4. 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.
  5. Saved the working paper as an Excel workbook.
A follow-up in Slack asking about vendors paid into the same bank account, and the agent's table showing two vendor names sharing one account
A follow-up in the same chat. The second pass found two vendor names paid into one bank account.

What it found

What the agent found in two years of AP payments
CheckVendorAmount ($)Next step
Exact duplicate (check and ACH)Pinecrest IT Services, PIT-7713,960.00Ask for a refund or credit
Look-alike invoice numbersHarlow Industrial Parts, INV-457 / INV4578,642.10Ask for a refund or credit
Look-alike vendors, same bank accountKeystone Supply / Keystone Supplies LLC6,115.00Merge the vendors and recover
Two vendor names share one bank account (found on the follow-up)Brightline Staffing / B. Line Consulting15,600.00Verify the vendor before the next payment
Wire paid five days after a bank change requested by emailMetro Freight Lines18,400.00Call the bank and the vendor on a known number
False positives clearedRent, cleaning, one verified bank changeSame amount every month on different invoices; signed form and call-back
The agent's corrections to payment method and entered-by details, re-checked against the payments file
The details it corrected after re-checking the payments file.

What you still check

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