Hi, I work at an accountants and have been tasked with reconciling a clients bank account. They use accounting software and have manually entered around 1400 bank transactions. The bank is now out by about £200k, and I need to find out where they have gone wrong. It's not 1 big transaction out, but 100's of transactions that don't add up.
I have the clients list of bank payments (in and out) in one column (say A), and a separate column (B) with the actual bank figures. What I want to do is find a way to match column A to column B without having to manually tick the 2. There are several payments in both columns that have the same value, for example £100 will be repeated multiple times in both columns, therefore looking at items that aren't duplicates doesn't really help.
Is there a way, either VBA or formula's that I can work through this data quickly? I'm dreading having to go through it manually and thought someone here must know!
Thank you.
I have the clients list of bank payments (in and out) in one column (say A), and a separate column (B) with the actual bank figures. What I want to do is find a way to match column A to column B without having to manually tick the 2. There are several payments in both columns that have the same value, for example £100 will be repeated multiple times in both columns, therefore looking at items that aren't duplicates doesn't really help.
Is there a way, either VBA or formula's that I can work through this data quickly? I'm dreading having to go through it manually and thought someone here must know!
Thank you.