Convert MT940 to ODS

Turn MT940 files into ODS. 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 a spreadsheet.Each booking becomes a row in one ODS sheet, ready for LibreOffice Calc.

  1. What you get

    One ODS file with one sheet, named after the file. A bold header sits above the rows and uses the same columns as the CSV conversion.

    Every statement line gives a row. The row holds 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.

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

  2. How cells are typed

    Dates are date cells shown as YYYY-MM-DD. Amounts and balances are number cells shown with as many decimals as the file wrote, so you can sum and sort them.

    Every other column is text. Account numbers and ids keep their leading zeros and all their digits.

    Each balance is counted from the opening balance when the count meets the statement's closing balance.

  3. When it stops

    An MT942 interim report fails with unsupported_elements. The conversion stops with that code when it meets one.

    For other formats, see every ODS conversion.

MT940 and ODS.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 · ODS

OpenDocument Spreadsheet

OpenDocument spreadsheet, the native format of LibreOffice Calc.

Extensions
.ods
MIME type
application/vnd.oasis.opendocument.spreadsheet
Kind
Documents

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

terminal
$ cv convert report.sta report.ods
$ cv convert report.sta report.ods

Questions.What people ask about MT940 to ODS.

01OF 04

Yes. Account numbers and ids are stored as text, so leading zeros and all digits stay.

Yes. Amounts are number cells, shown with as many decimals as the file wrote. Dates are date cells shown as YYYY-MM-DD.

They come from the :86: details. The converter reads the ?20 to ?33 subfields, the /NAME/ and /REMI/ keywords, or plain text.

An MT942 interim report fails with unsupported_elements. The conversion stops with that code when it meets one.

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