PPS Planning - Management Reporting Consolidation Model Properties Explained

There are 3 model properties that deal with executing a consolidation for a Financial Model without Shares. Let’s see what they are and how they are used.

Suppose we have the following entity hierarchy

North America

                                US

                                Canada

                                Mexico

 

The first model property we will talk about is called Management Consol Elim.

If this model property is set to TRUE then any intercompany transactions between US, Canada and Mexico will be eliminated and written to the Elimination Business Process Member of the parent entity, which in this case is North America. If this model property was set to FALSE then the elimination result will be written to the Elimination Business Process Member of the originating entity (either US, Canada or Mexico in our case).

 

The second model property we will talk about is called Consol balancing account Bal Sheet.

This model property should be set to an account where the results of all intercompany eliminations for balance sheet accounts for the consolidation will be written. This account must be a non-intercompany, leaf level balance sheet type of account. The reason for this model property is to keep everything double sided and balanced. If the debit/credit property of the account to be eliminated is the same as the debit/credit property of this model property, then the value in this account will be the same sign as the original data, otherwise it will be negated.

 

The third model property is called Consol balancing account Profit Loss.

This model property is identical in functionality to the above model property except that it is used when eliminating P&L accounts during the consolidation. This account must be a non-intercompany, leaf level non-balance sheet type of account.