Running Bank Statement

Hi guys

For work I have to keep an Excel version of our company card bank statement and day by day I have to update it, and then annotate it on Excel with notes. When exporting the Excel version of the bank statement, sometimes the order changes and a transaction or two appear amongst transactions I already have in my spreadsheet, which means I am manually having to identify what is new and what I already have, so I know what to copy and paste in and what not to.

Is there a way I can easily update my running statement whenever I need to, without duplicating transactions?

Things to note:
- Sometimes I may have two identical transactions with regard to date, vendor and amount on the statement; simply removing duplicates won't work
- I annotate my Excel sheet so I can't just copy and paste over what I have in my Excel running statement - I need the transactions I already have to remain in the spreadsheet with my annotations.

Any help would be hugely appreciated.

Thanks,
Jake

Originally Posted by spencerellis90

- Sometimes I may have two identical transactions with regard to date, vendor and amount on the statement; simply removing duplicates won't work

How would you know if this was a duplicate to be removed or a legitimate duplicate to remain?

BSB

Cross-posted: https://www.mrexcel.com/forum/excel-...statement.html