Required Keywords
Last updated on 2025-04-29
Overview
Required keywords are needed in order for Lucanet to recognize that it is an import. They are entered in column A or the Column definition row.
This article contains the following sections:
Keywords in Column A
The following keywords are required and must be contained in MS Excel in column A.
Keyword
Parameter
Name
Name of the import
Important: If an Excel import with this name already exists on the data level and in the reporting entity, it will be overwritten!
Reporting entity/Consolidation area
Name of the reporting entity or the consolidation area for which the import is to be executed
Data level
Name of the data level into which the import is to be performed
Adjustment level
Name of the adjustment level on which the posting is to be performed
Column definition
Determines what can be found in each column (see next table)
Posting date
Date by which the postings are to be created or the values imported
Posting/Auto posting
To enable Lucanet to identify which data are to be imported, one of the two keywords must be specified in column A. It is also possible to specify both keywords together as frequently as desired and in any order.
Together with the Value column, the keywords Posting and Auto posting form a matrix structure whose interfaces define the values to be imported.
For postings on a planning data level for which the automatic contra entry is defined in Lucanet.
Note: The keyword Auto posting can only be used when importing data into reporting entities.
For postings of one-off or rare business transactions.
Note: To ensure an integrated balance sheet, P&L, and cash flow statement at this time, only complete postings can be imported into Lucanet. The following applies for every column containing postings: Debit = credit.
Keywords in the Column Definition Row
The following keywords are required and must be included in the Column definition row in MS Excel.
Keyword
Parameter
Account
Defines that this column contains the account/item descriptions for the import
Value
Defines that the column contains the values to be imported
Debit
This keyword can be used instead of the keyword Value in order to assign additional information to the corresponding value, indicating that it is a debit value.
Credit
This keyword can be used instead of the keyword Value in order to assign additional information to the corresponding value, indicating that it is a credit value.
Optional keywords are used to import further information.