Consolidation Dimension

image_pdfimage_print

Return to Financial Consolidation Model Overview

The Consolidation dimension contains the elements that represent the steps of the consolidation process. You can see these steps below:

Element Description
Local GAAP Figures from separate financial statements according to general accepted accounting principles are imported into the the Local GAAP element.
Adjustment 1 This element contains late adjustments to the local GAAP values. Reasons for such adjustments can be time constraints or process limitations in the data collection process or the compensation of accruals and deferrals.
Transition This element contains transitions from the local GAAP (the reporting standards used by the individual legal entity) to the group GAAP (the reporting standards used by the group or subgroup) .
Group GAAP Reported figures once adjustments and transitions are accounted for.
Correction Corrections to disclose unrealized reserves and losses and the depreciation thereof.
Group GAAP Corrected Group GAAP after the corrections for unrealized reserves and losses are accounted for. The values on this level are used for the intercompany reconciliation.
Adjustment Consolidation Method This element contains adjustments for consolidation methods:

  • Separate financial statements from entities consolidated with the equity method are removed.
  • Separate financial statements from entities consolidated with the proportional method are reduced by the non-consolidation rate
  • Intercompany relations to entities consolidated with the proportional method are reclassified as external by tthe non-consolidation rate

This element is populated automatically during the Consolidation procedure. 

Combined Financial Statement (Calculated)

All the above elements aggregated. After conversion into the group currency and aggregation of all entities these values represent the combined financial statement.

When the consolidation is run, the results from the Combined Financial Statement (calculated) in the group currency are transferred to the report, then further run through the consolidation rules, which are outlined below:

Combined Financial Statement

This element represents the result of the preparation phase and the beginning of the consolidation phase. Basically the figures are a physical copy of the Combined Financial Statement (Calculated) element, converted into the group currency.

C Capital Consolidation: The group of any consolidation measures on investments and equity.
D Debt Consolidation: The group of any consolidation measures on assets and liabilities. 
I Elimination of Unrealized Profit on Inventory: The group of any consolidation measures on inventory accounts including an unrealized internal profit.
S Expenses and Income Consolidation: The group of any consolidation measures on income and expenses, including dividends.
M Manual Consolidation Bookings: Users can choose to store manual consolidation journal entries in this group (to separate these from automated journal entries) or store the manual journal entries in on of the other groups and leave this element unused.
All Consolidations The aggregated value of all consolidation measures.
Consolidated The Consolidated Financial Statement figures consisting of the Combined Financial Statement and all consolidation measures.
Adjustment 2 This element contains adjustments of the Combined Financial Statement.
Consolidated Adjusted The final Consolidated Financial Statement, including the adjustments.

Attributes

The Consolidation Dimension elements can be configured through their attributes:

Attribute Definition

Name

Readable name of the partner entity, visible in the report. Localized translations can be provided. There is no hard-coded behavior implemented upon this name. (string)

ID_Name

Combination of the element name, a dash (“ – “), and the localized name attribute. (calculated, string)

Journaled

Numeric attribute with the following settings:

  • 1 on base level elements: these elements are under full control of the Posting Journal. You can create journals to populate this element. Imported data and manually entered values are disallowed and may be overridden once journal entries are posted-
  • 0 on base level elements: these element are not affected by the Posting Journal. Values for these elements may be imported or entered manually. Journal entries are disallowed and may not be created or posted.
image_pdfimage_print