OFX, QFX, QBO and QIF converter

Your bank offers one format and your app wants another. Convert a statement file between QBO (QuickBooks), QFX (Quicken), OFX and QIF in your browser, keeping the dates, amounts, payees and transaction IDs.

OFX / QFX / QBO / QIFQBO / QFX / OFX / QIF

Choose your file

Choose an OFX, QFX, QBO or QIF file

or drop a bank or card statement file here

Your file stays on this device.

Keep a copy in History on this deviceView history

This converter is taking a while to load. Check your connection, then reload the page.

Your files stay on this device: the conversion runs in your browser and nothing is uploaded. Learn how your files are handled

How to convert a bank file

Choose the file: .qfx, .qbo, .ofx or .qif.
Choose the new format. A likely choice is picked for you (QFX becomes QBO, QBO becomes QFX, QIF becomes OFX). The account type, account number and bank IDs are copied from your file; change them only if you need to.
Check the preview and download the new file. Import it into a test or new account first, and check the balance.

Which format your app wants

QBO: QuickBooks Desktop (Banking → Bank Feeds → Import Web Connect Files; in older versions File → Utilities → Import → Web Connect Files). QuickBooks Online also accepts QBO, QFX and OFX uploads.
QFX: Quicken’s Web Connect format.
OFX: most other finance and budgeting apps, such as Xero, YNAB, GnuCash, Moneydance and Banktivity.
QIF: older programs and some current ones, such as GnuCash, Moneydance, MYOB and older Quicken versions.

Apps change what they accept, so check your app’s help page if an import is refused. For QuickBooks, see the QuickBooks Web Connect guide.

What changes between formats

QFX, QBO and OFX share one structure. Converting between them keeps every transaction with its ID (FITID), type, dates and reference number, the bank’s name, the account number, the statement period and the balances. The Intuit bank ID is added, kept or removed as the new file type needs, and you can change it.
To QIF: dates, amounts, payees, memos and check numbers are kept. QIF has no transaction IDs or account numbers, so the app can’t tell whether a transaction was imported before.
From QIF: each transaction gets a stable ID made from its date, amount, payee and memo, so converting the same file again gives the same IDs. Categories are left out, because OFX-type files have no field for them.

The Intuit bank ID

Quicken and QuickBooks Desktop only accept Web Connect files from banks they recognise, identified by the INTU.BID number in the file. If your file already has one, it is kept. Otherwise 3000 is used, which converters commonly use; the app may then label the file with that bank’s name, but you still choose your own account when importing. If the import is refused, enter your own bank’s ID.

Frequently asked questions

What is the difference between QFX and QBO?

Both are OFX statement files with an Intuit bank ID. QFX is the file type Quicken imports and QBO the one QuickBooks imports. Converting between them keeps the transactions, their IDs, the account and the balances; only the file type changes, and the Intuit bank ID if you change it.

Will importing the converted file create duplicates?

Not when converting between QFX, QBO and OFX: the transaction IDs are kept, so apps skip transactions they already have. QIF files have no IDs, so avoid importing overlapping dates from a QIF file.

QuickBooks refuses the file or can’t verify the bank. What can I do?

QuickBooks Desktop checks the Intuit bank ID in the file against the banks it knows. Try your own bank’s ID, or 3000, and convert again. The QuickBooks Web Connect guide covers the other common import errors.

Can I convert a CSV or Excel statement?

Yes, with the CSV to OFX converter (for OFX, QFX or QBO) or the CSV to QIF converter.

Can it convert investment accounts?

No. Only bank, cash and credit card accounts are converted. Investment holdings and trades (investment sections of a QIF file, investment statements in an OFX file) are left out, with a note, because bank statement files can’t hold them.