How to roll forward consolidated engagement files

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 individual entities

Roll forward the individual entities as instructed in How to Roll Forward an Engagement File?
2. Roll forward all the Consolidation file

Roll forward the consolidation file as instructed in How to Roll Forward an Engagement File?

Note: There is no difference in the roll forward process between Consolidated and Single entity engagement files.
3. Adjust Consolidation Properties

After both the individual (i.e subsidiary entities) and the Consolidation file have been rolled forward, follow the procedure below.


1. Open the newly rolled forward Consolidation file.

2. From the menus, select Engagement | Consolidate. The Consolidation screen will open.

3. Select the first entity in the tree and click Properties. The Entity properties screen will open.

Note: The entity is still pointing to last year’s engagement file.

4. Under External Source for Entity Detail, browse for the new appropriate rolled forward entity.

Untick Include Prior Balances. This will remain deselected for the life of the file.

5. Click OK to save the settings.

6. Repeat step 2) to 5) for each entity in the consolidation tree.

7. After all entities have been adjusted, click OK.

Note: You may wish to import the New Year’s trial balance into the individual entities prior to adjusting the consolidation properties.

    • Related Articles

    • How do I Carry Forward the Engagement File?

      The concept of a roll forward still applies to Cloud Financials, however, it is referred to as the carry forward procedure. This entails carrying forward data and responses from your prior year Cloud Financials engagement into your current year ...
    • Create New File and Import Data (update method 2)

      The conventional method of updating an engagement file to the new version of the template follows the Staff Update Guide (“update method 1”).   However, there is another method available when the standard year-end close and roll forward is not an ...
    • 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 ...
    • 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 to retain Document References on a Roll Forward?

      CaseWare Working Papers allows users to roll forward their Document References into next year’s file. This saves re-referencing in the new year’s file and can be particularly useful if also rolling forward external documents as Placeholders. ...