Basic Input Template, 1 Period (10 000)

Used for input unit level data, for example reported Profit and Loss and Balance sheet data. For instructions, refer to Entering Basic Unit Data in Clausion Input and Report User’s Online Help.

If the Advanced Options tab is enabled, you can change the Document Series, Scaling factor and Type of Data options (Periodical or Cumulative). Only one document series must be selected. Other options have no effect even if they are enabled in the task definitions.

Basic Input Template, All Periods (10 000)

Used for input unit level data, for example reported Profit and Loss and Balance sheet data. For more information about using the template, refer to Entering Basic Unit Data in Clausion Input and Report User’s Online Help.

If the Advanced Options tab is enabled, you can change the Document Series, Scaling factor and Type of Data options (Periodical or Cumulative). Only one document series must be selected. Other options have no effect even if they are enabled in the task definitions.

Internal Transactions, 1 Period (20 000)

Used for entering intragroup or inter-company transactions (internal transactions) by units (to an organization unit and its counter unit). For more information about using the template, refer to Entering Internal Transactions by Units in Clausion Input and Report User’s Online Help.

If the Advanced Options tab is enabled, you can change the Document Series, Scaling factor and Type of Data options (Periodical or Cumulative). Only one document series must be selected. Other options have no effect even if they are enabled in the task definitions.

Internal Transactions, Periods 0–12 (20 000)

Used for entering intragroup or inter-company items (internal transactions) by units (to an organization unit and its counter unit). For more information about using the template, refer to Entering Internal Transactions by Units in Clausion Input and Report User’s Online Help.

If the Advanced Options tab is enabled, you can change the Document Series, Scaling factor and Type of Data options (Periodical or Cumulative). Only one document series must be selected. Other options have no effect even if they are enabled in the task definitions.

Basic Input, Internal Transactions by Drill-down, 1 Period (10 000 & 20 000)

Used for entering intragroup or inter-company items (internal transactions) by using the account drill-down function. For more information about using the template, refer to Entering Internal Transactions Using Account Drill-Down in Clausion Input and Report User’s Online Help.

If the Advanced Options tab is enabled, you can change the Scaling factor and Type of Data options (Periodical or Cumulative). Other options have no effect even if they are enabled in the task definitions.

Consolidation Entries (30 000)

This template is used for viewing automatic consolidation entries relating to the selected unit. Consolidation entries may be those for non-controlling interest or for proportional consolidation. Type of entries created depends on the unit settings.

If the Advanced Options tab is enabled, you can change the Document Series, Scaling factor and Type of Data options (Periodical or Cumulative). Only one document series must be selected. Other options have no effect even if they are enabled in the task definitions.

Input of Balance Values of Internal Inventories (40 000)

Used for entering the balance values of internal inventories. For more information about using the template, refer to Entering Values of Internal Inventories (Buyer) in Clausion Input and Report User's Online Help.

Document series must be selected for the comparison column and the Show all drill-down input rows option must be in use. To use this template, an input level unit must be selected. The default template includes Clausion FAS/IFRS Package inventory accounts. To add or remove accounts, create own copy of the template and make changes to the spreadsheet (xlsx) file (account codes in column A).

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

Used for adding the margin and tax percents for internal margins in inventories.

Calculation of elimination entries based on the input is automated for series type 4. To use this template, the user must have 'write' rights to the buyer unit. A period does not need to be selected, because all periods are generated. The default template includes Clausion FAS/IFRS Package inventory accounts. To add or remove accounts, create own copy of the template and make changes to the xml definition file account generation (the account codes listing).

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

Used for entering internal margins in non-current assets. Internal margins that are activated in the balances of group enterprises are subtracted when compiling the group balance from their corresponding items and equity. The change in internal margins is eliminated from the financial year revenue. Internal margins and their fluctuations are entirely eliminated, independent of the group share in the enterprise that has disposed of or received goods with internal margins.

A task with the ID CardSheet can only have a type 6 document series as the value for the voucher component.

[v24.05 and later:] In Web Client, parallel versions of the template exist which can be utilized alternatively in environments where card entries are allocated to the units of dimension 01 or where conversion method is Unit currency * currency rate. [v24.05 and latercontent ends]

Note that unnecessary modifications to the template should be avoided as a modified template may not function correctly in all situations. If you need to customize the template, remember to take a copy of the original. For information about the XML definitions of the template, refer to Clausion Input and Report Template Parameters.

[v24.05 and later:] When the selected template and the datatype's currency table have the same conversion method, either Unit currency / currency rate or Unit currency * currency rate, the basic data calculations for the template are correct. [v24.05 and latercontent ends]

[v24.04 and earlier:] Calculations for the basic data of the template are performed correctly only for data types which use a currency table with conversion method Unit currency / currency rate. If Unit currency * currency rate is used, the template must be customized. [v24.04 and earliercontent ends]

Eliminations of Equity Investments (60 000)

Used for entering and managing subsidiary ownerships and changes in them. An elimination of equity investments document is created when the subsidiary is formed, that is, when the group has acquired a share that gives them control over the entity (the ownership usually being at least 50%).

A task with the ID CardSheet can only have a type 6 document series as the value for the voucher component.

[v24.05 and later:] In Web Client, parallel versions of the template exist which can be utilized alternatively in environments where card entries are allocated to the units of dimension 01 or where conversion method is Unit currency * currency rate. [v24.05 and latercontent ends]

Note that unnecessary modifications to the template should be avoided as a modified template may not function correctly in all situations. If you need to customize the template, remember to take a copy of the original. For information about the XML definitions of the template, refer to Clausion Input and Report Template Parameters.

