Duplicate transactions from overlapping statements
Upload two statements that share a few days and the same transactions appear twice. How overlaps happen, how to spot duplicates, and how to prevent them.
Key takeaways
- Overlaps come from mid-month downloads, re-downloaded statements and CSV exports that cover the same days as a PDF.
- A duplicate is the same account, date, amount and description appearing twice from two different files.
- Identifying each transaction by those fields lets a re-upload update rows instead of adding them again.
You download a statement, then a month later download another one that starts a few days earlier. Or you pull a CSV of recent activity to fill a gap, and it covers dates your PDF already had. Either way, some transactions are now in your data twice — and your totals are quietly too high.
How overlaps happen
- Custom date-range downloads that don't line up with the previous one.
- Re-downloading the same statement under a different filename.
- Mixing a bank CSV export with PDF statements for the same period.
- Card statements whose cycle start shifts by a day or two.
Spotting duplicates
Sort your transactions by account, then date, then amount. Duplicates sit next to each other: same account, same date, same amount, same description. Be careful — two genuine purchases can look identical, like two coffees on the same morning. Check the statement before deleting anything.
Preventing them
The robust fix is to give every transaction a fingerprint built from its account, date, amount and a normalized version of its description. When a file is imported, any transaction whose fingerprint already exists is treated as the same row, not a new one. Re-uploading an overlapping statement then changes nothing that was already there.
PaperSpend does this for every statement, so uploading overlapping months doesn't inflate your totals. Combined with bucketing by transaction date, it means you can upload statements in any order and still get the same monthly numbers.
Don't confuse duplicates with transfers
A card payment appearing on both your checking and card statements isn't a duplicate — it's two sides of one transfer, from two different accounts. Removing one would leave the other in your spending. Mark both as transfers instead.
Frequently asked questions
Why do I have duplicate transactions in my budget?
Usually two imported files cover some of the same days — for example, two statement downloads with overlapping date ranges.
How do I remove duplicate bank transactions in Excel?
Sort by account, date, amount and description, then review rows that match on all four. Check the statement before deleting, because two genuine purchases can be identical.
Is a card payment on both checking and card statements a duplicate?
No. It's one transfer seen from two accounts. Mark both lines as a transfer so neither counts as spending.
