Lucanet Lease Accounting uses interest rates to calculate the current value of lease payments. Interest rates are key to determining lease liability and the right-of-use asset for the balance sheet.

To provide a basis for accounting leases, interest rates can be managed in the workspace of the same name. New interest rates can either be created manually or added by importing CSV files.

Interest rates can also be entered manually during the creation or modification of a contract component, which will override pre-configured interest rates, if any were set.

To allow calculation of country-specific interest rates and rates for different asset classes, each interest rate is always created for a specific combination of asset class, country or region and currency. In addition to this, the interest for each interest rate is split into maturity brackets.

To ensure that an interest rate can be used for a specific asset class, start by creating the asset class in the Asset Classes workspace.

The Interest rates workspace in Lease Accounting displays all the interest rates that have already been created:

Shows the 'Interest rates' workspace in Lucanet Lease Accounting with the upload area 'Attach file using drag and drop, or browse' and 'Supported formats: CSV', the 'Add interest rate' button, and a table with the columns 'Asset class', 'Currency', 'Country or region', 'Valid from', 'Last modified on', 'Created', and 'Last modified by', listing interest rates in 'EUR' for 'Germany' valid from '2020-01-01' for the asset classes 'Real Estate', 'Machinery', and 'Car Fleet'. Highlighted in red is the 'Interest rates' item in the 'Settings' navigation.
The 'Interest rates' workspace

To create an interest rate in Lease Accounting, click Add interest rate.

The New interest rate dialog is displayed:

Shows the 'New interest rate' dialog in Lucanet Lease Accounting with the 'General' section containing the 'Asset class', 'Currency', 'Country or region', and 'Valid from' fields, the 'Yearly interest' section containing the fields 'Up to 1-year duration' to 'Up to 5-year duration' with the value '0,00' in percent, and the 'Cancel' and 'Save' buttons.
The 'New interest rate' dialog

Fields marked with a * are mandatory fields.

When configuring an interest rate in Lease Accounting, the following options are available:

OptionDescription
Asset classAsset class to which the interest rate applies

Note: Only those asset classes that have already been created in the Asset classes workspace will be available to choose from.
CurrencyCurrency to which the interest rate applies
Country or regionCountry or region to which the interest rate applies
Valid fromDate from which the interest rate will apply
Yearly interestAssignment of interest rates to maturity brackets. To do this, enter the applicable interest rate for each lease term.

The lease terms range from Up to one year to Undefined year (terms > 20 years).

As an alternative to manual creation, you can also import interest rates into Lease Accounting as CSV files:

Shows the upload area 'Attach file using drag and drop, or browse' with 'Supported formats: CSV' and the 'Add a new interest rate' button in the 'Interest rates' workspace in Lucanet Lease Accounting. Highlighted in red is the upload area.
Area for importing interest rates

To add the CSV file with interest rates in Lease Accounting, select one of the following options in the area above the overview table:

  • Click Browse and upload the required CSV file.
  • Use the Drag & Drop method to add the required CSV file.

Once this is done, click Start import.

CSV Import Templates

To make automatic imports easier for you, we have provided a template for the CSV file. The structure of this template matches that required for the import.

The CSV file includes instructions on how to add the data.

Use the following link to download the template for interest rate imports in Lease Accounting:

This content was generated using AI and reviewed by Lucanet subject matter experts before publication.