SOLVED
Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-892642%22%20slang%3D%22en-US%22%3EMacro%20to%20reconcile%20Large%20Set%20of%20Data%20(Bank%20Statement%20to%20Transactions)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-892642%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20very%20large%20sets%20of%20data%20(10k%20transactions%20per%20day).%20I%20wish%20to%20have%20a%20macro%20to%20match%20bank%20statement%20to%20transactions%20waiting%20for%20money.%20I%20am%20aiming%20to%20have%20it%20spit%20out%20a%20report%20which%20shows%20transactions%20on%20the%20bank%20statement%20which%20weren't%20matched%2C%20and%20one%20which%20shows%20transactions%20still%20waiting%20for%20money.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAttached%20is%20a%20template%20example.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20please%20assist.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-892642%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-893191%22%20slang%3D%22en-US%22%3ERe%3A%20Macro%20to%20reconcile%20Large%20Set%20of%20Data%20(Bank%20Statement%20to%20Transactions)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-893191%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F364226%22%20target%3D%22_blank%22%3E%40calof1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20job%20for%20Power%20Query%20if%20you%20consider%20such%20option%20-%20query%20all%20transactions%2C%20create%20reference%20queries%2C%20filter%20them%20as%20needed%20and%20load%20results%20back%20to%20Excel%20spreadsheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent 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
Highlighted
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.

Related Conversations
History and Data
rosenbloomsnka in Microsoft To Do on
0 Replies
How often the sync is triggered?
HotCakeX in Discussions on
5 Replies
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies