Wizard for Paired Elimination of Intercompany Income and Expense

Getting Started

Global Functions

Lucanet Lume

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

All Steps at a Glance

Creating and Configuring Consolidation Areas

Creating and Editing Configurations

Creating and Configuring Consolidation Wizards

Wizard for Paired Elimination of Intercompany Debt

Wizard for Lump Sum Elimination of Intercompany Debt

Wizard for Paired Elimination of Intercompany Income and Expense

Wizard for Lump Sum Elimination of Intercompany Income and Expense

Wizard for Elimination of Intercompany Income and Expense Based on Group-internal Revenue

Wizard for Inventory Consolidation

Automatic Cancellation in the First Planning Month

Consolidation 2

Dimensions

Excel-Integration

Workspace Configuration

ESG Reporting

Disclosure Management

XBRL Tagger

Lease Accounting

Banking & Cash Management

Data Collection

Tax Compliance & Reporting

Glossary

The Paired elimination of intercompany income and expense wizard enables the wizard-assisted elimination of expenses and income between affiliated companies. Pair combinations of accounts between reporting entities or cost centers are formed based on settings previously made in the Consolidation areas workspace.

The wizard for paired elimination of intercompany income and expense is displayed as follows, for example:

The following options must be configured in the Paired elimination of intercompany income and expense wizard:

Edit the general properties of the wizard for paired elimination of intercompany income and expense in the top area of the detail view:

Option	Description
Name	Name of the wizard
Period	Time period for which the elimination is to be performed Note: After the period has been changed, it is necessary to update the wizard (see section Updating Wizard).

Choose whether you want to perform consolidation for every month of the time period or for the entire period in the last month.

Option	Description
Cost center	Cost center for the postings
Currency	Currency, in which the consolidation postings are to be made. By default, the transaction currency of the consolidation area is used.
Basis	Adjustment level with the data for the generation of the consolidation postings
Target	Adjustment level on which postings are to be made

All pair combinations of reporting entities between which income and expense relationships exist are listed on the Values tab:

If the income corresponds to the expenses within the combined pair, the value is displayed in green.

If there is a difference, it is displayed in red or green – according to the definition of the threshold value.

To obtain detailed information, click the arrow in front of the desired pair combination or item.

Area 'Pair combinations'

The following options are available in the Pair combinations area:

Option	Description
Refresh	Refreshes the values in the wizard.
Resolve differences	Automatically resolves any differences that may have occurred within a posting. Click on a row that contains differences and then click the Resolve differences command.

Select the pair combination in the table whose details you want to view or edit.

The following options are available in the table on the right:

Option	Description
Threshold for Display	Differences above the entered value are highlighted in red in the Pair combinations area.

Click the displayed difference account to change it.

Click

+ Add Row

to insert a row and select an additional difference account.

Change the amounts to be posted to the difference account by clicking the respective amount.

Select

Debit

Credit

in the displayed drop-down list.

If necessary, click the

trash can icon

if you want to delete a difference account.

If you change the period in the General area, the message Please update the consolidation wizard is displayed. Proceed as follows in this case:

Click Update wizard in the Pair combinations area. The Update wizard dialog is displayed:

Choose the desired configuration for the paired elimination of intercompany income and expense.

Define which elements should be updated. Do one of the following:

Update pair combinations

, if only the pair combinations are to be updated.

Note: If the Retain settings for already existing combinations check box is deactivated, any settings already created might be overwritten by the configuration settings of the wizard.