Consolidation Areas and Units

Getting Started

Global Functions

Administration

Extended Planning & Analysis (xP&A)

Consolidation & Financial Planning

User Interface of Lucanet Consolidation & Financial Planning

General Functions

Basic Configuration

Dashboards

Reporting & Analyzing

Import and Journals

Planning

Consolidation

Consolidation 1

Consolidation 2

All Steps at a Glance

Basic Elements

Defining the Group Structure

Consolidation Dimensions and Consolidation Dimension Elements

Consolidation Areas and Units

Administrating Master Data

Creating Consolidated Financial Statements

Creating and Configuring Data Transfer and Proportioning

Creating and Configuring Consolidation Apps

Executing the Consolidation

Dimensions

Excel-Integration

Workspace Configuration

ESG Reporting

Disclosure Management

XBRL Tagger

Lease Accounting

Banking & Cash Management

Data Collection

Tax Compliance & Reporting

Glossary

Consolidation areas are used to summarize all consolidation units that are to be consolidated together. This could be groups or sub-groups, for example.

To facilitate administration, elements can also be grouped into consolidation unit groups.

Additionally, total lines can be used to display the total values for each consolidation area and consolidation unit group.

Consolidation areas are the object of consolidation, i.e. consolidation is performed in the consolidation areas. The values from the referenced organization elements are transferred to the consolidation areas using the app for Data transfer and proportioning. Based on the clear assignment of organization elements to consolidation dimension elements and consolidation units, it is always possible to determine which values come from which organization elements.

A single consolidation dimension element (e.g., a company) can be included in multiple consolidation areas.

If a group consists of several foreign currency companies, all relevant exchange rate tables have to be stored for the individual consolidation units.

To create a new consolidation area, select the folder Consolidation areas in the Groups workspace and choose Create | Consolidation area from the context menu.

The Create Consolidation Area dialog is displayed as follows:

Displays the 'Create consolidation area' dialog — 'Create consolidation area’ dialog

Please configure the following options:

Name of the consolidation area

Selection of the consolidation dimension element that are to be used as the default consolidation unit of the consolidation area.

The default consolidation unit defines the highest-level

parent company in the consolidation area

. Based on this element, the effective ownership interests are calculated.

All

consolidation dimension elements

are available for selection that have been configured beforehand.

A subsequent change of the default consolidation unit is

not

possible.

The dimension under which the previously selected consolidation dimension element was created is automatically used as the consolidation dimension.

Start of the fiscal year of the consolidation area

Default currency to be used for the consolidation area

In addition to the default consolidation unit, you can configure the following for a consolidation area:

In each consolidation area, consolidation units can be created in addition to the default consolidation unit.

The number of consolidation units is limited to the number of consolidation dimension elements that were selected when creating the consolidation area.

Proceed as follows:

Select the consolidation area under which the consolidation unit is to be created in the structure view and do one of the following:

Choose

Create | Transaction currency

from the context menu

Click

Create consolidation unit

in the detail view

The Create consolidation unit dialog is displayed as follows:

Select the consolidation dimension element(s) to be referenced as consolidation unit in the drop-down list and click Apply.

Click Save.

All defined consolidation units are shown directly below their consolidation area. To facilitate administration, elements can also be grouped into consolidation unit groups.

Proceed as follows:

In the structure view, select the consolidation area under which the consolidation unit group is to be created and select the Create | Consolidation unit group from the context menu.

Enter a name for the consolidation unit group and save it.

In the structure view, select the consolidation unit group and create the desired consolidation units below the group as described under Adding Further Consolidation Units.

Currency translation within a consolidation area is always necessary if there are foreign currency companies in the group. If a group consists of several foreign currency companies, all relevant exchange rate tables of the individual consolidation units must be included.

To create an exchange rate table, proceed as follows:

In the structure view, highlight the consolidation area under which the exchange rate table is to be created, and click Edit in the detail view.

Click Add element below the exchange rate table and select the desired exchange rate tables:

Click Adopt and Save.

In order to display total values, any number of total lines can be created for every consolidation area and every consolidation unit group.

Select the element under which you want to create a total line and select Create | Total line from the context menu.

In the detail view of a total line, you can also define whether you want to calculate the subtotal until the previous total line.

Shows the dialog 'Create Total Line' — 'Create total line’ dialog

To delete an element in the Consolidation areas workspace, right-click the desired element and choose Delete from the context menu.

Last updated on Aug 16, 2023

Consolidation Areas and Units

Overview

Creating a Consolidation Area

Configuring a Consolidation Area

Deleting an Element

Overview

Creating a Consolidation Area

Name

Default consolidation unit

Consolidation dimension

Start of the fiscal year

Default currency

Configuring a Consolidation Area

Adding Further Consolidation Units

Grouping Consolidation Units

Adding Currency Translation

Adding a Total Line

Deleting an Element

Table of Contents

Company

Legal Notice