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

    • Create New File based off Existing for purposes of Roll Forward

      When the standard year-end close and roll forward is not an option, users can create a new file based off an existing/ prior year file and opt to roll forward into a new year. Step One:  Within Working Papers: File > New > Based on template > Create ...
    • 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 ...
    • 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. ...
    • How to Roll Forward Risks and Controls.

      When recording risks throughout an engagement file, there is an option to have the risk roll forward to the next year. If the risk is likely to remain, this option should be ticked. This will avoid the need to re-enter the details in future years. To ...
    • How to Roll Forward an Engagement File

      Note: There is only one correct way to roll forward an engagement file (whether it is an audit or financials file). 1. From the Engagement tab, select Year End Close to display the "Year End Close and Roll Forward" dialog.  2. Press the Browse button ...