Convert MT940 to CSV

Turn MT940 files into CSV. Every statement line gives a row with the account from :25:, the booking date, the signed amount, the statement's currency, the type, the customer's reference and the bank's reference as the id.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop MT940 files on the dialor turn it to pick what to do

Bank statements as rows you can sort.Each booking in the MT940 file becomes one row in a CSV table.

  1. What you get

    One CSV file with a header row: account, date, amount, currency, payee, memo, reference, balance, type, category and id. Every statement line gives one row.

    Each row carries the account from :25:, the booking date, the signed amount, the statement's currency, the type, the customer's reference and the bank's reference as the id. Dates are written as YYYY-MM-DD. Amounts are signed, negative for money out, with the digits the file wrote.

  2. Payee and memo

    The :86: details fill the payee and the memo. They are read from the ?20 to ?33 subfields that German banks write, from /NAME/ and /REMI/ keywords, or as plain text.

  3. Balances

    Each balance is counted from the opening balance. The count has to meet the closing balance of the statement. A balance the file does not give stays empty.

    An MT942 interim report is not converted. The conversion stops with unsupported_elements.

MT940 and CSV.What each format is.

The formats

From · MT940

SWIFT MT940 Statement

The SWIFT customer statement that European banks offer as a download, with the opening and closing balances and each booking in tagged lines such as :61: and :86:.

Extensions
.sta .mt940 .940
MIME type
text/x-mt940
Kind
Text and data
To · CSV

CSV

Rows of comma-separated values. The plainest way to move a table between programs.

Extensions
.csv
MIME type
text/csv
Kind
Text and data

In your code.The same MT940 to CSV conversion through the API, for your app or your agent.

terminal
$ cv convert report.sta report.csv
$ cv convert report.sta report.csv

Questions.What people ask about MT940 to CSV.

01OF 04

Yes. Amounts are signed, and money out is negative. The digits are the ones the file wrote.

Dates are written as YYYY-MM-DD.

They come from the :86: details. These are read from the ?20 to ?33 subfields, from /NAME/ and /REMI/ keywords, or from plain text.

No. An MT942 interim report stops with unsupported_elements. If you have several CSV files afterwards, you can merge CSV.

More conversions.Other ways in and out of MT940 and CSV.