Concept: Type Setting for Accounts

Every account in Adaptive Planning, except metric accounts, has a

Type

, although you can't always change it. What type you choose depends on the kind of data you're tracking. The Type settings changes:

The time rollup options available.

How your team enters data for the account in sheets.

How data displays in sheets.

For general ledger accounts, the

Type

setting includes the family of accounts followed by the type in paranthesis. Example: A child account of Current Assets displays: Current Asset (cumulative)
for

Type

Change Account Type Setting

You find this setting in the

Account Details

in the

Modeling

area. You can select:

Periodic
: The value is the net for the period.

Cumulative
: The value is the running balance.

Link
: The value comes from other modeled or cube accounts.

Accounts that roll up to an account have read-only account

Type

settings. You can change the account

Type

by changing the rollup account or changing the

Type

of the rollup account.

Accounts Type Setting That You Can't Change

Assumptions, and cube and modeled assumptions. These accounts are always periodic.

Built-in general ledger accounts.

Metric and cube metric accounts.

Related Settings

When you choose these settings, the account remains either periodic or cumulative.

Link: The values of the account come from a modeled or cube account.

Spread: The value from another account spreads through a time period in this account. This option is available for calculated accounts in modeled sheets only. This is typically used for revenue recognition and asset depreciation.

Accounts That Are Always Periodic or Cumulative

These accounts are always periodic:

Assumptions accounts.

Cube and model assumption accounts.

Some general ledger accounts that are built into the model.

Accounts that are always cumulative include

Initial balance accounts on modeled sheets.

Some general ledger accounts that are built into the model.

Time Rollups and Account Types

Time rollups represent the values of an account over a period of time. Example: The quarter rollup represents the values of all the months in the quarter. Time rollups are based on your calendar setup, most commonly Months, Quarters, and Years.

The rollup method is an account setting that determines how the account displays the values for time rollups.

These are the four rollup options:

Sum of rolled up values
(periodic only).

Value in last time period
(cumulative only).

Average of rolled up values
.

Weighted average of rolled up values
.

General ledger accounts don't have time rollup options. For general ledger accounts, periodic types always use the Sum of rolled up values
, and cumulative types always use the Value in last time period
.

Data in Periodic Accounts on Sheets

For periodic accounts, the value in any given time period equals the net activity for that period.

Example: For the Revenue account:

Your team enters values for each period.

The values between periods are unrelated.

The Q1 time rollup sums the values for the quarter.

Account	Jan	Feb	Mar	Q1
Revenue	100	50	400	550

Data in Cumulative Accounts on Sheets

Cumulative accounts maintain a running balance. The value displayed in each cell is current as of the end of the time period.

Example: The Petty Cash account accumulates over time, either increasing or decreasing from the prior period.

In sheets:

The value displayed per period is the previous period's value plus any increase or minus a decrease.

The time rollup is the value of the last period because the values in cumulative accounts are already summing as they go.

Account	Jan	Feb	Mar	Q1
Petty Cash	100	150	550	550

There are additional settings for cumulative accounts that control how the data displays on sheets:

Balance

Delta

You can select different options for plan versions and actuals versions. Example: Selecting Delta
for

Planned by

enables you to enter the difference in each time period in sheets for your plan versions. The sheet calculates the accumulation. Selecting Balance
for

Actuals by

enables you to upload actuals data from sources that show the balance for each period.

When you select Balance
for cumulative accounts, the experience in sheets is similar to periodic accounts:

You enter the running balance per period.

Periods without data are blank.

When you select Delta
for cumulative accounts, you can enter data in sheets in these 2 ways:

Enter the variance in the formula bar.

Enter the running balance in the cell.

Regardless of how you enter the data, the cells always display the running balance.

You can tell an account is Delta
from sheets when:

Future time periods prefill with the running balance.

You see

Previous Plus

in the formula bar.