Skip to main content

Opening Balance

The CONSOLIDATION and ADMINUSER roles have rights for the tasks listed in this section.

Opening Balance Transfer

Files: UI_P_IDT_OpeningBalance.xml

Using the Opening Balance Transfer task, you can transfer the closing balance from period 12 of the previous year (from the selected data type) to period 0 of the selected year as the opening balance. Inventory data (inventory value and margin and tax percents) from period 12 of the previous year is also transferred to the selected year as opening values. If necessary, the transfer can be performed more than once. The accounts of transfer are selected from the account hierarchy Opening Balance (transfer), the default selection is specified in the user interface task.

After the transfer input data calculations are run for the target data automatically.

The default target year for the transfer is the current year (set with the %GLOBAL YEAR% parameter). Note that you need to select the correct source year on the Source Options 1 tab. By default, cumulative figures are transferred (target option: Cumulative), and the cumulative figures of periods starting from 1 do not change.

  • Opening balance account: The cumulative total should remain unchanged for the whole year both in unit and group currency. The periodic data of period 1 is not changed, so if the transfer is executed after input to period 1, the cumulative period 1 amount might require manual adjustment.

  • Other accounts: The cumulative amount of period 1 remains the same after the run.

If you want the cumulative figures of period 1 to change, select the Periodical option on the Target Options tab.

The following conversion tables are used for the opening balance transfer:

  • Account conversion table: Account conversions for opening balance transfer, other than internal transactions (ID: AccountsOpeningBalance, Type: Account)

  • Document series conversion table: Document series conversions for integrating entries of new standards to financial statements, other than internal transactions (ID: DocumentsNewStandards, Type: Document Series)

  • Period conversion table: Period conversion for opening balance transfer (ID: PeriodsOpeningBalance, Type: Period)

For more information about the Internal Data Transfer (IDT) function, refer to Clausion Administrator's Online Help.

Opening Balance Transfer, Internal Items

Files: UI_P_IDT_OpeningBalanceInternals.xml

Using the Opening Balance Transfer, Internal Items task, you can transfer the opening balance for internal items. For more information about opening balance transfer, see Opening Balance Transfer.

A separate transfer task is used for internal transactions because there is no reason to transfer opening retained earnings by unit and counter unit for them (this would cause difficulties in the analysis of the equity).

The following conversion tables are used for the opening balance transfer of document series type 2:

  • Account conversion table for type 2 document series: Account conversions for opening balance transfer, internal transactions (ID:AccountsOpeningBalanceInternals, Type: Account)

  • Document series conversion table: Document series conversions for integrating entries of new standards to financial statements, internal transactions (ID: DocumentsNewStandardsInternals, Type: Document Series)

  • Period conversion table: Period conversion for opening balance transfer (ID: PeriodsOpeningBalance, Type: Period).

Opening Balances, Check

P_REP_CHECK_BSOPEN.xml / P_REP_CHECK_BSOPEN.xlsx / UI_P_REP_CHECK_BSOPEN.xml

With this report, you can check that the balance of period 0 corresponds to the balance of the previous income statement and balance sheet both on the company and group level.

If the balance totals equal on the consolidated level in group currency, the data was most likely transferred correctly. If the totals do not equal, you can check the unit amounts and find out the unit and document with which the problem occurs. Even if this report does not show difference in balance totals, the data might not have been transferred correctly in account level. It is recommended to check also continuity reports to validate proper conversion to opening accounts.

The report includes two sheets, both of which have two retrieved rows: total assets and total equity and liabilities. The first sheet includes data by input unit (period 12 / %YEAR CODE-1% and period 0 / %YEAR CODE% columns generated for each). The first area of the sheet shows the data in group currency, retrieved from the group amount field, and the second area shows the data in unit amounts. When the report is run from a consolidated level that includes several currencies, the values of the different currencies are summed in the consolidated total and eliminations columns in the second area. The unit columns show the amounts in the input currency of each unit.

The second sheet includes data by document series. The columns and areas are similar as to the first sheet.

Internal Data Transfers (IDT) Status

You can monitor the status of internal data transfer runs and delete internal transfer log entries using the Internal Data Transfer (IDT) Status custom template. For more information see Monitoring IDT Status in Administrator’s Online Help or Customizing Input Template or Report Window in Input and Report User's Online Help.

Was this article helpful?

We're sorry to hear that.