Banking
How to find duplicate charges on business statements
A duplicate charge almost never looks like one. Two ordinary payments to a vendor you use weekly, days apart, pages apart. Here is why they slip through and how to find them.
Why they slip through
Nothing about a duplicate is suspicious on its own. Familiar vendor, normal amount, working day. Every property that would make a line stand out is missing, which is why it survives.
Date order makes it worse. Two charges four days apart sit dozens of lines apart, often on different pages, so you are being asked to hold a number in memory across a page turn, hundreds of times.
Where they come from
- The same delivery invoiced twice. Usually the vendor's paperwork error, not yours.
- A card run twice after a terminal error. The first attempt looked like it failed and did not.
- Autopay plus a manual payment, or two people paying the same bill without knowing.
- A promised credit that never arrived. The second charge is legitimate; the missing credit is the problem.
Doing it by hand
The single highest-value change is to stop reading in date order.
- 1. Export and sort by vendor, then by amount. Duplicates that were pages apart become adjacent rows. Expect to clean up first: pasted statements tend to collapse columns and turn amounts into text, and sorting text puts $1,000 next to $10.
- 2. Look for near matches, not exact ones. Tax, tips, fees and partial credits make the same charge appear as two different totals.
- 3. Put the cards in the same sheet. A charge paid once from the bank and once from a card only shows up if both are in front of you.
This works. It also takes an evening a month, which is why it gets done once, finds something, and never gets done again.
Getting the money back
Go to the vendor first. A duplicate is usually their error, they can see it in their own system, and a credit is straightforward once you send both line items. Vendors generally have no time limit on fixing their own mistake.
Card disputes are the fallback, not the opening move. Faster, but time-limited, and they cost goodwill with a supplier you want to keep.
Either way you need both charges, both dates, and ideally the invoice behind each. Gathering that is the slow part, and it is worth having before you pick up the phone.
Or have it checked for you
The Banking module reads bank and card statements together and flags possible duplicates automatically, alongside returned items, reversals and unfamiliar vendors. Every line stays searchable by name, amount or vendor.
Worth reading next: bank statement review software covers the whole check, and return item chargeback covers the reversal that looks like an ordinary debit.
Duplicate charges, answered
How common are duplicate charges really?+
Common enough that most owners who look carefully for the first time find at least one. They are rarely deliberate: a delivery invoiced twice, a card run again after a terminal error, autopay and a manual payment both going through, or a promised credit that never arrived.
Why does searching for the amount not work?+
Because a real duplicate often is not identical. Tax, tips, delivery fees and partial credits mean the same underlying charge can appear as two slightly different amounts. Searching for an exact figure finds the easy cases and misses the ones worth money.
Can I get the money back after a few months?+
Usually yes with the vendor, who can credit you any time once you show both charges. Card dispute rights are much more time-limited and vary by network and agreement. The vendor route is slower but the window is longer.
What is the fastest way to check by hand?+
Sort by vendor rather than date. Duplicates that sit pages apart chronologically land next to each other. That one change turns an unreadable list into a scannable one.
Does this cover credit cards as well as the bank account?+
It should, and that is often where the duplicates are. In Smooth Ops both are read together, so a charge that hit the bank account once and a card once is findable. Checked separately, those two lines never meet.
Stop sorting spreadsheets by vendor
Upload your statements and possible duplicates are flagged across every account at once.
30 days free, no credit card