Optional Keywords

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

Dimensions

Excel-Integration

Lucanet.Excel-Reporting

CFP Add-in for Excel 365

Installing the CFP Add-In for Excel 365

Querying Data from Lucanet

Transferring Data from MS Excel to Lucanet

Required Keywords

Optional Keywords

Troubleshooting Guide

Migrating From Integrated Excel.Add.-in to CFP Add-in for Excel 365

Workspace Configuration

ESG Reporting

Disclosure Management

XBRL Tagger

Lease Accounting

Banking & Cash Management

Data Collection

Tax Compliance & Reporting

Glossary

Optional keywords can be inserted if you need to import further information in addition to the required content. Optional keywords, just like required keywords, are entered in column A, while the corresponding parameters are generally entered in column B. Exceptions to this are the keywords in the row Column definition, whose parameters and posting data must be entered in the corresponding column.

Note: If no entry is made for an optional keyword, this cell is skipped during the import.

The following keywords can be defined in MS Excel in column A:

Can contain a description of or a comment on the import.

Only one description is allowed per import (see Description and text)

Breaks down annual values (Y), semester values (S), trimester values (T) or quarterly values (Q) automatically to monthly values (Periodicity)

Note: If the abbreviations (FY) or (FQ) are used, the annual or quarterly values are converted on a straight-line basis into the months of the deviating fiscal year/quarter.

When using Automatic cancellation, the posting in Lucanet is canceled automatically in the subsequent period after every month.

The following keywords can be defined in the row Column definition:

Defines the column for posting texts (see Description and text)

Specifies the item in Lucanet under which a new account is to be created (see Item)

Defines the column for partner information

Note: Only partners may be specified.

Defines the column for the cost center used

Note: The keywords cost center or CC can only be used together with the keyword reporting entity.

Defines the column for the utilized consolidation unit

Note: The keywords consolidation unit or CU can only be used together with the keyword consolidation area.

The following keywords can be defined both in column A and in the column Column definition:

Keyword	Description
Factor	Defines the factor globally for a row or a column with which the values are multiplied (see Factor)
Transaction type or TT	Defines the transaction type for a row or a column
Transaction currency or TC	Defines the factor globally for a row or a column with which the values are multiplied (see section Transaction currency)

The following optional keywords are available:

The LUCANET Excel workbook can be used to enter posting-specific texts and a description that can be transferred to Lucanet.

Keyword and its position	Position of the content
Description, in column A	The description is in the same row in column B.
Text, in the Column definition row	The text is located in the same column after the corresponding posting.

The keyword Factor enables conversion of the values during data transfer. The values to be imported are multiplied with the specified factor. This makes entries in TEUR possible, for example. The keyword Factor can be entered at different positions in the Excel workbook. The values to which the factor is applied depend on the position in the workbook.

The values to which a factor is applied depend on its position in the Excel workbook:

Position	Validity range
Column A, before the row Column definition	The entered factor applies for all values of the worksheet.
Within the Column definition row	The factor applies for all values of the column.
Column A, after the Column definition row	The factor applies for all values of the row.

Entering the keyword Periodicity in column A and a period in a value column for the same row informs Lucanet during the import that the values for e.g. are annual or quarterly values. During the import, the value from MS Excel is automatically broken down to month level in Lucanet.

The following periods can be specified:

Periodicity	Period
Y	Year
Q	Quarter
M	Month
S	Semester
T	Trimester
FY	Fiscal year
FQ	Fiscal quarter
FS	Fiscal semester
FT	Fiscal trimester

You can use the Item keyword to create unavailable accounts in Lucanet. To do this, the keyword Account must be entered in the Column definition row in front of the keyword Item in MS Excel.

The keywords Transaction currency and TC enable postings to accounts in all transaction currencies defined in Lucanet. If no transaction currency is specified, the default currency of the reporting entity or the consolidation areas is used automatically.

The values to which the transaction currency is applied depend on the position of the keyword in the Excel workbook:

Position	Validity range
Column A, before the row Column definition	The transaction currency applies for all values in the worksheet.
Within the Column definition row	The transaction currency applies for the values in a row.
Column A, after the Column definition row	The transaction currency applies for all values in a column.

The keywords consolidation unit and CU enable posting in the consolidation units of a consolidation area in the Groups workspace. If one of these keywords is used, the postings will occur in the default consolidation unit of the consolidation area.