Convert MT940 to JSON

Turn MT940 files into JSON. 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 of JSON.Each booking in an MT940 file becomes one object with the amount, date and payee.

  1. What you get

    One JSON file that holds an array with an object for each statement line. Each object has the keys account, date, amount, currency, payee, memo, reference, balance, type, category and id.

    The account comes from :25:, the currency is the statement's currency, and the id is the bank's reference. The reference is the customer's reference. Dates are written as YYYY-MM-DD.

  2. Amounts and balances

    Amount and balance are numbers with the digits the file wrote. Money out is negative. Each balance is counted from the opening balance when the count meets the statement's closing balance. A balance the file does not give is null.

  3. 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 taken as plain text.

  4. When it stops

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

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

JSON

JSON, the data format of every API.

Extensions
.json
MIME type
application/json
Kind
Text and data

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

terminal
$ cv convert report.sta report.json
$ cv convert report.sta report.json

Questions.What people ask about MT940 to JSON.

01OF 04

Yes. Amount is negative for money out.

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

No. An MT942 interim report stops with unsupported_elements.

The file does not give a balance for that row, so the value is null.

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