Income Statement and Financial Position
Input
Input IS and BS, Cum 1 Period (10 000 and 20 000)
Files: P_INPUT_101.xml / P_INPUT_101.xlsx / UI_P_INPUT_101.xml
This template is used for entering 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.
Tip: You can filter the rows shown on the template using different row sets.
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.
IFRS 18: Input All Selected Accounts, 1 period (10 000 and 20 000)
Files: IFRS18_INP_1PER_10_20 / IFRS18_INP_1PERIOD.xlsx / UI_IFRS18_INP_1PER_10_20
This template is used for entering 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.
Tip: You can filter the rows shown on the template using different row sets.
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 accounts.
Adjustments to Company IS and BS, Cum 1 Period (110 000 and 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 18: Input All Selected Accounts, 1 period (110 000 and 120 000)
Files: IFRS18_INP_1PER_110_120 / IFRS18_INP_1PERIOD.xlsx / UI_IFRS18_INP_1PER_110_120
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 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.
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 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.
IFRS 18: Input All Selected Accounts, 1 period (310 000 and 320 000)
Files: IFRS18_INP_1PER_310_320 / IFRS18_INP_1PERIOD.xlsx / UI_IFRS18_INP_1PER_310_320
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.
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 figures in the unit currency.
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.
IFRS 18: Company Statement of Financial Performance
Files:
IFRS18_REP_330000_UA / IFRS18_REP_330000.xlsx UI_IFRS18_REP_330000_UA
IFRS18_REP_C_330000_UA / IFRS18_REP_C_330000.xlsx / UI_IFRS18_REP_C_330000_UA
This report shows the comprehensive income for the selected period, year, and data type.
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.
Note: 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.
IFRS 18: All Selected Accounts by Document Series
Files:
IFRS18_REP_BY_DOC_UA / IFRS18_REP_1AREA_BY.xlsx / UI_IFRS18_REP_BY_DOC_UA
IFRS18_REP_BY_DOC_UA / IFRS18_REP_1AREA_BY.xlsx / UI_IFRS18_REP_C_BY_DOC_UA
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.
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.