Convert MT940 to PARQUET

Turn MT940 files into PARQUET. 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 table of rows.Each booking in the MT940 file becomes one row in a Parquet table.

  1. What you get

    A Parquet file with one row for every statement line. Each 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 columns are typed

    The table has a column for each key of the json conversion, typed from the values. Dates become dates, amounts and balances become numbers, and the other columns are text.

    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. If you need to combine several resulting tables afterward, you can merge PARQUET files.

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

Parquet

The columnar data format of analytics. Compressed, typed and fast to scan.

Extensions
.parquet .pq
MIME type
application/vnd.apache.parquet
Kind
Text and data

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

terminal
$ cv convert report.sta report.parquet
$ cv convert report.sta report.parquet

Questions.What people ask about MT940 to PARQUET.

01OF 04

A row holds the account from :25:, the booking date, the signed amount, the currency, the type, the customer's reference and the bank's reference as the id. The payee and memo come from the :86: details.

The ?20 to ?33 subfields that German banks write, the /NAME/ and /REMI/ keywords, and plain text.

No. Dates become dates, and amounts and balances become numbers. The other columns are text.

An MT942 interim report stops with unsupported_elements.

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