Configuring Profit and Loss

Except for the required default reporting structure of the entity and group income statement reports, you can configure two alternative parallel reporting structures. After you publish the model in Business Modeling, you can select the wanted reporting structure in the context panel of these reports:

Entity Income Statement
Group Income Statement
Group Income Statement Analysis

You can enable or disable alternative reporting structures independently.

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

004: Default reporting structure
005: Alternative reporting structure 1
006: 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.

Ensure that the Group Accounts business object has been configured.
Select Modules > Consolidation > Profit and Loss and click Configure.
On the Default Settings tab, specify this information to configure the required default Profit and Loss reporting structure:

Total Profit and Loss

Select the group account to be the top account in the profit and loss hierarchy and to reflect the period result. You can select only E (Expense) or R (Revenue) account types.
This account is used in consolidation processes to transfer the profit and loss result to the balance sheet. Total Profit and Loss is also used in the Budgeting & Planning module.

Sum of the P&L before Currency Translation

Select the profit and loss account to hold the period result before the currency translation. You can select only accounts of type E or R.

Currency Translation Differences

Select the balance sheet account to which to post system generated currency exchange differences. Those differences result from the retranslation of the profit and loss statement with the balance sheet exchange rate. You can select only accounts of type A (Assets) or L (Liabilities). We recommend that you set up this account with a meaningful name, such as Translation Reserve PL.

Deferred Tax – Expenditure

Select the expenditure account to store system generated deferred tax charges. You can select only accounts of type E.

Deferred Tax - Expenditure Detail

Optionally, select the Profit and Loss account detail that is used to post system-generated deferred tax charges.
If not selected, system-generated deferred tax postings in the Profit and Loss are posted to the configured account without the detail dimension breakdown. The default or empty detail dimension value is specified for these entries.

Deferred Tax – Revenue

Select the revenue account to store system generated deferred tax credits. You can select only accounts of type R.

Deferred Tax - Revenue Detail

Optionally, select the Profit and Loss account detail that is used to post system-generated deferred tax credits.
If not selected, system-generated deferred tax postings in the Profit and Loss are posted to the configured account without the detail dimension breakdown. The default or empty detail dimension value is specified for these entries.
Click Save.
Optionally, to configure an alternative Profit and Loss reporting structure, click the Alternative Settings 1 tab and enable the Alternative Settings 1 switch.
Optionally, in the Name field, specify the name for the alternative reporting structure or leave the default name.
In the Total Profit and Loss field, select an appropriate group account as the top element.
Click Save.
Optionally, to configure another alternative Profit and Loss reporting structure, click the Alternative Settings 2 tab and enable the Alternative Settings 2 switch.
Perform steps 6-8.