QIF to QBO Converter

Moving from Quicken to QuickBooks, or have an old QIF export? Convert it to a .qbo Web Connect file and import the transactions into QuickBooks Desktop or Online.

  1. Upload
  2. Check
  3. Download

Drop your .qif file here

or choose a file

Files are processed in your browser and never uploaded.

Only have a PDF statement? Convert PDF to QBO →

How to import the file

QuickBooks Desktop

  1. 1Go to File > Utilities > Import > Web Connect Files.
  2. 2Select the .qbo file you downloaded and click Open.
  3. 3Choose "Use an existing account", pick your bank or card account, then review the transactions in the Bank Feeds center.

QuickBooks Online

  1. 1Go to Transactions > Bank transactions, open the Link account menu and choose Upload from file.
  2. 2Drag in the .qbo file, then choose which QuickBooks account the transactions belong to.
  3. 3Click Continue, then categorise or match the transactions under For review.

What the .qbo file looks like

A .qbo file is plain text in the OFX format that QuickBooks reads. The header and bank ID come first, then one block per transaction with its own ID, so QuickBooks can skip anything it has already imported.

OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX>
…
<INTU.BID>3000
…
<BANKTRANLIST>
<DTSTART>20260115120000
<DTEND>20260116120000
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20260115120000
<TRNAMT>-42.50
<FITID>20260115b07214c56caac787
<NAME>HOME DEPOT #4521
<MEMO>Debit card purchase
</STMTTRN>
… one <STMTTRN> block per transaction
<LEDGERBAL>
<BALAMT>5012.83
<DTASOF>20260116120000
</LEDGERBAL>

Questions

Can QuickBooks import QIF files?

Not directly. QuickBooks dropped QIF import years ago. Converting the QIF to .qbo lets you bring the transactions in through Web Connect instead.

What happens to my Quicken categories?

QBO files do not carry categories, so the category is added to each transaction's memo. You can use it when you categorise the transactions in QuickBooks.

My QIF dates look like 1/ 3'26. Is that supported?

Yes. Quicken's apostrophe year format and padded dates are read correctly. If your file uses day-first dates, change the date format in the options and the preview updates.

Does it handle QIF files with several accounts?

All bank, cash and credit card transactions in the file are converted together. Category and memorized-transaction lists are ignored. For best results export one account per QIF file.

Is my QIF file uploaded?

No. It is converted in your browser and never sent anywhere.

More free converters

Have PDF bank statements?

Extract transactions from PDF statements, checked against the statement balances.

See pricingConvert PDF to QBO