ICE for profit and loss template

When you complete an ICE for Profit and Loss template with account information, the rule eliminates intercompany (IC) transactions.

By default, an ICE for Profit and Loss rule applies to entities that are fully owned subsidiaries and to entities that are holding companies for the parent.

For examples that show more about how to customize this template, see Examples: Customized consolidation rule templates.

For information about how Planning Business Modeler determines values for percent consolidation (PCON), see About measure groups for shares calculation and consolidation.

Prerequisites

The following list shows the tasks that are prerequisite for a rule that you create with this template:

• You built a model that is appropriate for shares calculation. For more information, see the topic How do I set up a model for shares calculation and consolidation?.

• You ran a shares calculation job for this model that calculated direct and indirect ownership percentages. For more information, see the topic About Shares Calculation jobs.

Placeholder substitution requirements

To use the ICE for Investments template to make a business rule, you must substitute actual account values for the placeholders in the template. For information about how to substitute values, see the topic Filling a placeholder in a rule template.

Rule actions in this template vary by account type. For more information about type of account, see the topic About the Account dimension.

The following list provides information about specific placeholders required for different account types:

• Income IC account type

  The following table describes the placeholder substitutions you must make for Income IC accounts that have different categories of IC partners. In addition, the table describes the adjustments that this rule performs when these values are supplied.

  When the IC partner is	Placeholder substitutions required	Action
  A holding company or fully owned subsidiary	Gross Margin Elimination account Net Income account	Eliminates the Income IC transaction by multiplying the value by PCON Multiplies the Income IC value by PCON, and posts the result in Gross Margin Elimination Multiplies the Income IC value by PCON, and posts the result in Net Income
  Controlled by parent equity	Revenue account	Eliminates the Income IC transaction by multiplying the value by PCON Multiplies the Income IC value by PCON, and posts the result in Revenue

• Expense IC account type

  The following table describes the placeholder substitutions you must make for Expense IC accounts that have different categories of IC partners. In addition, the table describes the adjustments that this rule performs when these values are supplied.

  Where the IC partner is	Placeholder substitutions required	Action
  A holding company or fully owned subsidiary	Gross Margin Elimination account Net Income account	Eliminates the Expense IC transaction by multiplying the value by PCON Multiplies the Expense IC value by PCON, and posts the result in Gross Margin Elimination Multiplies the Expense IC value by PCON, and posts the result in Net Income
  Controlled by parent equity	Expense account	Eliminates the Expense IC transaction by multiplying the value by percent consolidation (PCON) Multiplies the Expense IC value by PCON, and posts the result in Expense

• Invest Income IC account type

  The following table describes the placeholder substitutions you must make for Investment Income IC accounts that have different categories of IC partners. In addition, the table describes the adjustments that this rule performs when these values are supplied.

  When the IC partner is	Placeholder substitutions required	Action
  A holding company or fully owned subsidiary	Related Party LT Receivables account Net Income account	Eliminates the Invest Income IC transaction by multiplying the value by PCON Multiplies the Invest Income IC value by PCON, and posts the result in Related Party LT Receivables Multiplies the Invest Income IC value by PCON, and posts the result in Net Income
  Controlled by parent equity	Other Investment Income account	Eliminates the Invest Income IC transaction by multiplying the value by PCON Multiplies the Invest Income IC value by PCON, and posts the result in Other Income

• Invest Loss IC account type

  The following table describes the placeholder substitutions you must make for Investment Loss IC accounts that have different categories of IC partners. In addition, the table describes the adjustments that this rule performs when these values are supplied.

  When the IC partner is	Placeholder substitutions required	Action
  A holding company or fully owned subsidiary	Related Party LT Receivables account Net Income account	Eliminates the Invest Loss IC transaction by multiplying the value by PCON Multiplies the Invest Loss IC value by PCON, and posts the result in Related Party LT Receivables Multiplies the Invest Loss IC value by PCON, and posts the result in Net Income
  Controlled by parent equity	Other Investment Loss account	Eliminates the Invest Loss IC transaction by multiplying the value by PCON Multiplies the Invest Loss IC value by PCON, and posts the result in Other Investment Loss

• Other Inc-Exp IC account type

  The following table describes the placeholder substitutions you must make for Other Income and Expense IC accounts that have different categories of IC partners. In addition, the table describes the adjustments that this rule performs when these values are supplied.

  When the IC partner is	Placeholder substitutions required	Action
  A holding company or fully owned subsidiary	Related Party LT Receivables account Net Income account	Eliminates the Other Inc-Exp IC transaction by multiplying the value by PCON Multiplies the Other Inc-Exp IC value by PCON, and posts the result in Related Party LT Receivables Multiplies the Other Inc-Exp IC value by PCON, and posts the result in Net Income
  Controlled by parent equity	Other Income account	Eliminates the Other Inc-Exp IC transaction by multiplying the value by PCON Multiplies the Other Inc-Exp IC value by PCON, and posts the result in Other Income

• Income account type

  Income account types have ICMethod = Default, which indicates that there are no intercompany partners. Income account types do not enable intercompany transactions.

  The following table describes the placeholder substitutions you must make for Income accounts that have different categories of IC partners. In addition, the table describes the adjustments that this rule performs when these values are supplied.

  Placeholder substitutions required	Rule action
  Minority Interest Income account	Eliminates transaction by multiplying each value by PMIN Posts the result in Minority Interest income

• Expense account type

  Expense account types have ICMethod = Default, which indicates that there are no intercompany partners. Expense account types do not enable intercompany transactions.

  The following table describes the placeholder substitutions you must make for Expense accounts that have different categories of IC partners. In addition, the table describes the adjustments that this rule performs when these values are supplied.

  Placeholder substitutions required	Rule action
  Minority Interest Expense account	Eliminates the Expense transaction by multiplying each value by percent minority ownership (PMIN) Posts the result in Minority Interest Expense

See Also

Concepts

Consolidation rules
ICE for investments template
ICE for equity template
ICE for balance sheet template