Consolidated Ledger > Consolidation Reports > Consolidated Account Balance Report

The Consolidated Account Balance Report displays the subsidiary companies’ GL Account balances that are included in each GL Account ID in the consolidation company.

Note: This report is only accessible from within the consolidation company.

This report has the following uses:

•To aid in the evaluation and analysis of each subsidiary company’s contribution to the consolidated totals.

•To aid in verifying the completeness of consolidated balances.

To print the Consolidated Account Balance Report, follow these steps:

1.Access the Account Balance Report function from the Consolidation group of the Reports main menu.

2.Select the report configuration that you want to use by clicking the List box button beside the Configuration field.

3.Click the List box button beside the Sort By field and select one of the following sorting options:

•Account ID

•Post Pd and GL Acct ID

•Subsidiary Company ID

4.Click the List box button next to the Layout field and select the desired layout for the report.

5.In the Type area select whether you want the report to be displayed in Detail, Subtotal or Grand Total.

6.Mark the applicable checkboxes in the Report Header area if you want to Include Time or Include Printed By information in the report header.

7.In the Report Configuration area, define the desired report filters. You may mark the Individual checkbox if you want to generate the report for a single record and enter the appropriate value in the adjacent field; otherwise, select in the Filters area the desired criteria in generating the report.

Note: The available fields in the Filters area may vary when you select a different sorting option.

8.Choose either the Show Home Amount or Show Amt Used in Cash Flow Calculation option.

9.Mark the Show Multi-Currencies checkbox if you want to display the foreign currency amounts.

10.Click the Preview or Print button to preview or print the consolidated report. Click the Configure tab to return to the report configuration page.

The Consolidated Account Balance Report function also provides you with flexibility to perform the following:

Consolidated Account Balance Report

Consolidated Account Balance Report

See Also