Plainjar
← Back to the blog

— zzp —

Convert a bank statement CSV to MT940 or CAMT.053 (no upload)

4 min read

Export your bank statement as a CSV, drop it into the tool, check which column plays which role, and download an MT940 or CAMT.053 file. Those are the formats that Moneybird, e-Boekhouden and most accounting packages import. Everything happens in your browser; your transactions are never uploaded.

You use a neobank or a credit card, or you receive payments through PayPal, Revolut or Wise. At the end of the month you want those transactions in your bookkeeping, and you hit a wall: all you have is a CSV, but your accounting package wants MT940 or CAMT.053. Retyping everything by hand is error-prone, and the online converters that do it want you to upload your bank data to their server.

The Bank statement to MT940 / CAMT.053 tool does the conversion in your browser. You drop your CSV in, the tool guesses which column is the date, the amount and the counterparty, you check it, and you download a file your accounting package accepts.

The 'Bank statement to MT940 / CAMT.053' tool on Plainjar: drop your CSV in, map the columns and download MT940 or CAMT.053.

Why your bank CSV does not just import

Almost every accounting package wants a bank statement in MT940 or CAMT.053, two formats banks agreed on decades ago. A plain CSV is often refused outright: Moneybird states in its own help section that CSV is not supported for bank import, and Jortt and WeFact also ask for MT940 or CAMT.053.

At the same time every bank and fintech exports the CSV its own way: different column names, a different order, a comma or a semicolon as separator, and its own date format. So there is no single conversion that works "for all banks". That is exactly where the friction is, and exactly what this tool solves by letting you map the columns.

From CSV to MT940 or CAMT.053

You do not need to install anything. Export your transactions as a CSV in your banking app or at your fintech, and drop the file into the tool. The bank statement converter recognises known banks automatically and suggests a column for each role: the date, the amount, the counterparty and the description. If something is off, you fix it with one click. A preview below shows straight away whether the transactions are read correctly.

Then you download the result as MT940 (a plain text file) or CAMT.053 (an XML file). Not sure which you need? Try MT940; it is accepted almost everywhere. If your package does not recognise it, use CAMT.053.

Works with every bank and fintech

Because you map the columns yourself, the tool also works with an export your accounting package normally rejects. Whether the amount is in one column with plus and minus, in a separate debit/credit field, or in separate debit and credit columns: you pick the right variant and the tool converts it. Date formats like 20260105, 05-01-2026 or 2026-01-05 are recognised, and you set whether the decimal separator is a comma or a dot.

Why in your browser

A bank statement is exactly the kind of file you do not want to upload casually: it holds your account number, your balance and who you do business with. The existing converters run on a server, often behind a paywall, so your file goes there. With this tool everything happens on your own device. Open your browser's Network tab and you will see no upload at all. Close the tab and it is all gone.

How to do it

  1. Export your transactions as a CSV in your banking app, at your credit card or at PayPal, Revolut or Wise.
  2. Open Bank statement to MT940 / CAMT.053 and drop the CSV in, or paste it.
  3. Check the suggested columns and the preview. Enter your own IBAN if it is not already there.
  4. Download MT940 or CAMT.053 and import it into your accounting package.

Want to be sure the account numbers in your records are valid first? You can do that with bulk IBAN validation. And to clean up a CSV that opens wrong in Excel there is fixing a CSV in Excel.


Convert your statement: Bank statement to MT940 / CAMT.053. In your browser, and your bank data stays yours.

Frequently asked questions

Which format does my accounting package need, MT940 or CAMT.053?

It depends on the package. Moneybird, e-Boekhouden and many others accept CAMT.053; MT940 is accepted almost everywhere and is a safe first choice. You can download both and try the one your package recognises.

Does this work with Revolut, Wise, bunq or PayPal?

Yes, as long as you can export a CSV. Every bank and fintech uses its own column names, so you map the columns yourself or let the auto-detection do it. That way even an export your accounting package normally rejects will work.

Are my bank transactions uploaded?

No. The entire conversion happens in your browser. Your CSV, your IBAN and your transactions are never uploaded or stored. Paid converters do send your file to their servers; that is not needed here.

Why do I have to enter my own IBAN?

MT940 and CAMT.053 put the account number at the top of the statement so your accounting package can match the import to the right account. If your IBAN is already in the CSV, it is prefilled for you.

Convert a bank statement CSV to MT940 or CAMT.053 (no upload) — Plainjar