How to generate a bulk transfer using a .CSV file?

You can initiate up to 400 transfers at once by uploading a .CSV file in your Qonto app. You will find a downloadable template at the end of this article.

You can export a .CSV file from a simple Excel table.

💡 However, please ensure that your file includes these columns: beneficiary_name,iban,amount,currency,reference. They're all necessary for the execution of the transfer.

To initiate a bulk transfer using a .CSV file, simply follow these steps :

1. On the left-hand side of your screen, click on Business Account section on your desktop webapp

2. Click on the Transfers tab

3. Choose the Bulk transfer in Euros option.

4. Click on the .CSV file box to chose CSV format

5. Download the .CSV template we prepared for you and complete it, making sure that you respect the following formats:

Column	Description	Example
beneficiary_name	Name of the receiver of your payment. Maximum 140 characters.	"Supplier 1"
iban	Must be part of the SEPA scheme.	"FR76 0000 0000 0000 0000 0000 000"
amount	The amount you send to the beneficiary. Includes 2 decimals.	"123.45"
currency	As of today, we only accept Euro transfers.	"EUR"
reference	The note attached to the transfer. Up to 140 characters maximum.	"Invoice 123"

6. Upload it to your Qonto app. You can drag & drop your file or click on the drag & drop zone to select it from your computer.

💡 If the format is incorrect, a red window will appear.

7. You can schedule your transfers and organize them in categories if necessary.

8. Check each transfer that appears at the bottom of your screen ; if everything's right, you can confirm your bulk transfer.

💡 If you realize there is a mistake after confirming it, do not worry: you can cancel a single transfer by going back to the Transfers section of your app and clicking on the right one.

All the beneficiaries are then automatically saved in your beneficiary list.

💡 If you have set up Strong Customer Authentication on your account, you will receive a confirmation request on your associated phone.

⚠️ Make sure that:

your file contains less than 400 transactions
there is no missing field
your file only contains operations in EUR
your file does not contain an IBAN outside the SEPA scheme
the beneficiary name or the reference are not too long
your file does not contain any special characters (é, è, ¨, ^....)
your account has been topped up before proceeding
you do not invert any columns of your file, and respect the template downloaded

☝️ Depending on the accountant software you use, all your data can appear in one tab. You will need to separate each of them in several columns.

If you are using Excel:

Select the column with the data then go on the menu ➡️ Data ➡️ Convert
Choose “delimited”
Then specify the type of separation between each data (space, comma or other)
Select the columns where the data should be moved
Click on “finish” and it’s done !

If you are using Google sheets:

Select the relevant column then click on the ➡️ Data tab ➡️ Split text into columns
Choose the type of separation between each data (space, comma or other)
Select the columns where the data should be put
Hit “Enter” and voila!