Convert QIF to OFX

Turn QIF files into OFX. Every transaction of the bank, cash, credit card and other asset or liability accounts gives a row with the account's name, the date, the amount, the payee, the memo, the check number and the category, and the categories of split lines are joined when the transaction names none.

Converted in an isolated sandbox on our serversDeleted after 24 hours

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

A bank statement your money app can import.Your QIF transactions become an OFX 2.1.1 file with a statement for each account.

  1. What you get

    One OFX file. It holds a statement for each account and currency in the QIF file. Credit card accounts become credit card statements.

    Bank, cash, credit card and other asset or liability accounts are read. 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 by its sign.

    Each transaction gets an id. The id is the FITID from the source, or one made from the row when there is none.

  2. How fields are written

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

    The ledger balance is the closing balance the source gives. Without one, it is 0.00.

  3. What it leaves behind

    Investment transactions are left out. QIF holds no currency, so a statement without a currency gets XXX. A statement without a bank number gets 000000000.

QIF and OFX.What each format is.

The formats

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

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

Questions.What people ask about QIF to OFX.

01OF 04

No. Investment transactions are left out. Only bank, cash, credit card and other asset or liability accounts are read.

Yes. NAME holds up to 32 characters of the payee. EXTDNAME holds up to 100.

QIF holds no currency. A statement without a currency gets XXX.

The ledger balance is the closing balance the source gives. If the source gives none, it is 0.00.

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