camt.053 to Excel: read ISO 20022 bank statements
camt.053 is the XML bank statement of the ISO 20022 standard, replacing MT940. Convert camt.053, camt.052 and camt.054 files to Excel in your browser.
Convert a statement now PDF, camt.053 or MT940 · stays on your computer
camt.053 (Bank to Customer Statement) is the electronic bank statement in XML of the ISO 20022 standard. It contains everything MT940 had and more: name and IBAN of the counterparty, the full remittance information, end-to-end references and the details of batch bookings. Its relatives are camt.052 (intraday report) and camt.054 (debit/credit notification).
Convert camt.053 to Excel
- Download the camt file from your online banking (an
.xmlfile, sometimes inside a ZIP: unzip it first). - Drop it on KontoXL. All versions are recognised (camt.053.001.02 to .001.13).
- Download Excel or CSV: one row per booking, with counterparty, IBAN, purpose and reference in separate columns.
Details that matter
- Batch bookings (several direct debits in one booking) stay one row, so the totals match the bank balance; the single transactions are listed in the description.
- Pending entries (status
PDNG) are left out and counted, because they are not booked yet. - The balance check uses the opening (
OPBD/PRCD) and closing (CLBD) balances of the file.
Convert a statement now PDF, camt.053 or MT940 · stays on your computer