Qonto

Helpcenter

Your request was successfully submitted.
Contact us

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

You can initiate up to 200 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 the Transfers section. Then, 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. Max 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 correct, this zone turns green. If not, it goes red.

Here are the common errors you can do:

  • your file contains more than 200 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,
  • 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.

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.

Do you still have questions?

If you can't find the answer to your question in our FAQ, you can always contact us. We will answer you shortly!