Navigating Consolidated Engagements

You can view the trial balance data and reports at the consolidated level or for a single subsidiary entity.

To select the entity to view, do the following:

  1. In the gray navigation bar at the top of the page, click the icon.
  2. Select the entity you want to view. The consolidated entity is always the first item on the list, then each subsidiary with an imported trial balance is listed in the same order as they appear on the Subsidiary Setup page.

The data that displays on the page is for the consolidated or subsidiary entity selected.

Trial Balance

For a financial consolidated engagement, only the "Financial" tab displays on the trial balance page. For a tax consolidated engagement, only the “Tax” and “Send to Tax” tabs display on the trial balance page.

  • When viewing the consolidated entity, you have a choice to view the subsidiary data in columns or in rows.
    • View Subsidiaries in Columns: This is the default view for the consolidated entity.

      • The subsidiaries are displayed in columns in the order they appear on the Subsidiary Setup page. To change the order on the trial balance, you must change the order on the Subsidiary Setup page.

      • The subsidiary columns show the Final balance type for a financial consolidated engagement and the Tax balance type for a tax consolidated engagement.

      • Columns after the subsidiaries:.

        • ‘Subsidiary Total’ column sums up all the subsidiary balances for each row. This is the total for all subsidiaries, even if a subsidiary column is currently hidden from view.

        • ‘EJE’ column displays the net amount of eliminating journal entries posted for each row.

        • ‘Consolidated Total’ (current year) column sums up the ‘Subsidiary Total’ amount and the net EJE amount.

        • ‘Consolidated Total’ (prior year) column sums up the ‘Subsidiary Total’ amount from the prior year and the net EJE amount in the prior year.

      • The rows and amounts are the account balances summed up to either the financial groups and subgroups or the tax groups and subgroups.

    • View Subsidiaries in Rows:

      • The subsidiaries are displayed in rows in the order they appear on the Subsidiary Setup page. To change the order on the trial balance, you must change the order on the Subsidiary Setup page.

      • The rows and amounts are the account balances summed up to either the financial groups and subgroups or the tax groups and subgroups.

      • The columns show all balance types and journal entry types.

  • When viewing a subsidiary entity, the trial balance rows are the imported accounts and balances. You can perform the same tasks on a subsidiary view that you can perform in a trial balance for a non-consolidated engagement.

Refer to Managing the Display of Your Trial Balance for additional information on how to sort, pin, and order columns.

Leadsheets (available with Financial consolidated engagements)

The consolidated view displays totals for each subsidiary. To view the account detail for a subsidiary, click the arrownext to a subsidiary to expand the subsidiary.

This view includes the following columns which are not available for non-consolidated engagements and subsidiaries:

  • EJEs (current year)
  • Consolidated total (current year)
  • Consolidated total (prior year)

You can add and view eliminating journal entries (EJEs) from the consolidated view.

The subsidiary view displays the same information that is in leadsheets for non-consolidated engagements. You can perform the same tasks on the subsidiary view that you can perform on leadsheets for non-consolidated engagements.

Financial Statements (available with Financial consolidated engagements)

The consolidated view displays the consolidated totals for all subsidiaries. You can add and view eliminating journal entries (EJEs) from the consolidated view. You cannot export the financial statements at this time.

The subsidiary view displays the accounts and balances assigned to the corresponding group. You can perform the same actions on the subsidiary view that you can perform on the Financial Statements page for a non-consolidated engagement, except for adding tax journal entries.

Tax Summary Report (available with Tax consolidated engagements)

The consolidated view displays four levels:

  1. Tax group total
  2. Tax subgroup total
  3. Subsidiary total
  4. Account balance

Click the arrow next to each level to view the detail that makes up the sub-total.

This view includes the following columns which are not available for non-consolidated engagements and subsidiaries:

  • EJEs (current year)

  • Consolidated total (current year)

  • Consolidated total (prior year)

You can add and view eliminating journal entries (EJEs) from the consolidated view.

The subsidiary view displays the same information that is in a tax summary report for non-consolidated engagements. You can perform the same tasks on the subsidiary view that you can perform on the tax summary report for non-consolidated engagements, including the “Link” feature to send tax balances to a CCH Axcess Tax return and the “Download Compfile” feature to export tax balances to a text file which can be imported into either a CCH Axcess Tax or ProSystem fx Tax return.