How to report Translated Trial Balance of a Foreign Currency Entity in a Consolidated File?

If a trial balance for an entity that you are consolidating is in a foreign currency, to report on the converted values, do the following:


Step 1: In the individual file for the applicable entity, open the Working Trial Balance and create and map ( a new Foreign Exchange Gain / Loss account.

Step 2: Click on the Foreign Currency tab and enter the exchange rate for the first account. If it is appropriate to apply the same rate to all accounts, copy the first rate, highlight the entire column and paste.  

Step 3:¬†Click on the Settings button in the Working Trial Balance. For the ‘Foreign Exchange’ field, select the Foreign exchange gain/loss account.

Step 4: When linking to the entity into the Consolidation File (under Engagement | Consolidate > New), tick Apply Foreign Currency. This will convert the trial balance at the elected exchange rate. 

Attached Files
There are no attachments for this article.
Related Articles
How to add a Hyperlink Annotation Reference
Viewed 11232 times since Thu, Jun 19, 2014
What are the practical issues when setting up a ’Half-yearly’ file in CaseWare?
Viewed 7363 times since Wed, May 7, 2014
How to Create / Edit a New / Existing Document Filter in CaseWare?
Viewed 3026 times since Thu, Jun 19, 2014
How can I Identify invalid sign offs after enabling Role dependencies?
Viewed 1946 times since Fri, Jun 20, 2014
Why are my annotation controls greyed out in my Leadsheet?
Viewed 3918 times since Fri, Jun 20, 2014