Create a consolidation engagement

Consolidation allows you to combine several entities into one engagement file (the parent company) for the purpose of publishing consolidated financial statements.

Define a consolidation hierarchy

To consolidate an engagement file you must first define the consolidation hierarchy. This describes the relationship between a parent company and its subsidiaries. It is used to combine the financial results of subsidiaries into their parent company's financial results.

Note that you can add multiple levels of subsidiary engagements. For example, the parent entity can have two subsidiary entities and those subsidiary entities can have their own subsidiary entities as well.

The Consolidation Hierarchy page displays this relationship in either the form of a flowchart or a grid.

The graph view of the Consolidation Hierarchy page.

The grid view of the Consolidation Hierarchy page.

You can define subsidiaries in two different ways in the consolidation hierarchy:

  • Linked engagement - If the subsidiary requires its own engagement file in a separate entity in your Cloud site, you can link the subsidiary’s engagement file to the parent engagement file.

  • Imported TB - If the subsidiary does not require its own engagement file, you can add the subsidiary internally in the parent engagement file and import the subsidiary’s trial balance to the file.

To define a consolidation hierarchy:

  1. From the engagement properties pop-up of the parent engagement file, select Consolidate.

    The Engagement Properties popup.

    The Consolidation Hierarchy page displays.

    The Consolidation Hierarchy page.

  2. Select More actions () for the parent engagement.

  3. To add a subsidiary with its own engagement file:

    1. Select Add linked engagement.

    2. Search for the subsidiary’s engagement file and select the correct one from the search results.

    3. Select OK.

    The Add Subsidiaries dialog for linked engagements.

  4. To add a subsidiary without its own engagement file:

    1. Select Add imported TB.

    2. Enter a name for the subsidiary entity.

    3. If necessary, modify the parent entity’s ownership percentage in the Percent Owned field. This field is used for information purposes only. Final balances are not affected.

    4. Select SAVE.

    The Add Trial Balance Only Entity option for internal subsidiaries.

  5. Select Save in the upper right corner to save and close the consolidation hierarchy.

    The Consolidation Hierarchy page.

 

If you want to view or modify the consolidation hierarchy after you have defined it, select the Consolidation icon () that now appears in the top menu.

Once you have added a subsidiary firm to the Consolidation Hierarchy page, the Consolidate button () no longer appears in the engagement properties pop-up. You can add more subsidiaries from the Consolidation Hierarchy page.

Import a trial balance for an internal subsidiary

If you use the Add imported TB option to add subsidiaries that do not have separate engagement files, you can import the trial balances for these entities from the Data page. You can select which entity you’re importing the trial balance for during the import process.

See Import and manage data for more information.

The Select entity for import step in the data import process.

In some jurisdictions, financial reporting for the parent entity must happen separately from financial reporting for the consolidation itself.

Using the Consolidation Hierarchy page, you can link a consolidated engagement file with the parent entity engagement file using the Parent Engagement dialog. Linking the two engagement files ensures that both engagements are displayed as a single entity in the consolidation hierarchy.

The Parent Engagement dialog:

  • Only allows the selection of one engagement file

  • Filters for engagements based on the same SE product and same year-end

  • Does not show engagements that are consolidated (have subsidiaries.)

To link a consolidation engagement to another engagement file:

  1. From the Cloud menu, select Engagements.

  2. Select your consolidation engagement, then select the Consolidation icon ().

  3. On the Consolidation Hierarchy page, navigate to the highest level parent entity in the hierarchy and select More actions () | Link parent engagement.

    Note: This icon does not appear if there is more than one engagement in the entity, or if the consolidated engagement already has accounts (added or imported.)

  4. From the Parent Engagement dialog, select the desired parent engagement and select OK.

    A consolidation hierarchy linked to another engagement file.

Updating a linked subsidiary engagement's trial balance

You can update a subsidiary engagement's trial balance data in a consolidated engagement by bringing in any changes made in the subsidiary engagement, while keeping changes made in the consolidated engagement.

If an update to the trial balance of a subsidiary engagement file has been made since consolidating, the Consolidation icon () that appears in the top menu displays with a red dot. In the Consolidation Hierarchy page, entities with updated trial balances display a warning icon (). You can apply the update using the Reconsolidate option in the hierarchy.

In the example below, changes have been made to the trial balance data for the CaseWare Auto Shop subsidiary. Select More actions () | Reconsolidate to update the information in the consolidated file.

The Reconsolidate option for a subsidiary in graph view.

The Reconsolidate option for a subsidiary in grid view.