Convert OFX to QIF

Turn OFX files into QIF. Every bank and credit card statement in the file, OFX 1 with its unclosed tags or OFX 2 in XML, gives a row for each transaction with the account number, the posting date, the amount, the currency, the payee, the memo, the check or reference number, the transaction type and the bank's transaction id.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop OFX files on the dialor turn it to pick what to do

Bank statements ready for Quicken and Microsoft Money.Every bank and credit card transaction in an OFX or QFX file lands in one QIF file.

  1. What you get

    One QIF file with an !Account block and a !Type section for each account in the statement. OFX 1 with its unclosed tags and OFX 2 in XML are both read.

    Each transaction gets a row with its date, amount, payee, memo and category. The reference is written as the check number. Dates are written month first, as MM/DD/YYYY.

  2. What it leaves behind

    QIF holds no currency, balance, transaction type or id, so those are dropped. The bank's transaction id does not carry over to the QIF file.

    Investment statements are left out. A file that holds only investment statements stops with unsupported_elements.

OFX and QIF.What each format is.

The formats

From · 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
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 OFX to QIF conversion through the API, for your app or your agent.

terminal
$ cv convert report.ofx report.qif
$ cv convert report.ofx report.qif

Questions.What people ask about OFX to QIF.

01OF 04

Yes. OFX 1 with its unclosed tags and OFX 2 in XML are both converted.

Yes. QFX is Quicken's flavor of OFX, and it is converted the same way.

No. QIF holds no currency, so it is dropped along with the balance, the transaction type and the bank's transaction id.

The file holds only investment statements. Investment statements are left out, so there is no bank or credit card transaction to write.

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