Reporting Structures

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

The Finance universe of BPM Reporting and the General Ledger universe of BPM Analysis use reporting structures to structure and filter accounts. You can create reporting structures for the following purposes:

• Reporting Structure for Finance Measures
• Reporting Structures for Cashflow
• Reporting Structure for Cashflow Statement Indirect Method
• Reporting Structure for Statement of Changes in Equity

Note: You must have the correct access rights to configure some of these settings.

Reporting Structure for Finance Measures

To set up dimension grouping:

Part 1: Create Option List

1. Go to Setup » System Setup » Option Lists.
2. Click + New Option List to open the Create Option List dialog box.
3. In the Option List No. field, enter Finance.

   (Optional) Provide a description for the option list.

4. Click Create Option List.
5. On the Options table, click the Add icon.
6. In the Name and Description fields, enter how you want to identify and describe the option, for example:
   • Name — Standard
7. Click Save.

Part 2: Create Reporting Structure

1. Go to Reference Workspaces » Set-Up » Reporting » Reporting Structures.
2. Click + New Reporting Structure to open the Create Reporting Structure dialog box.
3. Provide a Name and Description, select a Type (or dimension), and input the following settings:
   • Type — Account
   • Option List — Finance
   • Selected Value — Standard
4. Click Create Reporting Structure.
5. (Optional) Insert group headers and subgroup headers to provide the desired account structure, and you can also include a small subset of accounts. The reporting structure works as a filter on accounts in addition to providing a hierarchical structure. Click Save.

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 set up for these as well. The Type 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):

Part 1: Create Option List

1. Go to Setup » System Setup » Option Lists.
2. Click + New Option List to open the Create Option List dialog box.
3. In the Option List No. field, enter Finance.

   (Optional) Provide a description for the option list.

4. Click Create Option List.
5. On the Options table, click the Add icon.
6. In the Name and Description fields, enter how you want to identify and describe the option, for example:
   • Name — Cashflow Statement
     Note: If BPM Reporting has already been set up in Maconomy, the option list might already exist; if so, add only the value Cashflow Statement.
7. Click Save.

Part 2: Create Reporting Structure

1. Go to Reference Workspaces » Set-Up » Reporting » Reporting Structures.
2. Click + New Reporting Structure to open the Create Reporting Structure dialog box.
3. Provide a Name and Description, select a Type (or dimension), and input the following settings:
   • Type — Account
   • Option List — Finance
   • Selected Value — Cashflow Statement
4. Click Create Reporting Structure.
5. (Optional) Insert group headers and subgroup headers to provide the desired account structure, and you can also include a small subset of accounts. The reporting structure works as a filter on accounts in addition to providing a hierarchical structure. Click Save.
6. Create another reporting structure with the option list value Cashflow Forecasting.

Reporting Structures for Cashflow Statement Indirect Method

To create a reporting structure for Cashflow Statement Indirect Method:

Part 1: Create Option List

1. Go to Setup » System Setup » Option Lists.
2. Click + New Option List to open the Create Option List dialog box.
3. In the Option List No. field, enter Finance.

   (Optional) Provide a description for the option list.

4. Click Create Option List.
5. On the Options table, click the Add icon.
6. In the Name and Description fields, enter how you want to identify and describe the option, for example:
   • Name — Cashflow Statement
7. Click Save.

Part 2: Create Reporting Structure

1. Go to Reference Workspaces » Set-Up » Reporting » Reporting Structures.
2. Click + New Reporting Structure to open the Create Reporting Structure dialog box.
3. Provide a Name and Description, select a Type (or dimension), and input the following settings:
   • Name — Cashflow Statement
   • Description — Cashflow Statement Reporting Structure
   • Type — Account
   • Option List — Finance
   • Selected Value — Cashflow Statement
     Note: If BPM Reporting has already been set up in Maconomy, the option list might already exist; if so, add only the value Cashflow Statement and description.
4. Click Create Reporting Structure.
5. (Optional) Insert group headers and subgroup headers to provide the desired account structure, and you can also include a small subset of accounts. The reporting structure works as a filter on accounts in addition to providing a hierarchical structure. For example:
   • Add two top-level groups for Net Cashflow and Cash Reconciliation.
   • Under Net Cashflow, add three sub-level groups for Operating, Investing, and Financing Activities.

     Then, you can configure the next levels based on your preference.

6. Click Save.

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 Reference Workspaces » Set-Up » Reporting » Reporting Structures.
2. Click + New Reporting Structure to open the Create Reporting Structure dialog box.
3. Provide a Name and Description, select a Type (or dimension).
4. Click Create Reporting Structure.
5. (Optional) Insert group headers and subgroup headers to provide the desired account structure, and you can also include a small subset of accounts. The reporting structure works as a filter on accounts in addition to providing a hierarchical structure.
   Note: The group names can be adjusted to fit 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.

6. Click Save.