Information about formats
Initiation and reporting formats within Rabo Business Banking, Rabo Direct Connect (RDC) and SWIFT FileAct, you can exchange files between your own systems and those of Rabobank. Below you will find more information about the standardized formats.
Initiation of payment and direct debit files
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.
This format is based on the pain.001.001.03 standard and supports different type of payments:
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.
This is the format used for SEPA Direct Debits. You can use this format with all Dutch banks.
The status information reports rejected Euro payments and rejected Euro direct debits.
Pain.002.001.03 – Status information
This format provides status information on rejected SEPA payments and direct debits, urgent domestic europayments, urgent europayments, worldpayments (payments outside the SEPA area) and multibank payments.
Why choose pain.002?
Is your software ready?
Please contact your software vendor to determine whether your software supports the format you would like to use.
These files are used to provide information about the processed transactions on your account. These files can be downloaded from Rabo Business Banking (Pro) 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.001.02 - Statement
This format contains information about processed transactions and the balance on your account. It contains only information over closed book dates (end of day).
Why choose CAMT.053?
Advantages
Possible disadvantages
SWIFT MT940 Structured - Statement
This format contains information about processed transactions and the balance on your account. It contains only information over closed book dates (end of day).
Why choose SWIFT MT940 Structured?
Advantages
Possible disadvantages
CSV – Statement / Intraday report
This format contains information about processed transactions on your account (End of day and intra-day).
Why choose CSV?
CSV Credit card
This format shows credit card transactions which are made with credit cards issued from 12th of Februari 2020.
Format description CSV Credit card (csv-extension) (available end of July 2020)
Manual import CSV format in Excel
CSV Cost overview
This format contains an overview of the incurred business payment costs and fees.
CAMT.052.001.02 – Intraday report
This format contains information about processed transactions on your account during the business day (intraday).
MT942 Structured – Intraday report
This format contains information about processed transactions on your account during the business day (intraday).
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.
Transaction type codes
In the document below you will find a description of the transaction type codes used in the reporting of the downloadformats (only CAMT and MT formats).
Applicable to Rabo Business Banking, Rabo Direct Connect and SWIFT FileAct.
This format is based on the ISO 20022 standard and support Sepa Direct Debit and Sepa Credit Transfer.
CSV
Use these formats to update your address directory for payments in Rabo Business Banking (Pro).
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: