QIF to QBO Converter
Convert QIF files from Quicken, GnuCash, or Microsoft Money to QBO format for QuickBooks Online. Free, instant, 100% in your browser.
Drop your QIF file here
or click to browse
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
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 using each transaction's FITID (a unique ID). This converter generates a FITID for every transaction based on the file's export timestamp, so re-uploading the exact same converted file won't create duplicates — but converting the same QIF file twice from scratch will generate new FITIDs and can duplicate. Convert and import once per QIF export.
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.