Hi,
I'm new to Alteryx world and need help in creating a Reconciliation tool for monthly transactions.
1. We will receive client provided transaction report which we need to reconcile with our books and give specific comments for mismatch for : Amount, Deal name and Currency and date of transaction.
2. Challenges: Deal name from client provided report is not same in our records for eg : in client report 1 deal name is ABC capital and, in our books, it is registered as Alpha Beta capital partners.
so, considering this deal name challenge how we reconcile rest of the elements like amount and ccy.
3. Input: a. Transaction records provided by client.
b. Transaction records as per bank.
Output: Data from client provided should be stacked next to bank records data according to deal name and recon column should be create for amount, currency, date of transaction and deal name (comments should be provided matching or not matching). also, data which is not matching with client records but is a part of bank records should be part of final output and can be stacked below the reconciliation data.
Attached sample screenshot of final output.
