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.
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.
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.
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
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
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.
$ cv convert report.sta report.ods$ cv convert report.sta report.odsQuestions.What people ask about MT940 to ODS.
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.