Convert a Rabobank business bank statement to Excel
Beta This tool is in beta. It is tested on sample files, and details may still change. Review the result before relying on it.
For Rabobank business accounts: download your transactions as CAMT.053 and convert the file to Excel or CSV for free, with a balance check first.
In short
Turn a bank statement file or a PDF statement into Excel, CSV, CAMT.053, MT940 or OFX. Klarbon reads a PDF statement into a draft; check the result before you use it. CSV and Excel free from bank files, otherwise 1 credit (€1.99).
To turn a Rabobank business bank statement into Excel or CSV, download your transactions from Rabobank as a CAMT.053 file and drop it on Klarbon. Klarbon splits Rabobank's batches into single payments, checks the PRCD opening balance against the closing balance and writes the result at no charge. Reading CAMT.053 is in beta. These steps are for Rabobank business accounts, as Rabobank's business help page describes them.
How do I download a CAMT.053 file from Rabobank?
Rabobank's help page names the menus in Dutch (checked on 10 November 2026, source). For a custom transaction overview ("Transactieoverzicht op maat"):
- Open "Transacties downloaden" and choose "Betaal- en spaarrekeningen".
- Choose the account or accounts.
- Choose a "Downloadformaat" and the period. Choose CAMT.053 (.xml). The period can be days, months or since your last download, up to 12 months for one account and 3 months for all accounts together.
- Click "Downloaden".
The monthly statements (rekeningafschriften) open as PDF; the CAMT.053 file comes from the transactions download.
What is particular about Rabobank's CAMT.053?
Rabobank describes its files in a "Formaatbeschrijving CAMT.053". Three points show in Klarbon:
- Batches are split. A collection or payment batch is one entry with every payment listed under it, each with its own amount. When those amounts add up to the entry, as they should, Klarbon writes one row per payment with its own counterparty, IBAN and description.
- The opening balance is PRCD, the previous day's closing balance, which Rabobank uses where other banks write OPBD. Klarbon treats both as the opening balance for the check.
- One description line per payment. Rabobank fills a single remittance line, so each row's description is that payment's remittance text, on one line.
How do I convert it with Klarbon?
- Drop the file on the box above. If you downloaded several accounts together, each account is a statement of its own in the preview.
- Check every statement's balance check, then the rows.
- Choose Excel or CSV and download it: one file per account, named after the last four characters of its IBAN and the period.
Klarbon is not affiliated with Rabobank. The menu names above are Rabobank's and can change; if they differ, follow Rabobank's own help page.
And the PDF rekeningafschrift?
Klarbon reads it into a draft to check against the PDF, and a download from it costs one credit per started 10 pages. The CAMT.053 file costs nothing to convert and needs no reading of a page. MT940 or OFX written from the CAMT.053 file cost one credit per started 500 transactions.
Related
Frequently asked questions
Which download format should I choose at Rabobank?
CAMT.053 (.xml). Of Rabobank's business formats it is the end-of-day statement with balances. CAMT.052 and MT942 are intraday reports, the CSV download opens in beta but carries no opening or closing balance, and MT940 Structured (.swi) opens in the converter for [MT940 to Excel](page:mt940-excel-en).
Does this work for a private Rabobank account?
This page covers business accounts, because that is what Rabobank's business help page describes. For a private account, Rabobank's help page does not list the download formats, so check the "Downloadformaat" list in your online banking for CAMT.053.
Why does my statement number look like 26308?
Rabobank numbers its CAMT statements with five digits, the year and the booking day of the year, so 26308 is day 308 of 2026. Klarbon keeps it. A target with a shorter field, such as CODA with three digits, gets a number worked out from the closing date instead, which you confirm before the file is written.
Can I convert Rabobank's own CSV?
Yes, in beta. Klarbon reads Rabobank's CSV layout as its format description sets it out and takes the balances from the Saldo na trn column. CAMT.053 still proves more, because it prints the opening and closing balance themselves.
Sources
Related
- Open any e-invoice. Check it. Convert it.
- Klarbon help centre
- Bank statement tools
- Convert CAMT.053 to Excel and CSV
- What is CAMT.053?
- Convert a CAMT.053, MT940 or OFX bank statement to Excel
- Convert a CAMT.053, MT940 or OFX bank statement to CSV
- Why do my statement balances not match?
- Supported bank statement files
- Simple pricing for invoices and bank statements
- What happens to my files?
- E-invoicing in the Netherlands: current and planned rules
- Understanding Bank CSV export
- Understanding Excel workbook (XLSX)
- Convert a bank statement PDF to CAMT.053
- Convert a Commerzbank CSV export to Excel