Log In
Register
Home
Active Member
June 28, 2024
Offline
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
Moderators
January 31, 2022
Offline
There is no attachment. Please try again and don't forget to press "Start upload" before you submit your reply.
Active Member
June 28, 2024
Offline
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
Trusted Members
October 18, 2018
Online
crossposted: https://www.mrexcel.com/board/.....s.1260936/
Suggest you read: https://excelguru.ca/a-message.....s-posters/
Active Member
June 28, 2024
Offline
Oh sorry! I didn’t realise cross posting was frowned upon. Just desperate to figure this out
Moderators
January 31, 2022
Offline
You could use a technique described here:
https://www.myonlinetraininghu.....on-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.
1 Guest(s)
