Reference: Settings for Custom Accounts

Adaptive Planning

Account Details Section

Field	Description
Code	A unique combination of letters, numbers, and underscores. You can't use spaces or other special characters. If left blank for imports, Adaptive Planning auto-generates the code.
Name	Displays on sheets, reports, and charts. The name doesn’t need to be unique. For words to avoid and other guidelines, see Reference: Naming Conventions Best Practices.
Short Name	Any combination of letters, numbers, and special characters. Overrides the display name of the account for dashboard charts when the account name is long.
Rolls up to	Indicates the parent account.
Type	Cumulative : The value accumulates period to period. Periodic : The value in any given time period equals the net activity for that period. Link (unavailable for rollup accounts): The value in modeled or cube accounts populate the values of this account. See Concept: Type Setting for Accounts and Concept: Linked Accounts.
Planned by	Available for cumulative leaf accounts. Sets how you enter data in the sheet cells of plan versions: Delta : On sheets, you enter the change from the previous time period. Example: The balance in February is 20 and the balance in March is 25. Enter 5 for March. Balance : On sheets, you enter the running balance. Example: The balance in February is 20 and the balance in March is 25. Enter 25 for March.
Actuals by	Available for cumulative leaf accounts. Sets how you enter data in the sheet cells of actuals versions: Delta : On sheets, you enter the change from the previous time period. Example: The balance in February is 20 and the balance in March is 25. Enter 5 for March. Balance : On sheets, you enter the running balance. Example: The balance in February is 20 and the balance in March is 25. Enter 25 for March.
Links to	Available for linked leaf accounts. Lists modeled and cube accounts that populate the account as an aggregated value.
Add Linked Accounts or Edit Linked Accounts	Available for linked leaf accounts. Displays when you add or edit links in the Links to content box. Use the prompts to select source sheets, then the accounts on the sheet.
Change Sign +/-	Available for linked leaf accounts. Pulls the inverse value of the highlighted link, which subtracts rather than sums. Example: Accumulated depreciation is a positive value in a modeled sheet. When linked to a General Ledger account, you can flip the sign so that it displays as a negative value in your General Ledger.
Apply Dimension Value	Available for linked leaf accounts. Applies dimension values that don't exist on the highlighted source sheet to the data.
Link Filters/Linked Filters	Available for linked leaf accounts. Pulls in only the data that tagged with the dimension or attribute that you select from the drop-down prompts.
Override links for specific version	Available for linked leaf accounts. Activates the link override fields so that you can enter data in linked accounts for specific versions.
Link Version Selector	Required: Select Override Links for Specific Versions check box. Provides list of plan versions. Select the version that you want to enable for data entry for the linked account. Data entry overrides remove the links and enable you to enter data for the account in sheets, through imports, and with Predictive Forecaster. Read-only if the account has no links.
Override Link Setting	Enables or disables data entry: None : Populates the account with the linked source account data for the selected version. Data Entry : Removes the linked source data so that you can enter data, import data, or use Predictive Forecaster to populate with data.
Time Rollup	Sum of rolled up values (periodic accounts only): Sums all the values for the period. Example: Sums January through March for the first quarter rollup. Value in last time period (cumulative accounts only): Takes the value of the last period before the rollup. Example: Takes the accumulated value for March for the first quarter rollup. Average of rolled up values : Takes the average of the time period values. Example: Totals the values for January through March and then divides by 3 for the first quarter rollup. Weighted average of roll up values : Uses the values of an account or assumption to weigh each period before averaging. Example: An average expense per headcount time rollup weighted by the headcount. Linked accounts inherit the time rollup of the source account.
Level/Dimension Rollup	Sets how the account calculates the totals for level and dimension rollups. Example: Total Company is a level that has 3 child levels: Sales, Manufacturing, and IT. You enter 100, 200, and zero for each level respectively. At the top-level, select how you would like Total Company to display the rollup value: Sum of rolled up values : Sums all the values for the level or dimension. Example: The level rollup is 300 (100+200+0). Non-Blank average of rolled up values : Takes the average of the data, excluding blanks. If a cell contains zero (not blank), the zero is calculated in the average. Example: The level rollup is 100 ((100+200)/3). Weighted average of roll up values : Uses the values of an account or assumption to weigh each dimension before averaging. Example: If Sales has twice the weight of the other 2 departments, the weighted average for the departments, the rollup for the departments is 133 ((2100+200)/3). For cube-entered accounts, you must select this option from the custom account hierarchy. Text* : Displays text that you specify for the dimension rollup. Select this option if you don't want to display data for dimension rollups. Linked accounts inherit the level and dimension rollup of the source account.
Weighted By	Required when the Level/Dimension Rollup is Weighted average of rollup values . Provides the weighted average of the time or dimension rollup.
Display Text	Required when Level/Dimension rollup is Text . Provides the text that displays for dimension rollups. Enter any kind of text, such as NA or --, or leave blank.
Enable actuals	Available for leaf accounts. Unavailable for linked accounts. Displays actuals data over the plan data of plan versions.
No actuals for account	Available for leaf accounts. Available for leaf accounts that aren't linked. Displays only plan data in plan versions. Formulas for accounts without actuals overlay result in blank data when the formula references actuals data, including cells in the sheet with actuals overlay.
Enable actuals for link	Available for linked leaf accounts. Displays actuals data over the plan data for plan versions in both the source and target accounts.
Show actuals if linked accounts has them	Available for linked leaf accounts. Displays actuals data over the plan data for plan versions only when the source account has actuals enabled already.
Specify Default Formulas	Available for leaf accounts with actuals overlay. Assigns shared formulas to the account for each level in actuals versions. On sheets, you can still override the shared formula with other formulas or values that you enter.
Set Default Values and Formulas	Available for leaf accounts. Assigns shared formulas to planning versions by level.
View Dependencies	Indicates where the model references the account: Calculated Accounts : Lists accounts that refer to this account in the formula of the account settings. Shared Formulas : Lists the accounts by version and level that refer to this account with shared formulas. Cube Entries : Lists the accounts by cube sheet name that refer to this account with formulas entered on cube sheets. Other Entries : Lists the accounts by version, level, and time period that refer to this account with formulas entered on modeled and standard sheets. Rules : Lists the allocation and elimination rules that refer to this account Journal Entries Available for Cosolidation only. Lists the journal entries that refer to this account by journal entry number, version, and level. Reports : Lists the report names that refer to this account with custom calculations.

