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 view my CaseWare Template
Viewed 3409 times since Tue, Jun 17, 2014
How to convert multiple CaseWare Documents into a single PDF File
Viewed 2362 times since Wed, Jun 18, 2014
Mapping source is missing
Viewed 1122 times since Wed, Aug 31, 2016
How to create a back-up of a CaseWare File
Viewed 4821 times since Wed, Jun 18, 2014
How to customise the ’Layout’ within an Issue Type
Viewed 2840 times since Fri, Jun 20, 2014