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.

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.