Hello,
Recently one of our bank accounts went from 10k+ transactions a month, to 15k+ transactions a month. Obviously this is far too large to click these transactions one by one in our accounting system (Quickbooks Enterprise), and unfortunately our bank does not have the ability to connect to auto reconcile, so what we do is create an OFX import file based on the bank statement and import it into QuickBooks. Since the 5k+ transaction increase, this does not seem to be working as well so I wanted to create a macro to simplify this.
Basically after we import the OFX file, there are several transactions that are checked off to be reconciled that should not be, and vice versa. What we do is compare the bank statement transactions to the reconciled export list from Quickbooks to see where the discrepancies are. Currently we have someone go through these line by line, clicking off transactions that should not be checked, and clicking the ones that the import missed. What I would love to create (with the wonderful help from the members of this forum) is a macro that would go through these exports and create a simple list of transactions to un-reconcile and reconcile. I think the attached excel spreadsheet describes what I'm looking for much better than I can explain it here (highlighted items will not be highlighted on actual bank rec file).
I consider myself a basic VBA user with the ability to understand and modify VBA coding, but really have a lot of trouble 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.
Bookmarks