Income Statement and Balance Sheet

Please note that the content on the images may differ from the content in your package due to package localization.

Eliminations

Non-controlling Interests 1+12 Periods (30 000)

Files: P_IT302.xml / P_IT302.xlsx / UI_P_DIM01_IT302.xml

This is a task and template for consolidation (non-controlling interest and proportional consolidation) entries are used. For more information, refer to Automatic Non-Controlling Interest Entries(NCI) in Clausion Input and Report User's Online Help.

Reversal of Untaxed Reserves (32 000)

Files: P_INP_ELIM_TAXBPROVS.xml / P_INP_ELIM_TAXBPROVS.xlsx / UI_P_INP_ELIM_TAXBPROVS.xml

This input sheet calculates entries (based on company's to IS and BS), which are needed to record all the reversals of reserves into equity and deferred tax liability. The template includes formulas that calculate the entries to be made by the input unit. By saving the template, these entries are saved. By running the input sheet calculation for the template, it is possible to save the entries for all group companies at once (other alternative is open the template and save it manually). Entries are saved to document series 32 000. The counter unit for the entries is the one the admin has set to CODIM00UNIT_TAXBASEDPROVISION - global parameter, and it must be within the reported consolidated level.

Note that separate template is needed for each reported consolidated level if several exist in the same database. In each template set the required counter unit code (or new global parameter you have created) as dimensionudid value of dimension (codim00) in settings of all relevant datacolumns. Tip: use search (codim00) to find all relevant columns.

The sheet takes also into account changes in tax and consolidation percentages. The unit currency and cumulative type of data are used by default.

Reversal of Untaxed Reserves1+12 Periods (32 000)

Files: DIM01_IT702.xml / DIM01_input70000 all periods.xlsx / UI_P_DIM01_IT702_32000.xml

This input template is a copy of the Clausion default template and functions similarly to the input template for document series 70 000 1+12 periods input sheet, except that the entries are saved to document series 32 000. The template may be used for manually adjusting the entries made by the on period task/template dedicated for the same document series.

Input of Margin and Tax Rates for Internal Margins in Inventories (40 000)

Files: BW_IT402.xml / BW_IntMargins_Inventories_margins.xlsx / UI_P_EXAMPLE_INP_IT402.xml

The Clausion default template is used for entering the internal margins and tax percentages by asset account-seller-buyer combination. The margin percentage may change periodically, but typically the same percentage is used for the year or quarter.

The consolidator must gather the margin information, for example through e-mail as the seller unit does not have access to this input template (unless the seller also has 'write' access to the buyer unit).

Values for Tax percent opening period, Tax percent active period, margin percent opening period, and Inventory value opening period are transferred in Opening Balance Transfer. If the tax percent for active period has been changed manually and the opening balance transfer is repeated, the changed tax percent is over-written and has to be changed again.

For more information, refer to Saving Margin and Tax Percents (Seller) in Clausion Input and Report User's Online Help.

Eliminations of Internal Margins in Non-current Assets (50 000)

Files: BW_IT501.xml / BW_IntMargins_NCassets.xlsx / UI_BW_IT501.xml

DIM01_IT501.xml / DIM01_IntMargins_NCassets.xlsx / UI_P_DIM01_IT501 or DIM01_MLP_IT501.xml / DIM01_MLP_IntMargins_NCassets.xlsx / UI_P_DIM01_MLP_IT501

This template is used for eliminating changes in internal margins. There are three different options to select from depending on whether you use dimension 1 values in the eliminations and the selected currency conversion. Note that the currency conversion method must be the same for currency tables and this template. For more information, see Card Functionalities – Eliminations of Equity Investments and Internal Margins in Non-Current Assets in Clausion Input and Report User's Online Help and Monitoring IDT Status in Administrator's Online Help.

Eliminations of Equity Investments (60 000)

Files: BW_IT601.xml / BW_MutualShareholdings.xlsx / UI_BW_IT601.xml

DIM01_IT601.xml / DIM01_MutualShareholdings.xlsx / UI_P_DIM01_IT601

BW_DIM01_MLP_IT601 / DIM01_MLP_MutualShareholdings.xlsx /DIM01_MLP_IT601 /

This template is used to enter and manage subsidiary ownerships and changes in them. There are three different options to select from depending on whether you use dimension 1 values in the eliminations and the selected currency conversion. Note that the currency conversion method must be the same for currency tables and this template. For more information, see Card Functionalities – Eliminations of Equity Investments and Internal Margins in Non-Current Assets in Clausion Input and Report User's Online Help and Monitoring IDT Status in Administrator's Online Help.

Other Entries, Fixed 1+12 Periods (70 000)

Files: DIM01_IT702.xml / DIM01_input70000 all periods.xlsx / UI_P_DIM01_IT702.xml

This is a default Clausion template that is used for entering data for all periods (0-12) at the same time.

Other entries are always entered in the unit currency and as cumulative data.

If you have transferred the opening balances from the previous year and the data is valid without any changes for the reporting period, you need to save the data on the input template for every reporting period after the exchange rates have been entered. This is required for currency amounts to be converted correctly to group currency and for automatic calculation for translation differences.

Investments Accounted for Using the Equity Method 1+12 Periods (80 000)

Files: DIM01_IT702.xml / DIM01_input70000 all periods.xlsx / UI_P_DIM01_IT702_80000.xml

This input template is used for entering consolidation entries of entities consolidated by equity method for all periods (0-12) at the same time.

The template is a copy of the Clausion default template and functions similarly to the input template for document series 70 000 1+12 input sheet, except that the entries are saved to document series 80 000.

Check Reports

All Selected Accounts by Unit

P_EXAMPLE_REP_GEU_BY_UNIT.xml /P_EXAMPLE_REP_GEU_BY_UNIT.xlsx / UI_P_EXAMPLE_REP_GEU_BY_UNIT.xml

All income and balance accounts in the default hierarchy are generated. Sum level accounts are formatted with bold.

The report is classified as a consolidated/group-level report, and the level you select from the organisation hierarchy should be a consolidation level. Note that by default only those eliminations are taken into account in which both the unit and the counter unit are under the selected consolidation level. If you want to include all entries allocated to the selected organisation unit regardless of what the counter unit of the entry is, select the All entries allocated to unit option for the report.

All Selected Accounts by Unit, Unit Data in Input Currency

Files: P_EXAMPLE_REP_GEU_BY_UNIT_UA.xml / P_EXAMPLE_REP_1AREA_BY.xlsx / UI_P_EXAMPLE_REP_GEU_BY_UNIT_UA

This report includes the same columns as the All Selected Accounts by Unit report. All income and balance accounts in the default hierarchy are generated.

This report shows the data entered to all entry levels below the selected consolidation level by columns in unit currency, so that each unit reconciles in its own input currency. Unit currency must be chosen on the Advanced Options tab. Units total, eliminations and group total are reported in group currency by default.

For group levels where currency is other than group currency, you can change the currency used in columns for group total, eliminations, companies total, on the Advanced Options tab.

Note that when currency selection is other than group currency, unit data is still reported in unit currency and translation differences are shown only in companies total, eliminations and group total columns.

All Selected Accounts by Document Series

Files: P_EXAMPLE_REP_BY_DOC.xml / P_EXAMPLE_REP_BY_DOC.xlsx / UI_P_EXAMPLE_REP_BY_DOC.xml

The report generates all sub accounts of the selected sum account(s). By default, account and balance sheet accounts are selected. The columns are generated with the document information defined on the Advanced options tab. By default, FINSTMT global parameter documents have been selected. These default values are defined in the user interface task.

The sum rows in the report's workbook are highlighted by conditional formatting. Conditional formatting accounts are retrieved from the database dynamically when the report is opened, meaning that the report can be used with all data types.

All Selected Accounts by DIM01 Value

Files P_EXAMPLE_REP_BY_DIM.xml / P_EXAMPLE_REP_1AREA_BY.xlsx / UI_P_EXAMPLE_REP_BY_DIM

The report generates all sub accounts of the selected sum account(s). By default, account and balance sheet accounts are selected. The columns are generated with dimension 1 input units defined on the Advanced options tab.

The report is classified as a consolidated/group-level report, and the level you select from the organisation hierarchy should be a consolidation level. Note that by default only those eliminations are taken into account in which both the unit and the counter unit are under the selected consolidation level. If you want to include all entries allocated to the selected organisation unit regardless of what the counter unit of the entry is, select the All entries allocated to unit option for the report.

Continuity Check by Unit and Document Series

P_EXAMPLE_REP_NEXT1_BY_UNIT.xml / P_EXAMPLE_REP_NEXT1_BY_UNIT.xlsx / UI_P_EXAMPLE_REP_NEXT1_BY_UNIT.xml

The report presents changes in equity by reserve; non-current assets by asset group, and changes in loan accounts summarised by loan group and notes accounts on the first tab (Sheet1) by unit and on the second tab (Sheet2) by document series. At the top of the report, before the reserve-specific review, there is a summary of equity continuity. The information is cumulative and reported in the Group's currency. In the default presentation, all entries are allocated to units.

If 'all entries allocated to unit' selection is removed, the selected unit data (first columns) shows the same data as in the corresponding changes and continuity report with that tasks default selections. Also the generated unit columns now do not include elimination entries, where counter unit is not the same unit. With changing the document series selection, it is possible to report e.g. only the series that always are allocated to the unit level. Removing all entries allocated selection is logical for viewing by document series especially, when report is opened from sub-group level and user does not want to see eliminations, when their counter unit is not part of the sub-group.

The first data column shows the amounts for the end of the previous year, the second data column shows the opening amounts for the selected year and in the third data column presents the amounts for the selected period.

The fourth data column has two control formulas for continuity analysis:

The first formula compares the ending balance of the previous financial year (1st data column: period 12 / %YEAR CODE -1%) and the opening amount of the selected year (2nd data column: period 0 / %YEAR CODE%).
The second formula compares the opening amount of the selected year (2nd data column: period 0 / %YEAR CODE%) and the opening amount of the selected period (3rd data column: %PERIOD CODE% / % YEAR CODE%).

By default, columns show the document series of the FINSTMT parameter. The default value for document series as well as selection of allocating all entries to units are defined in the task's user interface definition and can be changed on the Advanced tab.

Sheet1: by unit

Sheet2: by document serie

By default, the report opens with "Basic" row set. If you want to only analyse some of the groups, select different options in the row set.

Note that formatting may not work correctly with all columns when generating a lot of feeder units.

Reconciliation Report for Internal Transactions

Files: BW_RT103.xml / BW_ReconciliationReport.xlsx / UI_P_RT103_GROUP.xml

This report includes 4 sheets for checking from different angles how the input internal transactions reconcile, and whether they require adjusting.

The first sheet shows totals by unit pairs for selected and previous period. To view units' input rows click plus sign on the left from unit pair total row.
The report opens on the second sheet by default, where totals are shown by account group. It is possible to reconcile account group totals to reconciliation accounts' consolidated data. Opening the row grouping shows difference within the account group by unit pair, leaving the input row level as the next level. Data columns in this sheet include input data in selected currency and in input currency.
The third sheet shows by default the same unit pair totals as the first sheet, but opening the row grouping shows also account group totals by unit pair. Opening the next level show input level data rows.
The last sheet shows the internal transactions by unit pairs and by account groups, all periods of the active year.

By default, all entries are included where unit and counter unit are within the selected (consolidated level) unit. The report includes internal transactions from the input account level from document series 20 000 and 23 000 . The data is cumulative.

The internal transactions by unit pairs are shown by account groups (for more information about account groups, see Clausion Administrator's Online Help). Also external accounts are shown on the report according to the account groups they are connected to.

When the opening balance transfer is done for the active year, the closing balance from period 12 of the previous year is shown as the opening balance for period 0 for the active year also for document series 20 000.

The same signs are used as in accounting. Note that intragroup notes accounts (e.g. loan changes) are shown only on the last sheet of the reconciliation report.

If the internal transactions of a unit need to be adjusted due to reconciliation, the adjustments must be done to the intragroup document series 20 000 in the unit's income statement and balance sheet. Also it is possible to leave the difference on reconciliation account, and also change place of the reconciliation difference in Financial statements by Other Eliminations task using "Transfer of reconciliation" accounts.

Account 236980P Profit/loss for the period is not shown on the report, because the input type calculated is not retrieved.

Internal Inventories and Margins Used for Eliminations

Files: BW_RT401 / BW_IntMargins_report.xlsx / UI_BW_RT401.xml

Default Clausion report for viewing all data entered for the elimination of internal margins in inventories (amount, margin percent, and tax percent).

Untaxed Reserves

P_REP_ELIM_TAXBPROVS.xml / P_REP_ELIM_TAXBPROVS.xlsx / UI_P_REP_ELIM_TAXBPROVS.xml

This report is used for checking the saved entries and to verify that the reversals of untaxed reserves have been recorded according to latest actuals.

The report shows the data made by input unit, calculated reversal entries and compares them to the elimination entries.The report generates all input units under the selected consolidation level. The data is reported in the unit currency, and the type of data is cumulative.

The first column (D) shows the opening amounts from the period 0, the second column (E) amounts from the the end of the period, and the third (F) calculated entries based on input unit's financial statements. The column G and H shows the saved data from the elimination inputs. The check column (I) compares columns F and H and shows the possible differences between calculated entries and eliminations.

When there is a difference between calculated entries and eliminations, check if changes have been made to units after saving eliminations. Then, save the elimination sheet again in order to correct the entries.

The following table describes the calculation of entries (column F):

Row	Calculation
990600P Change in deferred tax liability	Tax % * change in P/L (cumulative accelerated depreciation and provisions) + change in the opening amount of deferred tax liability due to change in tax percent.
980000P Change in excess depreciation	Change of cumulative accelerated depreciation recognised in document series 10 000, 30 000
980100P Other appropriations	Change of tax-based provisions recognised in document series 10 000, 30 000
995000PNon-controlling interests	Non-controlling interests based on change in P/L. Non-controlling interests is calculated when 'Full consolidation' is defined as consolidation method of the unit.
230100P Earnings at beginning of period	Previous year's share of accumulated excess depreciation and provisions, tax and consolidation percents are retrieved from period 0 (like in the end of previous year)
230930P Earnings, Acquisition and disposal of subsidiary	Change due to change in ownership. In the elimination of equity investment, the sum must be added to the equity at the time of acquisition.
239100P Non-controlling interests at beginning of period	The opening amount of Non-controlling interests is calculated from the amount of excess depreciation and untaxed reserves accumulated before reporting year; tax and consolidation percents are retrieved from period 0.
239930P P Non-controlling interests, Acquisition and disposal of subsidiary	The balance of account 230930P with the opposite sign.
239980P Non-controlling interests, profit for the period	The balance of account 995000P with the opposite sign.
240000PAccumulated excess depreciation	Accumulated excess depreciation recognised in document series 10 000, 30 000 with the opposite sign.
245000P Other untaxed reserves	Tax-based provisions recognised in document series 10 000, 30 000 with the opposite sign.
260010P Deferred tax liability, opening amount	Deferred tax liability of accumulated excess depreciation and other untaxed reserves accumulated before reporting year; tax and consolidation percents are retrieved from period 0.
260076P Deferred tax liability, Change in ownership, proportional consolidation	Change in deferred tax liability due to change in ownership in proportional consolidation.
260040P Deferred tax liability, period change through profit/loss	The balance of account 990600P with the opposite sign.

Not Completely Eliminated Internal Transactions due to Proportional Consolidation

Files: P_REP_1020.xml / P_REP_1020.xlxs / UI_P_REP_1020.xml

This report shows the total of uneliminated amounts in internal accounts due to proportional consolidation. With this report it is possible to check which items are left and reconcile the balance. The items are shown in unit counter unit level and also the consolidation percentages are shown, so it is easy to verify, that the correct percentage has been used for the elimination correction in series type 23. For unit pairs in which one of the units is consolidated with the proportional consolidation method, the elimination is calculated using the consolidation percentage of the proportionally consolidated unit. If both units of the unit pair are proportionally consolidated, the elimination is calculated according to the lower consolidation percentage.

The report includes internal transactions from the input account level from document serie 20 000 . Note that also internal transactions entered to normal accounts are also shown in the report.

By default the type of data is cumulative and account selection is CALC010P.

Reports

Consolidated Statement of Financial Position

Files:P_EXAMPLE_REP_210000.xml / P_EXAMPLE_REP_210000.xlsx / UI_P_EXAMPLE_REP_210000.xml

This report shows the consolidated balance sheet for the selected period, year, and data type (first column). Data from the corresponding period of 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.

By default, the group currency is the reporting currency, the data type is ACT, the type of data is cumulative, and the document range is defined with the global parameter %FINSTMT%.

The cash flow document series are not included. You can change the default options on the Advanced Options tab.

Consolidated Statement of Comprehensive Income

Files: P_EXAMPLE_REP_320000.xml / P_EXAMPLE_REP_320000.xlsx / UI_P_EXAMPLE_REP_320000.xml

This report shows the consolidated cumulative comprehensive income for the selected period, year, and data type (first column). The data from the corresponding period of 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.

By default, the group currency is the reporting currency, the data type is ACT, the type of data is cumulative, and the document range is defined with the global parameter %FINSTMT_IFRS%.