This document describes the specifications for import files to update exchange rates in Acubiz.
Important Prerequisites:
System Currency: The system currency varies depending on the company's country-specific setup.
Exclusion: The system currency must NOT be included in the import file.
Rate Calculation: Rates must always be specified as the price in system currency (e.g., DKK) for 100 units of the foreign currency.
Scenario 1: Standard File (Currency and Rate Only)
Used for ongoing updates of current rates without history.
Data Structure
| Column | Field Name | Description | Format | Example |
| 1 | ISO Code | The foreign currency’s official ISO code | Text (3 characters) | EUR |
| 2 | Rate | Current rate per 100 units | Decimal (comma) | 744,94 |
File Example (CSV / Semicolon Separated):
Plaintext
EUR;744,94
USD;697,31
GBP;865,17
NOK;62,72
SEK;64,10
Scenario 2: Extended File (With Date)
It is recommended to include a date for the rate’s validity. This ensures full traceability, and the date will be displayed directly in Acubiz.
Data Structure
| Column | Field Name | Description | Format | Example |
| 1 | ISO Code | The foreign currency’s official ISO code | Text (3 characters) | EUR |
| 2 | Rate | Current rate per 100 units | Decimal (comma) | 744,94 |
| 3 | Date | Date of rate validity/update | DD-MM-YYYY | 13-04-2026 |
File Example (CSV / Semicolon Separated):
Plaintext
EUR;744,94;13-04-2026
USD;697,31;13-04-2026
GBP;865,17;13-04-2026
NOK;62,72;13-04-2026
SEK;64,10;13-04-2026
Comments
0 comments
Please sign in to leave a comment.