Convert a bank statement to reconciled CSV

Created by

Cedric Günther

Actor

CAMT.053 & MT940 Converter

Convert a CAMT.053 or MT940 bank statement into deterministic JSON and CSV, then verify opening-to-closing balance consistency.

Try for free

CAMT.053 & MT940 Converterceddl/bank-statement-standards-bridge

Record type

Source id

Status

Format

+11 fields

Input

Statements(required)

Source ID:source

Statement content:<?xml version="1.0" encoding="UTF-8"?> <Document xmlns="urn:iso:std:iso:20022:tech:xsd:camt.053.001.08"> <BkToCstmrStmt><Stmt><Id>S-1</Id><Acct><Id><IBAN>DE02120300000000202051</IBAN></Id><Ccy>EUR</Ccy></Acct> <Bal><Tp><CdOrPrtry><Cd>OPBD</Cd></CdOrPrtry></Tp><Amt Ccy="EUR">100.00</Amt></Bal> <Bal><Tp><CdOrPrtry><Cd>CLBD</Cd></CdOrPrtry></Tp><Amt Ccy="EUR">112.34</Amt></Bal> <Ntry><Amt Ccy="EUR">12.34</Amt><CdtDbtInd>CRDT</CdtDbtInd><BookgDt><Dt>2026-09-15</Dt></BookgDt> <ValDt><Dt>2026-09-15</Dt></ValDt><AcctSvcrRef>BANK-1</AcctSvcrRef><NtryRef>REF-1</NtryRef><AddtlNtryInf>Invoice 1</AddtlNtryInf></Ntry> </Stmt></BkToCstmrStmt> </Document>

Statement format:CAMT053

Validation mode:strict

Maximum transactions per statement:10000

Output fields

Record type

Source id

Status

Format

Statement id

Account id

Currency

Reconciliation status

Transaction count

Transaction id

Booking date

Amount

Credit debit

Reference

Error code

How it works

Sign up on Apify or log in

The CAMT.053 & MT940 Converter Actor is ready to run with the inputs already set for "Convert a bank statement to reconciled CSV". Sign up or log in and you'll land in Apify Console with a copy of this exact task.

Start the "Convert a bank statement to reconciled CSV" task

The CAMT.053 & MT940 Converter Actor will start running based on the input automatically. You can also change all the input fields, like statements, validation mode, and more, to match your specific use case.

Receive the "Convert a bank statement to reconciled CSV" output

Monitor the progress in real time. You will be notified as soon as your dataset is complete and ready for review. Each result includes data such as record type, source id, status, and more.

Integrate into your workflow

The final output is delivered in JSON, CSV, or Excel format, ready to be plugged into your workflow. You can also run the "Convert a bank statement to reconciled CSV" task via API.