Bank reconciliations

[Haihud]

Any suggestions on how can automate the bank reconciliation using VBA?
Note: we have more than 20 bank accounts and the statements are in csv format

 

[awoohaw]

There are many ways. You can use power query, tables, vstack(), LAMBDA tools etc. Are your .csv file consistently formatted (same number of columns, and the column headers in the same order)? What about your ledger time point balances and outstanding transactions at that time - How do you have those set up?
Is it the same account (20 months) or 20 accounts for 1 month?

Mr. Excel has a forum for power query, called Power Tools. You can also go there to find solutions if you choose that route.

 

[Haihud]

There are many ways. You can use power query, tables, vstack(), LAMBDA tools etc. Are your .csv file consistently formatted (same number of columns, and the column headers in the same order)? What about your ledger time point balances and outstanding transactions at that time - How do you have those set up?
Is it the same account (20 months) or 20 accounts for 1 month?

Mr. Excel has a forum for power query, called Power Tools. You can also go there to find solutions if you choose that route.

Hi awoohaw,
The formats are consistent and ledger accounts they are 20 accounts for 1 months.
I am new to this filed, so Thank you for suggesting the power query forum I will definitely check it out.