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

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 in the Consolidation file, you need to do the following:
Procedure in the individual foreign subsidiary engagement file: 
  1. Create and Map a Foreign Exchange Gain / Loss account
  2. Enter the Foreign Exchange rate (Opening / Current) for all applicable financial periods.
  3. Assign the new FX account created in step 1 to the Settings for Reports screen
  4. In the Consolidation file, Apply Foreign exchange.

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. 

    • Related Articles

    • How do I roll forward a Consolidation file?

      Once an engagement with a Consolidated Entity has been completed, the next step would be to roll forward the Consolidation File.  The correct way to roll forward a consolidation entity is following the process below: 1. Roll forward all the ...
    • Consolidation in Agile Audit

      Although consolidation is a feature in Agile Audit, it is important to be aware of a few key rules/best practices: 1. Only Trial Balance and journal data will be consolidated - there is no consolidation of risks or documentation between entities ...
    • Why is my Trial balance balancing in Excel but not in CaseWare

      If your trial balance in Microsoft Excel is balancing well, but not in CaseWare it is likely that there are existing duplicated account numbers within your Excel Spreadsheet. CaseWare Working Papers will only allow unique account numbers to be ...
    • How to prepare consolidated financial statements

      Consolidated financial statements can be prepared by creating: 1. Multiple engagement files (multiple entity trial balances)     This will require the setting up of a consolidation,  and the importing  of a trial balance into each engagement file.   ...
    • How do I Change the Colour of the Working Trial Balance

      Users can change the colour scheme of the Working Trial Balance. To do this: 1. From the Tools tab, select Options to display the 'Options' dialog. 2. From the 'Properties' menu select General. 3. From the 'Colour Scheme' picklist select from the ...