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