The process of designing the row structure of a financial statement is complex, but when you are finished, you can use the structure multiple times.

Create a row definition

  1. Click > > > .

  2. Press CTRL + N to create a new row definition.

  3. In the field, enter a unique identifier for the new row definition. This could be an identifier that links the row definition to a particular financial statement.

  4. In the field, enter a descriptive name for the row definition that further identifies the row structure.

  5. In the lookup list, select the dimension focus or dimension set that applies to this row definition and that defines the elements that belong to the row definition.

    Note Note

    If your company has received a row definition from its consolidated company or a country/region-specific cash flow template, import the row definition template. Click , and select the file that you want to import or transfer the structure from an XBRL definition. When you have imported the basic structure, you can then add your company data and accounts to the basic structure.


  6. To design or view the row structure of the selected row definition, click .

Design the row definition structure

The form (step 6 above) is similar to the form that is accessed from the form to create dimension hierarchies. Dimension hierarchies contain the row line types and ; the financial statement can contain these and several other row line types.

The options are listed in the drop-down list on the tab of the form for the financial statement. They are:

  • – Identifies element value(s), for example, a ledger account or a dimension value for each component of the row definition focus.

  • – Identifies a row type that can be used as a header for a group or for a subtotal, for example, a header for a collection of accounts or dimension values.

  • – Identifies or refers to another row definition.

  • – Expresses a calculation that uses other rows.

  • – Produces an exception report when the financial statement is generated. The report lists the missing and/or duplicate balances in the row definition.

Note Note

If you are preparing a row definition template for export, be aware that such a row definition can only contain rows of type , , or .


Two views in the structure designer

The structure designer has two views, the view and the line view.

If you select the check box, the row definitions are presented in a tree structure. You can drag basic elements to the tree structure when you design the financial statement.

When you double-click a row type in the tree structure or click the Editicon, the system switches between the edit mode and a list of values that you can select.

If you clear the check box, you enter the line mode of the structure designer, and you can create the structure of the financial statement as follows: Press CTRL+N to add a line, and enter values in the and a text boxes. Select a value in the field for the row. In the line mode, you can create rows of any type, such as , , , and .

The following procedures describe how to create various types of row lines in the tree structure.

Create row lines of type Element

  1. In the right pane of the form, view the accounts or the dimension values that are part of the main focus that you selected for the financial statement row definition.

    Accounts are displayed on the tab and dimension values on the tab. If the focus of the row definition contains more than one dimension type, you can change the dimension type in the field.

  2. Select the ledger accounts or dimension values that you want to use in the right pane and drag them to the item in the tree structure (left pane) that contains them.

    You can also use other methods to add rows to the row structure in the left pane:

    • Right-click on the row above the position where you want the new row to be placed; click Create.

    • Click the Newicon, or press CTRL +N and move the cursor downwards to see the new row.

    • Place the cursor at the place in the tree where you want to insert an element, and then double-click on a row in the right pane.

  3. When you work in the tree control view, you select and format individual lines in the left pane. To edit a line in the tree structure, double-click it, or click the Editicon. A new set of tabs appears in the right pane.

  4. On the tab in the right pane, you can enter a name and description that are used internally in the structure designer, as well as the name and description that are printed on the financial statement report.

    You can use placeholders (for example, %NAME or %DESCR) in the and fields to create rows in the generated financial statement for all elements that fit the placeholder requirements.

  5. On the tab, enter various kinds of information according to the value in the field.

    For example, select or in the drop-down list. An account that has a credit balance will show zero if the row settings is set to .

    Or, select the or check boxes to print a header, its sublevels, and then a subtotal rolling up the sub-level figures.

    Note Note

    Use expressions to generate multiple authorized values. Write an expression such as p* in the field. p* means that all departments starting with a p are listed in the tree structure. Select the check box to expand the row definition nodes in the tree structure.


  6. On the tab, define how the line will be formatted and in which column field the row value will be shown in the financial statement. For more information, see the field descriptions in Structure designer (form).

  7. To reuse an existing row definition, make sure that you are not in the edit mode by double-clicking the row definition in the tree structure area. When the list of values is presented in the pane on the tab, click the tab, and drag the row definitions that you want to reuse. In this way, you create nodes of the type described later in this topic.

  8. If you do not want to reuse the whole row definition, double-click the reusable row definition in the tree structure to activate the edit mode. On the tab, select a specific part of the row definition that will be used in the new row definition in the field.

    Note Note

    You cannot change the value in the field after the row definition line is created.


