---
title: "Exchange Rate Management"
description: "The Exchange rate management functional area allows you configure the exchange rates that product solutions on the Lucanet CFO Solution Platform use to convert between currencies."
source_url: https://support.lucanet.com/en/documentation/administration/exchange-rate-management
language: en
last_updated: 2026-06-01
---
# Exchange Rate Management

## Overview

The **Exchange rate management** functional area allows you to configure the exchange rates that solutions on the Lucanet CFO Solution Platform use to convert between currencies. For each currency combination, you choose whether the rates are retrieved automatically from the **European Central Bank** or from an **Excel file** you upload yourself.

{% info-box %}
Exchange rate management is currently used by the solution Lease Accounting only.
{% /info-box %}

## Prerequisites

To use the **Exchange rate management** functional area, your user account must have access to the **Administration** module in the platform (see [User Roles](https://support.lucanet.com/en/documentation/administration/user-management/users/user-roles.md)).

Exchange rate management is available in the menu under **Administration | Exchange rate management** and contains two workspaces:

- **Exchange rates** — manage currency combinations and view their corresponding rates.
- **Custom upload of exchange rates** — upload your own exchange rate file and review past uploads.

## Adding Currency Combinations

To add one or more currency combinations:

{% stepper %}
{% stepper-step %}
Navigate to **Administration | Exchange rate management | Exchange rates**. The **Exchange rates** workspace is displayed as follows, for example:

'Exchange rates' workspace
{% /stepper-step %}
{% stepper-step %}
Click **Add currency combinations**. The **Create New Currency Combination(s)** dialog is displayed:

'Create New Currency Combination(s)' dialog
{% /stepper-step %}
{% stepper-step %}
In the dialog, fill in the following fields:

- **Currency 1** — the source currency. Start typing to search the list of ISO 4217 currency codes (for example, _EUR - Euro_).
- **Currency 2** — the target currency. Search the same way.
- **Source** — choose where the rates for this combination are retrieved from:

 - **European Central Bank** — rates are pulled automatically from the ECB.
 - **Exchange rate upload** — rates come from the Excel files you upload in the **Custom upload of exchange rates** workspace (see the following section).
{% /stepper-step %}
{% stepper-step %}
Click **Add combination**. The combination is added to the pending list inside the dialog and the input fields are cleared.

Repeat the previous step for every combination you want to add.
{% /stepper-step %}
{% stepper-step %}
Once the pending list contains all the combinations you want, click **Save**.
{% /stepper-step %}
{% /stepper %}

{% info-box %}
Each combination is bidirectional. When you add **EUR → USD** with the European Central Bank source, **USD → EUR** is configured automatically with the same source. Only one row per pair is displayed in the table, marked with a double-way arrow.
{% /info-box %}

## Uploading Exchange Rates

If any of your currency combinations use the **Exchange rate upload** source, you must provide the rates yourself by uploading an Excel file in the **Custom upload of exchange rates** workspace on a regular basis.

### Downloading the Exchange Rate File Template

Before you upload an exchange rate file for the first time, download the official exchange rate template to make sure your file matches the required structure. To download the exchange rate template:

{% stepper %}
{% stepper-step %}
Navigate to **Administration | Exchange rate management | Custom upload of exchange rates**.
{% /stepper-step %}
{% stepper-step %}
Click **Download template**. An .XLSX file is downloaded to your computer.

'Custom upload of exchange rates' workspace with the 'Download template' link
{% /stepper-step %}
{% stepper-step %}
Open the downloaded exchange rate template and fill in your exchange rates.

Exchange rate file template
{% /stepper-step %}
{% /stepper %}

{% info-box %}
The template uses the same structure as the exchange rate file used in Consolidation & Financial Planning. If you already work with that file, you can reuse it directly.
{% /info-box %}

### Uploading the Exchange Rate File

To upload the exchange rate file:

{% stepper %}
{% stepper-step %}
In the **Custom upload of exchange rates** workspace, choose one of the following options to upload the file:

- Drag and drop the file onto the upload area.
- Click **choose a file** and pick the file from your file browser.

Only .XLSX files are supported. The maximum file size is approximately 10 MB.

The system validates the file. If any issues are detected, a validation summary is displayed listing the affected rows and the **Import exchange rates** button appears below the summary, or at the bottom of the page, if no summary is shown.

An example of a validation summary after uploading an exchange rate file
{% /stepper-step %}
{% stepper-step %}
Click **Import exchange rates.** This triggers the following:

- The validation summary updates to show how many exchange rates were saved. Any skipped rows remain listed in the validation summary.
- The uploaded exchange rate file appears in the **Upload history** table at the bottom of the **Custom upload of exchange rates** workspace.
- The imported exchange rates are stored in the **Exchange rates** workspace under their respective currency combination.
{% /stepper-step %}
{% /stepper %}

{% info-box %}
Only exchange rates whose period is up to the current date are imported. Future periods are listed in a warning and skipped automatically.

Exchange rates for currency combinations whose source is set to **European Central Bank** are also skipped — the configured source always takes precedence. You can change the source of a combination in the **Exchange rates** workspace by deleting the combination and re-creating it with the desired source.
{% /info-box %}

## Viewing Exchange Rates for a Currency Combination

Each currency combination accumulates many exchange rates over time — one per date and rate type. These exchange rates appear in the currency combination as soon as they are retrieved: automatically from the ECB for **European Central Bank** combinations, or imported from your uploaded exchange rate file for **Exchange rate upload** combinations. You can review the stored rates directly in the **Exchange rates** workspace:

{% stepper %}
{% stepper-step %}
Navigate to **Exchange rate management | Exchange rates** and select the currency combination you want to inspect.
{% /stepper-step %}
{% stepper-step %}
Review the exchange rates. The detail view includes the date, the rate value, the rate type, and the source.

Exchange rates are sorted by date in descending order by default. Use the filters, sorting, and pagination controls to narrow down what you see.

Detail view of an exchange rate
{% /stepper-step %}
{% /stepper %}

## Deleting a Currency Combination

To remove a currency combination you no longer need:

{% stepper %}
{% stepper-step %}
Navigate to **Administration | Exchange rate management | Exchange rates**.
{% /stepper-step %}
{% stepper-step %}
In the **Existing combinations** table, click the **Delete** icon on the row of the combination you want to remove. The **Delete Currency Combination** dialog is displayed:

'Delete Currency Combination' dialog
{% /stepper-step %}
{% stepper-step %}
In the **Delete currency combination** dialog, review the consequences listed below, then click **Delete** to confirm:

- Historical exchange rates and any calculations based on historical rates **are not** removed.
- Exchange rates that have already been used in product solutions **remain** in those solutions.
- Future uploads for the deleted combination are blocked until you re-create it.
{% /stepper-step %}
{% /stepper %}

{% warning-box %}
Before deleting a currency combination, review which product solutions depend on it. Deleting a combination prevents future exchange rate uploads for that currency pair, but existing values used in dependent solutions are kept as they are.
{% /warning-box %}