Ga naar hoofdinhoud

Step 3: Manage General Ledger Accounts in a Consolidation

In this step, General Ledger Accounts are imported, reviewed, and mapped within the Consolidation Dossier.

Import General Ledger Accounts with Balances (Required)

Step 1: Import and Split Accounts

Go to:

Main Menu → Consolidation → General Ledger Settings

  1. Select Show Existing Accounts in the Consolidation.

  2. Select Accounts with Transactions.

  3. Enable Automatically Split Accounts.

  4. Click the button to Import the Accounts.

  5. Click Update Consolidation.

Step 2: Map General Ledger Accounts

Go to:

Main Menu → Data → Manage and Organize → Structure Mapping

  1. In the red notification on the right, click Automatically Place Accounts in the Structure.

  2. Review the mapping.

  3. Manually drag accounts to the correct groups where necessary.

  4. Rename accounts if required.

Verify the reports (Balance Sheet and Profit and Loss Statement) to ensure:

  • Amounts appear on the correct side.

  • The report structure is logical.

Step 3: Apply the Report Structure

  1. Apply the standard Report Structure to all underlying entities.

  2. Also apply any custom Report Structures if applicable.

Import General Ledger Accounts Without Balances (Optional)

Step 4: Import Empty Accounts

Go to:

Main Menu → Data → Manage and Organize → Structure Mapping

Under Accounts:

  1. Select Accounts Without Balances (Balance = 0).

Step 5: Group Empty Accounts

In the Structure section:

  1. Select Move Accounts Without Transactions to !NM (Not Mapped).

This places all empty accounts into a single !NM group.

Check Account 99999

Go to:

Main Menu → Data → Manage and Organize → General Ledger Accounts

Verify that Account 99999 - Profit for the Year and Differences exists.

If necessary:

  • Add the account.

  • Map it to M250500 - Other Reserves.

  • Update the Import Sets again.