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.
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.
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.
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
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
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.
$ cv convert report.sta report.qif$ cv convert report.sta report.qifQuestions.What people ask about MT940 to QIF.
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.