Ga naar hoofdinhoud

Structure Mapping

In Factview, General Ledger Accounts are organized within a Report Structure. This structure determines how financial data is displayed in reports, such as the Balance Sheet and the Profit and Loss Statement.

Once accounts have been mapped, they are automatically included in the structure. Within the structure, you can view where accounts have been assigned and modify their location if necessary.

The structure consists of multiple categories and subcategories used to group accounts.

Opening Structure Mapping

Navigate to:

Data → Manage and Organize → Structure Mapping

This opens the Structure Mapping screen.

Screen Overview

The screen consists of several sections.

1. Report Structures​

This panel displays all available Report Structures.

A Report Structure determines how General Ledger Accounts are grouped in reports. Examples include:

  • Profit and Loss Statement structure

  • Balance Sheet structure

Selecting a Report Structure loads it into the Structure Panel on the right side of the screen.

2. Structure Panel (Navigation)​

The Structure Panel provides tools for quickly navigating through the Report Structure.

Available options:

  • Expand All Groups - Expands every section of the structure.

  • Expand Main Groups - Displays only the main categories.

  • Expand More Detail - Shows additional levels within the structure.

  • Collapse All Groups - Collapses the entire structure.

These options make it easier to navigate large Report Structures.

3. Account Panel​

The Account Panel allows you to filter General Ledger Accounts.

Available filters:

  • Profit & Loss - Displays only Profit and Loss accounts.

  • Balance Sheet - Displays only Balance Sheet accounts.

  • Unmapped - Displays accounts that have not yet been mapped to the structure.

You can also search for a specific account using Filter by Account.

Additional filters:

  • With Transactions - Displays only accounts that contain transactions.

  • Without Transactions - Displays only accounts without transactions.

You can also filter by balance:

  • > 0 - Accounts with a positive balance.

  • < 0 - Accounts with a negative balance.

  • = 0 - Accounts with a zero balance.

4. Mapping Status​

This section shows whether all accounts have been assigned to the selected Report Structure.

When the message "All accounts have been mapped" is displayed, every account has been assigned to a category within the structure.

5. Actual Balance​

This section displays the balance of the selected structure or account for the chosen period.

This provides a quick way to verify that amounts have been included correctly in the Report Structure.

6. Transactions for the Selected Account​

When an account is selected, this panel displays its transactions.

If no transactions are available, the following message is displayed:

"No figures found for this account."

7. Structure Panel (Report Structure)​

The right side of the screen displays the complete Report Structure as a tree view.

Here you can view:

  • The hierarchy of the Report Structure.

  • The categories within the structure.

  • The mapped General Ledger Accounts.

When an account is displayed in green, it indicates that figures are available for that account.

Accounts can be moved by dragging them to another category within the Structure Panel. They can also be moved temporarily to the Account Panel if required.

Additional Structure Functions

The Structure section also contains additional functions for managing and validating the Report Structure.

Export Mapping​

Exports an overview of all mappings between General Ledger Accounts and the Report Structure to an Excel file.

Mapping Table​

Displays an overview of all accounts and the categories to which they are assigned.

Show Balance For​

Select the reporting period for which balances are displayed in the Report Structure.

Move Accounts Without Transactions to !NM​

Automatically moves all accounts without transactions to the !NM (Do Not Map) category, helping to keep the Report Structure organized.