How to find duplicate payments in a bank statement

Download the statement as a spreadsheet, then count rows with the same description, amount and month. Anything above 1 is worth a look. Check each one before you contact anyone, because many repeats are real purchases, and act quickly if it is a mistake, since dispute windows are limited.

What a duplicate payment looks like

The same supplier and amount appear twice within a few days.
A monthly charge appears twice in one month.
The same bill is paid once by card and once by bank transfer. These have different descriptions, so they are easy to miss.

Some repeats are not mistakes. Two identical purchases can both be real, a pending charge can be replaced by the final one, and a repeat followed by a refund has already been fixed.

Steps

Assume date in column A, description in column B, amount in column C, and data in rows 2 to 2000. These formulas work in Excel and Google Sheets.

Download the statement from your bank's website as CSV or Excel, then open a copy. Choose a date range of at least a few months.
Make sure column A holds real dates and column C holds numbers, not text. If your bank uses separate money in and money out columns, use money out.
Add the month: in D2 enter =TEXT(A2,"yyyy-mm") and fill down.
Count repeats in the same month: in E2 enter =COUNTIFS($B$2:$B$2000,B2,$C$2:$C$2000,C2,$D$2:$D$2000,D2) and fill down.
Filter column E for values above 1, sort by description, and read those rows side by side.
For a second pass, sort the whole sheet by amount and scan for equal amounts with different descriptions. This is how you spot one bill paid two ways.
Compare each candidate with the bill or receipt. Keep notes on what you checked.

Limits of the manual method

Banks often add reference numbers to descriptions, so a real repeat may not match exactly.
Asterisks are common in card descriptions and act as wildcards in COUNTIFS, so a count can be too high. Check flagged rows by eye.
A repeat that crosses a month end is not counted. The second pass by amount can catch it.
A statement alone cannot prove a duplicate. You need the bill or receipt to know what was owed.

What to do if you find one

Ask the supplier first. They can often refund it directly, and it may be the fastest route.
If that fails, contact your bank or card issuer in writing and keep a copy.
Do not wait. In the US, a credit card billing dispute should reach the issuer within 60 days after the first bill with the error was sent. For personal bank accounts, Regulation E generally sets the same 60 days from the statement.

Regulation E covers accounts held mainly for personal, family or household purposes, so for a business account check your account agreement and ask early. This is general information, not legal advice.

FAQ

Can a pending charge look like a duplicate?

Yes. Wait for it to post, or ask your bank, before treating it as a second payment.

How far back should I look?

Start with the last three months, because recent errors are the easiest to dispute. Go back further if you find a pattern.

What if the same monthly charge is on every statement?

That is normally a subscription, not a duplicate, which is why the formula counts within one month. Do check that the amount has not crept up.

Check it automatically with Catchfold

Catchfold is a free tool that runs in your browser. Add a bank or card statement on Your files as CSV, Excel or a bank download. A statement alone is enough to flag a monthly charge taken twice in one month, or one that has gone up. Add a bills export too, and it also flags bills that look paid more than once and payments to your suppliers with no matching bill. It never leaves your computer. A person decides what to do with each finding, and Catchfold never pays, blocks or approves anything. It is a free prototype with no guarantee, and it will not catch every duplicate. The pilot guide has export steps for other tools.

Related guides

Sources

Menus and rules change; the official page is the source of truth.

Checked against official pages on 31 October 2026.