Accounts contain numerical information (both raw numbers and formulas involving them) is stored in accounts. Accounts can appear in reports and can be viewed and edited on sheets.
Role Permission: Model Management Access > Model
Adaptive Planning supports these account types: General ledger accounts, custom accounts, metric accounts, modeled accounts, cube accounts, and assumptions.
General Ledger Account
General Ledger Accounts include all Profit & Loss and Balance sheets. For example, the Expense sheet lists accounts that record monthly expenses, such as airfare or cell phones, and the Personnel sheet lists employees and used to plan for head count, salaries, and benefits.
Planners only see the sheets that an administrator has placed on the levels the planner owns, and only sees data for the owned levels or sheets that have been assigned to them. The organization structure admin exposes sheets to planners when setting up the top level. accounts, and hold entered or calculated plan values and imported actual values from a general ledger or similar system. The GL account tree often mirrors your GL system. If you don't plan at a GL account level, you can build an account tree in a different configuration.
General Ledger Accounts (GL accounts) include all profit-and-loss and balance sheet accounts, and are used to hold entered or calculated plan values and imported values from a GL or similar system. If you used a GL account system before your Adaptive model was set up, your account tree in Adaptive probably mirrors the one you had before
Custom Accounts can be used to hold any kind of numerical data, such as square footage for a facilities allocation Allocation is the process of reassigning values (like income or headcount expenses) from one part of an organization to a different part (or parts) of the organization. In Adaptive Planning and Adaptive Consolidation, this process is accomplished through allocation rules., or to gather information from other accounts, such as total R&D expense or total full-time headcount. These accounts can then be displayed on statements or reports or used to drive other accounts. With custom accounts, the values and formulas can vary from level to level and from version A version represents a particular planning scenario, such as Budget 2013 or a what-if plan for evaluating effects of an potential acquisition, down sizing, and so on. to version.
A metric in Discovery is similar to an account, but can be made up of any sort of data, not just financial data. Metrics can be displayed on dials just as accounts would be. Accounts are used to calculate financial ratios and non-financial metrics. Metric accounts must hold formulas, which pull data from elsewhere. An example is Gross Margin %, which divides gross margin by revenue.
The way that metric accounts perform calculations is slightly different from other accounts. GL and custom accounts perform the calculations at the current level and then roll up the resulting values across the organization structure. For example, if gross margin percentage were set up as a formula in a custom account, the system would take revenue-cost of goods sold divided by revenue for each level, and then roll these results up to arrive at the result at a parent level.
If the same formula is in a metric account, the system first rolls up revenue for at a parent level, and then rolls up the Cost of Goods Sold level, then performs the calculation specified in the formula at the levels in the organization structure. This method of calculating gross margin percentage is more appropriate. Because of this, metric accounts are particularly useful when the account’s calculation includes division that is to be performed at the top level or any parent level.
Modeled Accounts are created by administrators or implementers as part of configuring modeled sheets. Modeled sheets (for example, Personnel or Capital) are created to accept data entry from planners. Behind the scenes, this data is used to automatically calculate related values (like payroll and related expenses, depreciation, or bookings). These calculations are placed in modeled accounts such as ACCT.Personnel.Salary. Modeled accounts are administered from within the modeled sheet builder, or from within the modeled sheet's summary page.
Modeled accounts are typically managed by editing their corresponding modeled sheet . If you want to create new modeled accounts or change the formula logic of an existing modeled account, edit the corresponding modeled sheet.
You can modify modeled accounts when editing a model sheet.
Cube Accounts are created by administrators or implementers as part of configuring cube sheets. Cube accounts can be set up as standard accounts, where users can enter values or formulas directly into the sheet; calculation accounts, where the administrator can establish a global formula; assumptions, where the value can only be modified at the top level; or as metric accounts, where each term of the formula is evaluated at the rollup. You can edit some rollups directly.
Cube accounts are managed by editing their corresponding cube sheet. Cube accounts are administered from within the cube sheet builder or from the Cube sheet summary page. You can placed cube accounts in the cube sheet from which they are created or from standard sheets. You can reference cube accounts from formulas on other cube sheets.
You can modify cube accounts when editing a cube sheet.
Account Hierarchy and Rollups
Accounts are organized in a hierarchy called the account tree, where child accounts roll up to their parent accounts. For example, suppose that the General Ledger Accounts has an account: 1000 Assets with child acount. When 1000 Assets is expanded, its child accounts (and, in some cases, the child accounts’ child accounts) come into view, where:
1000 Assets is the parent account for 1100 Current Assets, 1500 Fixed Assets, 1600 Long Term Assets, and 1700 Other Assets
Each child accounts roll up to 1000 Assets. As a result, 1000 Assets contains the rolled up, or totaled values of all child accounts.