Performing Matrix Consolidation

Objectives
After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Perform matrix consolidation

Management Consolidation Use Case

Matrix consolidation key points

In the corporate close process, we have run the intercompany elimination tasks and now we can report on the results. We need reports that show the performance from a management perspective as well as from a legal perspective. For example, legal reports will be by consolidation unit but management reports will be by profit center or segment.

In addition, we have a business requirement to view income statement data with a consolidation view as compared to a contribution view:

  • The consolidation view will show total revenue by entity along with an elimination entity (for each consolidation unit hierarchy node).
  • The contribution view will show revenue net of eliminations by entity.
Note
The term matrix consolidation refers to the concept of preparing legal and management consolidated data simultaneously. Group reporting provides multiple views of the data to answer many different business questions. There is only one set of data, therefore there is no data redundancy.

In the Consolidation unit consolidation and contribution view example, we are reporting on consolidation unit revenue with the contribution view and the consolidation view. The same hierarchy is being used for both views. The consolidation view dynamically determines the elimination entity based on the first common parent in the legal hierarchy.

Each view uses a different dimension:

  • Contribution view uses the Consolidation Unit dimension.
  • Consolidation view uses the Consolidation Unit for Elimination dimension.

Matrix Report Examples

In the following content, you will an example of how to create multiple reports on a single set of data to answer multiple business questions.

In the Profit center - consolidation and contribution views example, we are reporting on profit center revenue with the contribution view and the consolidation view. The same hierarchy is being used for both views. The consolidation view dynamically determines the elimination entity based on the first common parent in the line-of-business hierarchy.

Each view uses a different dimension:

  • Contribution view - uses the Profit Center dimension.
  • Consolidation view - uses the Profit Center for Elimination dimension.

When analyzing management entity data, you can use either the Profit Center dimension for a contribution view or the Profit Center for Elimination dimension for a consolidated view. In order to do this, the relevant profit center hierarchy must be selected via the report prompts.

In addition, Segment and Partner Segment can also be used for evaluation of management consolidation data.

In the Elimination entity determination with two different hierarchies example, the consolidation view (total revenue by entity along with an elimination entity for each consolidation unit hierarchy node) is provided by using two different hierarchies:

  • Legal hierarchy: Elimination entities are dynamically determined via the parent nodes in the legal hierarchy.
  • Line-of-business (LOB) hierarchy: Elimination entities are dynamically determined via the parent nodes in the line-of-business hierarchy.

In summary, legal consolidation data can be evaluated with a legal-oriented consolidation unit hierarchy. An alternative hierarchy by line-of- business can also be used to provide a management perspective. In either case, the first common parent in each hierarchy will display the elimination values dynamically. And, because the calculation is on-the-fly, there is no duplication of data.

Elimination Entity Documents

When reporting on data by consolidation unit for elimination or profit center for elimination, you can jump to the underlying documents to view the dynamically determined elimination entities.

You can also view the elimination entity values by running the Display Group Journal Entries with Reporting Logic app. In either case, hierarchies must be selected for the consolidation unit and profit center/segment dimensions.

In the following scenario, you need to solve a business scenario. Note: There is no audio with this interaction.

Analyze Intercompany Eliminations with Microsoft Excel

Save progress to your learning plan by logging in or creating an account

Login or Register