Hi, I’m trying to do a reconciliation and see what has been offset. I have a column of debits and credits and I have a difference of £68k between the 2 columns. There’s about 1000 lines in total but I’ve uploaded a small sample. I’ve tried matching but quite a few of the figures appear more than once. Is there a formula I can use to see which transactions haven’t netted off please? Thanks
There is no attachment. Please try again and don't forget to press "Start upload" before you submit your reply.
Hi, hopefully my sample has attached properly. I’m trying to do a reconciliation and see what has been offset. I have a column of debits and credits and I have a difference of £68k between the 2 columns. There’s about 1000 lines in total but I’ve uploaded a small sample. I’ve tried matching but quite a few of the figures appear more than once. Is there a formula I can use to see which transactions haven’t netted off please? Thanks
crossposted: https://www.mrexcel.com/board/threads/reconciling-debits-and-credits.1260936/
Suggest you read: https://excelguru.ca/a-message-to-forum-cross-posters/
Oh sorry! I didn’t realise cross posting was frowned upon. Just desperate to figure this out
You could use a technique described here:
https://www.myonlinetraininghub.com/excel-bank-reconciliation-formula
I've adapted it to your example in the attached file. One comment though. It tries to find matches based on the amounts (debit and credit) only. In real life you might want to include the vendor as well.
If this solves your issue, I suggest you either remove your post on the other forum or edit it to include a comment that you cross-posted and have a solution. That prevents others from spending their time on a problem that already has been resolved.
