The Consolidated Profit and Loss report shows the Profit and Loss statement of one scope after the consolidation.
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 (
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:
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:
Suppress Zero Linesif 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).
Show Account No.if you wish to display the account number prior to the account name (e.g.
311300 - Total Revenue).
Show Two Decimal Placesif you wish to show the (e.g.
The Consolidated Profit and Loss report displays different aspects of the base elements you select in several tables. Each table shows the profit and loss accounts in rows and the time dimensions in columns (specifically the
Month_YTD dimension and its prior period, e.g.
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 five parts. Above we see the Profit (Loss) section, which shows the profit and loss accounts. There are also sections for Profit (loss) attributable to, Total income, and Total income attributable to, all of which show their own account, i.e the base elements of which they are a parent element, see the PnL Account dimension article for more information. Finally, the KPIs section shows different types of calculated statistical indicators.
|Row labels||Account shown as localized name.||
The first column shows the row labels, broken down into five hierarchies of the
This report exposes profit and loss accounts with the
|Data selected in the header (e.g.
||Selection from the Comboboxes in the header (Version, Month_YTD, Scope, and Currency)||The selection are base elements in the
The previous version and prior period of the data selected in the header (e.g.
|The previous version and prior period of the data selected from the Comboboxes in the header.||The