Convert an ABN AMRO 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.
Download your ABN AMRO transactions as CAMT.053, then convert the file to Excel or CSV for free. Klarbon checks the balances and shows a preview.
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 an ABN AMRO bank statement into Excel or CSV, download your transactions from ABN AMRO as a CAMT.053 file and drop it on Klarbon. Klarbon checks ABN AMRO's PRCD and CLBD balances against the entries and writes the spreadsheet for free. Reading CAMT.053 is in beta. The steps below are for a private account in ABN AMRO Internet Bankieren or the ABN AMRO app.
How do I download a CAMT.053 file from ABN AMRO?
ABN AMRO's help page names the menus in Dutch (checked on 10 November 2026, source). In Internet Bankieren:
- Log in and open "Bij- en afschrijvingen downloaden" (download transactions).
- Choose the account holder and the file format: pdf, txt, mt940, xls or camt.053. Choose camt.053.
- Choose a start date and an end date. Transactions go back up to 18 months.
- Click the download symbol to the left of the account you want, and save the file.
In the ABN AMRO app, go to "Profiel" > "Rekeningen en betalen" > "Afschriften en jaaroverzicht", choose the account holder, tap "Bij- en afschrijvingen" under "Soort overzicht", then choose the dates and the format camt.053.
The monthly statements (rekeningafschriften) come as PDF only; the camt.053 file comes from the transactions download.
What is in an ABN AMRO camt.053 file?
ABN AMRO publishes an addendum to the CAMT standard for its files, version 1.5 of July 2015, written for camt.053.001.02. What matters for your spreadsheet:
- The opening balance has the code PRCD (previously closed booked) and the closing balance CLBD. Klarbon uses both for the balance check. The available balances (CLAV, FWAV) are informative and are not checked.
- Entries carry ABN AMRO's own mutation codes, listed in Annex A of the addendum. They do not become a column; the description and the counterparty do.
- Outgoing SEPA batches are reported as one entry with the total, without the single payments.
How do I convert it with Klarbon?
- Drop the camt.053 file on the box above.
- Check the period and the balance check in the preview, then the rows.
- Choose Excel or CSV and download it.
Klarbon is not affiliated with ABN AMRO. The menu names above are ABN AMRO's and can change; if they differ, follow ABN AMRO's own help page.
The other downloads, and a PDF
Klarbon does not read the xls or txt download. The mt940 download is read too, by the converter for MT940 to Excel. Klarbon reads a PDF rekeningafschrift into a draft, and a download from it costs one credit per started 10 pages; compare it with the original before you import it. From the camt.053 file, Excel and CSV are free; MT940 or OFX written from it cost one credit per started 500 transactions.
Related
Frequently asked questions
Which file should I download from ABN AMRO?
camt.053. Of the five choices ABN AMRO offers (pdf, txt, mt940, xls and camt.053), it is the one that carries the booked opening and closing balance next to every transaction in its own field, so Klarbon can check the period before writing anything.
How far back can I go?
ABN AMRO says you can download your transactions up to 18 months back. Older months are only available as monthly statements (rekeningafschriften) in PDF.
Why is a SEPA batch one row in my sheet?
ABN AMRO's CAMT description does not list the single payments of a batch you sent, only the batch total. Klarbon cannot split what the file does not contain, so the batch is one row with its total. Your payment overview in Internet Bankieren shows the payments inside it.
The file opens as one long line in a text editor. Is it broken?
No. ABN AMRO writes the whole XML without line breaks, as its description allows. Klarbon reads it the same way as an indented file.
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