Information about formats

Initiation and reporting formats within Rabo Internet banking Professional

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 (available Q2 2018)

Format description Generic Payment File

Example format Generic Payment File (.zip)

PAIN.008

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

Format description SEPA DD XML

Exampleformat pain.008

BTL91

This is the format used for cross-border payments. From 1st of May 2019 the BTL91 will not be accepted and you can use the new Generic Payment File.

Format description BTL91

Exampleformat BTL91

Differences BTL91 and Generic Payment File

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

Format description CAMT.053

Format description CAMT.053 (expected implementation Q2 2018)

Exampleformat CAMT.053

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 needs
  • Possibility 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).

Format description SWIFT MT940 Structured

Format description SWIFT MT940 Structured (expected implementation Q2 2018)

Exampleformat SWIFT MT940 Structured

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

Format description CSV (csv-extension)

Example file CSV (csv-extension)

Manual import CSV in Excel

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

Format description CAMT.052 (expected implementation Q2 2018)

Exampleformat CAMT.052

MT942 Structured

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

Format description MT942 Structured (expected implementation Q2 2018)

Exampleformat MT942 Structured

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

Technical explanation

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

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

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