Consolidated Balance Sheet Report

Return to Financial Consolidation Model Overview.

The Consolidated Balance Sheet report shows the Balance Sheet statement of one scope after the consolidation.

Report Heading

The report heading updates dynamically as various reporting options are selected. Below it shows the Version, Month_YTD, Scope, and Currency dimensions for the Profit and Loss report (Actual 2018_12, EU (Subgroup European Union) and In Euro, respectively):

The logo can be changed in Administration; see Configuring Design Elements for more on report design.

You can select your base elements in the Comboboxes below the report heading:

The Version dimension separates actual figures from planning figures, see full article. The Month_YTD dimension accumulates float values from the beginning of the calendar year to the current date, while respectively holding the final figure for stock values, see full article. The Scope dimension contains all target elements for financial consolidation in a flat list, see full article. The Currency dimension separates input and output elements of the currency conversion.

The check-boxes below allow you to customize the appearance of your report:

Click Suppress Zero Lines if you wish to hide the fields in your report with no data (if you select this option all, all available transaction types will appear: those without data will have a dash in place of numeric input).
Click Show Account No. if you wish to display the account number prior to the account name (e.g. Total property, plant and equipment → 110100 - Total property, plant and equipment).
Click Show Two Decimal Places if you wish to show the figures in double-decimal form (e.g. 2,947,066 → 2,947,066).

Table Columns

The Consolidated Balance Sheet report displays different aspects of the base elements you select in several tables. For each the table, the columns shows the balance sheet accounts in rows in relation to the time dimension in columns (specifically the Month_YTD dimension and its prior period, e.g. 2018-12_YTD and 2017-12_YTD, see screenshots below). The columns displayed in the report depend on the the selection made in the PoV area:

The table breaks down into three parts. Above we see the Total assets section, which shows the assets accounts. There is also a section for Total equity and liabilities. Finally, the KPIs section shows different types of calculated statistical indicators.

Field	Description	Implementation
Row labels	Account shown as localized name.	Three hierarchies of the `BS account` dimension. The first column shows the row labels. The first hierarchy shows the element configured by the `configuration.bs_account_assets` setting and it's decendants. The second table shows `configuration.bs_account_liabilities` and the third one `configuration.bs_account_kpis`. This report exposes balance sheet accounts with the `Consolidated Statement` attribute set to `1`.
Data selected in the header (e.g. `2018-12_YTD` above).	Selection from the Comboboxes in the header (Version, Month_YTD, Scope, and Currency)	The selection are base elements in the `Balance Sheet` cube. In addition to the `Version`, `Month_YTD`, `Scope`and `Currency` dimension, the data will reflect the scope aggregation in the Legal Entity dimension on the `Consolidated Adjusted` element of the Consolidation dimension.
The previous version and prior period of the data selected in the header (e.g. `2017-12_YTD` above).	The previous version and prior period of the data selected from the Comboboxes in the header.	The `Previous Version` attribute of the selected element in the `Version` dimension and the `Prior Period` attribute of the selected element in the `Month_YTD` dimension. All other data is the same as above.

Note: to use Name attribute as an alias for elements of the Month_YTD dimension, change the setting of the key month_ytd_use_name_alias to TRUE.

Updated September 27, 2024