ICE for profit and loss template in Planning Business Modeler

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.

Note:  When a transaction value is eliminated, PerformancePoint Planning Business Modeler removes the transaction from the aggregated total and makes a corresponding adjustment to the Elimination member of the Business Process dimension. For more information, see the topic About the Business Process dimension.

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

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

In this topic

Prerequisites

Placeholder substitution requirements

Prerequisites

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

Top of Page

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.

Wh ere 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 substituti ons 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 require d

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.

Place holder 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

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×