Online CSV to ClieOp file generator

Select language:    English      Dutch
 
ClieOp (short for clientopdrachten - client orders) is a file format supported by large Dutch banks. The processing of ClieOp files is provided by Equens (formerly Interpay) and is the largest pan-European payment processor and settles incoming and outgoing payments, incasso's (direct debits) and acceptgiro's (transfer forms) in the Netherlands.

ClieOp is designed for business clients to deliver multiple domestic payments orders or direct debits orders electronically to their banks using a single file. Most major banks offer their customers the option of using online banking to send in ClieOp files. You must have a business bank account and (usually) an additional agreement with your bank for using this.

This online service allows you to safely create ClieOp03 files with maximum 1000 items (transactions) per batch and maximum 2 batches. All entries are sent securely to Mobilefish.com. No data is stored in databases or files.
Please read the Mobilefish.com privacy policy.

ClieOp is an ASCII file with fixed record lengths.

ClieOp file example:
0001A071110CLIEOP03MFISH07011                     
0010B0003003003010001EUR                          
0030B1251110Mobilefish.com                     P  
0100A000000000000050003003003010000000044         
0160ADonation Greenpeace                          
0170BGreenpeace                                   
0173BAmsterdam                                    
0100A000000000001352003003003010417164300         
0160AJubilee Klaasen                              
0170BBakkerij Top                                 
0173BZaandam                                      
0100A000000000000100003003003010000230000         
0160ABicycle repair                               
0170BHet Zadeltje                                 
0173BAmsterdam                                    
0100A000000000002255403003003010002000400         
0150A1111222233334444                             
0160AGas and Electricity may                      
0170BEssent                                       
0100A000000000023456703003003010115592474         
0160ASalary payment may                           
0170BT. Klaasen                                   
0173BAlmere                                       
9990A00000000000027214120364887230000005          
9999A                                             

The above displayed ClieOp file is created based on the following data:
  • Number of batches: 1
  • Batch type: business payments
  • File creation date: 07-11-2010
  • Sender identification: MFISH
  • File identification: 0701
  • Duplicate code: Unicate
  • Delimiter used in CSV data in all batches: ;
  • Column layout in CSV data in all batches:
    • Name is in column number: 1(A)
    • Amount is in column number: 4(D)
    • Account number is in column number: 3(C)
    • Payment reference is in column number: 5(E)
    • Description 1 is in column number: 6(F)
    • 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: 2(B)
  • Transaction type: 0000
  • Name ordering party: Mobilefish.com
  • Account number ordering party: 300300301
  • Desired processing date: 25-11-2010
  • Test code: P
  • Receive beneficiary's name: Beneficiary's name not requested
  • Fixed description 1: -
  • Fixed description 2: -
  • Fixed description 3: -
  • Fixed description 4: -
  • Batch identification: -
  • CSV data:
    Greenpeace;Amsterdam;44;5.00;;Donation Greenpeace;
    Bakkerij Top;Zaandam;417164300;135.20;;Jubilee Klaasen;
    Het Zadeltje;Amsterdam;230000;10.00;;Bicycle repair;
    Essent;;2000400;225.54;1111222233334444;Gas and Electricity may;
    T. Klaasen;Almere;115592474;2345.67;;Salary payment may;
This online service creates ClieOp03 files based on the ClieOp03 file specifications written by Equens. Banks such as ING, ABN AMRO, Rabobank, etc. do not follow exactly the Equens ClieOp03 file specifications but they apply different rules when reading a number of ClieOp03 fields.
Contact your bank and ask what different rules they apply!

YOU USE THIS SERVICE AT YOUR OWN RISK. MOBILEFISH.COM WILL NOT BE LIABLE FOR ANY DATA LOSS, DAMAGES, LOSS OF PROFITS OR ANY OTHER KIND OF LOSS WHILE USING OR MISUSING THIS SERVICE.



Input online CSV to ClieOp file generator:


Number of batches*: Help     Changing this value will erase all entered data.
Batch type*: Help Information will be sent securely
File creation date*: Help Select date   Information will be sent securely
Sender identification*: Help Information will be sent securely
File identification*: Help Information will be sent securely
Duplicate code*: Help Information will be sent securely

Delimiter used in CSV data in all batches*: Help
Column layout in CSV data in all batches*: Help
Name is in column number
Amount is in column number *
Account number is in column number *
Payment reference is in column number
Description 1 is in column number
Description 2 is in column number
Description 3 is in column number
Description 4 is in column number
City is in column number

Batch 1
Transaction type *: Help
Information will be sent securely
Name ordering party*: Help Information will be sent securely
Account number ordering party *: Help Information will be sent securely
Desired processing
date *:
Help Select date    or process the batch at the first opportunity    Information will be sent securely
Test code *: Help Information will be sent securely
Receive beneficiary's name *: Help Information will be sent securely
Fixed description 1: Help Information will be sent securely
Fixed description 2: Help Information will be sent securely
Fixed description 3: Help Information will be sent securely
Fixed description 4: Help Information will be sent securely
Batch identification: Help Information will be sent securely
Upload the CSV file: Help       
           
CSV data *: Help Number of items       Max. 1000 items per batch allowed. Information will be sent securely

To prevent automated submissions an Access Code has been implemented for this tool.   access code
Please enter the Access Code as displayed
above. *:
 
* = required          
 


Output online CSV to ClieOp file generator:


   

To create a ClieOp file, do the following:
  1. Press the above mentioned "Select all" button to select all ClieOp data.
  2. Press Ctrl+C to copy the selection.
  3. Open the Notepad program.
  4. Press Ctrl+V to paste the selection in the Notepad (you must not add lines or remove spaces).
  5. Save the file.
Information will be sent securely

ClieOp overview:

 
   
Information will be sent securely