neatstatement

Find duplicate transactions

Drop a CSV of transactions and see which ones repeat. Useful before importing into accounting software, where a duplicate becomes a second payment.

Drop a CSV of transactions here

or click to choose · nothing is uploaded

Why duplicates cost money

The expensive case is not the obvious one. It is the same invoice or transfer arriving twice from two overlapping exports — a statement pulled for January to March and another for March to May, both containing March. Imported together, each March transaction is now two legitimate-looking entries, and the second one gets paid.

Someone processing several thousand invoices by hand found roughly six percent with a mismatch, and reported that the duplicates were the bigger risk of the two — worth tens of thousands in potential double payments. That kind of error is invisible when you scroll, because both rows are individually correct.

Choosing what counts as the same

By default every column has to match, which is the strict reading: same date, same description, same amount. That is the safe place to start.

Narrowing the comparison is what makes it useful. Untick the description and you catch the same amount charged twice on the same day with slightly different merchant text. Compare on a reference number alone and you catch the same invoice entered under two different names.

Values are compared loosely enough to be practical: case, spacing, currency symbols and leading zeros are ignored, so USD 1,200.00and 1200.00 count as the same amount.

What the download gives you

The first occurrence of each repeated row is kept and the later ones are removed, so the file stays in its original order with the extras stripped. Nothing is deleted from your original — you get a new file.