Exchange Rates File Import

Administrators can import FX rates into the system using a .csv file. This process automatically triggers the recalculation of model, property, and request/project data based on the updated rates. Users can also manually trigger recalculation if they possess global permission to create FX rates.

CSV File Structure

The .csv file used for importing FX rates must follow this structure:

Year

Month nr

Currency

FX Rate

2022

11

SEK

9.98

2022

11

USD

1.0

  • Decimal Separator: Dot .

  • Field Separator: Semicolon ;

  • No Thousand Separators: Ensure that no thousand separators are used.

Example CSV Rows:

Year;Month nr;Currency;FX Rate
2022;11;SEK;9.98
2022;11;USD;1.0

Handling Currency FX Rates

  • A currency's most recent FX rate (based on Year and Month nr) will be applied for all future periods until a new FX rate is provided.

  • For example, if the last rate for SEK is from November 2022, that rate will be applied for all future months and all years until a newer rate is imported.

Steps to Import FX Rates

  1. Navigate to the Admin Page:

    • Go to Administration → Common> Integrations to importing FX rates. See the screenshot below.

  2. Upload the CSV File:

    • Ensure the file follows the correct format.

    • Click "Import" to begin the process.

  3. Automatic Recalculation:

    • After importing, the investment model, expenditures, and request/project data will automatically recalculate based on the new FX rates.

image-20240826-121248.png

The location within the admin interface to manually perform FX rate import

Search