Overview:
The Bulk FX Upload feature is a premium feature.
It supports file uploads in XLSX or CSV formats.
The maximum file size allowed is 2MB.
You can watch this video that guides you through how to use the bulk foreign exchange feature:
Video length: 2 Minutes
Alternatively, follow the step-by-step instructions below.
Prerequisite: The Bulk FX Upload feature is part of the premium functionality in the Foreign Exchange Module. Please confirm your subscription with your system administrator or sales team before proceeding.
Step 1: Prepare the file
Format: The file must be either a XLSX or CSV.
Content:
The first column must contain dates formatted as 'yyyy-mm-dd' or in Excel date format.
The second column should contain the numerical exchange rate.
A header row is optional.
Size: The file should not exceed 2MB.
Use this template as a guide for preparing your file: bulk_fx_template.xlsx
Step 2: Click Foreign Exchange Rates. Choose an existing currency pair or create a new one to upload foreign exchange rates for.
Step 3: Click on Upload csv/xlsx
Step 4: Click Upload a file or drag and drop your prepared file into the upload area.
Handle duplicates: Specify how duplicates should be treated.
Header row: Check the box if your file contains a header row to avoid processing it as data.
Step 5: Click Upload to complete the process. Once the file is successfully uploaded, your foreign exchange rates will be available for use.
FAQs:
When should I use Bulk FX Upload function? Use the Bulk FX Upload feature when you can easily extract exchange rates from your ERP system or export them from a trusted source.
Further reading: