Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

Add and Edit Accounts

Explains how to manually add and edit general ledger, custom, metric, and assumption accounts for administrators who build or manage the model in Adaptive Insights.

Audience: Administrators who manage the model. 

An account is a container that groups actuals or planning information, such as expenses, assets, liabilities, sales, and any business metrics.

When you first create your model, you generally import the account structure.  Then, you add and edit accounts one at a time, or import bulk updates. The settings you choose change the account's behavior and visibility. Different combinations have different results. See Account Fields and Settings for each account type before you choose the settings for new and existing accounts.  

Some general ledger accounts have locked settings. See the list of built-in general ledger accounts.

After you create accounts, add them to sheets. Use the sheets to view and update the account data in various versions. For cube and modeled accounts see Create Cube Sheets, and Create Modeled Sheets.

Before You Begin

  • New to accounts? See Accounts Overview and Accounts Interface Tour.
  • Required permissions for accounts: Model Management > Model
  • Additional permission for assumptions: Model Management > Assumptions.

How You Get There

Get to GL, Custom, Metric, and Assumption Accounts

Navigation Icon5.png From the nav menu, click Modeling. From the Accounts menu, choose: General Ledger Accounts, Custom Accounts, Metric Accounts, or Assumptions.

You can add and edit accounts, create system accounts, and reorganize the account structure.

Get to Cube or Modeled Accounts

Navigation Icon5.png From the nav menu, click Modeling. From the Sheets menu, select either Level-Assigned Sheets or User-Assigned Sheets. Click the Edit link next to the cube or modeled sheet. Click the Cube Account link or the Modeled Account link.  

Add  and Edit Accounts Manually

Add Accounts

All accounts you add to your model are child accounts of a root account at the highest level. 

  1. From the list of accounts, highlight a root, account or group.
  • If you highlight an account or root, the new account rolls up to the highlighted root or account. 
  • If you highlight a group, the new account is categorized in the group for navigation purposes. The data of the new account does not roll up to the group.
  1. From the toolbar:
    • For general ledger and custom accounts: Click Create New Account Create Account Icon.
    • For metric accounts: Click Create New Account Create Metric Account.
    • For assumption accounts: Create New Account Create new Assumption account.
  2. In the Account Details panel, click Collapse All collapseAll.png so you can see all the sections you need to complete. 
  3. Click the section name expand it and complete that section's settings. The settings and fields control how an account and its data behaves. See Account Fields and Settings.
  4. Click Save adminSaveDetail.png or Cancel Cancel at the top of the Account Detail panel.

The new account appears in the accounts list as the last item under its parent account or group. To change the order of accounts, highlight the account and click Move up Move Up and Move down Move Down.

To have the account roll up to a different account, edit the account and choose a different account or group from the Rolls Up to drop-down.

Edit Accounts

Built-in general ledger accounts have some settings that are locked. See the list of built-in general ledger accounts.

  1. From the list, highlight the account.
  2. Edit the Account Details panel on the right of page. Not all the fields are editable. The settings and fields control how an account and its data behaves. See Account Fields and Settings.
  3. Click Save adminSaveDetail.png or Cancel Cancel at the top of the Account Detail panel.

Add System Accounts

For general ledger and custom accounts.

The system controls the contents of system accounts. Your team cannot use sheets or any other method to edit system accounts. system account icon.pngidentifies a system accounts in the account list.

Use system accounts for allocations, CTA, and minority interest adjustments when you use the full consolidation method. 

  1. From the list of accounts, highlight the parent account or group. The account must already be a rollup account without values to add a system account to it.
  2. Click Create New System Account createSystemAccount.png.
  3. In the Account Details panel, click Collapse All collapseAll.png to see all the sections of the settings you need to complete. 
  4. Click the section name of each section to expand. Complete the settings.  See Account Fields and Settings.
  5. Click Save adminSaveDetail.png or Cancel Cancel at the top of the Account Detail panel.
  • Was this article helpful?