Bank reconciliation using VBA

Hello,

I am looking for a way to automate the bank reconciliation process and make it a little less manual since we currently reconcile daily for multiple bank accounts and multiple locations. We currently use a report from QuickBooks Enterprise that generates the data we are matching to the bank account and insert both into a worksheet in an Excel spreadsheet. I have attached an example of what the start of the process looks like and the desired result. I would like to match the amounts from both QuickBooks to the amounts from the bank account, using column G and I, then the line with the bank account info would move next to the corresponding entry from QuickBooks. Entries that don't have a match do not need to move and can stay where they are at. I think the attached excel spreadsheet describes what I'm looking for much better than I can explain it here.

I'm a basic VBA user with the ability to understand and modify VBA code, but need more practice at getting something started from scratch.

If anyone could provide me coding for something similar to this that I can attempt to modify for our needs, that would be great. As always, I greatly appreciate any help I can get on this.

Thank you.

Still looking for an answer.

Alan and Scottie,

Thank you both for the help! This is working wonders.

Alan,

I have run into a problem with the marco working with data that comes from one of our banks. The data gets exported as a .csv file where as the other exports as .xls the data in the .csv file doesn't function through the macro. Any ideas? Is it just as simple as a formatting issue?