At times, a company only owns a percentage of another company. In this situation, when producing a consolidated report, it is important to only account for the percentage of ownership you own. Management Reporter uses the Rollup % in the Reporting Tree Definition, and setting this up is outlined in this blog post (the last in a series of blogs on consolidations).
In the Reporting Tree Definition, enter the % of ownership in column K, Rollup %, and when the report is generated, that percentage will be used to calculate the consolidated amount. In this example, Contoso only owns 80% of Contoso Denmark. The user can enter 80 in the column, or .8 and 80% will roll up to the consolidated level.
NOTE: You can apply this ownership percentage to any reporting unit, not just at the company level. This is helpful when ownership is at a business unit or division level, not just a legal entity.
At report generation, Contoso Denmark shows its full amount in the report for Contoso Denmark, and only 80% of it is allocated to the consolidated node. In the following example, at the consolidated level for Sales, you can see only 80% shows.
NOTE: For the month of June, Contoso Entertainment did not have any Sales, so Sales only reflects Contoso Denmark in this case.
If you own less than 1% of a company, select “Allow rollup less than 1%” in the Additional Options tab of the Report Settings form, and then the rollup % in the reporting tree will be treated as less than 1%. For example, if the setting is selected, then .8 would .8%, not 80%. Alternatively, you can also enter .008 and leave the setting cleared.
NOTE: If you prefer to see minority interest on its own line view this blog for additional information.
The series of blogs has covered the many different consolidation scenarios that a company faces during the reporting process. From multiple Dynamics ERPs, to different charts of accounts, to ownership percentage, Management Reporter is designed to fit your consolidation reporting needs.
Is this method IFRS compliant? I believe the "equity method" prescribes that for influential participations, the P&L needs to be consolidated for 100%, while the balance sheet goes for the participation percentage. In that case, this method won't work for companies that need to be IFRS compliant. Or what am I missing?