Importing Exchange Rates

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

Organization Elements

Currency Translation

Creating and Configuring Currencies

Creating and Configuring Exchange Rate Tables

Importing Exchange Rates

Exporting Exchange Rates

Partner

Data Levels

Adjustment Levels

Transaction Types

Fiscal Years

Reporting Entities

Configuring Values of Attributes

Excel-Integration

Workspace Configuration

ESG Reporting

Disclosure Management

XBRL Tagger

Lease Accounting

Banking & Cash Management

Data Collection

Tax Compliance & Reporting

Glossary

Exchange rates for exchange rate tables can either be queried from the European Central Bank or imported from MS Excel.

Exchange rates can be queried online from the ECB and imported at the same time into one or more exchange rate tables. All the EURO exchange rates of these currencies, as well as all the exchange rates between these currencies, can be queried.

To call up the exchange rates from the ECB:

Right-click the root folder Exchange rate tables or an individual exchange rate table.

Choose Import | Import exchange rates from European Central Bank from the context menu . The Import Exchange Rate From European Central Bank dialog is displayed:

‘Import Exchange Rate From European Central Bank’ dialog

Specify the exchange rate table, data level, and period.

Click Import.

All of the exchange rates in the selected data levels and in the selected time period defined in Lucanet are updated on the basis of the exchange rates from the ECB.

The most recently available exchange rate of the respective month is used as the closing exchange rate.

The average exchange rate is determined in Lucanet by calculating the average using the daily closing exchange rates of the month. This means that the ECB calculation method is used.

To import exchange rates from MS Excel:

Right-click the Exchange rate tables root folder.

Choose Import | Import exchange rates from MS Excel from the context menu.

Navigate to the desired file and click its name.

Click Import or press Enter to start the import.

The import can be carried out successfully only if the structure of the Excel file matches the structure of an exchange rate file export file (see Exporting Exchange Rates).

Last updated on Aug 16, 2023

Importing Exchange Rates

Overview

Importing Exchange Rates from the ECB

Importing Exchange Rates from MS Excel

Overview