Strategic Modeling Supports User-Defined Accounts on the Web

Strategic Modeling now supports user-defined accounts on the web. Previously, user-defined accounts were supported only in Smart View.

Depending on the template, some predefined user-defined accounts slots can be edited, and in some cases, you can insert new user-defined accounts.

User-defined accounts can be defined as:

Input Accounts:

  • If you want to manually enter the value for the account, you define it as an input account. This allows for direct data entry, bypassing any automated calculations.
  • You can also use input accounts to forecast values in forecast periods.

Calculated Accounts:

  • If you want the account value to be calculated based on other accounts or formulas, define it as a calculated account.
  • This involves specifying a formula that uses output from other accounts to derive the value.
  • In this case, the account's value is recalculated when the model is calculated.

To add or configure a user-defined account:

  1. In the Account View, navigate to or search for the account for which you want to add a user-defined account. Right-click the account, and then select Insert Child or Insert Sibling.
    Alternatively, you can select an existing editable account.
  2. Select the account, and then from Actions menu, select Properties.
  3. Enter properties for the selected account. Properties vary depending on the account, and include:
  • Key
  • Name
  • Output Unit and Type
    • Currency (THOUSANDS / MILLIONS / BILLIONS / TRILLIONS)
    • Items
    • Percent
    • Days
    • Ratio
    • Ones
  • Measure Type
    • Flow (Input)
    • Flow (Calculated)
    • Balance (Input)
    • Balance (Calculated)
    • Rate (Input)
    • Rate (Calculated)
    • Ratio (Calculated)
    • Discount Rate (Input)
    • Discount Rate (Calculated)
  • Weighted Average Based On (WTAVEKEY)
    • Rate (Input)
    • Rate (Calculated)
    • Discount Rate (Input)
    • Discount Rate (Calculated)
    • Applies to rate-based accounts, such as:
  • Formula
    • Available for calculated types.
  • Forecast Method
    • Available for input types.
  1. Available for input types: Click the Forecast Method icon  Forecast icon, and then enter Forecast Method details.
  2. Available for calculated types: Click the Formula Builder icon Formula builder iconand then enter the formula on the Formula Builder page. 
  3. Click Apply.

Business Benefit: You have the convenience of working with user-defined accounts on the web, not only in Smart View.

Key resources