Create row lines of type Group

  1. In the left pane of the form, position the cursor where you want to insert a group row line, and click the Createicon. A group row line could be a header for a group of accounts or dimension values.

  2. In the right pane, in the field, select . Complete the and fields.

  3. Drag the row line to its proper position in the tree structure.

  4. To format the lines of a single row in the tree structure, select the row, and then click Edit. In the right pane, new tabs appear. On the tab, select how you want the row to be formatted in the financial statement.

    Note Note

    If you clear the check box, you can view, create, and format all the lines within a specific group on a grid structure. Select the group row for which you want to create or format the component rows, and click . You can create the rows that together define the group, or you can format all the rows in a consistent manner, by selecting and clearing the fields on each line that otherwise in the tree control view appear on the tab. When you create a sub-branch, you cannot return to the view. The parent branch is noted at the bottom of the grid form. Return to the parent level by closing the form for the sub-branch. From the top-level parent branch, you can return to the view as appropriate.


Create row lines of type Structure

Use the steps below to create row lines of the type that links to branches in another row definition.

  1. In the left pane of the form, position the cursor where you want to insert a structure row line and click the Createicon. Row lines of type link to branches in another row definition. They enable you to reuse substructures that you have already set up for other financial statements. For example, you can reuse the row structure that presents the income statement when you are preparing a cash flow statement.

  2. In the field, select . Complete the and fields.

  3. On the tab, select another row definition in the field and link to a certain branch of the selected row definition in the field.

    Note Note

    You can reuse row definitions with the row type .


Create row lines of type Calculation

  1. In the left pane of the form, position the cursor where you want to insert a calculation row line and click the Createicon.

    Calculation rows are usually created last because they use the position of other lines in their definition.

  2. In the field, select . Complete the and fields.

    Drag row definition nodes from the tree structure pane to the grid area in section on the tab, and then write the expression in the field.

    For example, if you have added two row definition nodes and write a + operator in the field, the sum of the two row definition nodes is added to the printout of the financial statement.

Create row lines of type Exception

Use the steps below to create row lines of the type to print inconsistencies in the tree structure like missing and duplicate lines.

  1. In the left pane of the form, position the cursor where you want to insert an exception row line, preferably at the end of the tree structure, and click the Createicon.

  2. In the field, select . Complete the and fields.

  3. On the , select the exception type in the field. For example, a financial statement with an exception type value lists element value combinations whose balances are present several times in the financial statement.

Check the tree structure

  1. When the basic structure of the row definition is in place, complete the tab next to the tab.

    Note Note

    If you want to format the rows quickly, clear the check box at the top of the form. In a grid structure, you can now view and edit the formatting of each row. You can also build the row structure in the line view.


  2. Before you update the structure make sure that there are no errors and duplicates. Click the check box to explode the tree structure into all the actual values.

    To look for duplicates, click the check box, and then click the check box. A search is performed for duplicates, which are marked with a specific icon. Both icons are displayed to make it possible to go to the next or previous error.

    Note Note

    In simulation mode the form is not editable.


When the row definition structure is complete, you can prepare, view, and print a financial statement in > > > > .

Example: Create a cash flow statement

You design a cash flow statement to include all company data that is relevant to cash holdings and cash equivalents. You make decisions about how to include all relevant data and then use the financial statement functionality to create the cash flow statement.

Typically a cash flow statement includes the following rows (line items), most of which you create as rows with type in the field.

Net cash from operations– This usually includes the company's net income.

You can create a row with in the field that identifies to the company's income statement row definition and the row within this definition that produces the net income.

Net cash used for financing– In this group, you map the appropriate ledger accounts. You can specify the structure further by introducing intermediate row type groups such as common stock issued, common stock repurchased, common stock cash dividends, and other.

Net cash from investments– In this group, you map the appropriate ledger accounts. You can specify the structure further by introducing intermediate row type groups.

Net change in cash and equivalents– Sum of first three categories (debit or credit), which you can produce either as a calculation-type row that uses the prior line items as arguments of a sum or a group-type row that is set up as a total and that includes the prior lines (the lines that are described above) as part of the group total. In effect, the prior lines are rolled up to produce a total.

Effect of exchange rates on cash and equivalents– Adjustments to unrealized (open) customer and vendor transactions (debit or credit). Identity these adjustments by mapping the appropriate accounts.

Cash and equivalents, beginning of period– From cash flow statement of the previous period (debit or credit). Select the ledger accounts that compose the cash flow statement, and set the field on the tab of the right-hand pane ( Editmode) to .

The prior period balance of the rows that have been defined is then obtained. You can also use the copy function if necessary, and adjust the attributes to match the needs of the cash flow statement.

Cash and equivalents, end of period– Net change in cash and equivalents (debit or credit) + Effect of exchange rates on cash and equivalents (debit or credit) + Cash and equivalent, beginning of period (debit or credit).

You will use either the calculation row to perform a calculation in reference to the line items previously listed or else introduce a group-type row as a total, under which the prior line items are inserted and rolled up.

For all cash flow statements, it is important that each ledger account is used only once:

  1. In the view, click the tab in the left pane of the form.

  2. Select the check box. The field now appears on the grid in the right pane, and you can easily see if an account or dimension has been used more than once.

    NoteTo update the field after you make changes in the row structure, click the check box at the top of the form.

See Also