Working with Subaccounts

You create subaccounts for additional input detail in main accounts. For example, you can add subaccount SG & A Expense (1080) to display two different expense categories: SG & A Expenses (1080.00.010) and Research & Development (1080.00.020). Subaccounts inherit attributes of main accounts in both historical and forecast periods.

Adding and Maintaining Subaccounts

When you divide Income Statement accounts, you produce one subaccount. When subaccounting Balance Sheet accounts (2000 level), related accounts are automatically subaccounted.

Subaccounts add detail to the standard financial accounts. Each subaccount appears in the Accounts spreadsheet and in respective financial statements. When you subaccount a financial account that has related accounts, all of the related accounts are subaccounted automatically.

To add subaccount:

1. Access the Strategic Modeling ribbon in Microsoft Excel.

2. Select an Account by placing your cursor on an account. For example, select Salary Expense account in the account view or a standard report.

3. From the Account grouping label, click Subaccounts. The subaccount dialog displays the Salary Expense account information.

   
   
   

4. In Current Account Information, select a main account.

   List of all available main accounts are displayed. Click to search accounts. In Search for, enter the first few characters of the account name or enter account ID.

5. In Current Account Information, you can add an account by selecting any descendant account member, and then click .

   The newly created subaccount is based on the current active account selection in the account list. New Sibling subaccount is enabled when active account is a subaccount. Upon creating a new subaccount, you can add a new sibling subaccount for the current active subaccount selection in the list. See Adding a New Sibling Subaccount

6. In Subaccount Information, enter a Subaccount Key.

   Keys can contain alphanumeric characters only.

7. In Subaccount Information, enter a subaccount name or description.

   You can modify individual subaccount name or description, later the modified name or description is displayed in the account view.

8. Select an account type: Additive, Subtractive, or Independent.

9. Optional: Select Lock Children option, which enables you to avoid further addition of subaccounts to calculated account hierarchy list, and then click OK.

Modifying Subaccount Descriptions

You can edit subaccount descriptions.

To modify subaccount descriptions:

1. From the Account grouping label, and then select Subaccounts.

2. In Subaccounts, select a subaccount.

3. In Subaccount Information, enter a new subaccount name or description.

4. Click OK.

Modifying the Subaccount Key

If the Subaccount Key is changed then all data associated to the subaccount is maintained with the new key. Most of the subaccount data such as: account descriptions, forecast methods input values, UDA attributes, custom settings, funding options settings, scenarios, graphing, dimensions, report information, and formula references will change accordingly to maintain the new key.