Convert MT940 to XLSX

Turn MT940 files into XLSX. 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

A bank statement as an Excel sheet.Each booking becomes one row, with the payee and memo split out.

  1. What you get

    An XLSX workbook with one sheet, named after the file. The rows sit under a bold, frozen header, and the columns are the same as in the CSV conversion.

    Every statement line gives a row. It 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. Each balance is counted from the opening balance when the count meets the statement's closing balance.

  2. Payee and memo

    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.

  3. How cells are stored

    Dates are date cells shown as YYYY-MM-DD. Amounts and balances are number cells shown with as many decimals as the file wrote. Every other column is text, so account numbers and ids keep their leading zeros and all their digits.

  4. When it stops

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

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

Excel Workbook

Excel's workbook format since 2007. Sheets, formulas, formats and charts in zipped XML.

Extensions
.xlsx
MIME type
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Kind
Documents

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

terminal
$ cv convert report.sta report.xlsx
$ cv convert report.sta report.xlsx

Questions.What people ask about MT940 to XLSX.

01OF 04

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

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

The file is an MT942 interim report. Only statements are converted.

Yes. You can merge XLSX files once each statement is converted.

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