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