Skip to main content

logoCorrectSize.png

Adaptive Insights LLC.

Custom Accounts Fields and Settings

Describes the account settings for custom accounts and cube standard accounts.

Audience: Administrators who manage the model. 

custom account is an account that can hold any kind of numerical data or formulas. The rollup logic for time, dimension, and level is flexible as are many of the settings that create accounts with unique capabilities. 

To learn more about accounts, see the Accounts guide. For step-by-step instructions, see Add or Edit Accounts.

Account Details Section 

Field Description
Code

Required. No default.

Identifies a unique numerical code for the account. Appears in formulas. Enter a unique combination of letters and numbers. You can use underscores but not spaces or other special characters. If left blank for imports, Adaptive auto-generates the code based on the account name. 

Name

Required. No default.

Identifies the name of the account as it to appears on sheets, reports, and charts. Enter any combination of characters, spaces, and special characters. The account name does not need to be unique.

Short Name

Optional. No default.

Identifies the name of the account as it appears on Dashboards charts. Use if the account name is long. Enter any combination of letters, numbers, and special characters.

Rolls up to

Required. Default: the account or group that's highlighted when you select Create New Account.

Indicates the parent account of the account you're editing. Choose a rollup account. See Account Overview for information about rollup accounts and Reorganize Account Structure for information on how to re-parent an account.

Description

Optional. No default.

Describes the account. Enter any combination of letters, numbers, special characters and spaces.

Type 

Required. Defaults: the same type as the rollup account, or periodic if the account rolls up directly to either the Custom root or a group.

Sets how the account data entries relate to other data entries.  If you change a rollup account type, you automatically change its child accounts too.

For new accounts choose:

  • Cumulative (available if the account rolls up to  a group, the root account, or a cumulative rollup account): Cumulative accounts can be planned by balance or delta. See Planned By and Actuals By below.
  • Periodic (available if the account rolls up to  a group account, the root account, or a periodic rollup account).  
  • Link (not available for rollup accounts or accounts with Cube selected for Data Entry Type): A modeled or cube account populates the values of this account. 

See Account Type Setting: Cumulative or Periodic and Linked Accounts Overview

Links to 

Required if you selected Link for the Type of the account you're editing. Not available for rollup accounts. No default.

Populates the account you're editing with the data of the account you choose from the drop-down. This is a two part process: first pick your cube or modeled sheet, then the account. See Pull Data from from a Modeled or Cube Sheet into Another Account.

Link Filters 

Optional. Available only if you selected Link for Type. Not available for rollup accounts. No default.

Populates this account only with the values that are tagged with the dimension or attribute you select from the drop-down. The available list includes only dimensions and attributes of the account selected in Links to drop-down.

Time Rollup

Required. Read-only if you select Link for Type or  Cube for Data Entry Sheet Type. Defaults: the Time Rollup of its rollup account or linked account. If it rolls up to a root or group, the default is Sum of rolled up values for periodic accounts and Value of last time period for cumulative accounts. 

Sets how the account calculates the values for time rollups. For example, how does the account calculate the quarter totals or annual totals?  If editable, choose from the drop-down:

  • Sum of rolled up values (periodic accounts only): Sums all the values for the period. For example, it 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. For example, it takes the accumulated value for March for the first quarter rollup.
  • Average  of rolled up values: Takes the average of the time period values. For example, it totals the values for January through March and then divides by three 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. For example, an average expense per headcount time rollup should be weighted by the headcount. 
Level/Dimension Rollup 

Optional. Read-only for child accounts, or if you chose Link for Type, or  Cube for Data Entry Type. Default: Sum of rolled up values for new accounts or the Dimension Rollup of the parent account or linked account. 

Sets how the account calculates the totals for level and dimension  rollups. For example, Total Company is a level that has three departments as sub-levels: Sales, Manufacturing, and IT. You enter 100, 200, and 0 for each level respectively. At the top-level, choose 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. For 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. For 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.  For example, if Sales has twice the weight of the other two departments, the weighted average for the departments, the rollup for the departments is 133 ((2*100+200)/3).
  • Text: Displays text you specify for the dimension rollup. Choose this option if you don't want to display data for dimension rollups. 
Weighted By 

Required if you chose Weighted average of roll up values for Time Rollup or Dimension Rollup. No default.

Provides the weighted average of the time or dimension rollup. Choose from the list of accounts.

 

 

Display Text 

Optional. Available if you chose Text for Dimension Rollup. No default.

Provides the text that displays for dimension rollups. Enter any kind of text, such as NA or --, or leave blank.

Planned by 

Required when visible. Available for cumulative accounts only. Not available for rollup accounts. Default: the setting of the rollup account.

Sets how you enter data for the account you're editing in the sheet cells of planning versions. For example, the initial petty cash balance for the account is in January and the value is 10. In February the value is 20. In March the value is 20. Choose: 

  • Delta: On sheets you enter the change from the previous time period. The delta (or difference) in the example is 10 for February and 0 for March.  
  • Balance: One sheets you enter the running balance. The balance in the example is 20 for February and also 20 for March. 
Actuals by

Sets how you enter data for the account you're editing in the sheet cells of actuals versions. 

For example, the initial petty cash balance for the account is in January and the value is 10. In February the value is 20. In March the value is 20. Choose: 

  • Delta: On sheets you enter the change from the previous time period. The delta (or difference) in the example is 10 for February and 0 for March.  
  • Balance: One sheets you enter the running balance. The balance in the example is 20 for February and also 20 for March. 

Actuals Overlay 

Required. Not available for rollup accounts or accounts that have Cube selected for Data Entry Sheet Type.

Determines if the account displays actuals data on planning versions prior to the Start of Plan date. See Set Up or Turn Off Actuals Overlay.

