Convert MT940 to QIF

Turn MT940 files into QIF. 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 ready for Quicken.Each booking in the MT940 file becomes a transaction in a QIF file.

  1. What you get

    One QIF file with an !Account block and a !Type section for each account in the statement. The account comes from the :25: line.

    Every statement line becomes one transaction. It has the booking date, the signed amount, the payee, the memo and the category. The customer's reference is written as the check number. Dates are written month first as MM/DD/YYYY.

  2. Payee and memo

    The payee and the memo come from the :86: details. The conversion reads the ?20 to ?33 subfields that German banks write, the /NAME/ and /REMI/ keywords, or plain text.

  3. What it leaves behind

    QIF has no place for a currency, a balance, a transaction type or an id. These are dropped, so the statement's currency and the bank's reference do not appear in the QIF file.

    Before the conversion, each balance is counted from the opening balance. The count has to meet the statement's closing balance.

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

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

Quicken QIF

Quicken Interchange Format, the plain-text list of transactions with dates, amounts, payees and categories that Quicken, Microsoft Money and many banks export.

Extensions
.qif
MIME type
application/x-qif
Kind
Text and data

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

terminal
$ cv convert report.sta report.qif
$ cv convert report.sta report.qif

Questions.What people ask about MT940 to QIF.

01OF 04

No. QIF holds no currency, so it is dropped. Amounts are written as signed numbers only.

From the :86: details. It is read from the ?20 to ?33 subfields, from /NAME/ and /REMI/ keywords, or from plain text.

No. An MT942 interim report stops with unsupported_elements.

It is dropped, because QIF has no id. The customer's reference is kept as the check number.

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