Bulk Upload - Exchange Rates

The below article is relating to the bulk upload - Exchange Rates which can be found by going to Administration -> Company -> Bulk Upload.

The Exchange Rates Bulk Upload can be found within the Non Core Data section:

This bulk upload allows you to add Exchange Rates to the system.

When you load the page the most important parts relating to bulk upload are at the top of the page:

CSV file to upload

This is where you will load your CSV when it is ready to upload. Press browse and select the CSV file.

Download help file and instructions

This option will download our bulk upload help file. This includes instructions on how to use each bulk upload and lets you know which columns are mandatory and which are optional, it's important to look at the relevant help file before performing a bulk upload so you can get it right the first time.

Download CSV Model

The second option downloads an example template for you to use for the bulk upload with all the headers needed for the bulk upload to be successful.

 

Editing your CSV:

When you download your sample CSV file it will look like this:

Date 1: The first date in the array that this exchange rate is valid within. This field must be entered in dd/mm/yyyy format and is Mandatory.

Date 2: The first date in the array that this exchange rate is valid within. This field must be entered in dd/mm/yyyy format and is Mandatory.

Currency: The currency this exchange rate is for, must be entered exactly as shown below:

• GBP
• EUR
• USD
• JPY
• AUD
• CAD
• ZAR
• SGD
• AED
• INR
• THB
• HKD
• PHP
• IDR
• FJD
• KES
• BWP
• BGN
• SAR
• DKK
• MYR
• CHF
• CZK
• CNY
• NZD
• BHD
• EGP
• OMR
• SAR
• XOF
• GTQ
• COP
• SEK
• MXN
• YEN

This field is Mandatory.

Rate: The exchange rate for this currency in relation to your default currency. This field is Mandatory.