BPM Admin Guide

Reporting Structures

This section describes the steps you need to follow to setup reporting structures.

Reporting Structures

The Finance universe of BPM Reporting and the General Ledger universe of BPM Analysis use reporting structures to structure and filter accounts.

Reporting Structure for Finance Measures

To set up dimension grouping:

  1. Open the Option List window.
  2. In the Option List No. field, enter Finance.
  3. In theName field, enter Standard.

  4. Open the Reporting Structures window in the workspace Reporting.
  5. Create a reporting structure with the following settings:
    • Type - Account
    • Option List - Finance
    • Selected Value - Standard
  6. Insert group headers, sub-group headers to provide the desired account structure.
  7. Add accounts to the individual groups of the reporting structure.

Each group states the header labels for the finance report using the reporting structure. For example, account number 1110 is displayed in the group with the top-level header RESULT, then RESULT BEFORE EXTR. ENTRIES, REVENUE, and so on.

Note: If using Local Charts of Accounts, reporting structures should be setup for these as well. The Type for these is Local Account.

Reporting Structures for Cashflow

Note: If Maconomy is already set up for BPM Reporting, this reporting structure may already exist. If it does, you do not need to perform the following procedure.

To select the accounts for which postings are considered as contributing to cash flow (cash flow statement):

  1. Open the Option Lists window.
  2. Create an option list named Finance.
  3. Enter a value with the name Cashflow Statement.

    If Business Performance Management Reporting has already been set up in Maconomy, the option list might already exist; if so, add only the value Cashflow Statement.

  4. Open the Reporting Structure window in the workspace Reporting.
  5. Create a new reporting structure with the following settings:
    • Type - Account
    • Option List - Finance
    • Selected Value - Cashflow Statement
  6. Create grouping headers and add accounts similar as done above. Cashflow usually only include a small subset of accounts. Thereby, the reporting structure works as a filter on accounts in addition to providing a hierarchical structure.
  7. Create another reporting structure with the option list value Cashflow Forecasting.

Reporting Structure for Cashflow Statement Indirect Method

To create a reporting structure for Cashflow Statement Indirect Method:

  1. Go to Setup » System Setup » Parameters and Numbers » Option Lists.
  2. Click + New Option List.
  3. In the Option List No. field, enter Finance.
  4. Click Create.
  5. On the Options sub-tab, click Add Option or press Ctrl + M.
  6. In theName and Description fields, enter Cashflow Statement.
  7. Click Save Option (Enter), then click Save Option List (Enter).
  8. Go to Setup » Reporting » Reporting Structures.
  9. Click + New Reporting Structure.
  10. In the Create Reporting Structure dialog, enter the following setting:
    • Name - Cashflow Statement
    • Description - Cashflow Statement Reporting Structure
    • Type - Account
    • Option List - Finance
    • Selected Value - Cashflow Statement

    If Business Performance Management Reporting has already been set up in Maconomy, the option list might already exist; if so, add only the value Cashflow Statement and description.

  11. Click Create.
  12. Insert group headers, sub-group headers to provide the desired account structure, similar as done above. Cashflow usually only include a small subset of accounts. Thereby, the reporting structure works as a filter on accounts in addition to providing a hierarchical structure.
    1. Add two top-level groups for Net Cashflow and Cash Reconciliation.
    2. Under Net Cashflow, add three sub-level groups for Operating, Investing, and Financing Activities.
    3. Then, you can configure the next levels based on your preference.
Reporting Structure for Dashboard Components

The dashboard components and dashboards in BPM Reporting also require the same kind of reporting structure as is needed for the dashboards in BPM Analysis. The following replicates the setup steps. However, it is not necessary to define all dimension categories, only Revenue on level 5 and Gross Profit on level 4. Deltek recommends that you set up a meaningful structure that includes all of the groups.

