Configuring Balance Sheet

Except for the required default reporting structure of the entity and group Balance Sheet reports, you can configure two alternative reporting structures. After you publish the model in Business Modeling, you can select the wanted reporting structure in the context panel of the Balance Sheet report.

The default reporting structure is based on the principles of assets and liabilities.

The alternative reporting structure 1 has these sections:

  • Total Assets Less Current Liabilities
  • Total non-current liabilities and equity

The alternative reporting structure 2 has these sections:

  • Total Assets
  • Total Liabilities
  • Equity

The default reporting structure and both alternative reporting structures for the Balance Sheet are stored in the OLAP database in this way:

  • 001: Default reporting structure
  • 002: Alternative reporting structure 1
  • 003: Alternative reporting structure 2

To view these settings in the database, select EPM Administration > Dashboards > OLAP > Edit Database. In the DEPMAPPS model, select the DGAAP hierarchy and view the settings on the Elements tab.

  1. Ensure that the Group Accounts business object has been configured.
  2. Select Modules > Consolidation > Balance Sheet and click Configure.
  3. On the Default Settings tab, specify this information to configure the required default Balance Sheet reporting structure:
    Total Assets
    Select the top group asset account in the balance sheet hierarchy. You can select only accounts of type A (Assets). Total assets are calculated for the purposes of equal checks, reporting, and consolidation processes. Total assets are also used in the Budgeting & Planning module.
    Total Liabilities
    Select the top group liability account in the balance sheet hierarchy. You can select only accounts of type L (Liabilities). Total liabilities are calculated for the purposes of equal checks, reporting, and consolidation processes. Total liabilities are also used in the Budgeting & Planning module.
    Balance Sheet Profit/Loss
    Select the group equity account that is increased by the period's profit or decreased by the period's loss. You can select only accounts of type A or L. Typically, type L is used. This account receives the results from the profit and loss statement. This account is used in consolidation processes and in the Budgeting & Planning module.
    Schedule Detail for Balance Sheet Profit/Loss
    Specify the ID of the schedule detail for the specified equity account. Typically, this is an opening balance.
    Deferred Tax - Assets
    Select the group account to store system generated deferred tax assets. You can select only accounts of type A.
    Deferred Tax - Assets Detail
    Optionally, select the deferred tax asset account detail for the balance sheet.
    Deferred Tax - Liabilities
    Select the group account to store system generated deferred tax liabilities. You can select only accounts of type L.
    Deferred Tax - Liabilities Detail
    Optionally, select the deferred tax liabilities account detail for the balance sheet.
    Currency Translation Differences
    Select the balance sheet group account for system generated currency exchange differences. Those differences result from the retranslation of the balance sheet statement with the balance sheet exchange rate. You can select only accounts of type A or L. We recommend that you set up this account with a meaningful name, such as Translation Reserve BS.
    Rounding Differences
    Select the balance sheet group account to store system generated rounding differences that result from consolidation processes. You can select only accounts of type A or L. We recommend that you select the same account as in the Currency Translation Differences field.
  4. Click Save.
  5. Optionally, to configure an alternative Balance Sheet reporting structure, click the Alternative Settings 1 tab and enable the Alternative Settings 1 switch.
  6. Optionally, in the Name field, specify the name for the alternative reporting structure or leave the default name.
  7. Select appropriate group accounts for each reporting hierarchy element and assign the report sign value and variance for each account.
  8. Click Save.
  9. Optionally, to configure another alternative Balance Sheet reporting structure, click the Alternative Settings 2 tab and enable the Alternative Settings 2 switch.
  10. Perform steps 6-8.
    Note: When you hover over the Information icon on the Alternative Settings 1 and Alternative Settings 2 tabs, the tooltip shows the report structure.