top of page

Duplicate transactions in Excel


StatementReader identifies and separates duplicate (or unique) payments or receipts using a combination of the date, description, amount and category columns, as selected by the user. An acceptable date variance can also be defined to allow for posting differences.

This is a one-click solution to the laborious and inaccurate manual task of comparing multiple rows, either within the same job, or across merged jobs (simply right click on your selection of jobs on the main StatementReader interface).

Recent Posts

See All

Improving Excel with Python (May 2022)

Revisited starter script from January 2021: Split Excel file into separate files Excel is essential, and Python is the future - forcing ourselves to practice the latter by automating some of the commo

Message us or

Call us on +44 (0)20 3287 8283

Mon to Fri: 8am-8pm

Weekends: 10am-6pm

bottom of page