Skip to content

Convert a bank CSV to MT940 or CAMT.053

Klarbon reads a bank's CSV export in beta and writes MT940 or CAMT.053 from it when the CSV names the account. If the CSV gives no opening balance, Klarbon asks for it, then checks that the opening balance plus the transactions gives the closing balance. Your bank's own MT940 or CAMT.053 stays the first choice: accounting software can refuse a file a bank did not produce.

On this page 7

How does Klarbon turn a CSV into MT940 or CAMT.053?

  1. Download your transactions as CSV in online banking and drop the file on Klarbon.
  2. Klarbon finds the header row, also below lines with the account or the period, and works out the separator, the character set, the decimal comma or point and how money in and out are marked. It leaves out transactions the bank marks as not yet booked.
  3. If a date or an amount could be read two ways, the file names no currency or it holds no balance, Klarbon asks you. A row it cannot read stops the whole file, with the line number.
  4. You see a free preview with the account, the period, the balances and the balance check. Compare it with your bank statement, then choose MT940 or CAMT.053. For MT940, confirm the statement number Klarbon suggests from the closing date. MT940, CAMT.053 and OFX cost one credit per started 500 transactions; CSV and Excel are free on the site.

Which bank CSV files does Klarbon read?

These are the layouts Klarbon knows, each read in beta. Rabobank's and Qonto's come from the banks' own descriptions; the others come from descriptions and sample files published by third parties, and Klarbon's test file for each is synthetic.

Market Banks MT940 or CAMT.053?
Germany Sparkasse, Volksbank Raiffeisenbank, DKB, ING, Commerzbank, Postbank yes
Germany N26 no: the file names no account; CSV, Excel and OFX with the account typed in
Netherlands Rabobank, ING, Knab, bunq yes
Belgium KBC, Belfius yes
International Wise, Revolut, Qonto no: the files name no account; CSV, Excel and OFX with the account typed in
Any other bank a CSV whose date and amount columns Klarbon recognises by name; check the preview yes, if the file names the account

Some banks print a balance after each row, and Klarbon takes the opening and closing balance from it. A balance "as of" the day you exported, as DKB, Postbank and Belfius print above the table, is not used, because bookings after your period can be in it.

What should you do instead, if you can?

What you have What to do
Access to online banking Download MT940 or CAMT.053 from your bank for the period you need. It is the bank's official file; check which one your software asks for.
Your bank gives CAMT.053, your software wants MT940 Convert it with CAMT.053 to MT940 and back. Free preview with the balance check, then one credit per started 500 transactions.
Only a CSV from your bank Drop the CSV on Klarbon and choose MT940 or CAMT.053, as above. Test the file with one short statement in your software first.
You want the transactions in a spreadsheet CAMT.053 to Excel or MT940 to Excel, free on the site, also as CSV. Klarbon turns a bank CSV into Excel for free too.
Only a PDF statement Klarbon reads a PDF statement too: a draft with a balance check and a free preview, then one credit per started ten pages. Compare it with the PDF before you import it. See bank statement PDF to MT940.

Pages on single banks show where their own downloads are. For CAMT.053: ABN AMRO statement to Excel, Rabobank business statement to Excel, Wise statement to Excel and Revolut Business statement to Excel. For OFX: Qonto transactions to Excel.

What goes wrong with a constructed MT940?

  • The file can be refused. Moneybird, a Dutch accounting package, takes only official MT940 files from banks and says a self-made MT940 often does not match a bank's file exactly and then cannot be processed (Moneybird, in Dutch). An MT940 that Klarbon writes from a CSV is such a file.
  • The balances can be wrong. When the CSV holds no balance, you type the opening balance in yourself. Klarbon then checks that the transactions add up, not that the opening balance or every row is right. A typing error stays in your books until they no longer agree with the bank.
  • Transactions can arrive twice. If you import the same period from your bank's file and from a converted one, the two can differ in small details, so your software may not see them as the same transaction. Never import one period from both.

A file Klarbon writes is not your bank's file. The balance check confirms the arithmetic, not that your software will accept the file or that no transaction is missing; compare the result with your bank statement and test with one short statement first.

Frequently asked questions

Can Klarbon convert a CSV file to MT940 or CAMT.053?

Yes, in beta, when the CSV names the account. Klarbon knows the column layouts of a number of German, Dutch and Belgian banks and reads other bank CSV files by their column names, with a note on the preview to check it. MT940 and CAMT.053 both need an account number. An export without an account column, such as N26's, Revolut's, Wise's or Qonto's, can still become CSV, Excel or OFX, with the account typed in for OFX.

What if the CSV has no balances?

An MT940 or CAMT.053 file starts with an opening balance and ends with a closing balance. When the CSV has a balance after each transaction, such as Saldo na trn at Rabobank or Saldo at KBC, Klarbon takes the balances from it and says they were worked out. Otherwise Klarbon asks you for the opening balance; take it from a statement from your bank.

Why is my bank's own MT940 or CAMT.053 still the first choice?

It is your bank's official file, with its balances and statement number. An MT940 that Klarbon writes from a CSV adds up, but your accounting software can still refuse a file a bank did not produce. If your bank offers MT940 or CAMT.053, download that.

My bank offers CAMT.053 but my software wants MT940. What now?

Convert the CAMT.053 file with Klarbon. Reading it is in beta, the preview with the balance check is free, and MT940 costs one credit per started 500 transactions. Test the result with one short statement in your software first.

What about a CSV from PayPal, a credit card or a payment app?

Klarbon tries to read it, in beta, if it recognises the date and amount columns. If the file names no account, MT940 and CAMT.053 are not possible, but CSV, Excel and OFX are. Such an export is often not a complete statement either; check whether your accounting software connects to that service directly.

Sources

Updated 21 November 2026

Klarbon, https://klarbon.app/csv-to-mt940