You are here: All Help Topics > Accounting and Assurance > Automatic Documents > Creating consolidation reports

Creating a Consolidated View Document

Procedure

On the Document Manager, click on the location (document or folder) where you would like to add the new automatic document.

Note: If you click on a document, the new automatic document will be created below the document you clicked. If you click on a folder, the new automatic document will be created as the first document in the folder.

On the Home tab, in the Insert group, click Automatic Documents.

In Document Type, select one of the following document types: Trial Balance or Leadsheet/Grouping.
In Format, select a corresponding format for the document type using the preceding table.
Select the Consolidated View check box. The consolidated view is supported only if the Balance Type is set to Report or Consolidated.

Balance Type	Description
Report	The following balance columns appear: Report Balance entity 1 to Report Balance entity n Total Report Balance Prior Year Report Balance
Consolidated	The following columns appear: Report Balance Entity 1 to Report Balance entity n Total Report Balance Eliminating Entries Total Consolidated Balance Prior Year Consolidated Balance

Balance Type

Description

Report

The following balance columns appear:

Report Balance entity 1 to Report Balance entity n
Total Report Balance
Prior Year Report Balance

Consolidated

The following columns appear:

Report Balance Entity 1 to Report Balance entity n
Total Report Balance
Eliminating Entries
Total Consolidated Balance
Prior Year Consolidated Balance

The consolidated view is not supported if a five-year format is selected or if the Order is set to Report. If the consolidated view is not supported for a certain report, the Consolidated View check box is grayed out.

Complete the remainder of the options. See Automatic Documents properties for details.
Click OK.

Results

Trial Balance or Leadsheet/Grouping document with consolidated view is added to the Document Manager. Working Papers attempts to fit the columns across a single page. If the number of entities is sufficiently large, Working Papers splits the columns among multiple pages when printing.

As well, when Working Papers spans consolidated reports across multiple pages, the account number and account descriptions are held in a Column Freeze, meaning they will remain onscreen as the document is scrolled.

Notes

Annotation cannot be inserted on consolidated reports.
Any changes to the consolidation hierarchy will result in consolidation reports being set to their defaults.
You can drill-down by entity and account in consolidated view documents. To view detail by entity, select a line and right-click on the applicable entity column and select expand. Detail for that entity and all its sub entities are displayed. Note: Click in the body of the entity column, not the column heading. To view detail by account to show the top most entity applicable in the document and all its sub entities, do any of the following while your cursor is positioned outside of an entity column:
You can link CaseView documents to the balances in a consolidated Working Papers file. You can also link one CaseView document to balances from two or more entities in the consolidation tree, allowing you to create reports that compare the performances of all the subsidiaries in the consolidation.For more information, see To link balances from a consolidated file in the CaseView help.