Consolidation Report

Report Module Guide: Consolidation Report

Module Location

General Ledger > Report > Consolidation Report

Module Objective

The Consolidation Report module is used to combine the financial statements of multiple company entities (a parent and its subsidiaries) into a single, unified financial report as if they were one entity. This report is crucial for group (holding) companies to get a comprehensive overview of their combined financial position.

1. Report Parameters (Consolidation Filter)

The main page of this module is a form containing various parameters to customize the consolidation report that will be generated.

Here is an explanation for each parameter:

Include Account Numbers / Rounding:
- Check Include Account Numbers to display account codes on the report.
- Check Rounding to round the monetary values on the report.
Period:
- Select the month and year of the reporting period to be consolidated (e.g., July 2025).
Report Type:
- Choose the type of consolidation report you want to generate.
- Worksheet: Generates a consolidation worksheet that details the data from each individual company, the elimination entries, and the final results. This is useful for auditing and verification processes.
- Balance Sheet: Generates the final, combined Consolidated Balance Sheet.
Currency:
- Choose how currency values will be displayed, either in Respective Currency (original currency) or Base Currency (company's base currency).

2. Steps to Generate the Report

Step 1: Set Report Parameters

Select all the parameters you need in the Consolidation Filter section, especially making sure to define the desired Period and Report Type.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons in the bottom-left section of the page:

Display Report: To preview the consolidation report directly on your screen.
Export To MS Excel: To download the report data in an Excel file format.

Tips & Important Notes

The Consolidation Report is crucial for group companies to see the combined financial position of all their subsidiaries.
To get accurate data, ensure the book-closing process in each subsidiary is complete before running this report.
Use the Worksheet report type to trace and verify elimination entries (e.g., the elimination of intercompany transactions) that are made during the consolidation process.
This module is generally used by the Accounting team at the corporate or holding company level.

Revision #2
Created 31 July 2025 08:37:02 by Muhammad Ali Akbar
Updated 15 August 2025 10:27:37 by Muhammad Ali Akbar

Consolidation Report

Report Module Guide: Consolidation Report

Module Location

General Ledger > Report > Consolidation Report

Module Objective

1. Report Parameters (Consolidation Filter)

The main page of this module is a form containing various parameters to customize the consolidation report that will be generated.

Here is an explanation for each parameter:

Include Account Numbers / Rounding:

Check Include Account Numbers to display account codes on the report.

Check Rounding to round the monetary values on the report.

Period:

Select the month and year of the reporting period to be consolidated (e.g., July 2025).

Report Type:

Choose the type of consolidation report you want to generate.

Worksheet: Generates a consolidation worksheet that details the data from each individual company, the elimination entries, and the final results. This is useful for auditing and verification processes.

Balance Sheet: Generates the final, combined Consolidated Balance Sheet.

Currency:

Choose how currency values will be displayed, either in Respective Currency (original currency) or Base Currency (company's base currency).

2. Steps to Generate the Report

Step 1: Set Report Parameters

Select all the parameters you need in the Consolidation Filter section, especially making sure to define the desired Period and Report Type.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons in the bottom-left section of the page:

Display Report: To preview the consolidation report directly on your screen.

Export To MS Excel: To download the report data in an Excel file format.

Tips & Important Notes

The Consolidation Report is crucial for group companies to see the combined financial position of all their subsidiaries.

To get accurate data, ensure the book-closing process in each subsidiary is complete before running this report.

Use the Worksheet report type to trace and verify elimination entries (e.g., the elimination of intercompany transactions) that are made during the consolidation process.

This module is generally used by the Accounting team at the corporate or holding company level.