Files: P_INPUT_05.xml /  P_INPUT_05.xlsx / UI_P_INPUT_05.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 report column, that shows the unit balance sheet data, which usually is helpful in entering correct arrangement balances.

Note! 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.