Online CSV to ClieOp file generator 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:

44;Greenpeace;Amsterdam;5,00;10 jan 2010;Donation Greenpeace
417164300;Bakkerij Top;Zaandam;135,20;12 jan 2010;Jubilee Klaasen
230000;Het Zadeltje;Amsterdam;10,00;12 jan 2010;Bicycle repair
2000400;Essent;Ede;225,54;13 jan 2010;Gas and Electricity may
115592474;T. Klaasen;Almere;2345,67;18 mei 2010;Salary Payment may

Specify the column number for each of the following fields:
  • name
  • amount
  • account number
  • payment reference
  • description 1-4
  • city
According to the CSV data above, the CSV data layout looks like:

Name is in column number: 2
Amount is in column number: 4
Account number is in column number: 1
Payment reference is in column number: Absent
Description 1 is in column number: 6
Description 2 is in column number: Absent
Description 3 is in column number: Absent
Description 4 is in column number: Absent
City is in column number: 3

As you will notice column number 5 contains dates. 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 and account number are required.

The name is only required for 'unchecked' transaction types.
For some banks it is required to give up the city if it concerns business payments and only with 'unchecked' transaction types.

If batch type business payments is selected than these are the 'unchecked' transaction types:
  • 0000 - unchecked creditor payment to an account with maximum 7 digits
  • 0003 - unchecked salary payment to an account with maximum 7 digits
If batch type direct debits is selected than these are the 'unchecked' transaction types:
  • 1002 - unchecked direct debit off an account with maximum 7 digits
Note:
Unchecked items have account numbers with up to 7 digits (former giro account numbers). These numbers have no self validating mechanism (11-test). To check these account numbers for authenticity you must supply the corresponding name (and if necessary the city). The bank will then apply name-number checks. If you are sure the account numbers are correct, you may specify these items as checked items. For checked items, the name (and city) is not necessary and the bank shall not apply name-number checks on account numbers with up to 7-digits.

Account numbers with 9 or 10 digits have a self-validating mechanism (11-test). The bank will not apply name-numbers checks and items which such account numbers are always considered checked items.