Basic Input Template, 1 Period (10 000)

BW_IT102.xml

BW_BasicInputsheet.xlsx

InputSheet10000

Admin User > Basic Input and Report Templates > Input

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 Financial Performance Management Input and Report User’s Guide.

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)

BW_IT103.xml

BW_BasicInputsheetAllPeriods.xlsx

InputSheet10000

Admin User > Basic Input and Report Templates > Input

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 Financial Performance Management Input and Report User’s Guide.

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)

BW_IT201.xml

BW_input 20000 series example.xlsx

InputSheet20000

Admin User > Basic Input and Report Templates > Input

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 Financial Performance Management Input and Report User’s Guide.

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)

BW_IT203.xml

BW_input 20000 all periods.xlsx

InputSheet20000

Admin User > Basic Input and Report Templates > Input

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 Financial Performance Management Input and Report User’s Guide.

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)

BW_IT202.xml

BW_InputByDrilling.xlsx

InputSheet10000

Admin User > Basic Input and Report Templates > Input

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 Financial Performance Management Input and Report User’s Guide.

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)

BW_IT301.xml

BW_input 30000 series example.xlsx

InputSheet20000

Admin User > Basic Input and Report Templates > Input

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)

BW_IT401.xml

BW_IntMargins_Inventories.xlsx

InputSheet10000

Admin User > Basic Input and Report Templates > Input

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 Financial Performance Management Input and Report User's Guide.

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)

BW_IT402.xml

BW_IntMargins_Inventories_margins.xlsx

InputSheet40000

Admin User > Basic Input and Report Templates > Input

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)

BW_IT501.xml

BW_IntMargins_NCassets.xlsx

CardSheet

Admin User > Basic Input and Report Templates > Input

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.

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 Financial Performance Management Input and Report Template Parameters.

Note! 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.

Eliminations of Equity Investments (60 000)

BW_IT601.xml

BW_MutualShareholdings.xlsx

CardSheet

Admin User > Basic Input and Report Templates > Input

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.

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 Financial Performance Management Input and Report Template Parameters.

Note! 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.

Other Entries, 1 Period (70 000)

BW_IT701.xml

BW_input 70000 series example.xlsx

InputSheet70000

Admin User > Basic Input and Report Templates > Input

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)

BW_IT702.xml

BW_input70000 all periods.xlsx

InputSheet70000

Admin User > Basic Input and Report Templates > Input

See the description above.

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). Period IDs 0 to 12 have been set for the data columns, therefore this template works as such only in environments that include these period IDs.