Export Bank Statement — bank statement PDF to Excel
Runs in your browser · no sign-in

QIF to QBO converter.

QuickBooks stopped accepting QIF. Drop the file below and get a QBO you can import — converted on your own machine, nothing uploaded.

upload_file

Drop your .qif, .ofx or .qfx file

Converted in your browser — nothing is uploaded, no sign-in.

Why the conversion is needed

QIF is Quicken's original interchange format and it is genuinely old — a flat text file with one letter per field and no notion of an account balance, a currency or a unique transaction ID. QBO is Intuit's Web Connect format, which is OFX underneath: structured, identified, and what QuickBooks expects from a bank today. QuickBooks removed QIF import for bank, credit card and similar accounts, so a perfectly good QIF export is simply refused.

The transactions in both formats are the same information — a date, an amount, a payee. Converting between them is a container change, and that is what this page does.

How to convert

  1. Drop your .qif file onto the converter above — it's read in your browser, not uploaded.
  2. Check the transaction count matches what you expect from the file.
  3. Choose QBO, then download.
  4. In QuickBooks, go to Transactions → Banking → Upload from file, and select the .qbo you just saved.
info

If QuickBooks refuses the file

Intuit checks which institution a QBO came from, and a converted file can't claim to be from your bank's Web Connect feed. Some QuickBooks versions accept it anyway; some return OL-301. If yours refuses, download the Excel or CSV instead and use QuickBooks' spreadsheet import — less elegant, but it always works.

What this page does not do

It doesn't reconcile. A QIF file has no opening or closing balance in it, so there is nothing to check the transactions against — and claiming a check we can't perform would undermine the one we can. If you have the original PDF statement, convert that instead: the bank prints both balances, and every transaction is verified against them before you download.

Convert a PDF statement with reconciliation →

Frequently asked questions

Is the QIF file uploaded to your server?expand_more

No. QIF and OFX are small text formats, so the whole conversion runs in JavaScript in your browser. The file never leaves your device, which is also why there's no sign-in and no limit on this page.

Why does QuickBooks reject QIF files?expand_more

QuickBooks dropped QIF import for bank accounts years ago in favour of QBO (Web Connect). The data is nearly the same; the container is what QuickBooks cares about. Converting the file is usually all that's needed.

QuickBooks says the QBO file is from a different financial institutionexpand_more

That's Intuit's OL-301 / bank-ID check. A converted file carries a generic institution ID because it didn't come from your bank's own Web Connect feed. Some QuickBooks versions accept it, some refuse. If yours refuses, import the Excel or CSV export instead — it's the reliable route.

Will the balances be checked?expand_more

Not on this page, and we'd rather say so. A QIF file contains transactions but no opening or closing balance, so there is nothing to reconcile against. Our reconciliation check applies when converting a PDF statement, where the bank prints both balances.

What about QFX or OFX files?expand_more

Both work here too — drop them in the same box. QFX is Quicken's variant of OFX, and the parser reads either.

Related

Other conversions