Return to Financial Consolidation Model Overview.
This Report provides a detailed view of the financial transactions and relationships between different legal entities and partner entities within a company that is consolidated in a single financial statement.
This report is used to identify relations, mismatches, and transaction currency mismatches. This report includes the total number of Intercompany Amounts
Report Heading
The report heading updates dynamically as various reporting options are selected. Below it shows the Version, Month_YTD, Entity, Scope, Consolidation Rule, and Measure dimensions. (Actual, 2020-12_YTD, Total Group):
The logo can be changed in Administration; see Configuring Design Elements for more on report design.
You can select your base elements in the ComboBoxes below the report heading:
The Version dimension separates actual figures from planning figures, see full article. The Month_YTD dimension accumulates float values from the beginning of the calendar year to the current date, while respectively holding the final figure for stock values, see full article. The Scope dimension contains all target elements for financial consolidation in a flat list, see full article.
Table Columns
The Intercompany Matrix report displays different aspects of the base elements you select in several tables. The table includes Balance Sheet elements for Business combination elements. It shows data from two consequent years (PY and current year chosen in POV.) The columns displayed in the report depend on the the selection made in the PoV area:
The table breaks down into three parts. Above we see the Total property, plant and equipment section.
| Field | Description | Implementation |
| ComboBox selection | Current POV selection for filters needed. |
Shows Combobox filters to choose |
| Row data | Elements from Balalnce sheet | Row names include accounts from Balance Sheet for PY and current year based on POV selection. |
|
Column |
Shows data for Business Combination elements. | Shows data for Business Combination elements like Goodwill and investments |
Updated March 27, 2024