Get an overview of the Consolidation Rules form on this page. Learn about the Non-Controlling Interest (NCI), Equity Pickup, and Intercompany Eliminations modifications required to tailor the pre-configured rules to your chart of accounts.
Anaplan Financial Consolidation comes out of the box with several pre-configured consolidation rules, including Non-Controlling Interest (NCI), Equity Pickup, and Intercompany Eliminations.
In theory, the only change required is to update these rules with the naming convention of the customer's chart of accounts.
Consolidation rules form
To access the Consolidation Rules form:
- Navigate to the Maintain module.
- Select the Consolidation Rules link under the Consolidation card.
- Select the checkbox next to the rule you want to edit, or select the Create icon to create a new one.
Different columns of the form are:
| Column | Description |
| Details | Select a checkbox next to a consolidation rule to view the details of the rule. |
| Consolidation | It's the name of the consolidation rule. |
| Parent Consolidation | One or more consolidation rules can be assigned to a single-parent rule. This is used when there are multiple consolidation rules for a given account. It's used in the Account Attribute form. |
| Model | Certain rules can be applied to certain data models. You can either specify a specific data model or select All. The default is the Consolidation data model. |
| Source Audit | This field is used to define the Source Audit member. It's rarely used and left blank, which means applying the consolidation to all Audit members. It's been used in case where you want to combine using Accounting Standards for Private Enterprises (ASPE) rules for Audit members and combine using International Financial Reporting Standards (IFRS) rules for other Audit members. |
| Audit | It defines the target Audit member where the calculation result will be stored. |
| Source Dataview | It's used to define the Source Dataview member. This field is rarely used and left blank, which means applying the consolidation to all Dataview members. |
| Dataview | This field defines the Target Dataview member where the calculation result will be stored. The default is Consolidation. |
| Journal Number | Financial Consolidation generates an Automatic Journal Entry report for all consolidation rules. This field is user-defined and can be typed in manually. |
| Elimination Dimension | The default value is No. This field isn't being used currently. |
| Elimination Entity | The default value is No. This field isn't being used currently. |
| Special Event | This field is used when certain rules are applied to all accounts. These rules include the rule to reverse the Trial Balance for the Equity Method and the Proportionate Consolidation calculation. Both of these rules are applied to all accounts and aren't set using the Account Attribute table. Consolidation rules set to No are account-specific and must be set in the Account Attribute table. |
| Active | Use this field to activate a consolidation rule. A rule with Active field set to No won't be calculated during the consolidation process. |
| Start Date | Use this field to define the start date for a consolidation rule. It's useful when there are changes in accounting policy or when switching from one accounting standard to another. |
| End Date | Use this field to define the end date for a consolidation rule. It's useful when there are changes in accounting policy or when switching from one accounting standard to another. |
| Source Scenario | Use this field to define the source scenario for a consolidation rule. |
