Information about formats

Initiation and reporting formats within Rabo Internet banking Professional

Read this the page in Dutch

This section provides information about all supported initiation and reporting formats. With these formats you are able to exchange information between your own systems and the Rabobank systems.

Initiation of payment and direct debit files
You can use initiation formats to import Direct Debit- and payment files in Rabo Internet Banking Professional. The files are exported from your own systems.

PAIN.001 (Generic Payment File)

This format is based on the pain.001.001.03 standard and supports different type of payments:

  • Europayments
  • Urgent Domestic Europayments
  • Urgent Europayments
  • Worldpayments (payments outside the SEPA area)
  • Multibank payments
Example format Generic Payment File (.zip) Format description Generic Payment File (PDF)

Pain.001.003.03 – pain formaat used in Germany

This format is used in Germany for SEPA Credit Transfers and can be used in addition to the pain.001.001.03.

The format is applicable to Rabobank NL-accounts and Rabo Network Banking accounts.

Format description pain.001.003.03 (PDF)

PAIN.008

This is the format used for SEPA Direct Debits. You can use this format with all Dutch banks.

Exampleformat pain.008

Format description SEPA DD XML (PDF)
Reporting transactions
These files are used to provide information about the processed transactions on your account. These files can be downloaded from Rabo Internet Banking Professional and imported in your own systems.

Which format should I use?

There is some diversity when it comes to reporting formats. Below you will find a description per format. With that description you will find information which should help you make an informed decision about which format best suits you.

CAMT.053

This format contains information about processed transactions and the balance on your account. It contains only information over closed book dates (end of day).

Example format CAMT.053

Format description CAMT.053 (PDF)

Why choose CAMT.053?

Advantages


The entire market is gradually switching to ISO20022 XML standards. Of all formats these formats will be most futureproof. Therefore you can expect less maintenance on your systems when using this format.Richer data set. The format enables the use of new services in answer to future business needsPossibility for detailed information. Every piece of information is supplied using its own XML tag.Realisation of efficient end-to-end business processes. Initiation files are also XML files and contain the same information under the same tags.

Possible disadvantages


More complex implementation. Entirely new format. Possibly a bigger impact on your ERP- or software implementation.Larger files due to more data. Check with your software vendor or IT-specialist if this poses any problems.

SWIFT MT940 Structured

This format contains information about processed transactions and the balance on your account. It contains only information over closed book dates (end of day).

Example format SWIFT MT940 Structured

Format description SWIFT MT940 Structured (PDF)

Why choose SWIFT MT940 Structured? 

Advantages


If you already use a version of the SWIFT MT940 Structured the impact on your IT is probably less then switching to a completely new format like CAMT.053.The SWIFT MT940 Structured is similar to the standard MT940 with the addition that SEPA specific information is added in the remittance information using structured code words.


Possible disadvantages


Limited room for information. The SWIFT MT940 Structured will eventually not be suited to deliver all information added in the future.


 

CSV

This format contains information about processed transactions on your account (End of day and intra-day).

Example file CSV (csv-extension)

Format description CSV (csv-extension) (PDF) Manual import CSV in Excel (PDF)

Why choose CSV?


CSV is a simple standard which is compatible with Excel.

CAMT.052

This format contains information about processed transactions on your account during the business day (intra-day).

Example format CAMT.052

Format description CAMT.052 (PDF)

MT942 Structured

This format contains information about processed transactions on your account during the business day (intra-day).

Example format MT942 Structured

Format description SWIFT MT942 Structured (PDF)

Why choose MT942S/CAMT.052?


Use CAMT.052/MT942S when you need information about booked transactions on your bank account during business days.Pros and cons are similar with MT940S and CAMT.053.

PAIN.002

This format provides status information on rejected SEPA transactions. Format description Pain.002 (PDF)

Why choose PAIN.002?

Use Pain.002 to gain insight in rejected transactions after importing an PAIN format.

Is your software CAMT.053 or MT940S ready?

The below document gives an overview of different software vendors and their preferred file format. Is your vendor not on this list? Ask your software vendor about this information and ask them to share the information with us so we can help inform other customers.

Transaction type codes

In this document you will find a description of the transaction type codes used in the reporting of the downloadformats (only CAMT and MT formats). Transaction type codes (PDF)
Update address book

CSV

Use these formats to update your address directory for payments and direct debits in Rabobank Internet banking Professional. Format description CSV Payment Directory (PDF)
Test service for formats

It is important that your formats adhere to the Rabobank specifications. This will prevent rejections from occurring during the processing of your payments. In our test portal it is possible to test your files.


Test if your files meet the Rabobank specifications

 

Differences in Rabobank Channels
The documentation on the following site will give you information about the differences which exist between Rabobank Cash Management and other Rabobank Channels. This documentation will help you when switching from one Rabobank channel to the another channel.

Changes Online Banking