Information about formats

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 - SEPA credit transfer in Germany

Applicable to RIB (Pro) and RDC and SWIFT FileAct

This format is based on the ISO20022 standard and is applicable to SEPA Credit Transfers. This format is mainly used in Germany.

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

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

Exampleformat CAMT.053

Exampleformat CAMT.053

• Format description CAMT.053 (valid until 1st July 2019) (PDF)
• Format description CAMT.053 (valid from 14th January 2019) (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 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).

Example format SWIFT MT940 Structured

• Format description SWIFT MT940 Structured (valid until 1st July 2019) (PDF)
• Format description SWIFT MT940 Structured (valid from 14th January 2019) (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 (valid until 1st July 2019) (PDF)
• Format description CAMT.052 (valid from 14th January 2019) (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 MT942 Structured (valid until 1st July 2019) (PDF)
• Format description SWIFT MT942 Structured (valid from 14th January 2019) (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 (valid until 1st July 2019) (PDF)
• Transaction type codes (valid from 14th January 2019) (PDF)

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)

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

 

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