Help & Support ↗ Lucanet Learning Space ↗
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
Journals
Importing Data into Reporting Entities
All Steps at a Glance
Defining a Data Source
Creating Assignment Tables
Creating and Executing the Data Import
Assigning Data
Finalizing Data Import
Updating Data Imports
Importing data into Lucanet.Financial Warehouse
Creating and Executing Scripts
Configuring Period Locks
Planning
Consolidation
Dimensions
Excel-Integration
Workspace Configuration
ESG Reporting
Disclosure Management
XBRL Tagger
Lease Accounting
Banking & Cash Management
Data Collection
Tax Compliance & Reporting
Glossary

Creating and Executing the Data Import

Overview

All data that is imported into reporting entities is transferred to the current Lucanet database using data imports. The data import object is used to determine which data source and assignment table are to be used during the import.

The actions in the detail view of the data import are used to execute the data import, create assignments in the assignment table used and save the data import. You can create any number of data imports which can be updated at any time and combined in data import folders.

Creating a Data Import

To create a data import:

1

Choose the command Create | Data import from the context menu of the Data imports root folder or a data import folder.

Creating a data import
2

Enter a name for the data import in the Create data import dialog and click Save.

The data import is created. The detail view of the data import is displayed as follows:

Detail view of a data import
3

If necessary, activate the Execute data import as initial consolidation check box, if all items of the general ledger are to be posted automatically to the corresponding transaction type category with transaction type Addition to consolidation area. This ensures that the effects of the initial consolidation are displayed correctly also in the cash flow statement.

Detail view of an import with activated 'Execute data import as initial consolidation' check box

When activating the check box, three drop-down lists are displayed:

  • Choose the accounting period (posting month) and carry forward account for P&L values from the Accounting period and Carry forward account drop-down lists displayed.
  • If necessary, choose a subledger in the P&L drop-down list. All subledgers can be selected.
4

Configure the data import (see section Configuring the Data Import).

5

Import the data (see section Executing the Data Import).

Configuring the Data Import

Click Edit to configure the data import. The following options are available in the detail view of a data import:

OptionDescription
NameName of the data import
Data sourceThe data source to be used. You can choose from all data sources in the Data sources root folder.
ConfigureOpens the dialog with the properties of the data source. Used to check or change the data source(see chapter Defining the Data Source).
Assignment tableThe assignment table to be used. You can choose from all assignment tables in the Assignment tables root folder.

If necessary, a description of the data source is displayed on the Additional information tab. The description of a data import is optional and can currently be entered only in Lucanet.Financial Client.

Importing Data

To import data:

1

Click 1. Import. The Configuration dialog is displayed:

Dialog for the configuration of the import parameters
2

Enter the data level and the desired adjustment level and add the Excel file to be imported in the Data source field.

3

Click Save. If there are any missing assignments, these assignments will be displayed in the detail view of the import:

Detail view with the display of missing assignments
4

Click 2. Assign. The assignments are displayed, for example as follows:

Assignment table with missing assignments
5

Check the assignments and, if necessary, edit any missing assignments (see chapter Assigning Data).

6

Save the data import by clicking 3. Save.

  • Every newly-created data import can only be saved when the import has been successfully performed and all elements have been assigned so that debit = credit is guaranteed in the general ledger (assets side = equity and liabilities side).
  • If a data import is to be performed for a period, a reporting entity, a data level or a adjustment level disabled by any audit trail, an error message is displayed. If necessary, switch to Lucanet.Financial Client to edit the relevant audit trail.

As soon as a data import has been successfully saved, the data of the created postings are displayed on the Postings tab. You can open the details of each posting by clicking the corresponding link in the Posting column.

Furthermore, the data source and assigment table used for this import can be accessed via a link in the general properties of the data import.

Detail view of a data import with the 'Postings' tab. The tab heading is outlined in red. A posting is displayed on the 'Postings' tab.
'Postings' tab with a created posting

Last updated on Aug 16, 2023

Table of Contents
Creating and Executing the Data ImportOverviewCreating a Data ImportConfiguring the Data ImportImporting Data
Related Articles

Company

Legal Notice

© Copyright 2026 - Lucanet AG