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.
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)
PAIN.008
This is the format used for SEPA Direct Debits. You can use this format with all Dutch banks.
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.
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 (expected implementation Q4 2018)
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 Q4 2018)
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)
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 Q4 2018)
MT942 Structured
This format contains information about processed transactions on your account during the business day (intra-day).
Format description MT942 Structured
Format description SWIFT MT942 Structured (expected implementation Q4 2018)
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.
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 (expected implementation Q2 2018 / Q4 2018)
CSV
Use these formats to update your address directory for payments and direct debits in Rabobank Internet banking Professional.
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.