Import QIF into QuickBooks
QuickBooks doesn't accept QIF files. Convert your QIF to QBO below, then upload the QBO file to QuickBooks. Free, 100% in your browser.
Drop your QIF file here
or click to browse
Can you import a QIF file into QuickBooks?
QuickBooks Online: no. Banking > Upload transactions accepts QBO, QFX, OFX and CSV files only, and a .qif file is rejected.
QuickBooks Desktop for Windows: no. It reads bank data as QBO (Web Connect) and imports lists and transactions as IIF, but has no QIF import.
What works instead: convert the QIF file to QBO and upload that to QuickBooks Online. For Desktop, take the QBO file one step further to IIF.
- Export the account from Quicken (File > Export > QIF File) or GnuCash (File > Export > Export Accounts to QIF). One file per account.
- Drop the .qif file into the QIF to QBO converter above and download the .qbo file.
- QuickBooks Online: Banking > Transactions > Upload transactions, pick the file and the matching bank account. QuickBooks Desktop: run the QBO file through the QBO to IIF converter and import it with File > Utilities > Import > IIF Files.
- Review the transactions in the For Review tab before adding them.
How to convert QIF to QBO
Export QIF
Export transactions from Quicken, GnuCash, or any app that saves QIF files.
Upload QIF
Drop your QIF file into the converter above.
Import QBO
In QuickBooks Online: Banking > Upload transactions > select your QBO file.
Migrating from Quicken to QuickBooks Online
Quicken and QuickBooks Online use incompatible file formats. Quicken (and QIF-exporting apps like GnuCash and Microsoft Money) writes QIF — a plain-text format from the 1980s that uses single-letter field codes. QuickBooks Online, on the other hand, only accepts QBO files in OFX SGML format for its Banking upload feature. There is no built-in way to import a .qif file into QuickBooks Online — Intuit dropped QIF support from QBO years ago, which is exactly why this converter exists.
Our converter parses each QIF transaction record — pulling out the date, amount, and payee — and generates a valid OFX/QBO file with the header, bank account block, and STMTTRN transaction list that QuickBooks Online expects. You upload the result the same way you'd upload a QBO file downloaded directly from your bank.
This is also the fastest path for GnuCash and Microsoft Money users moving historical transactions into QuickBooks: export your data as QIF from the old app, run it through this converter, and import the resulting QBO file — no manual re-entry of years of transaction history.
How QIF fields map to the QBO file
| QIF field | QIF code | QBO / OFX field |
|---|---|---|
| Date | D | DTPOSTED |
| Amount | T / U | TRNAMT |
| Payee | P | MEMO |
| Transaction type | derived from sign | TRNTYPE (CREDIT/DEBIT) |
| Unique ID | generated | FITID |
Split transactions (S/E/$ lines) are not broken into separate entries — each QIF record imports as a single transaction using its total amount.
Common issues when converting QIF to QBO
"No transactions found" error. This usually means the QIF file doesn't have the expected D (date) and T (amount) lines, or the file was saved with a different transaction type header (e.g. a QIF investment export instead of a bank/cash export). Re-export from Quicken using the "Bank" or "Cash" account type, not "Investment."
Dates look wrong after import. Quicken can export dates as MM/DD/YYYY or M/D'YY depending on your regional settings. The converter auto-detects the most common US formats — if your dates are off by a day or transposed, check your Quicken date format setting before re-exporting.
All transactions land in one account. QuickBooks Online assigns every imported transaction to whichever bank account you select during the upload step, regardless of what account the QIF came from. If you're migrating multiple Quicken accounts, convert and upload each QIF file separately, choosing the matching QuickBooks account each time.
Frequently asked questions
How do I import a QIF file into QuickBooks?
You can't import a .qif file into QuickBooks Online or QuickBooks Desktop for Windows directly. Convert it to QBO with the converter on this page, then upload the QBO file in QuickBooks Online via Banking > Upload transactions. For QuickBooks Desktop, convert the QBO file on to IIF and use File > Utilities > Import > IIF Files.
Does QuickBooks Desktop import QIF files?
QuickBooks Desktop for Windows imports bank transactions as QBO (Web Connect) files and lists or journal entries as IIF files. It has no QIF import. Convert QIF to QBO here, then QBO to IIF with the QBO to IIF converter, and import the IIF file.
What is a QIF file?
QIF (Quicken Interchange Format) is a plain-text format used by Quicken, GnuCash, Microsoft Money, and other personal finance apps to store transactions. It uses single-letter codes for fields like Date (D), Amount (T), Payee (P), and Memo (M), separated by a caret (^) between records.
Why convert QIF to QBO?
QuickBooks Online does not import QIF files directly — it requires the QBO (OFX) format for the Banking > Upload transactions feature. If you're migrating from Quicken, GnuCash, or Microsoft Money, this converter bridges the gap so you don't have to re-enter years of transaction history by hand.
How do I export QIF from Quicken?
In Quicken, open the account you want to export, go to File > Export > QIF File. Select the date range and the account, then save the file. Quicken exports one QIF file per account, so if you're migrating multiple accounts you'll need to repeat this for each one.
How do I export QIF from GnuCash?
In GnuCash, go to File > Export > Export Accounts to QIF, choose the account and date range, and save the file. GnuCash's QIF export is compatible with this converter as long as the Date and Amount fields are present.
How do I import the QBO file into QuickBooks Online?
In QuickBooks Online, go to Banking > Transactions > Upload transactions (or Update Bank/File Upload). Select the downloaded QBO file, choose the bank account you want the transactions added to, and review the imported transactions in the 'For Review' tab before adding them to your books.
Does this preserve my payee names?
Yes — payee names (the P line in QIF) are mapped to the MEMO field in the generated QBO/OFX file, so they show up in the transaction description when you review the upload in QuickBooks.
Will this duplicate transactions I already entered manually?
QuickBooks Online deduplicates by FITID, and this converter builds each FITID from the transaction's date, amount, and description — so converting the same QIF file again produces the same IDs and QuickBooks skips what it already imported. Transactions you entered by hand have no FITID, so QuickBooks may surface them as a possible match instead of adding a new one — review them in Banking.
What happens to QIF transfer transactions (with brackets like [Savings])?
Transfers between accounts in QIF use bracketed account names in the category field (e.g. [Savings]). This converter treats every QIF record as a standalone transaction and does not attempt to reconcile transfers between two converted accounts — review these in QuickBooks after import to avoid double-counting.
Does the converter handle split transactions?
The converter reads the top-level Date, Amount, and Payee/Memo fields of each QIF record. Split lines (S/E/$ codes within a single transaction) are not broken out individually — the transaction imports as one line using the total amount.
Is there a transaction limit?
No — the converter is completely free with no limits on file size or number of transactions. Your data never leaves your browser, so there's no upload wait time either.
Can I convert QIF to QBO on Mac or without Quicken installed?
Yes. The converter runs entirely in your browser (Chrome, Safari, Firefox, Edge) — no Quicken installation, no Windows requirement, and nothing to install. Just drag in the .qif file.