To classify accounts that are used to calculate finance key metrics:

  1. Open the Option Lists window.
  2. Create an option list with the number Finance and a value with the name Key Metrics.

    If BPM Reporting has already been set up in Maconomy, this option list might already exist. If so, add only the Key Metrics value.

  3. Open the Reporting Structure window in the workspace Reporting.
  4. Create a reporting structure with the following settings:
    1. Type - Account
    2. Option List - Finance
    3. Selected Value - Key Metrics
  5. The reporting structure needs to have specific grouping headers and a certain structure.
  6. Place each account in the group where it belongs.
    Assign To the Value For All Accounts in which
    Grouping 1 NET PROFIT Posted amounts should contribute to the calculation of Net Profit.
    Grouping 1 ASSET Posted amounts should contribute to the calculation of Assets.
    Grouping 1 LIABILITY Posted amounts should contribute to the calculation of Liability.
    Grouping 1 EQUITY Posted amounts should contribute to the calculation of Equity.
    Grouping 2 EBIT Posted amounts should contribute to the calculation of EBIT.
    Grouping 3 EBITDA Posted amounts should contribute to the calculation of EBITDA.
    Grouping 4 GROSS PROFIT Posted amounts should contribute to the calculation of Gross Profit.
    Grouping 5 REVENUE Posted amounts should contribute to the calculation of Revenue.
    Grouping 5 COST Posted amounts should contribute to the calculation of Cost.
    Grouping 5 DEPRECIATION Posted amounts should contribute to the calculation of P&L depreciation.
    Grouping 5 INTEREST Posted amounts should contribute to the calculation of P&L interest.
    Grouping 5 TAX Posted amounts should contribute to the calculation of P&L TAX.
Reporting Structure for NSAFT

The NSAFT report uses a reporting structure to group finance data.

To create a reporting structure for NSAFT:

  1. Go to Setup » System Setup » Parameters and Numbers » Option Lists.
  2. Click + New Option List.
  3. In the Option List No. field, enter Finance.
  4. Click Create.
  5. On the Options sub-tab, click Add Option or press Ctrl + M.
  6. In theName and Description fields, enter NSAFT.
  7. Click Save Option (Enter), then click Save Option List (Enter).
  8. Go to Setup » Reporting » Reporting Structures.
  9. Click + New Reporting Structure.
  10. In the Create Reporting Structure dialog, enter the following setting:
    1. Type - Accounts or Local Accounts
    2. Option List - Finance
    3. Selected Value - NSAFT
  11. Click Create.
  12. Insert group headers, sub-group headers to provide the desired account structure.
  13. Add accounts to the individual groups of the reporting structure.

Grouping Headers

The grouping headers specified in the reporting structure is mapped to the generated XML file following the structure below:

Tags (attributes indented) Mapping
<MasterFiles>
<GeneralLedgerAccounts>
<Account>
<AccountID> [Account No.]
<AccountDescription> [Account Description]
<StandardAccountID> [Grouping Level 1]
<GroupingCategory> [Grouping Level 2]
<GroupingCode> [Grouping Level 3]
<Account>
<GeneralLedgerAccounts>
<MasterFiles>

Reporting Structure for Statement of Changes in Equity

The Statement of Changes in Equity report uses a reporting structure to group data.

Note:
  • Only Grouping Level 1 is used for this report. No other grouping levels need to be set for this report as it does not utilize them.
  • The reporting structure does not need to have Option List and Option Value set as the report prompts the user to select a reporting structure instead.

To set up a reporting structure for the Statement of Changes in Equity report:

  1. Go to Setup » Reporting » Reporting Structures.
  2. Click + New Reporting Structure.
  3. Add a group for each of the columns to be displayed.

    Example:

    Column 1: "Share Capital"

    Column 2: "Statutory Reserve"

    Column 3: "Other Reserve"

    Column 4: "Retained Earnings"

    Note: The naming groups and naming of them can be adjusted to your business needs. However, it is usually standard to have one group named "Retained Earnings" or something similar. This group should include the Year-end-Result Account and all the profit and loss accounts.

    Each of the other groups should include the respective Equity accounts for which you want the postings to appear for in the respective columns.

  4. Click Create.

For more information on the column structure and how it is utilized in the report, see the Deltek Maconomy BPM Report Description Guide.