Automation required for bank reconciliation

Since this is my first post it is not allowing me to attach any file or link or images!
Is there any other way I can send you the workbook?

The paperclip Icon is broken. you are allowed to upload excel workbooks

1. Click Go advanced right bottom under the replybox.
2. Scroll down to the "Manage Attachments" under the advanced text editor
3. pick the file to upload and choose upload.
4. close the window
5. complete your message text and post your message with the attachement

(attachement does not always show under attachement link. try to p"review post" to see if the attachment was added. )

As I said I have 2 sheets in my workbook - Bank Statement and Bank Book.
So Basically I have to reconcile entries in Bank Statement sheet with entries in Bank Book sheet.

For reconciling I have to use various combinations for matching.

Here is the procedure:

If the "Date & Description & Amount" of a row in the first sheet matches with "Date & Description & Amount" of any other row in second sheet then I should get a unique code/number in the "Matching Reference" cells of the both the rows

If it does not match,
then match the "Description & Amount" in both the sheets as earlier and bring the unique code.

If this also does not match then show "unmatched" in "Matching Reference" cell.

I have attached a fresh sheet!
Hope this is understandable!

Seems like a very interesting task.

Works flawlessly! Thanks a lot!

Hi Mate...does your excel work okay.
could you upload the excel here please.

Can you share how you did this? I have the same situation. Thanks

As all the necessary is yet in this thread !

Ok I see it now - too complicated for my excel knowledge. Thanks anyway

Would this be able to give exact info like full match =which row, partial match which rows in a separate worksheet.
I am really keen to know if a modification can be done on your macro to obtain that, especially the partial matches.
I have the same challenge now.

Hello, I have a similar issue reconciling bank stmt activity to GL activity, with one added wrinkle. There maybe multiple transactions on the GL side that make up one transaction on the bank statement activity. I am fairly new to VBA, but this sure seems to be the closes thing i have found to solve my problem. Please help!

Hi I also required this VBA but when i try i am getting

"Subscript out of range error" on the below line

Please Login or Register  to view this content.