Skip to main content
Documentation
Documentation
Adaptive Planning
Last Updated: 2023-06-23
Example: Set Up Levels for Full Consolidation

Example: Set Up Levels for Full Consolidation

This example illustrates how to create a parent company that owns a subsidiary. 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.
  • Contact Workday to enable Consolidation. See Reference: Contact Us.
  • Security:
    • Model includes: sheets, accounts, dimensions, and formulas
       permission.
    • Consolidation
       permission.
  1. Go to
    Modeling
     and click
    Levels
    .
  2. From the toolbar, click
    Create New Level
    , and in the settings for:
    • Name
      , enter
      Parent
      .
    • Version Selector
      , select
      Actuals
       and click the
      Available in version
       check box.
    • Sheets
       section, click the check boxes next to
      Income Statement
       and
      Balance Sheet
      .
  3. Click
    Save
    .
  4. Click
    Create New Level
    , and in the settings for:
    • For
      Name
      , enter
      Child
      .
    • For
      Rolls up to
      , select
      Parent
      .
  5. Click
    Save
     and click the warning check boxes and
    Next
     until you can save.
When you open the sheets, you can see the levels in the
Level
 drop-down list.
Parent
 has 2 children:
Child
 and
Parent (Only)
. You can only enter data in:
  • Parent (Only)
  • Child
Data you enter aggregates in the Parent level.
To automate the ownership adjustments, set up the Net Income accounts for full consolidation.