Cash Flow
The CONSOLIDATION role has rights for the templates listed in this section.
Please note that the content on the images may differ from the content in your package due to package localization.
Other Entries to Consolidated Cash Flow (870 000)
Files: BW_IT702.xml / DIM01_input70000 all periods.xlsx / UI_P_DIM01_IT702_870000.xml
This input template is used for group level elimination for consolidated cash flow. The input template is a copy of the Clausion default template and works similarly to the input template for document series 70 000, except that the entries are saved to document series 870 000.
Company Arrangements
Balance Sheet of Acquired Company (830 000)
Files: P_INP_1PER_830.xml / P_INP_1PERIOD_CFARRS.xlsx / UI_P_INP_1PER_830.xml
This input template is used to enter the balance sheet data of an acquired unit or business at the time of the acquisition. The data is saved to document series 830 000.
The data is included in the cash flow statement reports in order to remove the change in balance items caused by the acquisition. In other words, the cash flows, for example, a change in net working capital consist of the change in the balance value after the acquisition.
In the cash flow reporting of the acquired unit, the net cash flow relating to the acquisition consists of only the cash and cash equivalents at the time of the acquisition. This item is reported outside the net cash flow (consists of sections for operating cash flow, investments, and financing) in the reconciliation section for cash balance change.
If the acquired business is recorded as part of a unit that existed already in the consolidation, note that also document series 835 000 entries must be saved for matching unit level reporting (includes other related entries, for example, the equity effect removal, acquisition cost and goodwill).
The same balance data may also be reported in the notes for financial statements relating to the acquisitions. We recommend that only arrangements which should be included in this notes section are saved with this task. For example, document series 850 000 should be used for internal mergers.
First data column of the template includes cumulative balance values of the arrangement from previous period. Input of changes from previous period to the data of the arrangement is entered to the second data column. Cumulative arrangement balances adjusted from the selected periods cash flow statement are calculated in the third column. If selected period is period 1, the previous year closing balances show in the first data column, but they are not included in the cumulative data of selected year. The 4th column is a report column, that shows the unit balance sheet data, which usually is helpful in entering correct arrangement balances.
If there are several input units whose entries you want to save only to one unit, the input sheet can be changed so that all report columns include data of consolidation unit. The change is done by changing the value of <dimension type="dim00"> parameter. By default, the value is %PARENT_0%, which means that the data in report columns is retrieved from input unit level. In the following example if you change the value for example to %PARENT_1% the reporting data is retrieved from 100 German Entity Total level, but the adjustments can be saved only to one input unit.
Balance Sheet of Disposed Company (840 000)
Files: P_INP_1PER_840.xml / P_INPUT_1PERIOD_CFARRS.xlsx / UI_P_INP_1PER_840.xml
This input template is used to enter balance sheet data of a disposed unit or business at the time of the disposal. The data is saved to document series 840 000.
The data is included in the cash flow statement reports in order to remove the change in balance items caused by the disposal. In other words, the cash flows, for example, a change in net working capital consist of the change in the balance value until the disposal.
In cash flow reporting of the disposed unit, the net cash flow relating to the disposal consists of only the cash and cash equivalents at the time of the disposal. This item is reported outside the net cash flow (consists of sections for operating cash flow, investments, and financing) in the reconciliation section for cash balance change.
If the disposed business was recorded as part of a unit that still exists in the consolidation, note that also document series 845 000 entries must be saved for matching unit level reporting (includes other relating entries, for example, the equity effect removal and sales prize).
The same balance data may also be reported in the notes for financial statements relating to the disposals. We recommend that only arrangements which should be included in this notes section are saved with this task. For example, document series 850 000 should be used for internal mergers.
First data column of the template includes cumulative balance values of the arrangement from previous period. Input of changes from previous period to the data of the arrangement is entered to the second data column. Cumulative arrangement balances adjusted from the selected periods cash flow statement are calculated in the third column. If selected period is period 1, the previous year closing balances show in the first data column, but they are not included in the cumulative data of selected year. The 4th column is a report column, that shows the unit balance sheet data, which usually is helpful in entering correct arrangement balances.
If there are several input units whose entries you want to save only to one unit, the input sheet can be changed so that all report columns include data of consolidation unit. The change is done by changing the value of <dimension type="dim00"> parameter. By default, the value is %PARENT_0%, which means that the data in report columns is retrieved from input unit level. In the following example if you change the value for example to %PARENT_1% the reporting data is retrieved from 100 German Entity Total level, but the adjustments can be saved only to one input unit.
Balance Sheet Items of Other Company Arrangements (850 000)
P_INP_1PER_850.xml / P_INPUT_1PERIOD_CFARRS.xlsx/ UI_P_INP_1PER_850.xml
This input template is used to enter balance sheet data for other company arrangements (included in the cash flow statement). The data is saved for document series 850 000.
Enter new balance items as positive amounts and decreases as negative amounts. For example, when a subsidiary is merged with the parent company:
Enter the balance of the subsidiary at the time of the merger as negative figures (decreases from the point of view of the subsidiary).
-
Enter the balance of the parent company as new items (positive figures).
First data column of the template includes cumulative balance values of the arrangement from previous period. Input of changes from previous period to the data of the arrangement is entered to the second data column. Cumulative arrangement balances adjusted from the selected periods cash flow statement are calculated in the third column. If selected period is period 1, the previous year closing balances show in the first data column, but they are not included in the cumulative data of selected year. The 4th column is a report column, that shows the unit balance sheet data, which usually is helpful in entering correct arrangement balances.
If there are several input units whose entries you want to save only to one unit, the input sheet can be changed so that all report columns include data of consolidation unit. The change is done by changing the value of <dimension type="dim00"> parameter. By default, the value is %PARENT_0%, which means that the data in report columns is retrieved from input unit level. In the following example if you change the value for example to %PARENT_1% the reporting data is retrieved from 100 German Entity Total level, but the adjustments can be saved only to one input unit.
Change in Ownership, Proportional Consolidation, Adjustments to CF (860 000)
Files: P_INP_1PER_860_PROC.xml / P_INPUT_108.xslx / UI_P_INP_1PER_860_PROC.xml
The entries to cash and cash equivalents of cash flow relate to consolidation method, but show on company reports on cash balances reconciliation. Otherwise the company level cash flows are reportable on a period when the percentage has changed.
This input template is used in case of change in ownership in a proportional consolidation unit. This sheet saves the adjustment to cash and cash equivalents (SUM3186P) arising from changes in ownership in proportional consolidation to Document series 850 000 (Other arrangements). Before saving this template you must:
define a new percentage of ownership/consolidation to unit
excecute Input Data Calculation to cash flow opening documents.
After these steps amounts are shown in change-column (H). If the input sheet is not saved, note of this shows on the header rows.
The figures to be recorded shall be retrieved for the off-balance-sheet sub-accounts in column H using the formulas; therefore, they will appear in the column even if the template is not saved. If the template is not saved, a message is displayed in cell H1. The text is deleted when the template is saved and the Refresh function is performed after saving.
Group Elimination Adjustments for Acquired Company (835 000)
Files: P_CFARRS_DIM01_IT702.xml / DIM01_input70000 all periods.xlsx / UI_P_CFARRS_DIM01_IT702_835.xml
This input template is used to enter group elimination adjustments for an acquired company (included in the cash flow statement). The data is saved for document series 835 000.
Input currency is the input currency of the unit of each row. If you enter several currencies in same document, save and refresh to check that the entries in group currency are "in balance" in columns W to AI (debit=credit).
For acquisition or new entries due to other arrangements, enter reverse signs compared to period closing.
The items to enter include, for example, the following:
Acquisition cost
Equity eliminations at the date of acquisition
Goodwill and other allocations recorded at acquisition
Reversal of appropriations at the date of acquisition
Group Elimination Adjustments for Disposed Company (845 000)
Files: P_CFARRS_DIM01_IT702.xml/ DIM01_input70000 all periods.xlsx / UI_P_CFARRS_DIM01_IT702_845.xml
This input template is used to enter group elimination adjustments for a disposed company (included in the cash flow statement). The data is saved for document series 845 000.
Input currency is the input currency of the unit of each row. If you enter several currencies in same document, save and refresh to check that the entries in group currency are "in balance" in columns W to AI (debit=credit).
For disposals or other removals, use the signs used for eliminations before disposal which no longer exist in consolidation.
The items to enter include, for example, the following:
Historical acquisition cost
Equity eliminations at the date of disposal
Remaining goodwill and other allocations as at the date of disposal
Reversal of appropriations at the date of disposals
Group Elimination Adjustments for Other Company Arrangements (855 000)
Files: P_CFARRS_DIM01_IT702.xml / DIM01_input70000 all periods.xlsx / UI_P_CFARRS_DIM01_IT702_855.xml
This input template is used to enter group elimination adjustments for other company arrangements (included in the cash flow statement). The data is saved for document series 855 000.
Input currency is the input currency of the unit of each row. If you enter several currencies in same document, save and refresh to check that the entries in group currency are "in balance" in columns W to AI (debit=credit).
For removals, use the signs that would be used if the entries we still made.
For a merger with the group, the items to enter include, for example, the following:
Historical acquisition cost of shares
Equity eliminations at the date of the merger
Merger profit/loss
Group Elimination Adjustments for Change in Ownership, Proportional Consolidation, Adjustments to CF (865 000)
Files P_CFARRS_DIM01_IT702.xml / DIM01_input70000 all periods.xlsx / UI_P_CFARRS_DIM01_IT702_865.xml
This input template is used to enter group elimination adjustments for change in ownership for proportionally consolidated unit (included in the cash flow statement). The data is saved for document series 865 000.
Input currency is the input currency of the unit of each row. If you enter several currencies in same document, save and refresh to check that the entries in group currency are "in balance" in columns W to AI (debit=credit).
For removals, use the signs that would be used if the entries we still made.
Reports, Cash Flow
Consolidated Statement of Cash Flows, Direct Method
Files: P_REP_510000.xml / P_REP_510000.xlsx / UI_P_REP_510000.xml
This report shows the consolidated cash flow, direct method, for the selected active period, year, and data type. The cumulative cash flow of the corresponding period (second column) and the cumulative cash flow to the end of year (third column) of the previous year are shown for reference.
The group currency is the default reporting currency.
Consolidated Statement Of Cash Flows, Indirect method
Files: P_REP_520000.xml / P_REP_520000.xlsx / UI_P_REP_520000.xml
This report shows the consolidated cash flow, indirect method, for the selected active period, year, and data type. The cumulative cash flow of the corresponding period (second column) and the cumulative cash flow to the end of year (third column) of the previous year are shown for reference.
The group currency is the default reporting currency.
Consolidated Statement of Cash Flows by Unit, Direct Method
Files: P_REP_510000_GEU_BY_UNIT.xml / P_REP_510000_GEU_BY_UNIT.xlsx / UI_P_REP_510000_GEU_BY_UNIT.xml
This report shows the consolidated cash flow, direct method, for the selected active period, year, and data type.
The group currency and cumulative values are used by default in the report.
The report shows the data entered to all entry levels below the selected consolidation level by columns, the total of the selected entry levels (the cash flows and cash flow adjustments of individual units), all group eliminations in one column, and the group total data.
Note that formatting may be lost in the report when a lot of input units are generated.
Consolidated Statement Of Cash Flows By Unit, Indirect Method
Files: P_REP_520000_GEU_BY_UNIT.xml / P_REP_520000_GEU_BY_UNIT.xlsx / UI_P_REP_520000_GEU_BY_UNIT.xml
This report shows the consolidated cash flow, indirect method, for the selected active period, year, and data type.
The group currency and cumulative values are used by default in the report.
The report shows the data entered to all entry levels below the selected consolidation level by columns, the total of the selected entry levels (the cash flows and cash flow adjustments of individual units), all group eliminations in one column, and the group total data.
Note that formatting may be lost in the report when a lot of input units are generated.
Cash Flow Check Report
Files: P_EXAMPLE_REP_CFCHECKP_REPORT_110.xml / P_EXAMPLE_REP_CFCHECKP_REPORT_110.xlsx / UI_P_EXAMPLE_REP_CFCHECKUI_P_REPORT_110.xml
This report is a group report for checking and analyzing the results of cash flow adjustments.
The report includes the same rows and row sets (indirect and direct) as the cash flow statement, as well as the reconciliation of the opening and closing cash flows and the cash flow statement in total.
The first column shows the reported cash flow and the following columns show the first column divided into different document series: the opening balance, income statement and balance sheet, and different adjustments. The opening balance columns (D-E) are hidden by default.
The data is retrieved from the selected period to all columns, excluding the opening balance with opening balance rates.
The second sheet of the report shows the effect of group elimination documents on cash flow: the first column shows the total group eliminations as in the Consolidated Statement of Cash Flows by Unit report, the following columns break down the cash flow effect by type of elimination.