System reports - Intercompany Report window
User
System reports tile > Gross and IC amounts > Intercompany report
Processes tile > select process > Consolidator > Overview tab or Step tab > (Actions) Process reports > Intercompany report
Processes tile > select process > Contributor > Detail summary tab > (Actions) Process reports > Intercompany report
Navigation panel > Processes > select process > Consolidator > Overview tab or Step tab > (Actions) Process reports > Intercompany report
Navigation panel > Processes > select process > Contributor > Detail summary tab > (Actions) Process reports > Intercompany report
Purpose of window¶
Allows you to set filters to export the desired data related to intercompany entries in a single Excel file.
Report contents¶
Collects data on the intercompany entries (IC amounts and entity journals) that exist between entities belonging to the same group.
Reports on consolidation scenarios show the proportional amount type data. They show the IC entries that flow into the consolidation area, before the consolidation process. These are therefore still in the entity/transaction currency rather than the consolidation currency. This also allows you to view the IC entries of the entities consolidated at equity which, as they are not consolidated, would not be shown on the consolidated amount type.
Filters in the window
| Element | Description |
|---|---|
| Original scenarios | Allows you to select only scenarios/periods related to original scenarios. |
| Consolidation scenarios | Allows you to select only scenarios/periods related to consolidation scenarios. |
| Scenario /Period | Allows you to select an original or consolidation scenario that is active and visible to the user. Contributor users can only select original scenarios/periods. |
| Report type | - Synthetic: the data are grouped by category, declaring entity, custom dimension 2, account and, if sorting by Category/Declaring entity/CTP Entity/Account is selected, also by counterparty entity. A row with the subtotals is inserted for every grouping. - Analytic: all the rows of data are reported, without any grouping. |
| Account nature | Allows you to include in the report only intercompany entries on accounts of the indicated nature: - Balance Sheet - Profit & Loss - Memorandum - Other Variations - Other Stocks |
| Account type | Allows you to include in the report only intercompany entries on accounts of the indicated type: - Normal - Variation - Detail |
| Account | Allows you to include in the report only intercompany entries of the selected accounts: Note: only accounts that are consistent with the filters set in the Account nature and Account type fields are proposed. |
| Transaction currency | Allows you to include in the report only intercompany entries in the indicated transaction currency. |
| Declaring entity | Allows you to include in the report only intercompany entries for the indicated declaring entity or entities. Note: if a consolidation scenario/period is selected, the entities must belong to the consolidation area of the selected scenario. |
| CTP entity | Allows you to include in the report only intercompany entries for the indicated counterparty entity or entities. Note: you can also select an entity that is not visible to the user. Note: if a consolidation scenario/period is selected, the entities must belong to the consolidation area of the selected scenario. |
| Also show inverted relationships | If a declaring entity has been selected, the report will include both the intercompany entries in which this entity is the declaring entity and those in which it is the counterparty. If a counterparty entity has been selected, the report will include both the intercompany entries in which this entity is the declaring entity and those in which it is the counterparty. |
| Category | Allows you to include in the report only intercompany entries on the indicated category. Note: You can select a amount or entity journal category that is visible to the user. |
| Elimination/Matching Rules | Allows you to include in the report only intercompany entries on accounts belonging to the indicated matching logic. Note: only one IC matching logic can be selected. |
| Sorting | Allows you to set the sorting criteria for the data shown in the report: - Category/Declaring entity/Account/CTP Entity - Category/Declaring entity/CTP Entity/Account |