[v24.05 and later:] When the selected template and the datatype's currency table have the same conversion method, either Unit currency / currency rate or Unit currency * currency rate, the basic data calculations for the template are correct. [v24.05 and latercontent ends]

[v24.04 and earlier:] Calculations for the basic data of the template are performed correctly only for data types which use a currency table with conversion method Unit currency / currency rate. If Unit currency * currency rate is used, the template must be customized. [v24.04 and earliercontent ends]

Other Entries, 1 Period (70 000)

Used for entering elimination rows that are not created with the internal transactions input, equity elimination, or margins templates (for example, elimination entries from merger revenues).

Otherwise use the same user interface task definitions as for Basic input template except remove settings for the dimension component and add settings for the voucher component using the desired document series as value (default task: 70000).

Other Entries, Periods 0–12 (70 000)

Basic Report, All Periods

All options on the Advanced Options tab can be used. In the User Interface Management, add the 'showadvanced' setting with value 'yes' to the task (no component definitions are needed).

Internal Transaction Reconciliation Report

The user interface task requires the parameter setting value=yes for the 'allentriesallocated' component. To enable reporting all entries when either the unit or the counter unit is the selected unit (or sub-unit), set value=yes for the 'allinternaltransactions' component.

Unit and counter unit generation in each sheet includes xml element "Groupby". Add definitions for these in the local report copy if you want to reconcile internal transactions on consolidated levels. Add the same definition to each sheet, to both unit and counter unit. In UI management, an applicable example for parameters is available to add.

By default, the data includes only series 20000 and 23000 (can be changed in Advanced Options).

Internal Inventories and Margins Used for Eliminations

Used with document series type 4. The default template includes Clausion FAS/IFRS Package inventory accounts. To add or remove accounts, create own copy of the template and make changes to the xml definition file account generation (the account codes listing).

General Ledger

To view the data by document number, position and input type, drill down to the data from the report.

Journal Ledger

Recommended for type 6 and 7 document series. To view the data by position and input type, drill down to the data from the report. On report sheet Filtered, end user account selections is used for filtering accounts. This sheet does not include calculated entries (usually include result shown in balance sheet).

Journal Ledger with Subtotals by Unit

Drill-Down Template

BW_Drilldown default.xlsx

Drill-Down Cumulative (TR) Template

BW_TR cumulative.xlsx

Drill-Down Periodic (TR) Template

Parameters

Used for managing environment and global parameters. See the template for instructions.

Language, All Users

Used for setting the default language for all system users. See the template for instructions.

Changing of user interface language requires restarting the Clausion client application.

Language

Used by end users to change their personal user interface language. See the template for instructions.

Period Locking for Roles

Used for locking periods for the different roles in the system. See the template for instructions.

User Role Order

Used for defining the order in which roles are shown in the user interface for users who have several roles. See the template for instructions.

Sum Row Calculation

Used for running sum row calculations. See the template for instructions.

Currencies

Environment Configuration

Saving this template enables users to view, for example, the account chart and units in Excel.

Dimension Codes

Used for adding dimensions and hierarchy settings. For instructions, see Adding Dimensions.

Document Series

Used for adding document series to the system. See the template for instructions.

Period Start and End Dates

Used for adding the start and end dates for the periods separately for each year. The period dates are used on almost all reports.

Rate Difference Entries (ARD)

Used for managing automatic rate difference definitions. For instructions, see Automatic Rate Difference Definitions.

Calculated Accounts (ACA)

Used for managing automatic calculated account definitions. For instructions, see Automatic Calculated Account Definitions.

Non-Controlling Interest (NCI)

Used for managing automatic non-controlling interest entry definitions. For instructions, see Automatic NCI Entry Definitions.

Proportional Consolidation (PROC)

Used for managing proportional consolidation definitions. For instructions, see Proportional Consolidation Definitions.

The proportional consolidation definitions contain only the opening balance type accounts for which the target account for change in ownership needs to be defined. For all other accounts not included in these definitions, the default calculation is applied (the calculated entry is recorded to the input account).

Internal Margins in Inventories (INV)

SSIS Runs

Used for executing SSIS runs. For instructions, see Executing SSIS Runs.

Input Data Calculations (IDC) Status

Used for monitoring the status of input data calculations. For instructions, see Data Calculations on Server Side.

Internal Data Transfers (IDT) Status

Used for monitoring the status of internal data transfer runs. For instructions, see Monitoring IDT Status under Internal Data Transfer (IDT) section.

Input Template Calculations (ITC) Status

Input, 3 Dimensions

Used in this manual to illustrate how input template and report template definitions differ.

Input, One Column Generation

Used in this manual to illustrate column generation of a single column.

Input, Set of Columns Generation

Used in this manual to illustrate column generation of a set of columns.

Simple Report

Used in this manual to illustrate the definitions of basic features of a template.

Language Translations

Used in this manual to illustrate the use of language translations in templates.

Static Row Generation

Used in this manual to illustrate generation of rows to a template.

Shows combinations of regions (dim01) and accounts.

Dynamic & Static Row Generation

Used in this manual to illustrate the difference between static and dynamic row generation.

Shows combinations of regions (dim01) and accounts.

Dynamic Row Generation, 2 Dimensions

Used in this manual to illustrate reporting the breakdown of a company's sales by segments (dim00) and regions (dim01).

Dynamic row generation over 2 dimensions.

Row Generation, 3 Dimensions

Used in this manual to illustrate generation of more than 2 dimensions on rows.

Shows a set of accounts broken down by segments (dim00) and regions (dim01) of a company.

Report, Block Headers

Used in this manual to illustrate how to make a generated report easier to read.

Shows row generation over 3 dimensions with block headers.

Report, Multiple Areas

Used in this manual to illustrate how to make a template with multiple areas on the same sheet.

Report, Multiple Sheets