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.

Go to

Modeling

and click

Levels

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

Click

Save

Click

Create New Level

, and in the settings for:

For

Name

, enter Child
.

For

Rolls up to

, select Parent
.

Click

Save

and click the warning check boxes and

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.