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.

Contact Workday to enable Consolidation. See Reference: Contact Us.

Set up your net asset accounts. See Example: Set Up Net Assets for Full Consolidation.

Security:

Model includes: sheets, accounts, dimensions, and formulas
permission.

Consolidation
permission.

Go to

Modeling

and from the

Others

menu, click

Consolidation Percentages

From the sheet toolbar, click the gear icon.

Clear the

Proportional

check box.

Click the

Full

and

No Consolidation

check boxes.

In the

From (%)

field next to

Full

, enter 50.000000001
.

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.

For the

General Ledger Account

, select Net Income
.

You must select the parent account of the system account to work properly.

Click

Apply

Enter 80% in the Child row for January 2018.

This value means that Parent Company owns 80% of Child Company.

Right-click and select Copy Forward
> Copy To End
.

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.