You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Using multiple currencies in Transaction Matching

Received Response
35
Views
5
Comments
edited Oct 9, 2019 9:36AM in Account Reconciliation 5 comments

Summary

How to match in multiple currencies and pass the unmatched transactions into the correct currency in a reconciliation

Content

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!