How to generate a bulk transfer using a .CSV file?
Julie avatar
Written by Julie
Updated over a week ago

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.

Did this answer your question?