Importing and Exporting Exchange Rates
You can create and update exchange rates through a CSV file. For example, you can import the exchange rates you are using in your enterprise resource planning (ERP) system into the system so that the rates match in both systems.
You can import exchange rates with a CSV file by doing the following:
- Export a copy of the CSV file structure.
- Populate the CSV file with currency rate information.
- Import the CSV file into the system.
To export a copy of the CSV file structure
- Go to the Company Workspace tab and switch to Admin mode.
- In the left Navigator, click Standards & Libraries > Exchange Rates. The Exchange Rates log opens
- Choose File > Export.
Depending on your browser, the CSV file will be automatically downloaded or you will be prompted to download the file manually.
To populate the CSV file with exchange rate information
- Open Microsoft® Excel (or another program compatible with the CSV format), and open the exported CSV file.
- Enter currency exchange rate information in the spreadsheet. The fields are discussed in the table below.
Notes:
- Do not delete or change the order of the columns.
- Successful import creates a currency exchange rate set with the Active status.
- Only the currency code is validated, but the system will add to the exchange rate set the values you specify in the CSV upload file.
- Only the absolute value for the exchange rate is considered. If you enter a negative value, the negative sign is dropped and only the value is considered.
- You can enter new rates, or update existing rates.
- Only the first five decimal values of the exchange rate are imported; if less than five decimal values are entered, zeros are added during the import to add up to five values.
- If you remove an exchange rate from the CSV file, the rate is retained in the system, and is not deleted.
- If there are errors in the CSV file, the system will not import the CSV file.
- Save in CSV format.
In this column: | Do this: |
---|---|
Currency Name | Enter the name of the currency. For example, United States Dollar. This currency name is not validated and is for reference only. |
Currency Code | Enter a valid currency code. Only the Currency Code is required and validated. |
1.0 Base Currency = | Enter the exchange rate for the currency. The number you enter rounds at ten decimal places. Enter numbers and decimal points only; do not enter special characters. |
To import the CSV file
- Go to the Company Workspace tab and switch to Admin mode.
- In the left Navigator, click Standards & Libraries > Exchange Rates. The Exchange Rates log opens
- Choose File > Import to import the completed CSV file.
- Click Browse and navigate to where you saved the file.
- Click OK to import.
Only files with exchange rate information in the correct format will be imported. If the upload fails, the CSV file will contain an error message that explains why the upload failed. The user who imported the CSV file is listed in the Audit log as the User.
To fix import errors
- Re-open the CSV file.
- Delete rows that were successfully imported.
- Fix the rows that were not imported correctly.
- Re-import the file.
To export exchange rates to your desktop
- Go to the Company Workspace tab and switch to Admin mode.
- In the left Navigator, click Standards & Libraries > Exchange Rates. The Exchange Rates log open.
- Choose File > Export.
Depending on your browser, the CSV file will be automatically downloaded or you will be prompted to download the file manually.
Last Published Thursday, December 14, 2023