Ebury offers the ability to upload multiple beneficiaries in one shot.
Go to Add beneficiary in the top right corner and select from file
Then, download the sample in .csv
Please fill the .csv template as per the below instructions.
Column A - Beneficiary name: filled with no special characters "#~$%€&¬]Ǩ}@
Column B - Beneficiary Street Name: It is mandatory for Australian clients, Canadian clients, Brazilian clients, payments to Canada, Australia, Nigeria or payments in CAD, AUD or NGN. However, it is highly recommended to be included in all payments to all beneficiaries. If there is a beneficiary in INR, the bene's telephone needs to be filled in this field.
Column C - Beneficiary Building Number: It is mandatory for Australian clients, Canadian clients, Brazilian clients, payments to Canada, Australia, Nigeria or payments in CAD, AUD or NGN. However, it is highly recommended to be included to all payments to all beneficiaries
Column D - Beneficiary Floor: Not mandatory but recommended.
Column E - Beneficiary Apartment/Office: Not mandatory but recommended.
Column F - Beneficiary Post Code: It is mandatory for Australian clients, Canadian clients, Brazilian clients, payments to Canada, Australia, Nigeria or payments in CAD, AUD or NGN. However, it is highly recommended to be included to all payments to all beneficiaries
Column G - Beneficiary Country Sub Division: It is mandatory for Australian clients, Canadian clients, Brazilian clients, payments to Canada, Australia, Nigeria or payments in CAD, AUD or NGN. However, it is highly recommended to be included to all payments to all beneficiaries
Column H - Beneficiary City: It is mandatory for Australian clients, Canadian clients, Brazilian clients, payments to Canada, Australia, Nigeria or payments in CAD, AUD or NGN. However, it is highly recommended to be included to all payments to all beneficiaries
Column I - Beneficiary country: Two letters of the country of the beneficiary (or the bank). ES for Spain, CN for China, US for the USA, FR for France. This is the alpha-2 code.
Column J - Purpose Code: This field has to be left empty unless it’s a CNY payment to China or it’s a payment to UAE. In that case, please check the Note 2 at the end of this article.
Column K - CURRENCY - The currency that will be sent to that beneficiary
Column L - IBAN: to be written without blank spaces and/or hyphens. Find out more about IBAN structure and mandatory IBAN countries in this website. When European IBAN's have been added into Column L there is no need to add the account number in Column M
Column M - Account number: to be filled if the country does not have mandatory IBAN. Applicable to most African IBANs as well.
Column N - SWIFT codes must be added for all benes
Column O - Sort code: Must be written without blank spaces or hyphens and are just numbers. This column can be filled if there is an specific bank code apart from the SWIFT: only for certain currencies (Sort code- GBP, IFSC-INR, ABA/Routing-USD, BSB-AUD). If there is no specific bank code, leave this column blank
Column P - Bank Name: Leave blank
Column Q - Bank Address: Leave blank
Column R - Bank country: Two letters of the country of the beneficiary (or the bank). ES for Spain, CN for China, US for the USA, FR for France. This is the alpha-2 code. It must be the same as the letters 5 and 6 of the SWIFT code
Column S - Beneficiary reference: Permanent reference to that beneficiary. Please check the requirements for each currency and if there are any extra details needed, they need to be input here except for the countries/currencies here
Column T - Reason for Payment: Leave blank unless the bene is related to any of the currencies/countries in Note 3 at the end of this article
Columns U, V, W, X - INN, VO, KIO, Russian central bank account: leave blank.
Note 1: For GBP payments to UK - IBAN + SWIFT + 8 digit account number + 6 number sort code are mandatory.
Note 2: for CNY payments to China or payments to UAE, please fill the column L (Purpose code) with the codes below according to the reason of the payment
CNY |
|
Reason for payment | Code |
Trade Settlement for Goods | /CGODDR/ |
Trade Settlement for Services | /CSTRDR/ |
Charity Donation | /CCDNDR/ |
Trade Settlement for Goods - Partial return | /CGODDR/PART/ |
Trade Settlement for Services - Partial return | /CSTRDR/PART/ |
Payment to Current Account | /COCADR/ |
Payment to Capital Account | /CCTFDR/ |
|
|
AED - full list here |
|
Goods Sold | GDE |
Goods Bought | GDI |
Travel | STR |
Financial Services | FIS |
Salary | SAL |
Charitable Contributions | CHC |
Note 3: Countries and/or currencies where Purpose of payment needs to be included in field AE (Multipayment) or field T (Multibene)
If any of the fields of the file contains one of these currencies OR even one of these countries in another currency, field AE (Multipayment) or field T (Multibene) must be filled
BDT | Bangladesh |
CNY |
|
INR | India |
JOD | Jordan |
KES | Kenya |
LKR | Sri Lanka |
NGN |
|
PKR | Pakistan |
RUB | Russia |
For further assistance, feel free to contact Ebury support directly via live chat or at the below email addresses:
EMEA (operationsteam@ebury.com)
Asia Pacific (operationsteam.apac@ebury.com)
America (operationsteam.ca@ebury.com)