RadarPricesOrderHome › APIs › Business & tax
Bank Statement Converter
Turns a bank statement file (camt.053 or MT940) into a normal table you can open in Excel, and checks that the balances add up.
Used by: Accountants, finance teams, online shops selling to businesses.
Convert bank statements without software or AI: camt.053 (ISO 20022, versions .001.02 to .001.08, also camt.052) and MT940 files, single or zipped, to clean JSON, CSV, Excel (xlsx) or back to MT940 for older accounting tools. Every statement gets a balance check (opening + entries = closing). Counterparty name, IBAN, BIC, remittance text, end-to-end ID, mandate and creditor ID, bank transaction code and German ?20-?33 / Dutch /TRTP/ fields are parsed. Files are processed in memory only and never stored. Monitor mode returns only transactions not seen before.
Try it live, no sign-up
Run the example as is, or change the input. 5 own tries a day without a key.
Example request
curl -X POST https://radarbg.com/v1/bank-statement-converter \
-H "X-API-Key: YOUR_KEY" -H "Content-Type: application/json" \
-d '{"fileContent": ":20:STMT1\n:25:DE02120300000000202051\n:28C:1/1\n:60F:C261101EUR1000,00\n:61:2611021102D25,00NTRFNONREF\n:86:Coffee\n:62F:C261102EUR975,00", "fileName": "statement.sta", "format": "json", "inputFormat": "auto"}'
Answer: {"ok": true, "count": N, "items": [...], "usage": {...}}. Failed calls are not counted.
Inputs
| Field | Type | Description |
|---|---|---|
fileUrl | string | Public http(s) link to a camt.053, camt.052 or MT940 file, or a .zip with several (max 10 MB, 50 files). For example a pre-signed S3/Drive link. Private and local addresses are refused. Leave empty and fill File content instead, or leave bo |
fileContent | string | The statement itself: raw XML / MT940 text, or base64 of the file (zip allowed). Max 10 MB. Processed in memory only, never stored or logged. |
fileName | string | Optional original file name, used as sourceFile in the rows and as the name of the output file (for example statement-2026-11.xml). |
format | string | json = one row per statement (balances + balance check) and one row per transaction; csv or xlsx = one row with the file as base64 (contentBase64) plus statement summaries; mt940 = camt converted to MT940 text (also base64). |
inputFormat | string | auto detects camt (XML) or MT940 by content. Set it only if detection fails. |
onlyNew | boolean | With format json: return only transactions not returned before under this Monitor ID (useful when a daily feed repeats yesterday's entries). Only one-way hashes of the transaction keys are kept, never the statement. |
monitorId | string | Name of the feed for only-new mode, for example account-de-main. Each Monitor ID keeps its own memory. |
Price
Included in every plan: 500 calls a month free, then from €5 a month for 5,000 calls across all APIs.
Questions
What does the Bank Statement Converter do?
Turns a bank statement file (camt.053 or MT940) into a normal table you can open in Excel, and checks that the balances add up.
Where does the data come from?
Convert bank statements without software or AI: camt.053 (ISO 20022, versions .001.02 to .001.08, also camt.052) and MT940 files, single or zipped, to clean JSON, CSV, Excel (xlsx) or back to MT940 for older accounting tools. Every statement gets a balance check (opening + entries = closing). Counterparty name, IBAN, BIC, remittance text, end-to-end ID, mandate and creditor ID, bank transaction co
How much does it cost?
500 calls a month are free with no card. Paid plans start at EUR 5 a month for 5,000 calls and include every API on Radar. Failed calls are not counted.
Can I use it without writing code?
Yes. Try it live on this page, use our free browser tools, or ask us to run it on your list as a service.