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 delete Transactions entered into Trial Balance
Viewed 12880 times since Thu, Jun 19, 2014
How to Create Split-up Accounts in the Working Trial Balance
Viewed 6246 times since Fri, Jun 20, 2014
What is the difference between Sign out and Check out?
Viewed 6797 times since Thu, Jun 19, 2014
How to Roll Forward an Engagement File
Viewed 41394 times since Tue, Jun 17, 2014
How to Ensure Journal Entries are always in Balance
Viewed 1793 times since Wed, Jun 18, 2014