Separate Cash Flow Report

Return to Jedox Models Overview.

The Separate Cash Flow report shows the Cash Flow statement of one individual legal entity as submitted before any adjustments and conversions. It exposes the data in a very early stage of the consolidation process.

Report Heading

The report heading updates dynamically as various reporting options are selected. Below it shows the Scope, Entity and Currency dimensions for the Cash Flow report (Actual 2018_12, Bikers Best Corp. and Local Currency (USD), 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 Legal Entity dimension represent the companies within a group hierarchy, see full article.

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.Net cash flows from (used in) operating activities → 1000 - Net cash flows from (used in) operating activities).
  • Click Show Two Decimal Places if you wish to show the figures in double-decimal form (e.g.1,112,010 →1,112,010.64).

Table Columns

The Separate Cash Flow report displays different aspects of the base elements you select in several tables. The table shows the cash flow accounts in rows and the time dimensions in columns (specifically the Month_YTD dimension and its previous 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:

Above we see the full Separate Cash Flow table, which shows the Total cash and cash equivalent accounts.

Field Description Implementation
Row labels Account shown as localized name.

The first column shows the row labels, consisting of one hierarchy of the CF Account dimension. This hierarchy shows the element configured by the configuration.cf_accounts setting and it's descendants.
Data selected in the header (e.g. 2018-12_YTD above). Selection from the Comboboxes in the header (Version, Month_YTD, Legal Entity) The selection are base elements in the Cash Flow cube. In addition to the Version, Month_YTD, and Legal Entity dimension, the data will reflect the local currency (LC) for the chosen legal entity as submitted on the ~ Scope and the Local GAAP elements 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