SOLVED

Macro to reconcile Large Set of Data (Bank Statement to Transactions)

Iron Contributor

Hi 

 

I have very large sets of data (10k transactions per day). I wish to have a macro to match bank statement to transactions waiting for money. I am aiming to have it spit out a report which shows transactions on the bank statement which weren't matched, and one which shows transactions still waiting for money. 

 

Attached is a template example.

 

Can someone please assist.

1 Reply
best response confirmed by calof1 (Iron Contributor)
Solution

@calof1 

That's job for Power Query if you consider such option - query all transactions, create reference queries, filter them as needed and load results back to Excel spreadsheet.

1 best response

Accepted Solutions
best response confirmed by calof1 (Iron Contributor)
Solution

@calof1 

That's job for Power Query if you consider such option - query all transactions, create reference queries, filter them as needed and load results back to Excel spreadsheet.

View solution in original post