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 (2.9.0.810.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. 

    • Related Articles

    • Transfer a mapped Trial Balance from a Working Papers Consolidation file to a Cloud engagement

      CloudBridge can import a mapped trial balance from Caseware Working Papers Consolidation file into a Cloud engagement file. Please refer to the instructions below:  In  Export Trial Balance Data? select Yes. CloudBridge will pick up whether the ...
    • 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) Click on the following link for guidance using this option: How to create a consolidation hierarchy 2. A standalone ...