Account Attributes

Field	Description
Prompts with the account attributes available in your model. Varies per instance.	Available if your model has account attributes. Tags the account with attributes. The number of drop-down prompts match the number of account attributes available in your model.

Data Type

Field	Description
Account Time Stratum	Read-only indication of the time strata intersection where data exists.
Display As	Currency : Converts to the currency of the level. Select when your model converts currencies at different levels. Otherwise, the rollups of the account display the total of the first child account instead of the total of all child accounts. Number : Displays a numerical value. Percent : Displays a percent.
Formula Version Selector	Available for leaf accounts. Unavailable for cube-entered accounts. Prompt to display the default or override formula of the selected version. Read-only if the account has no default formula.
Override Formula Setting	Available for leaf accounts. Unavailable for cube-entered accounts. Adds formula overrides to the selected version. Override Formula : Add an override formula. Data Entry : Make the account editable. This option isn’t available for calculated accounts on merged cube sheets or modeled sheets. None : Revert to the default formula. Read-only for locked or archived versions with an activated Disable Version-Specific Formula Setting check box.
Disable Version-Specific Formula Setting	Available for leaf accounts. Unavailable for cube-entered accounts. Reverts any existing formula overrides for active versions, including locked versions, to the default formula. Doesn't change data in archived versions. Locks the Formula Version Selector and Override Formula Setting . Calculated data in locked version continues to change anytime you change the formula. Unchecked: You can add overrides per version or automatically protect data in versions that you lock.
Default Formula/Override Formula	Available for leaf accounts. Read-only for locked or archived versions. Unavailable for cube-entered accounts. Calculates the value of the account through a formula across all levels and all versions. You can change the default formula or create an override for a specific version. You can't override the formula in sheets. For cube accounts, we don't recommend that you create formulas that reference system accounts. See FAQ: What's the best way to reference a system account from a cube sheet?
Weighted-Average Translation	Available for leaf level, cumulative accounts with Delta for Plan by and Actuals by and a default formula. Unavailable for cube-entered accounts. Converts currencies by the average rate per period on the delta of cumulative accounts. Generally references a periodic account in the default formula and provides a way to convert the currency of periodic data in cumulative accounts.
Reset Balance	Requires Weighted Average Translation . Resets the balance to zero at the specified time period. At the start of the next period, the account starts accumulating again. Select the time period. Available options are based on the calendar setup of your model, typically Month, Quarter, Year.
Transfer Balance on Reset	Requires Reset Balance . Transfers the accumulated balance to another account. Select the account to receive the balance transfer.
Decimal Places	Indicates the number of decimal places for the data: Any number 0-9. Currency's precision : Follows the setting for the currency. You can use the link to review the decimal places for all your currencies.
Exchange Rate	Required when Currency's Precision is the Decimal Places setting. Determines how to convert currencies for the account. Select: Avg: Monthly Average : Uses the average exchange rate of the month to convert currency. EOM: End of Month : Uses the exchange rate at the end of the month to convert the currency per month. Any additional exchange rates types that you’ve created for your model.

Sheets

Field	Description
Account may be suppressed when zero or blank	Hides the account on sheets when all values are zero or blank.
Account will not be suppressed even when zero or blank	Always displays the account on sheets.
Start expanded	Available for rollup accounts. Yes : Expands rollup or group accounts on sheets to display child accounts. No : Collapses rollup or group accounts on sheets. Each person who opens a sheet can change their sheet view and save it as their default, which overrides this setting.
Data Entry Sheet Type	Unavailable for accounts with formulas. Standard : You can add the account to any number of standard sheets. Cube : Makes the account a cube-entered account. You can add the account to any number of standard sheets and up to 1 cube sheet.
Entered on Sheet	Links to the cube account hierarchy that has the cube-entered account.
Read only on sheet	Available for cube standard accounts only. Locks the account on the cube sheet.

Data Privacy

Field	Description
Value of account is private	You can enter formulas that refer to the account on the current level and direct child levels.
Value of account is public at top level only	You can enter formulas on any level that refer to the top-level rollup value. You get an error if you refer to the account at any other level.
Value of account is public at all levels	You can enter formulas that refer to the value of this account on any level.
Contains Salary Detail	Available for accounts with Standard for Data Entry Sheet Type . Read-only for linked accounts. Yes : People with the Salary Detail permission can view the data. No : Any one with access to the account can view the data.