Consolidating trial balance data

Alerts and notices
Leave feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.

Characters left:

AdvanceFlow allows you to consolidate trial balance data from multiple engagements. 

Note: AdvanceFlow allows you to consolidate multiple consolidated engagements (tiered consolidations). There is no limit to the number of levels that you can consolidate.

You can designate a parent engagement for trial-balance consolidation by choosing Consolidated Trial Balance for the account structure when you add an engagement.

To consolidate trial-balance data for multiple engagements, follow these steps.

  1. Click the Engagements button in the navigation pane and then select a parent engagement.

    Note: Engagements that have been designated as parent engagements for trial-balance consolidation are indicated by a multiple binder Consolidated binder icon icon in the navigation pane.

  2. Click the Trial Balance tab in the workspace and then click the Consolidation Consolidation button button in the ribbon.
  3. In the toolbar of the Consolidation dialog, click the Add Add Subsidiary Engagement button button.
  4. Click the Lookup list Lookup list button button for the Client field, select a client, and click OK.


    • When you consolidate trial balance data by account number or by account grouping, only engagements that match the consolidated trial balance's reporting periods will be available.
    • When you consolidate trial balance data by tax code, only engagements that match the consolidated trial balance's reporting periods and tax entity will be available.
  5. Select an engagement and click OK.
  6. In the Subsidiary Engagement dialog, verify that the balance type and label information are correct, update this information as needed, and click OK.

    Note: AdvanceFlow uses label information to create column headers and report column headers in the Trial Balance workspace.

  7. Repeat steps 3 - 6 to add additional subsidiary engagements as needed.

    Note: You can add up to 100 subsidiary engagements per consolidated engagement.


    • To update the subsidiary engagements list, select an engagement and then click the Move Up Move Up button, Move Down Move Down button, or Delete Delete button toolbar buttons.
    • To update the properties of a selected engagement, click the Properties Subsidiary Engagement Properties button button in the toolbar.
  8. Optional: Select a new primary subsidiary option from the Primary field.

    When you change the primary subsidiary, AdvanceFlow reconstructs the Trial Balance view and removes all workpaper references.

  9. Choose the appropriate option from the Consolidate By field.
    • Account Grouping
    • Account Grouping with Subcode
    • Account Number
    • Tax Code
    • Tax Code with Subcode

    To consolidate by Tax Code, tax vendor information must be designated for your firm in AdvanceFlow.

  10. Click OK to close the Consolidation dialog.
  11. In the Trial Balance workspace, click the Consolidate Consolidate button button in the ribbon.

Related topics

Share This