Edit table columns in the financial statements

You can enrich the dynamic table data by adding columns. You can also view and modify the settings for the existing columns.

Note: The default font size for content in dynamic tables is 12 and cannot be modified.

To add a column in a dynamic table:

  1. Select the table.

  2. Select More actions (), then choose Edit Dynamic Table.

    The table opens in edit mode.

  1. Go to where you want to add a column.

  2. Select Add () at the upper table border.

    A column is added to the table and the column settings display on the page.

To edit column settings:

  1. Select the column header.

  2. Modify the following settings as needed:

    • Type

      Choose a column type. The following columns have predefined values:

      • Prior year - prior year balance

      • Current year - current year balance

      • Current period - balance for the current period (for interim engagements)

      • Comparative period - balance for the comparative period

      • Amount variance - difference between prior year balance and current year balance

      • Percent variance - percentage difference between prior year balance and current year balance. If you choose this column type, you can also select the number of decimal places to display in the column. By default, percent variance columns will display values to 2 decimal places.

      You can enter custom values for the following columns:

      • Input - enter text, numbers, currency values or percentages.

      • Custom calculation - enter a calculation using the calculation editor. The calculation is applied to all column cells.

      • Note reference - add references to existing notes in the financial statements.

      • Annotation - add annotations column. Select Add () in each cell in the column to add annotations.

    • Heading

      You can insert Dynamic Text or formula (fx) for the header. You can also type simple text in the Output field or combine simple text with dynamic text and formula.

    • Dimension

      Dimensions are group properties that authors can configure for the groupings to provide further categorization for accounts. For example, to have a further categorization for accounts based on location (Europe, North America, etc.).

      You can select a dimension to set the column to only display data for that dimension.

    • Entity

      If your engagement is consolidated, you can select whether to display total consolidated data, consolidated data or data for a specific subsidiary entity. If there are at least 15 subsidiary entities, you can use the search box to find the entity you want to select.

    • Width

      Select a width for your column. The width options for all columns are Narrow, Standard and Specific, except for note reference, annotation and description columns, where the width options are Small, Medium and Large.

      If you select Specific, you can then specify the width of the column in centimeters or inches. The measurement unit is determined by the unit selected in the product settings.

    • Currency Symbol

      Allows you to select whether to display the currency symbol in the column header.

      Available options:

      • Use document default - the table uses the default currency symbol settings for the financial statements. See Set default currency symbols options for dynamic tables to learn more.

      • Show in header - the currency symbol displays in the column header.

      • Do not show in header - the currency symbol does not display in the header.

    • Format

      For input or custom calculation columns, you can choose one of the following formats for your cell values:

      • Currency

      • Number

      • Percent

      • Text

      If you select Number or Percent, you can also choose the number of decimal places.

    • Display options

      For some column types and formats, you can select one or more display options:

      • Expand to fill the width of the page - sets the column width so the dynamic table fits the full width of the page.

        Note: This setting is enabled on the Description column by default.

      • Display zero balances - shows accounts with zero balances in the column.

      • Display opposite sign for balances - displays the opposite sign (negative or positive) for the values in the column.

      • Exclude from totals - excludes the values in this column from the calculation in the account group Total row.

      • Display symbol in heading - displays the currency symbol or percentage sign at the top of the column.

      • Show year in heading - adds the year to the heading of Current year or Prior year columns.

      • Use non-consolidated data - if this is a consolidated engagement, selecting this option removes consolidated data from the column and displays the non-consolidated data only.

      You can select the Visibility icon ( ) to reveal a dropdown with the following options:

      • Apply default behavior - the default behavior is applied to the column. Note that the default behavior differs based on the column type.

        • For trial balance columns:

          The column always displays in the financial statements and the print copy (PDF) if the column contains data (at least one cell is not empty and its value is not zero). Note that this default behavior can be changed for an individual dynamic table from the table settings.

          Note: Prior year columns do not display if there is no prior year data.

        • For input and custom calculation columns:

          The column always displays in the financial statements and displays in the print copy (PDF) if the column contains data (at least one cell is not empty and its value is not zero).

      • Always display this column - the column is always displayed in the financial statements and in the print copy (PDF).

      • Always hide this column - the column is always hidden in the financial statements and in the print copy (PDF).

    • Delete ()

      Select this icon to delete the column from the table.

  3. Select DONE.

  4. Select SAVE or SAVE & CLOSE.