Entering opening balance data

Opening balances for all balance sheet accounts are required in order to start a configuration set. You can generate opening balances by importing them from a source system or entering opening balances manually.

To load an initial opening balance, you can import a manually created .csv file to the OLAP BPCMAIN cube through OLAP Administration. To verify the BPCMAIN cube structure that is required for import, first you should export the cube.

For the purpose of the correct import of an opening balance, you must address these slices:

  • Level: Import_OB.
  • Time: The last period of the previous year, for example, period 12.2022 (12_2022) to import actuals for 2023.
  • Schedule Detail: You can choose all opening balance-relevant details, for example, E_OB.
  • Cycle, Version, Entity, Account, and any other potential references, as required.

By the online rules, the imported values are carried forward to the current year as an opening balance.

Note: Before the import, ensure that the target area is empty. Otherwise, any existing values will be overwritten by the imported values. You can verify whether the target area is empty by exporting the cube and filtering in Excel.
Note: Ensure that you import opening balance values only once per configuration set-version combination.

Calculation of opening balances is done via OLAP rules. Therefore it is important the initial values for opening balances only exist for the first year within a configuration set or version. For example, you can import opening balance values for 2016 for configuration set 1. Opening balances for 2017 are calculated via a rule.

The Input Opening Balance feature populates the opening balance of the first period of the first year in the configuration set. For each subsequent year in the configuration set the opening balance is automatically adjusted for the previous year's budgeted movements. This process is the same for manually entered balances as it is for generated balances.

This is a simplified representation of the opening balance process:
Balance sheet accountConfiguration set year 1Configuration set year 2Configuration set year 3
Input opening balance100,000100,000100,000
Cumulative configuration set budgeted changes1,0003,000
Subtotal opening balance100,000101,000103,000
Budgeting movements1,0002,0001,000
Closing YTD balance101,000103,000104,000