Return to Financial Consolidation Model Overview.
The Intercompany Relation Summary report provides a summary of the transactions between different entities within a Group. It shows transactions between a pair of two different entities, like the Intercompany matrix report, but the difference is that it shows the data in a summarized format rather than in a matrix or table format
The report shows all the consolidation rules, relations, mismatches, and transaction currency mismatches.
Report Heading
The report heading updates dynamically as various reporting options are selected. Below it shows the Version, Month_YTD, Entity, Partner Entity, Consolidation Rule, and Currency dimensions. (Actual 2020-12_YTD, Total Group, 16- Bikers Best Nippon, Local Currency (JPY) ):
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 check-boxes below allow you to customize the appearance of your report:
- Click
Show Account No.if you wish to display the account number prior to the account name (e.g.Total property, plant and equipment→110100 - Total property, plant and equipment). - Click
Show Two Decimal Placesif you wish to show the figures in double-decimal form (e.g.2,947,066→2,947,066).
Table Columns
The Intercompany Relation Summary 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 December 9, 2024