FILTERING/MATCHING TRANSACTIONS

Question

Good day everyone,

I am trying to perform a reconciliation of transactions from two data sources (internal and external statements) I am able to match 90% of the transactions however the 10% is made up of 8 different scenarios for which I need assistance in creating a workflow/workflows to match/filter out the transactions. Attached is sample data with the 8 different scenarios, also included is explanations of how each scenario should be matched.

SAMPLE DATA MATCHING.xlsx

MulengaYB · Answer

Hi The Rad Valentina

Thank you for the workflows and time spent to create them, unfortunately none of them are giving the desired results, and I think the issue is when you filter the internal refs that are null, its an issue because it does not fit into the logical criteria for matching the transactions, also another issue I have seen is when you use the join tool, this is an issue because it will join duplicates as one transaction. Thank you again I really do hope I find a solution to these scenarios.

The_Rad_Valentina · Answer

See how I solved 1, 2 and 3. Hope this helps to continue on. Ultimately, you can make them into a Macro for each different scenario. I attached one that will work for 2 and 3.

Scenario 1, 2, 3.yxmd

External to External Match.yxmc

MulengaYB · Answer

Hi Everyone

Even a solution to any one of the scenarios will be appreciated.