Convert the statement

Turn a PDF bank statement into a clean CSV or Excel file for accounting and review.

AI categorization
Spending charts
CSV & Excel export
Private & encrypted
Convert free →

No signup · deleted after analysis

← Blog
GuideJuly 8, 2026·4 min read

How to Import QIF Into QuickBooks (Online & Desktop)

How to Import QIF Into QuickBooks Online and Desktop
Quick answer

QuickBooks no longer imports QIF files directly. Convert the QIF to a .qbo Web Connect file (or CSV), then import it: QuickBooks Online via Banking → Upload transactions, QuickBooks Desktop via File → Utilities → Import → Web Connect File. Our free QIF to QBO converter does the conversion in your browser.

QIF was Quicken's interchange format from the 1990s, and a lot of software still exports it — old Quicken installs, Moneydance, GnuCash, some credit unions, and countless accounting tools. But Intuit removed QIF import from QuickBooks Online in 2015, and modern QuickBooks Desktop won't take it either. The reliable path is a two-step: convert, then import.

Step 1 — Convert the QIF to QBO

  1. 1Open the QIF to QBO converter — it also accepts OFX and QFX
  2. 2Drop in your QIF file — the parser auto-detects dates, amounts, memos, and multi-account files
  3. 3Check the transaction count and date range shown after parsing
  4. 4Download the .qbo Web Connect file

Step 2 — Import into QuickBooks Online

  1. 1In QuickBooks Online, go to Transactions → Bank transactions (older layouts: Banking)
  2. 2Click the dropdown next to 'Link account' → Upload transactions
  3. 3Choose the .qbo file and pick the QuickBooks account the transactions belong to
  4. 4Review the preview — QuickBooks skips duplicates by FITID — and accept

Step 2 (alternative) — Import into QuickBooks Desktop

  1. 1Open your company file in QuickBooks Desktop
  2. 2Go to File → Utilities → Import → Web Connect File
  3. 3Select the .qbo file and choose whether to link it to an existing bank account or create one
  4. 4Open the Bank Feeds Center to review and add the imported transactions

Troubleshooting a rejected import

“QuickBooks is unable to verify the financial institution”
The .qbo file's bank ID (INTU.BID) isn't one QuickBooks recognizes. Use a converter that writes a generic accepted institution ID, or import via CSV instead.
Transactions are missing after import
QuickBooks silently skips transactions whose FITID matches one already imported. If you re-import an overlapping date range, only the new FITIDs come in.
Dates are shifted or wrong
QIF dates are ambiguous (US vs UK order). Re-run the conversion and confirm the detected date format matches the source file before downloading.
Amounts have flipped signs
Some QIF exports treat debits as positive. Fix the sign convention at conversion time — QuickBooks expects money out as negative in bank feeds.

What if my source isn't a QIF file?

Free tool · 30 seconds · No signup

Have the statement but not the QIF?

Upload the PDF statement — AI extracts every transaction and exports straight to QBO, CSV, Excel, QIF, or OFX. First page free, no signup.

Continue readingView all posts →
Guide6 min read
How to Import a Bank Statement into Xero or QuickBooks (2026)
Step-by-step guide to importing a bank statement PDF into Xero, QuickBooks Online, and Wave. Convert your PDF to CSV first, then follow the exact import steps for each platform.
Guide6 min read
How to Paste CSV Into Excel (and How to Open CSV Files Properly)
Step-by-step guide to pasting CSV data into Excel without formatting issues. Covers opening CSV files, fixing delimiter problems, handling special characters, and importing bank statement CSVs.
Guide5 min read
Bank Statement QIF Format: What It Is and When to Use It
QIF (Quicken Interchange Format) is a legacy file format for importing bank transactions into Quicken and older accounting software. Learn what QIF is, how it compares to CSV and OFX, and the easiest way to get your bank statement data into any format.