Skip to main content
Documentation
Documentation
Adaptive Planning
Last Updated: 2023-06-23
Example: Set Up Full Consolidation and Assign Ownership Percentages

Example: Set Up Full Consolidation and Assign Ownership Percentages

This example illustrates how to define the ownership triggers for full consolidation. When completed as part of full consolidation, the data rolls up in the level hierarchy with the appropriate minority adjustments.
Parent Company owns 80% of a subsidiary called Child Company. You want the Net Income account in the Income Statement to flow properly into the Net Asset account in the Balance Sheet. You also want data to roll up to the parent company with adjustments based on ownership.
Your model:
  • Actuals version.
  • Calendar set up with Months, Quarters, and Years.
  • Your Income Statement is a standard sheet that includes the Net Income general ledger account.
  • Your Balance Sheet is a standard sheet that includes the Equity general ledger account.
  1. Go to
    Modeling
     and from the
    Others
     menu, click
    Consolidation Percentages
    .
  2. From the sheet toolbar, click the gear icon.
  3. Clear the
    Proportional
     check box.
  4. Click the
    Full
     and
    No Consolidation
     check boxes.
  5. In the
    From (%)
     field next to
    Full
    , enter
    50.000000001
    .
  6. From the
    Minority Interest Account
     drop-down list, select
    Minority Interest Adjustment
    .
    Minority Interest Adjustment is the system account that you created under Net Income.
  7. For the
    General Ledger Account
    , select
    Net Income
    .
    You must select the parent account of the system account to work properly.
  8. Click
    Apply
    .
  9. Enter 80% in the Child row for January 2018.
    This value means that Parent Company owns 80% of Child Company.
  10. Right-click and select
    Copy Forward
     >
    Copy To End
    .
  11. From the sheet toolbar, click
    Save
     .
The system account, Minority Interest Adjustment, automatically calculates the minority interest and subtracts it from the Net Income (Pre-Adj) value at the parent level rollup. Example: If Parent owns 80% of Child, the system account multiplies the Net Income value by 20%, reducing the value for the Parent rollup.
Build an initial balance sheet for the Net Asset accounts and seed the initial balances.