Convert MT940 to TSV
Turn MT940 files into TSV. 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 statement rows in a spreadsheet.Each booking in the MT940 file becomes one tab-separated row.
What you get
A single TSV file with one row for every statement line. The header is account, date, amount, currency, payee, memo, reference, balance, type, category and id.
The account comes from :25:. The date is the booking date, written as YYYY-MM-DD. The currency is the statement's currency. The reference is the customer's reference, and the id is the bank's reference.
Amounts and balances
Amounts are signed, negative for money out, and keep the digits the file wrote. Each balance is counted from the opening balance when the count meets the statement's closing balance. A balance the file does not give stays empty.
Payee and memo
The :86: details fill the payee and the memo. The converter reads the ?20 to ?33 subfields that German banks write, the /NAME/ and /REMI/ keywords, or plain text.
MT942 reports
An MT942 interim report is not converted. The conversion stops with
unsupported_elements.
MT940 and TSV.What each format is.
The formats
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
Tab-Separated Values
Tab-separated values.
- Extensions
- .tsv .tab
- MIME type
- text
/tab -separated -values - Kind
- Text and data
In your code.The same MT940 to TSV conversion through the API, for your app or your agent.
$ cv convert report.sta report.tsv$ cv convert report.sta report.tsvQuestions.What people ask about MT940 to TSV.
Yes. MT940 files can use the sta, mt940 or 940 extension.
Yes. Amounts are signed, and money out is negative.
No. An MT942 interim report stops with unsupported_elements.
Yes. Once each statement is a TSV file, you can merge TSV files into one.