Skip to main content
Adding beneficiaries from file

How to use Ebury online to upload beneficiaries in bulk by using a .csv or excel

Daniel Diaz avatar
Written by Daniel Diaz
Updated over a week ago

Ebury offers the ability to upload multiple beneficiaries in one shot.

How to add a file with beneficiary details?

Go to Beneficiaries in the top right corner and select Add from file

You will be then taken to the below page, where you will be able to download our sample file:

Complete the .csv template as per the below instructions (special characters ("#~$%€&¬]Ǩ}@...) are not allowed):

Column

Content

Mandatory

Notes

A

Account type

Yes

"Business" or "Personal"

B

Beneficiary name

Yes

C

Beneficiary street name

Recommended

1. & 2.

D

Beneficiary building number

Recommended

1.

E

Beneficiary Floor

No

F

Beneficiary Apartment/Office

No

G

Beneficiary Post Code

Recommended

1.

H

Beneficiary Country Sub Division

No

I

Beneficiary City

Yes

J

Beneficiary Country

Yes

K

Purpose code

CNY & UAE

3. & 4.

L

Currency

Yes

M

IBAN

If available

5.

N

Account number

If no IBAN

6.

O

Swift Code

Yes

P

Sort code

If available

7.

Q

Bank Name

No

Leave blank

R

Bank Address

No

Leave blank

S

Bank Country

Yes

T

Beneficiary Reference

Currency dependent

8.

U

Reason for payment

Currency and/or country dependent

9.

V

INN

No

Leave blank

W

VO

No

Leave blank

X

KIO

No

Leave blank

Y

Russian central bank account

No

Leave blank

If the file is submitted correctly, all beneficiaries will be added to your Ebury account.

Troubleshooting files

What happens when a file doesn't work as expected?

Click on "View invalid beneficiaries" and then go through each beneficiary to see what's the problem. The system will signal the erroneous field/s with a red exclamation mark “ⓘ”.

By following the above table, you should be able to troubleshoot the issues and, if not, feel free to reach out to our expert help via the live chat button.

Sometimes errors happen when the file structure is modified. If a field is not needed, do not "erase" the column - instead, just leave it blank.

Notes


Note 1. Mandatory for Australian, Canadian, Brazilian and Polish clients & beneficiaries, and payments in their currency. Recommended for all clients.


Note 2. For INR beneficiaries, include the phone number in this column before the street name.


Note 3. For CNY payments to China, input the corresponding code.


Note 4. For payments to United Arab Emirates, input the corresponding code.


Note 5. Input in digital format (no spaces or hyphens). For more information on how IBANs work, we recommend you check this independently.


Note 6. IBANs in certain countries under IBAN development that have not yet been catalogued for general international use should be inputted in this field (for instance, certain IBANs outside of EEA). In these cases, IBANs should be placed in the account number field.


Note 7. Also called ABA/Fedwire, BSB, Transit code, IFSC depending on the jurisdiction.


Note 8. Permanent payment reference. Certain currencies may have mandatory information that have to be included in this field. Check "Setting Up Beneficiaries: A guide to Currency Requirements" to see what applies.


Note 9. For the these countries and/or currencies, include one of the following:

BDT

Bangladesh

CNY

INR

India

JOD

Jordan

KES

Kenya

LKR

Sri Lanka

NGN

PKR

Pakistan

RUB

Russia

  • Purpose of Payment: Please specify one of the following:

    • Payment for goods

    • Payment for services

    • Charitable aid

    • Salary payment


For further assistance, feel free to contact Ebury support directly via live chat or at the below email addresses:

Did this answer your question?