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 (220.127.116.110.100.000.000.000.00000.000) 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.¬†