Return to Financial Consolidation Model Overview.
The Consolidation Rule report allows users to easily filter the scope of consolidation parameters and create consolidation rule lines. This report enables users to define the rules and scope of their consolidation process, ensuring that the financial data is accurately consolidated and reported.
The Consolidation rule report allows users to filter the scope of consolidation parameters, such as the entities included in the consolidation, the accounts used, and the time period covered by the consolidation.
Once the scope of consolidation parameters is defined, the Consolidation rule report can be used to create consolidation rule lines. These rule lines specify how the financial data should be consolidated. This allows users to ensure that the consolidation process is performed in accordance with accounting standards and best practices.
Rule Consolidation tools
The buttons are described as below:
| Button | Description |
| Posting Journal Instructions |
The Posting Journal Instruction provides information on the Posting journal header and Consolidation Rule Lines for the selected Consolidation Rule. It is a detailed view to set the instructions for each Consolidation Rule Line.
|
| Analyze Consolidation Rule |
The Analyze Consolidation Rule report is created for experienced users who want to understand the Consolidation Rule filters of the selected Consolidation Rule and debug the rule when required. The report first shows the Consolidation Filters. When all the combined filters are valid, the posting Journal Instructions and Intercompany Cube are shown for the selected Consolidation rule in combination with the POV filters.
|
Filters on Scope of Consolidation Parameters
Four filters in the scope of consolidation parameters can be activated/enabled by the user in the Financial Consolidation Consolidation Rule report.
-
The filter for the direct ownership rate: retrieves pairs of the holding entity as the legal entity with any entity included in the group with a direct ownership rate as the partner entity.
-
The filter for the direct ownership rate of the partner entity on the legal entity: is a mirrored direct ownership rate filter. This filter retrieves pairs of the holding entity as the partner entity with any entity included in the group with a direct ownership rate as the legal entity
-
The filter for the consolidation rate of the partner entity in the scope of the legal entity: retrieves pairs of the holding entity as the legal entity with any entity which is included in the group with a non-zero consolidation rate as the partner entity
-
The filter for the consolidation rate of the legal entity in the scope of the partner entity: is a mirror of the above consolidation rate filter. This filter retrieves pairs of the holding entity as the partner entity with any entity which is included in the group with a non-zero consolidation rate as the legal entity.
Filter on Investment Register Parameters
This section currently includes only one optional filter. To filter for consolidation rules related to the Total Divestment Business Transaction Type, this filter should be selected (enabled). Otherwise, the section should remain empty.
Consolidation Rule Lines
This section shows the list of Consolidation Rule Lines for the chosen Consolidated Rule and the calculation used to compute the Consolidate Rule line.
Consolidation Rule Line report
When clicked on, the Consolidation Rule Line report shows all the details of the selected Consolidation Rule Line. It includes data like the Name, Description, and Consolidation Rule detail.
Updated November 4, 2024