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

  • Updated

You can initiate up to 400 transfers at once by uploading a .CSV file in your Qonto app. 

 

💡Good to know: It is possible to send bulk transfers as instant, but please note, we can’t guarantee that all bulk transfers will be processed as instant.

 

Furthermore, 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

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

1. Click on Business account in the menu on the left of your web app.
2. Click on Transfers and then on Make a transfer.
3. Select SEPA bulk transfer in euros→ Upload a file.

4. Download our CSV template and consult our guidelines for CSV files which are linked there to help you with correctly formatting your CSV file.
5. Once you are done with the formatting of your CSV file, drag and drop or click on the drag and drop zone to select your CSV file from your computer and upload it.

💡 An error message will appear If there are any issues with the file format or the contents of the file and specify which issue was encountered.
6. Click on Continue once your file has successfully been uploaded.
7. The web app will prompt you to Review transfers details
Here you can review transfer details and make any changes if necessary for each beneficiary from your uploaded file before clicking on Continue.

💡Any missing or invalid data will be highlighted in red with a brief description of the issue.
8. Select which account to debit and optionally schedule the transfer before clicking on Continue

💡 If you want the destination bank(s) to recognize this transfer as a payroll, you can enable that by toggling Salary payment on
9. Take a one last look at the summary and review if everything is correct before clicking on Confirm.

 

💡 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.

 

For 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 !

 

For 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!