Choose Consolidation Methods

Prerequisites

Your model must have the consolidation capability. Contact us for more information.
Security:
Model
and
Consolidation
.
Organize your levels so that subsidiaries roll up to parent companies.

Trigger Considerations

Full consolidation triggers at a specified percent of ownership.
Full consolidation follows a specific method. Once activated, it works for any level whose ownership falls within the range.
You must also activate a method for ownership ranges that fall below the trigger for Full. If Full triggers at 50%, you must choose a method for percentages below 50%.

Prerequisites For Full Consolidation

Net Income must be a rollup account with child accounts:

Net income (prior to adjustment).
System account for minority interest adjustment.

Navigation

From the nav menu click

Modeling

. From the

Others

menu, click

Consolidation Percentages

to open the sheet.

Choose and Define Methods

From the sheet toolbar, click Settings.
Select the radio button next to the method you want activated.
In the From (%) field, enter the minimum percent of ownership that triggers the method. For example, if you enter 70%, any level that owns 70% or more triggers the method.
The To (%) field, prefills to complete the 100% range through all activated methods. This defines the end of the ownership range for the method. In the example, any level that's owned 69.99% or less, follows the No Consolidation method.
If you choose Full:
From the Minority Interest Account drop-down, choose the system account that holds the calculated adjustment.
From the General Ledger Account, choose the net income account used to calculate the adjustment. This should be the parent net income account.
Click
Apply
.
Save the sheet.