Income Statement and Financial Position

Input

Input IS and BS, Cum 1 Period (10 000 & 20 000)

Files: P_INPUT_101.xml / P_INPUT_101.xlsx / UI_P_INPUT_101.xml

This template is used for entering cumulative profit and loss and balance sheet data for the selected period. The figures are entered in the unit currency.

The input task basic options are: data type, period, year and unit/dimension. By default, the task opens to data type "Actual".

The same input template is used for document series 10 000 and 20 000. Document series 10 000 is used for financial statement data and document series 20 000 for internal transactions. If there is a dependency between type 1 (10 000) and type 2 (20 000) document series, the data cells of type 1 document series input template are locked for internal accounts. It is recommended that you use only the internal accounts for entering internal transactions.

Enter external data directly to external accounts and to the reporting period columns. To enter data to internal accounts, use the account statement function (drill-down). The default color for the internal account rows in the reporting period columns which cannot be edited is gray, and orange or purple in cells to which data can be entered by drilling down. Note that the total amount on internal account does not update when saving, the total shows only after you refresh or re-open the template.

You can filter the rows shown on the template using different row sets.

FPM_IFRS_img9

If you enter pre-consolidated data to company document series 10 000 (not recommended), the shares from profit & loss and equity must be entered to the non-controlling interest accounts.

Adjustments to Company IS and BS, Cum 1 Period (110 000 & 120 000)

Files: P_INPUT_101B.xml / P_INPUT_101.xlsx / UI_P_INPUT_101B.xml

Document series 110 000 is used, for example, to adjust a unit's financial statement to correspond to the group's consolidated accounting principles. Document series 120 000 is used for internal transactions related to document series 110 000.

When entering data to external and internal accounts, use the same principles as for document series 10 000 and 20 000 (see section Input IS and BS, cum, 1 period, 10 000 & 20 000). Enter cumulative figures in the unit currency.

Figures from document series 10 000, the total unit data of document series 10 000 and 110 000, and the previous annual closing from document series 110 000 are reported as additional information.

IFRS Adjustments to Company IS and BS, Cum 1 Period (310 000 and 320 000)

Files: P_INPUT_101C.xml / P_INPUT_101.xlsx / UI_P_INPUT_101C.xml

Document series 310 000 is used for adding IFRS adjustments to financial statements.

Document series 320 000 is used for internal transactions related to document series 310 000.

Figures from document series 10 000 and 110 000, the total unit data of document series 10 000, 110 000, and 310 000, and the previous annual closing from document series 310 000 are reported as additional information.

Input of Balance Values of Internal Inventories (40 000)

Files: BW_IT401.xml / BW_IntMargins_Inventories.xlsx / UI_BW_IT401_IFRS.xml

This input template is used by the buyer of an inventory for entering the value of internal inventories each month. The value is saved to document series 40 000. Document series 10 000, 110 000, and 310 000 are included in the template for reference.

The Clausion default template and task definitions are used.

For more information, refer to Entering Values of Internal Inventories (Buyer) in Clausion Input and Report User's Online Help.

Reports

Company Statement of Financial Position

Files: P_REPORT_101B.xml / P_REPORT_101.xlsx / UI_P_REPORT_101B.xml

This report shows the balance sheet for the selected period, year, and data type (first column).

The data of the period from the previous year (second column), change from the previous year (third column) and the cumulative figures from the previous annual closing (fourth column) are shown for reference. The last two columns may be hidden with group functionality.

The document range is defined with the global parameter %FINSTMT_IFRS% for document series selection. Note, that any internal transactions and other adjustments between the cost centers of a company are taken into account, thus it is important to consider which counter unit to use for group-level eliminations and adjustments to avoid them being shown in company-level reporting.

You can change the default options on the Advanced Options tab.

Company Statement of Comprehensive Income

Files: P_REPORT_102B.xml / P_REPORT_102.xlsx / UI_P_REPORT_102B.xml

This report shows the cumulative comprehensive income for the selected period, year, and data type (first column). The data of the period from the previous year (second column)change from the previous year (third column) and the cumulative figures from the previous annual closing (fourth column) are shown for reference. The last two columns may be hidden with group functionality.

Unit currency, cumulative type of data, and global parameter %FINSTMT_IFRS% for document series selections are used by default in the report. Note, that any internal transactions and other adjustments between the cost centers of a company are taken into account, thus it is important to consider which counter unit to use for group-level eliminations and adjustments to avoid them being shown in company-level reporting.

You can change the default options on the Advanced Options tab.

Company Statements, Input Series as Columns

Files: P_REPORT_111D.xml / P_REPORT_111.xlsx / UI_P_REPORT_111D.xml

This report shows the data entered to input series as columns. Unit currency, cumulative type of data and the global parameter %FINSTMT_IFRS% is used by default in the report. Note that, usually only the company document series (10 000, 110 000, 310 000, 510 000 and 410 000) contain data for which the counter unit is the same unit, and therefore the other document series are not shown. You can change the default options on the Advanced Options tab.

If both the 310 000 and 410 000 document series are used in the IFRS Package, the total does not represent neither the IFRS or FAS data for the company. By default, only the 310 000 document series is included in the company's reports.

Reconciliation for Internal Transactions with Counter Units

Files: BW_RT103.xml / BW_ReconciliationReport.xlsx / UI_BW_RT103_IFRS_AllInternal.xml and UI_BW_RT103_FAS_AllInternal.xml

The report is as the Reconciliation report for internal transactions report with the difference that only document series 20 000, 120 000 and 320 000 are selected. Also All internal transactions for unit is selected by default so it is possible to compare selected unit's internal transactions to counter units entries.