Skip to main content
Mass beneficiary upload - Multibeneficiary file

How to use our platform to upload beneficiaries in bulk

Vitaliy Lytvynyshyn avatar
Written by Vitaliy Lytvynyshyn
Updated over 4 months ago

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:

Did this answer your question?