Online SEPA XML message generator for business payments orders and direct debits orders help


Setting Remark
Column layout in CSV data in all batches Using a spreadsheet program such as Excel, you can create payment orders or direct debit orders and then convert it to a CSV file.

The CSV data layout differs for each user, for example:

Greenpeace;5.00;NL31INGB0000000044;INGBNL2A;1;Next line
Donation Greenpeace;Jollemanhof 15-17;1019 GW Amsterdam
Bakkerij Top;135.20;NL91ABNA0417164300;ABNANL2A;2;Next line
Jubilee Klaasen;Zuiddijk 17;1501 CA Zaandam
Het Zadeltje;10.00;NL92INGB0000230000;INGBNL2A;3;Next line
Bicycle repair;Nieuwe Uilenburgerstraat 114;1011 LX Amsterdam
Essent;225.54;NL19INGB0002000400;INGBNL2A;4;Next line
Gas may;Papendorpseweg 91;3528 BJ Utrecht
T. Klaasen;2345.67;NL57RABO0115592474;RABONL2U;5;Next line
Salary payment may;Zandzuigerstraat 53;1333 MV Almere

Specify the column number for each of the following fields:
  • Name
  • Amount
  • IBAN number
  • BIC code
  • Payment reference
  • Description
  • Street an number
  • Zip and city
  • Ultimate name
  • Mandate reference
  • Mandate date of signing
According to the CSV data above, the CSV data layout looks like:

Name is in column number: 1
Amount is in column number: 2
IBAN number is in column number: 3
BIC code is in column number: 4
Payment reference is in column number: Absent
Description is in column number: 6
Street and number is in column number: 7
Zip and city is in column number: 8
Ultimate name is in column number: Absent
Mandate reference is in column number: Absent
Mandate date of signing is in column number: Absent

As you will notice column number 5 contains sequence numbers. This column is ignored. It is recommended to delete unused columns because each value increases your browser memory consumption and might affect your browser performance.

The amount, BIC code and IBAN number are required.