This report is used to show a trial balance for a consolidated company. Before a business unit can be included in the report, it must be set up in the Business Unit table and have a check mark in the Consolidate field. If there are four business units or fewer, you can use the Consolidated Trial Balance (4) report.
Each account appears on a line by itself (following the structure of the chart of accounts). An account is not shown if all the amounts on the line are 0. The following information is shown for each account:
The total for each business unit in a separate column. The total can be displayed as either a net change or the balance to date.
The total for the consolidated company, shown as either a net change or the balance to date.
The eliminations made in the consolidated company. They will always be shown for a period corresponding to the consolidated company's fiscal year.
The total for the consolidated company after the eliminations, shown either as a net change or the balance to date.
You can define what will be included in the report by setting filters. You can set additional fields on the tab by clicking the Field field, then clicking the AssistButton that appears to the right. You can also determine what is shown in the report by filling in the fields on the Options tab. Fill in the fields as follows:
No.: Select the G/L accounts to be included in the report. To see the existing G/L account numbers, click the Filter field and then click the AssistButton that appears to the right.
Global Dimension 1 Filter: Enter the dimension values to be included in the report.
Global Dimension 2 Filter: Enter the dimension values to be included in the report.
Click the up-arrow at the lower left-hand corner of the window to see the result of the filters you have defined for the table.
Starting Date: Enter the first date in the period from which posted entries in the consolidated company will be shown.
Ending Date: Enter the last date in the period from which posted entries in the consolidated company will be shown.
Amounts in whole 1000s: Place a check in the box if you want the amounts in the report to be shown in whole 1000s.
Click the Print button to print out the report. If you want to see the report on the screen before printing, click the Preview button. If you do not want to print the report now, click Cancel to close the window.