Income Statement and Balance Sheet
Input
Input IS and BS, Cum 1 Period (10 000 & 20 000)
Files: P_INPUT_01.xml / P_INPUT_01.xlsx / UI_P_INPUT_01.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.
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 minority accounts.
Adjustments to Company IS and BS, Cum 1 Period (110 000 & 120 000)
Files: P_INPUT_01C.xml / P_INPUT_01.xlsx / UI_P_INPUT_01C.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.
FAS Adjustments to Company IS and BS, Cum 1 Per. (410 000 & 420 000)
Files: P_INPUT_01C.xml, P_INPUT_01.xlsx / UI_P_INPUT_01C.xml
Document series 410 000 is used to adjust a unit's financial statement to correspond to the Finnish Accounting Standards (FAS). Document series 420 000 is used for internal transactions related to document series 410 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, 110 000, the total unit data of document series 10 000, 110 000, and 410 000, and the previous annual closing from document series 410 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_FAS.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 410 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 Income Statement
Files: P_REPORT_01B.xml / P_REPORT_01.xlsx / UI_P_REPORT_01B.xml
This report shows the cumulative income statement for the selected period, year, and data type (first column). Cumulative figures for the period from the previous year (second column), change from previous year (%), and the previous annual closing are shown for reference. Two last columns may be hidden with grouping functionality.
Unit currency, cumulative type of data and the global parameter %FINSTMT_FAS% for document series selection 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 Balance Sheet
Files: P_REPORT_12B.xml / P_REPORT_12.xlsx / UI_P_REPORT_12B.xml
This report shows the balance sheet for the selected period, year, and data type (first column). Figures for the period from the previous year (second column), change from previous year (%), and the previous annual closing are shown for reference. Two last columns may be hidden with grouping functionality.
Unit currency, cumulative type of data, and the global parameter %FINSTMT_FAS% for document series selection 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_02D.xml / P_REPORT_02.xlsx / UI_P_REPORT_02D.xml
This report shows the data entered to input series as columns. Unit currency, cumulative type of data and the global parameter %FINSTMT_FAS% are used by default in the report. Note that, usually only the company document series (10 000, 110 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_FAS_AllInternal_AH0P.xml
The report is as the Reconciliation report for internal transactions report with the difference that only document series 20 000, 120 000 and 420 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.