Audience: Administrators who manage the model.
A general ledger account (GL) for planning mirrors the accounts in your real-world general ledger. The settings follow standard accounting principles in general. Many of the general ledger accounts are built into the account tree.
To learn more about accounts, see the Accounts guide. For step-by-step instructions, see Add or Edit Accounts.
You can't edit some of the settings of certain general ledger accounts. The accounts are built in to the instance. See the list of accounts.
Account Details Section
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, the code is auto-generated.
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.
Optional. No default.
Identifies the name of the account as it appears on dashboard charts. Use if the account name is long. Enter any combination of letters, numbers, and special characters.
|Rolls up to||
Required. Read-only for accounts that come with your model by default. Default: the account that's highlighted when you select Create New Account.
Optional. No default.
Describes the account. Enter any combination of letters, numbers, special characters and spaces.
Required. Default: Same type as the root account, or linked account (if selected). Root account types are based on standard accounting practices. For example, asset accounts are cumulative and expense accounts are periodic.
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.
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.
Read-only. Only visible if you selected Link for Type.
Read-only. Only available if you selected Link for Type. Defaults: the Dimension Rollup of the linked account. If the account isn't a linked account, it does not have dimension rollups.
How the account calculates the values 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 data for each level. How does the account calculate the total for the Total Company? Possible read-only setting from linked account:
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.
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.
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:
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:
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:
For Link accounts, choose:
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.
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.
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.
Accounting type by standard accounting practices: credit or debit. Sets according to standard accounting practices per each GL account.
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
|Account Time Stratum||
Shows how sheets display time for this account. Based on the default time stratum in your instance's calendar setup. Most commonly, this is month
Currency means that the data displays a number in the currency of the selected level.
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.
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.
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.
Required. Default: Currency's precision.
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.
Required. Default: the exchange rate selected for the rollup or root account.
Determines how to convert currencies for the account. Choose:
|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:
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:
|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:
Data Privacy Section
Restricts how formulas can use the account's data by level. Choose:
|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:
Only available if you have Consolidation.
|Elimination Trading Partner||
Only available if you chose Yes for Intercompany.
Identifies the level selected as the trading partner of this intercompany account. Choose a level.