Add data in the financial statements tables

You can include more information in your financial statement. You can add columns or rows into tables and rearrange rows. You can also modify the account group settings.

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

      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.

    • Width

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

    • 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 eye 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).

          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.

To add a row 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 row.

  2. Select Add () at the left border of the table.

  3. Select one of the following row types:

    Trial balance data: to select the row data from the trial balance data. You can insert an account or group. If the group has subgroups, they are inserted into the table as well. A Total row is also inserted to hold the sum of the accounts or subgroups within the group.

    Input row: to add an empty row, where you can enter custom text and values.

    Commentary row: adds a commentary row. By default it inserts a reference to existing notes in the financial statements. You can change the default by deleting the note reference and enter a comment for the row.

    Spacing row: to add white space into your dynamic table. You can add white space to make your content easier to read.

    Page break: to add a page break between table rows.

    Custom group: to insert a text field so you can enter a title or a brief description for your group. To learn more, see Create custom groups in tables.

  4. Select SAVE or SAVE & CLOSE.

To move a row:

  1. Select the table.

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

    The table opens in edit mode.

  1. Locate the row that you want to move and select the Move icon ().

  2. Drag the row then drop it in the desired location.

  3. A grid displays in the table to mark the borders of each row. Valid places to move your row have dark blue grid lines while invalid places have gray grid lines. Use the grid for guidance as you drag and drop.