Macro for Bank rec with deposit dates

[NaomiKeetham]

Hello,

Our bank accounts have nearly 10K transactions in a month and we donot have any automated in system or in excel to reconcile bank transactions with trade debtors.

What we do currently is one of the staff go through line by line and create a variance to reconcile.

I have seen similar post in Excel forum and tried that method but didnt work for me as we have deposit date as against check no.


Can anyone help me with modify VBA so that it can work. I have attached the excel file.

Thank you in advance