Using multiple currencies in Transaction Matching
SummaryHow to match in multiple currencies and pass the unmatched transactions into the correct currency in a reconciliation
When using RC by itself we can load several currency balances in the Entered bucket and explain these individual currency balances so that each individual currency difference is 0. I want to replace the explanations in each currency with unmatched transactions fed from TM on our bank recs.
I can set up TM and match over several currencies by using a currency attribute in the data source to drive the matching, but when TM shows the unmatched amount in the corresponding rec, it aggregates all unmatched amounts into the default currency for the rec. How do I set this up so that all USD unmatched transactions go into the Entered - USD - Less Unmatched entry slot, EUR unmatched into their corresponding slot, etc. I have attached an image to help explain. The -36 mill GBP Less Unmatched amount is actually the USD, EUR and GBP transaction amounts summed