Convert MT940 to OFX

Turn MT940 files into OFX. 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 your money app can import.Each MT940 booking becomes an OFX transaction, grouped by account and currency.

  1. What you get

    One OFX 2.1.1 file with a statement for each account and currency. Credit card accounts become credit card statements.

    Each transaction keeps its posting date and amount. Its type is kept when it is an OFX type, and otherwise it is CREDIT or DEBIT, chosen by the sign of the amount. The id is the FITID, or one made from the row when the bank gives none.

  2. How the details are read

    Every statement line gives a row with the account from :25:, the booking date, the signed amount, the statement's currency, the type, your 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 as plain text.

  3. Limits and defaults

    The payee goes into NAME cut to 32 characters, with up to 100 characters in EXTDNAME. The memo is cut to 255 characters. A numeric reference becomes CHECKNUM.

    The ledger balance is the closing balance the statement gives, or 0.00 when it has none. A statement without a currency or bank number gets XXX and 000000000.

    Each balance is counted from the opening balance when the count meets the statement's closing balance. An MT942 interim report is not converted and stops with unsupported_elements.

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

OFX Bank Statement

Open Financial Exchange, the statement download of North American banks and card issuers that Quicken, GnuCash and most money apps import; QFX is Quicken's flavor of it.

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

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

terminal
$ cv convert report.sta report.ofx
$ cv convert report.sta report.ofx

Questions.What people ask about MT940 to OFX.

01OF 04

No. An MT942 interim report stops the conversion with unsupported_elements.

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

Yes. NAME holds up to 32 characters, and EXTDNAME holds up to 100. The memo holds up to 255 characters.

The ledger balance is then 0.00. A statement without a currency or bank number gets XXX and 000000000.

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