Importing Data from Consolidation & Financial Planning into Income Taxes

If necessary, open Lucanet.Financial Client.

Switch to the Users and user groups workspace.

Select the Users root folder and choose New | Technical user from the context menu. The Create element dialog is displayed:

In the User area, enter the user name.

In the Password area, define the password.

Click OK or press Enter.

Open Tax Data Hub.

Navigate to the Datasources workspace and click Create. The following parameters are displayed:

Configure the parameters as follows:

Parameter

Description

Username

User name in Lucanet database

Password

Password of the database user

Database name

Database name

Lucanet client URL

URL of the server, e.g. https://lncloud1c3.lucanet.cloud

Click Next.

The system checks whether the connection to Lucanet Consolidation & Financial Planning can be established. If successful, a second column will appear with additional input fields for the configuration of the interface:

Parameter

Description

Ledgers

Selection of the general ledger

Level depth

The depth to which data are to be loaded from the source tree structure. The default value -1 means that the entire tree should be extracted.

Account level

The type of balance sheet objects to be imported. Available options are: All, Items, and Accounts.

Data level

Selection of the data level

Adjustment level

Selection of the adjustment level

Navigate to master data and Interfaces | Structure.

Click Create. The following dialog is displayed:

Configure the new structure. The following parameters must be configured:

Parameter

Configuration

Name

Name of the interface; displayed in the Import Suite workspace as the configuration interface

Direction

Import (enhanced)

Interface Type/Source

Select either Tax Data Hub - REST or Tax Data Hub - Financial Warehouse.

Destination

IFRS

Default Interface

Yes: The interface is displayed always in the Import Suite workspace.

No: The interface is displayed only if it is assigned to the company in the master data.

Open the Import Mapping workspace and select the created interface structure.

Click + and enter a template name and, if required, a description. Then click + again. The template will then be displayed, for example, as follows:

Click to download the template, i.e. the Excel file.

Edit the template and configure the Excel file as follows:

Field

Description

Schnittstelle

Enter the interface defined under Master Data | Interfaces | | Structure.

Bilance type

IFRS/Local GAAP

Mapping type

External => IFRS

Click to upload the edited template, i.e. the Excel file, again.

In Income Taxes, navigate to Master Data and select Companies.

On the Company data tab, enter the OID of the desired reporting entity in the Company assignment LN-Client field.

Click Update to save your entries.

Go to the Company | Import Suite workspace.

Select the configured interface.

Adjust the start and end dates if required. The suggested end date corresponds to the last day of the selected period, while the start date is generally January 1 of the relevant calendar year.

Click Import to start the process. After a few moments, the result is displayed as an import log:

This view of the log shows a condensed list of all successfully imported items. To view comprehensive details, including information on items that were not imported, click Import protocol.

Click Save to complete and save the import in the tax calculation.