For cumulative or periodic accounts, choose: 

  • Enable actuals (default): Displays actuals prior to each planning version's Start of Plan date. 
  • No actuals for accounts: Displays only plan data on the planning versions. 

For Link accounts, choose:

  • Enable actuals for link: Overrides the Actuals Overlay setting of the linked account. Allows actuals to display prior to the Start of Plan date on the account you selected for Links to  and the account you're editing. 
  • Show actuals if linked account has them: Honors the Actuals Overlay setting of the linked account. Actuals display on the account you're editing only if the the linked account has Actuals Overlay enabled.

Specify Default Formulas link:

Optional. Not available for rollup accounts. Only available if you chose Enable actuals for Actuals Overlay. No default.

Assigns shared formulaa to the account for each level in actuals versions. On sheets, you can override the values calculated by the shared formula with formulas or data entered in the sheet. 

Select the Specify Default Formulas link to access and assign shared formulas of your actuals by level. If you don't have access to actuals, you can link to the shared formulas of your planning version.

Specify Default Formula link

Formulas

Optional. Not available for rollup accounts. No default.

Assigns shared formulas to the account for each level of your planning versions. On sheets, you can override the values calculated by the shared formula with formulas or data entered in the sheet . 

Select Set Default Values and Formulas to access the shared formulas of your planning versions. Assign formulas to each level. See Formulas for more information.

Formulas link

Dependencies

Shows how the account is used throughout the model in calculated accounts, shared formulas, cube entries, other entries, rules, journal entries and reports. Select View Dependencies and browse through the tabs.

 

Account Attributes Section

Optional. Only available if your model has account attributes. No default.

Tags the account you're editing with account attributes. The number of drop-downs match the number of account attributes available. Select an attribute value from any or each of the drop-downs. 

Data Type Section

Field Description

Account Time Stratum

 

Read-only.

Shows how sheets display time for this account. Based on the default time stratum in your instance's calendar setup. Most commonly, this is months, but it might be weeks or days.

Display As 

Required. Read-only for child accounts or accounts with Link for Type. Default: Number or whatever was chosen for the rollup account.

Sets how data appear in sheets and on reports. Choose:

  • Currency: Displays a numeric value converted to the currency of the level. Best practice: choose if your model converts currencies at different levels. Otherwise the rollups of the account show the total of its first child account instead of the total of all its child accounts.
  • Number: Displays a numerical value.
  • Percent: Displays the value as a percent (90%).
Master Formula 

Required if you select the Weighted-Average Translation check box. Not available for rollup accounts or if you chose Cube for Data Entry Sheet Type. No default.

Calculates the value of the account you're editing through a formula. Unlike default formulas, master formulas calculate the value across all levels and all versions. A master formula overrides any default formulas and all data. You cannot edit data of accounts with a master formula.

Enter a formula. Select the Formula Assistant link for a user-friendly interface that helps you create error-free formulas.

Weighted-Average Translation

Optional. Not available for rollup accounts or periodic accounts. Cumulative accounts must have Delta chosen for Plan by and Actuals by. No default.

Converts currencies by the average rate per period on the delta of cumulative accounts. Generally references a periodic account in the master 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. Choose 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. Choose the account to receive the balance transfer.

Decimal Places

 

Required. Default: 0.

 

Indicates the number of decimal places for the data. Select any number between 0-9 or choose Currency's precision to follow the setting for the currency. 

To see the decimal place settings for all the currencies, choose Currency's precision from the drop-down and select the View Precision link.

Exchange Rate

Required. Default: the exchange rate selected for the rollup or root account.

Determines how to convert currencies for the account. Choose:

  • 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 have created for your model.

 

Sheets Section

Field Description
Suppress on sheets

Required. Default: Account may be suppressed when zero or blank.

Determines if the account appears on sheets if all its cells have zeros and/or blanks. Choose:

  • Account may be suppressed when zero or blank
  • Account will not be suppressed even when zero or blank
Start expanded

Required. Only available for rollup and root accounts. 

Determines if the account is expanded on sheets to show child accounts when you first open the sheet.

Each person who opens a sheet can change their sheet view and save it as their default, which can override this setting.  Choose:

  • Yes (default): Expanded to show child accounts by default.
  • No: Collapsed by default.
Data Entry Sheet Type

Required. Not available if you chose Link for Type or for standard cube accounts. Default: Standard or the sheet type selected for the parent account or group.

Specifies the type of sheets you can add the account to when building sheets. Choose:

  • Standard: Can add the account to any number of standard sheets. 
  • Cube: Can add the account to any number of standard sheets and up to one cube sheet. 
Entered on Sheet

Read-only. Available if you chose Cube for Data Entry Sheet Type.

Displays the name of the cube sheet that has this account. Displays None until you add the account to the cube sheet. Select the sheet name to link to edit the cube sheet. 

Cube Sheet Link

Read only on sheet

Available for cube standard accounts only. 

Makes the account uneditable on the cube sheet.

 

Data Privacy Section

Field Description
Data Privacy

Required.

Restricts how formulas can use the account's data by level. Choose:

  • Value of account is private (default): Formulas refers only to the account value on the current level and direct sub-levels. 
  • Value of account is public at top level only: Formulas on any level can refer to the top level rollup value. You get an error if you refer to the account's value at any other level.
  • Value of account is public at all levels: Formulas can refer to the value of this account on any level.
Contains Salary Detail

Required. Not available if you chose Cube for Data Entry Sheet Type. Read-only if you chose Link for Type. Default: the same as the rollup or linked account. 

Indicates if this account is restricted to only user roles with the Salary Detail permission. See Available Permissions. Choose:

  • Yes: (default) This account data is restricted by role permissions.
  • No: Any one with access to the account can view the data.
  • Was this article helpful?