Financial statement templates
What is a financial statement template¶
A financial statement template (FST) is a structure used to aggregate accounts or custom accounts/dimensions that can represent financial statements (IAS profit and loss statements and balance sheets, management reports, direct/indirect financial reports), KPIs and other indices for reporting. A financial statement template can be added to a matrix in its entirety or in part as a filter to be able to design its structure more quickly and efficiently.
Note: financial statement templates without accounts or with control type or multi-dimensional formulas cannot be added to matrices drawn on the Analytical Workspace.
For each financial statement template, relationships can be defined based on account dimension, custom dimension, account/custom dimension pair, account/analytical dimension pair or account/control type pair.
Relationships can be defined synthetically by specifying, in the definition, the individual accounts (or dimensional elements) and/or hierarchy nodes that must be added to or removed from the various FST items: the effective resulting relationships are identified by applying the specifications according to the defined order.
Structure of a financial statement template¶
A financial statement template is structured into two levels:
| Element | Description |
|---|---|
| First level | May contain the following elements, which constitute the FST items: - Parent element, or a node to which one or more accounts can be related, showing the sum of the amounts of the relative accounts. - Formula, or a formula-type node defined on the basis of a relatable items and/or other formulas. - Description, or a description-type node which allows you to customise the template header. |
| Second level | Contains all the accounts associated with relatable elements. |
Specific FST items can be recalled from other financial statement templates.
Financial statement templates in row/column filters¶
The FST can be added to other row/column filters of the matrix in the following ways.
| Element | Description |
|---|---|
| Analytic | Adds the whole FST structure to the row/column/matrix filters tree, organised over two levels according to the levels of the original template. |
| Synthetic | Adds the FST structure to the row/column/matrix filters tree, organised over one level, i.e. the first. |
Accounts in the financial statement template¶
For every financial statement template, relationships can be defined based on the following criteria:
- account dimension
- custom dimension
- analytical dimension
- control type
Relationships can be defined synthetically by specifying, in the definition, the individual hierarchy nodes and/or dimensional elements that need to be added to or removed from the FST items.
The order in which relationships are specified in FST items determines the final content of the FST item.
For forms that use FST items with relationships with Accounts or Account/Custom Dimension nodes or Custom Dimension nodes, especially in the presence of relationships with Initial balance accounts/Custom Dimensions, it is advisable to use the in memory reporting engine.
Note: financial statement templates containing multidimensional formulas or defined on analytical dimensions can only be used in forms based on the in-memory engine.
Multiple account relationships¶
By default, the account or account/custom dimension pair can only be related to a single FST item. Where there are several relationships between one account or account/custom dimension pair and several FST items, the system uses the most recently defined relationship on which deployment has been run. If multiple relationships are activated, the system considers all the FST items related to the account or the account/custom dimension pair and adds the amounts of all related FST items together.
This option may be useful in the following cases:
- For indirect cash flow forecasts in which, based on the annual profit, the depreciation account must be reclassified as two report items in order to obtain the flow of net working capital generated by operations and flow of net working capital generated by investments and disposals.
- To define an FST item with several relationships and specific items with details of the individual components.
Several FST items related by OR clauses can be concatenated in a formula. In this case, the final result is not equivalent to the sum of the amounts of the accounts involved, but the sum of the amounts of the FST items used. Thus, one single account can contribute several times to the final value of the amount.
Note: the in memory engine and the standard engine manage OR clauses in the same way, with the exception of OR clauses between FST items with multiple relationships and FST items without multiple relationships: for forms containing such clauses, the standard reporting engine is not recommended, as it cannot correctly manage multiple contributions for a single account.
Tagetik styles on FST items¶
To highlight FST item data (formulas, subtotals), a specific formatting style can be related to FST items. This relationship can be established at the Tagetik style level, and therefore applied to all forms to which it is associated, or at the individual FST item level, and therefore applied to the specific FST item. For more details on styles, see Tagetik styles .
Financial statement template on Analytical Workspaces¶
For matrices drawn on analytical workspaces, it is possible to use:
- Standard FST defined for the account dimension
- Advanced FST with custom dimension and account dimension
The following are not supported:
- FST without account dimension
- FST with control type
- FST with multi-dimensional formulas
- FST on which on-the-fly conversion is applied
- FST on which onScenarioPeriod is applied