Configuring ACCT dimension columns for the Income Statement and Balance Sheet Template Builders

By default, both the Income Statement and Balance Sheet Template Builders include the FSSummary and FSDetail columns from the ACCT dimension. You can also include other columns from the ACCT dimension, even custom columns, but you must complete the following steps:

  1. In the column description, prefix the column name with "FS ". This triggers the system to add the column to the template builder.

    NOTE: Make sure you add a space between "FS " and the column name.

  2. The following dimension columns must be configured as follows:

    Income Statements

    Statement Column Type Column FSummary Column
    IS Must have entries Must have entries

    Balance Sheets

    Statement Column Type Column FSummary Column
    BS N/A Must have entries
  3. Save the changes to the dimension.