Convert QIF to QBO — Quicken to QuickBooks
QuickBooks can't import QIF files. Convert to QBO format and import via Web Connect — the bridge from Quicken to QuickBooks.
For QuickBooks Desktop and Online. Handles all QIF account types. Free online — no signup.
How It Works
Upload Your QIF File
QIF exported from Quicken, Microsoft Money, or GnuCash. Bank, credit card, and cash account types all supported.
Converted to QBO
Transaction data (dates, amounts, payees, memos) mapped to QBO format with the INTU.BID header QuickBooks requires. FITIDs generated for duplicate detection.
Download QBO
Import via File > Utilities > Import > Web Connect in QuickBooks Desktop, or upload in QuickBooks Online's bank feed.
What Transfers — and What Doesn't
QBO format (based on OFX) supports less data than QIF. Here's exactly what makes it across.
Preserved in QBO
- Transaction dates
- Amounts (debits and credits)
- Payee / description names
- Memo text
- Check numbers
- Transaction type (debit/credit)
Lost in Conversion
- Quicken categories (Auto:Fuel, etc.)
- Tags and custom labels
- Split transaction breakdowns
- Cleared/reconciled status
- Transfer links between accounts
- Investment action details
After importing, use QuickBooks' bank feed matching rules to automatically re-categorize transactions based on payee names.
Quicken → QuickBooks Migration Workflow
Export from Quicken
File > Export > QIF. Do one account at a time.
Convert QIF to QBO
Upload here. Download the QBO file.
Import into QuickBooks
Web Connect import. Map to correct account.
Categorize
Use matching rules to re-assign categories.
What is QIF?
Quicken Interchange Format
Quicken's legacy text format with single-letter codes (D, T, P, L). Supports categories and tags but QuickBooks can't read it. Being phased out in favor of QFX and QBO.
What is QBO?
QuickBooks Web Connect
OFX-based format with Intuit headers (INTU.BID). Imports via Web Connect into both QuickBooks Desktop and Online. Transactions land in the bank feed for matching and categorization.
Why This Tool
QuickBooks-Ready Output
QBO file with the INTU.BID header QuickBooks requires. Import via Web Connect on the first try — no "unable to read" errors.
FITID Generation
Unique transaction IDs generated for every transaction. QuickBooks uses these to detect duplicates if you import the same date range twice.
All QIF Account Types
Bank, credit card, cash, and investment QIF files all converted. Map each to the appropriate QuickBooks account during import.
Date Format Handled
QIF dates vary by locale (MM/DD vs DD/MM). Auto-detected and converted to QBO's YYYYMMDD format correctly.
Desktop & Online Compatible
One QBO file works with QuickBooks Desktop (Pro, Premier, Enterprise) and QuickBooks Online. Same import, both platforms.
Memo & Check Numbers
QIF memo (M) and check number (N) fields preserved in QBO output. Available during bank feed matching in QuickBooks.
When to Use This
Quicken to QuickBooks Migration
Export QIF from Quicken, convert to QBO, import into QuickBooks. The most common way to move transaction history between the two platforms.
Historical Data Import
Bring years of old Quicken data into QuickBooks for complete financial history. Convert one account at a time for clean mapping.
Legacy File Recovery
Found old QIF files from Microsoft Money or GnuCash? Convert to QBO to get that data into QuickBooks without needing the original software.
QIF-to-QBO Import Issues
QuickBooks says "This file is not a valid Web Connect file"
The QBO file needs the INTU.BID header. If you tried renaming .qif to .qbo, that won't work — the formats are completely different. Use this converter to properly restructure the file.
Transactions import but categories are missing
Expected behavior. QBO format doesn't support Quicken categories. Set up bank feed matching rules in QuickBooks to auto-categorize by payee name — it learns from your first few matches.
Duplicate transactions after importing multiple QIF files
If QIF files have overlapping date ranges, the same transaction may appear in both. QuickBooks flags duplicates by FITID during import — review the "already exists" warnings before accepting.
Investment transactions (Buy, Sell, Div) not appearing correctly
QBO doesn't support investment transaction types. Buy/Sell/Div actions are converted as basic debits/credits. For full investment tracking, consider keeping that data in Excel instead.
Frequently Asked Questions
Why can't QuickBooks import QIF files directly?
Intuit removed direct QIF import from QuickBooks years ago. QuickBooks Desktop only accepts QBO via Web Connect, and QuickBooks Online accepts QBO or OFX. QIF-to-QBO conversion is the only path.
Will my Quicken categories transfer to QuickBooks?
No — this is a known limitation. QBO format (based on OFX) doesn't support categories or tags. Transactions import with dates, amounts, and descriptions. Use QuickBooks' bank feed matching rules to re-categorize after import.
Does it work with both QuickBooks Desktop and Online?
Yes. QBO files import via Web Connect in Desktop (Pro, Premier, Enterprise) and via bank feed upload in QuickBooks Online.
Can I migrate my entire Quicken history to QuickBooks this way?
Yes. Export each account from Quicken as QIF, convert to QBO, and import into QuickBooks. Do one account at a time and map each to the correct QuickBooks account.
What data is preserved in the conversion?
Dates, amounts, payee names, memos, and check numbers. What's lost: Quicken categories, tags, split transaction details, cleared status, and transfer links between accounts.
Will QuickBooks detect duplicate transactions?
Yes. We generate unique FITIDs for each transaction. If you import the same QBO file twice, QuickBooks will flag duplicates during the bank feed matching step.
MoneyThumb charges $549+ for their QIF-to-QBO converter. Is this free?
Yes. No transaction limits, no trial restrictions, no desktop software needed. Convert as many QIF files as you need in your browser.
Can I just rename .qif to .qbo?
No. QIF and QBO are completely different formats — QIF uses single-letter field codes (D, T, P), while QBO uses OFX/SGML markup with STMTTRN blocks. The file must be restructured, not just renamed.
Is my data secure?
Encrypted in transit via TLS, processed in memory, never stored. Your QIF file is deleted immediately after conversion.
Related Tools
QIF to CSV
Convert QIF (Quicken Interchange Format) files to CSV. Extract all transactions including multi-account QIF files. Free, instant, no signup required.
Convert now →QIF to Excel
Convert QIF (Quicken) files to formatted Excel spreadsheets. Includes Date, Description, Amount, Category, and Memo columns. Free, instant, no signup required.
Convert now →CSV to QBO
Convert CSV financial files to QBO for QuickBooks Desktop and Online. Auto-detects columns and maps your data. Free, instant, no signup required.
Convert now →OFX to QBO
Convert OFX files to QBO for QuickBooks Desktop and Online. Ensures smooth import when QuickBooks prefers QBO over OFX. Free, instant, no signup required.
Convert now →