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 group transfer using a .CSV file, simply follow these steps.
1 - Create a new bulk transfer
On the left-hand side of your screen, click on Business Account section on your desktop webapp then on the Transfers tab. Choose the Bulk transfer in Euros option.
2 - Select the .CSV format
To initiate a bulk transfer, you can choose between 2 types of file format: the .XML one, or the .CSV one. Just click on the .CSV file box.
3 - Upload your .CSV file once completed
Once you downloaded the .CSV template we prepared for you, you can complete it. Please ensure 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" |
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.
Here are the common errors you can do:
your file contains more than 400 transfers,
there is a missing field,
your file contains one or several operations that are not in Euros,
your file contains one or several IBAN that are not part of the SEPA scheme,
the beneficiary name or the reference is too long,
your file has special characters (é, è, ¨, ^....)
you have to top-up your account before proceeding,
you inverted one or several columns of your file, or you have not respected the template you downloaded.
☝️Depending on the accountant software you work with, all your datas can appear in one tab. You will need to separate each them in several columns.
To do so if you are using excel :
Select the column with the datas 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 a Google sheets user :
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!
4 - Plan and organize your transfers
You can schedule your transfers and organize them in categories if necessary.
5 - Verify and confirm
Once you uploaded your .CSV file on your app, you just have to check each transfer that appeared on 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.