I want to write a program that can help me automate the reconciling of a general ledger. This will involve one source file (any output of excel available) with multiple accounts and its transactions in each account on my side. This will be compared to statements from multiple banks (also in excel) that will be linked by the same account number.
My plan is to bring all data together, then sort by account and currency and highlight any outages. Anything that has a difference will go through a hierarchy of steps to resolve depending on the transaction type.
What would be the best recommended program for this project?