Account dimension properties

This property is used to classify Account members, such as assets, liabilities, and equity for balance sheet accounts and income, expenses for Profit and Loss accounts, etc. 

This property is used in the Periodic and YTD calculations.

This property is used with the Movement Classification form. It helps define the correct Account/Movement combinations when using the Balance Sheet Continuity Schedule. Administrators can create Movement Classification groups using the Movement Classification form. Each grouping defines the Account - Movement combinations that are allowed for data input or journal entry. These groupings are then assigned as an account attribute.

To access the form:

1. Select the Maintain module.
2. Select Consolidation if prompted for a Rule Set.
3. Select Movement Classifications in the General Setup section to open the form.
4. A list of the current Movement Classification is displayed.

The form has two sections:

• Headers
• Details

This property is used to define how the rollup of quarterly and yearly totals will be handled for certain accounts.

• First: The first leaf member, such as 2020 Jan, is used for the quarterly total.
• Last: The last leaf member, such as 2020 Mar, is used for the quarterly total.
• Sum: The sum of all leaf members, such as 2020 Jan, 2020 Feb, and 2020 Mar, is used for the quarterly total.

The Time Balancing calculation, which the query engine handles, also uses the property defined in the Measure dimension.

This property is used to tag certain accounts so that certain calculations work out of the box regardless of the member name being used. 

The list here contains the most common properties and where they're being used. These system names are constantly being used in new calculations, so the list below may not be all comprehensive.

These system names should be set for all systems regardless of the calculations that are being used.

This property is used to define if an account is either a debit or a credit. This property is used in the Journals module for journal entries, and is also used in most of the calculations in the consolidation system. It is also used when reversing the sign of a credit account when importing data from a source system. 

The member operator is often used with debit and credit to find the correct sign of an account on financial statements.

It's important to set this property to be set at the leaf and parent member level. Generally, all asset and expense accounts are assigned as debit whereas, all income, equity, and liability accounts are assigned as Credit. There are accounts of contra nature which need to be assigned as required, for example, Accumulated depreciation is assigned as Credit and Dividend paid is assigned as Debit. 

Anaplan Financial Consolidation automatically initializes the system for the next reporting period or the next reporting year. This process is known as Rollover. There's a Year End Rollover called Copy Opening and Month End Rollover called Rollover Month. Financial Consolidation comes with several pre-set rollover rules, but customers can add as many as they want.

The Rollover Rule property is used to define which rollover rule will be applied to which account. The available choices are based on the rules that are created in the Rollover Rules form.

• Year End: A standard rule would be to copy P12 Closing balances to the Opening movement member of the next fiscal year, and apply the required adjustments to the retained earnings and other comprehensive income accounts.
• Month End: A standard rule would be to copy balance sheet continuity details from the current period to the next period to minimize manual input. Another example would be to copy Cash Flow Adjustment from the current period to the next period.

This property is used to define the Conversion Rule for a given account and works together with the Conversion Rules form. The conversion details, such as which rate to use, that is Period End or Period Average, and how each Movement member is calculated, are defined in the conversion rules. This property is used to tag accounts with the appropriate Conversion Rule.

This property is used to define the consolidation treatment for certain accounts like Intercompany Eliminations, NCI, and Equity Pickup. It works with the Consolidation Rules form. This form defines the calculations for eliminations, NCI, Equity Pickup, or any other Consolidation Rule. This property is used to tag accounts with the correct rule. 

For example, there are two Consolidation rules, Equity Pickup Blended and StockholderEquity Blended that are assigned to one Parent Consolidation rule StockHolderEquity (Blended). This can be because there are two consolidation rules that need to be assigned to the same account. ‌‌Only the Parent Consolidation rule can be selected in the Account property form.

This property is used in the Journals module to limit certain accounts. For example, you may want to restrict journal entries to calculated accounts such as Current Year Net Income.

This property is used in the Variation calculation to determine whether Anaplan Financial Consolidation calculates the Auto Variation member in the Movement dimension.

This property is used to store the Variation Auto value by Account. If a specific movement is set in this property, it will replace the standard Variation Auto movement for storing the calculated variation. If you leave it blank, the system uses the default Variation Auto member.