An account is a container that groups actuals or planning information, such as expenses, assets, liabilities, sales, and any business metrics.
An account group, is an organization tool that contains accounts in the account lists, without summing the totals.
An account rollup is the total for an account that has child accounts. For example, a Travel account rollup might include hotel expenses, car rental, and so on.
Actuals versions contain your actual financial results for a given period of time, like your income or expenses from May 2014. Actuals are records of things that happened.
Admin Publishing enables administrators to make multiple changes to an instance and publish them all at once, rather than publishing each change individually.
Allocation rules define the calculations used to distribute values (like expenses and incomes) to different parts of your organization.
An area chart visualizes trends as data points, where the x-axis is time or dimension. This chart is similar to a line chart with color fills between the line and the threshold.
An assumption is a global value that is accessible to all users when writing formulas in their own plans. Assumptions can vary over time and have different values in different versions, but will have the same value at all levels and in every account.
An attribute is a logical grouping with a list of possible values that you can use to tag accounts, dimensions, and levels. You can create attributes to represent different rollup hierarchies for your organization (for example, geography vs. function).
Audit trail provides a history of user-entered changes on sheets. This information helps to answer questions about where and when the data originated in a cell, who made the latest changes, and so on. The audit trail also tracks changes resulting from imports and formula updates.
A bar chart visualizes multi- data series as horizontal columns, where the y-axis is time or dimension. This chart is similar to a column chart where the axes are switched.
A breadcrumb is a navigational aid to help users track their location in the Adaptive Planning interface.
Breakback is a configurable set of rules used to spread a value entered in a time rollup back into the time units that comprise the rollup.
Designed for computational efficiency, a calculated account contains a single formula that is consistent across all plans and is used to run calculations on data from elsewhere in your model. Metric accounts are a type of calculated account.
A column chart visualizes a data series as vertical columns, where the x-axis is time or a dimension.
A consolidation percentage is the percent of a company owned. Sometimes called a minority interest.
A crosstab chart visualizes data in tabular format. This chart is often used to compare relationships between data sets.
A cube sheet is a type of sheet that allows for multi-dimensional data input in a few accounts across a potentially large set of dimensions.
Cumulative Translation Adjustment
A cumulative translation adjustment (CTA) is an entry in the comprehensive income section of a translated balance sheet summarizing the gains/losses resulting from varying exchange rates over a certain time period.
A dashboard is a container for grouping a series of charts or other data analysis often by a theme or subject.
A dimension is an accounting characteristic with a list of possible values. Dimensions are used in all types of sheets to tag levels in the organization structure. For example, a product dimension can represent the product lines and products sold by your corporation and a job dimension can represent the job titles assigned to employees.
A doughnut chart visualizes a data series as a circular chart. This chart is similar to a pie chart without the center.
Elimination is the process of negating the financial effect of two or more account balances under the umbrella of a common parent.
An elimination level is the level at which inter-company account balances are eliminated.
The Formula Assistant is a tool to help you construct syntactically-correct formulas. You can use it to insert valid accounts, assumptions, qualifiers, and functions into a formula.
A funnel chart visualizes data segmented by a category. This chart type is often used to show progression in business phases, such as a sales cycle or manufacturing process. This chart type can help you identify potential revenue at various sales stages or identify inefficiencies in a production line.
A gauge chart visualizes data as a meter (speedometer) or gauge. Often used to represent percentages, such as a gross margin percentage or EBITDA percentage. Zones indicate if the metric is good, fair, or bad.
An instance is the collection of structural components that define a fully-functional entity within Adaptive Planning. Sometimes called an installation, an instance consists of a single set of accounts, organization structure, versions, dimensions, attributes, sheets, versions, permissions, fiscal years, integrations, and so on. Adaptive Planning allows multiple instances of its hosted system, so users can switch between them. See Multi-Instance.
The multi-instance feature that lets you link instances together in a hierarchy or tree. Instance trees can contain any number of instances with any level of hierarchy.
Adaptive integration is an application that acts as a secure bridge to import data from different data sources like spreadsheets, databases, on-premises sources, and cloud sources into Adaptive Insights products.
Journal Entry Version
Journal entry versions are a type of sub-version that allows Consolidation instances to maintain the integrity of their imported actuals. Instead of changing the data, you create journal entries that adjust the data. These adjustments must be balanced, meaning that the sum of all debits in an adjustment must be equal to the sum of all credits before the journal entry can be posted. Create multiple journal entry versions for IFRS to GAAP, Accruals, and reclassifications.
A KPI (key performance indicator) visualizes a metric in way that helps you understand how your business is doing relative to set goals.
The leaf strata are the smallest unit of time in a time structure. Only time periods in the leaf strata can contain data.
Levels in a plan represent the organizational structures of your business (for example, departments, profit centers, cost centers, or geographical regions).
Level rollups are totals calculated from values entered in sublevels and rolled up the organizational structure. For GL Accounts, a level rollup is always a sum. For Custom and Cube Accounts, you can set level rollups as sums, non-blank averages, weighted averages, or a text field where no rollup applies.
Level Workflow Task
A level workflow task is a type of task that is assigned to a level (instead of a specific user). Only level owners see this type of task.
A line chart visualizes trends as data points, where the x-axis is time or dimension.
A linked level is a level in a parent (target) instance that inherits some or all the data from the top level of a child (source) instance.
A list dimension is a dimension that is entirely non-hierarchical. It has no sub-dimensions and no hierarchy of dimension values, only a flat list of values.
A locked version has data that cannot be altered or edited. With the appropriate permissions, administrators can lock and unlock versions.
Modeled sheets are for entering record-based data. The sheet has customized field names across the columns and records as rows. A modeled sheet contains the underlying business logic for modeling financial events, such as revenues generated from sales, monthly salaries of personnel, or the depreciation of capital purchases.
Multi-Instance is a feature enabling multiple Adaptive Planning instances to be linked together in a hierarchical fashion. Data from a child instance can be brought up automatically based on mappings established between accounts and dimensions. See also Instance.
The navigation icon appears in the upper left corner of the Adaptive Planning interface. Click this icon to open the navigation menu.
An organization structure models the operations of your company and the way data rolls up for planning and analysis purposes. Also known as the hierarchy of levels. See also, level.
A perspective is a group of dashboards and charts, usually focused on a common function such as finance or sales.
A perspective context is a set of system or admin-defined filters available from any perspective. You can use these contexts to temporarily narrow the focus of the analysis and test ideas or check for patterns.
A pie chart visualizes a data series as a circular chart with slices sized proportionally to represent the data values.
Planning versions, also referred to as plan versions, plans, and planning, may be budgets, what-if scenarios, or almost anything else you can imagine.
A primary axis on a chart indicates the magnitude of metric values. For example, the y-axis on a column chart can display values based on account units.
A pyramid chart visualizes data segmented by a category. This chart is similar to a funnel chart - only inverted.
A reclassification is movement of an amount from one general ledger account to another. Examples of a reclassification include correcting an incorrect entry after month end close or consolidating ledgers of multiple business entities,where certain accounts for one entity must be moved to a different account when considered in the context of its larger owning entity.
A currency is marked as a reporting currency when it is important to have exact exchange rates for it, rather than converting through an intermediate currency. In large companies, however, marking a currency as a reporting currency may create hundreds of exchange rate accounts and should be done only sparingly.
A rollup is a total or a rolled up value for levels, accounts, time periods, or splits.
To contribute the total of a rollup. In the Adaptive Suite a values can roll up to levels, accounts, and time periods. Splits also roll up to the original account total. See Rollup.
A rollup account is a parent account that sums the totals of its child accounts.
A root account is the top-level account in the hierarchy. It has no parent account and does not roll up to another account. The Adaptive Suite comes with several General Ledger (GL) root accounts, and any account you add rolls up to one of the root account eventually.
The root strata is the largest unit of time in a time structure. In most cases, Fiscal Year is the root containing all other strata.
A scatter chart visualizes trends as data points, where the x-axis is time or dimension.
A scorecard visualizes a series of data in a tabular format that summarizes actuals versus planned data, and variance. This chart often includes a micro chart to highlight key metrics.
Sheets provide the Adaptive Planning interface for financial managers and planners to view, enter, and update financial data (such as actual ledger data, forecasts, personnel information and budgets). There are three types of sheets: standard, modeled, and cube.
A sheet chart is a container for displaying sheets from the Adaptive Suite within a Discovery dashboard. Sheet charts let you make changes to the sheet data your charts rely on without the need to navigate out of Discovery. Saved changes immediately update related charts and sheets in a dashboard.
Sheet Workflow Task
A sheet workflow task is a type of task that is assigned to a sheet (instead of a specific user). Only users who have access to the sheet can see this type of task.
A snapshot is static image of a changeable item, such as a dial or dashboard. A snapshot shows the item at a particular moment in time, and does not update.
When an allocation or elimination rule is applied to the actuals version, source actuals allow you to specify a particular sub-version of actuals to be used as the source for the rule. See also Target Actuals.
A sparkline is a tiny line chart or bar chart on that represents changes in account values over time. You can add sparklines as a display option on standard and cube sheets (and on modeled sheets that include a timespan column).
A split is a supporting calculation for accounts. A split lets you plan accounts, such as expenses or business metrics, with greater detail. The entered value of splits are rolled up to their parent account. Splits are for your information only and do not appear on other sheets or levels.
A standard sheet contains a simple grid for data-entry composed of accounts and time periods. Common examples of standard sheets include expense sheets, revenue sheets, profit-and-loss sheets, balance sheets, and cash flow sheets.
Sub-versions are slices of your actuals, created under an existing Actuals version in the version tree. The data of each sub-version rolls up to the data displayed in actuals; that is, data is not duplicated. You can have any number of sub-versions under actuals, and sub-versions can also have sub-versions. Create actuals sub-versions to organize and filter your actuals in different ways.
When an allocation or elimination rule is applied to the actuals version, target actuals allow you to specify a particular sub-version of actuals to be used as the target for the rule. See also Source Actuals.
When creating a territory map, territory assignments are required to indicate the names of sales representatives and the geographies they own. You set territory assignments within a modeled sheet by selecting dimension values for sales representatives in one column and geographies in another. Territory assignments commonly include other information like market segment or industry.
A territory map is a geographic chart that defines the boundaries of sales territory ownership. You can view sales-related data for a territory by clicking it. Territory maps require a cube sheet containing sales representatives, their geographic assignments, and other multi-dimensial data related to their sales performance or sales opportunities.
Territory planning is the process of deploying sales representatives to geographies, market segments, or industries as part of achieving sales goals.
A text chart is a container for displaying text in dashboard. They can be useful for providing explanatory information or notes about the other charts or sheets in a dashboard. The text can be entered unformatted, as HTML, or as markdown syntax.
A time period is a collection of consecutive days, weeks, months or other time stratum with established start and end dates. They can be leaf or rollup strata where data is stored.
A time rollup specifies how account totals appear on any worksheet with time periods (for example, quarterly or yearly totals).
Time strata are the layers of time that roll up to each other from the leaf stratum to the root stratum.
A time stratum is an individual level of time within the time strata.
The top level is the required, highest level in an organizational structure. All sheets appear on the top level, and all levels in the organization roll up to it.
Trading partners are two parties within a company, typically subsidiaries or departments which do business with each other and post intra-company transactions. Typically, a debit transaction and credit transaction gets booked by the two parties and the seller invoices the buyer.
Unpublished changes are changes made to an instance while Admin Publishing is in effect. These changes are not activated until an administrator publishes them.
A user-assigned sheet is a sheet that an administrator assigns to one or more specific users. Unlike level-assigned sheets, assigned users can view these sheets at any level.
Created by administrators, a user group is a collection of individual logins for an installation. These groups are useful for assigning and managing version permissions for a large number of users. They are also useful for emailing reports to different sets of users.
A version is a collection of accounts, levels, and other data that represents a particular financial scenario. For example, a version can include current-year actuals, a budget for next year, a three-year plan, and a what-if plan for evaluating the effects of a business transaction.
Virtual versions use data from two different versions to create a read-only composite version. With virtual versions, you can use the data of one version and apply the exchange rate of another version, which removes the rate fluctuations. For Consolidation, create virtual versions to enable Constant Currency Reporting.
A waterfall chart visualizes data to show where you started, where you ended, and how you got there. The initial and the final values are often represented by whole columns, while the intermediate values are denoted by floating columns.
A weight formula in an allocation rule describes how the allocated-in amounts are distributed among target levels.
A weight formula in an allocation rule describes how the allocated-in amounts are distributed among target levels.