Blog/Software Integrations/Convert QFX to QBO: QuickBooks Import Guide (bank2qif & More)
๐Ÿ“Š

Convert QFX to QBO: QuickBooks Import Guide (bank2qif & More)

6 min readJune 12, 2024

Quick Answer: QuickBooks Desktop and Online import QBO (QuickBooks Online bank format) and QFX (Quicken/OFX variant) through Banking upload โ€” but versions differ. To convert QFX to QBO, use QuickBooks' built-in import where supported, or tools like bank2qif/qboconverter alternatives. When you only have PDF statements, convert to QBO-ready CSV with QuickBankConvert first.


QFX, QBO, OFX, QIF โ€” What Is the Difference?

Financial import formats confuse everyone because names sound alike:

FormatFull nameUsed byNotes
QFXQuicken Financial ExchangeQuicken, some banksOFX variant with Quicken extensions
QBOQuickBooks Online (export)QuickBooksNot the same as QBO the product name
OFXOpen Financial ExchangeMany US banksBroad standard
QIFQuicken Interchange FormatLegacy QuickenOlder, limited fields
CSVComma-separatedUniversal fallbackMap columns on import

When someone searches qfx to qbo converter, they usually need to move bank data from a Quicken-export file or bank QFX download into QuickBooks โ€” or fix a file QuickBooks rejected.


Does QuickBooks Import QFX Directly?

QuickBooks Desktop: Often accepts QFX/OFX through File โ†’ Utilities โ†’ Import โ†’ Web Connect (.qbo web connect files are related but not identical to "QBO the cloud product").

QuickBooks Online: Banking module accepts QFX/OFX uploads on the Upload file tab for many institutions. If upload fails, the file may be the wrong OFX version or contain account ID mismatches.

Common rejection reasons:

  • File created for a different account number
  • Duplicate import (transactions already in register)
  • Unsupported OFX version from older bank exports
  • Corrupted download

Using bank2qif and qboconverter Tools

bank2qif historically described scripts and utilities that transform bank CSV into QIF for Quicken. Modern workflows often need the reverse โ€” QFX/OFX into something QuickBooks accepts.

Third-party qboconverter style tools (various vendors, desktop utilities) typically:

  1. Read QFX, OFX, or CSV input
  2. Normalize dates and amounts
  3. Output QBO Web Connect or IIF (Desktop legacy)
Tool typeProsCons
Desktop converter utilitiesHandles odd OFX versionsPaid; Windows/Mac only
bank2qif scriptsFree, scriptableRequires technical skill
QuickBooks native uploadNo extra costPicky about file format
PDF โ†’ CSV โ†’ QuickBooksWorks when bank only gives PDFExtra conversion step

Always back up your company file before bulk imports.


Step-by-Step: Convert QFX to QBO (QuickBooks Online)

Step 1: Download QFX from your bank (or export from Quicken).

Step 2: In QuickBooks Online, go to Transactions โ†’ Bank transactions โ†’ Upload from file.

Step 3: Select your QFX file. Map to the correct bank account if prompted.

Step 4: Review imported transactions in the For review tab; match or add to register.

If upload fails: Convert transactions to CSV โ€” open QFX in a converter tool or re-download from bank as CSV. Or convert your original PDF statement via QuickBankConvert and upload CSV instead.

Full QuickBooks workflow: import bank statements into QuickBooks.


When Your Bank Only Provides PDF

Many credit unions and international banks offer PDF only. The convert qfx to qbo search intent still applies โ€” users want QuickBooks-ready data from whatever the bank gave them.

  1. Download PDF statement.
  2. Open QuickBankConvert.
  3. Upload on convert#convert.
  4. Export CSV formatted for accounting.
  5. Upload CSV to QBO Banking.

This path often beats fighting a malformed QFX from an outdated bank export system.


QuickBooks Desktop: Web Connect vs IIF

Web Connect (.qbo files): Preferred for bank feeds; imports into Banking Center.

IIF: Legacy bulk import format โ€” powerful but easy to break with wrong column order. Use only if you know IIF structure.

Desktop users switching from Quicken often export QFX from Quicken, then attempt Web Connect import. If account IDs conflict, create a new QuickBooks bank account and import fresh โ€” merge duplicates later.


Avoiding Duplicate Transactions

The #1 qfx to qbo converter frustration is duplicates:

  • Never import the same date range twice
  • If connected live bank feed exists, do not also import overlapping QFX
  • Use Banking โ†’ Update to see what's already downloaded
  • For CSV imports, sort by date and compare counts before confirming

QuickBooks marks duplicates during review โ€” still check manually for near-duplicate amounts on adjacent dates.


Alternative Format Paths

Starting pointTargetTool chain
PDF statementQBO registerQuickBankConvert โ†’ CSV โ†’ QBO upload
QFX from bankQBONative upload or desktop converter
Quicken QFXQuickBooks DesktopWeb Connect import
Excel from accountantQBOSave as CSV โ†’ upload
OFX internationalQBO USMay need currency column cleanup

For OFX-specific tips, see our finance file converter guide.


Migrating Years of Quicken History to QuickBooks

Long-time Quicken users often face a multi-year QFX archive during convert qfx to qbo projects:

  1. Export each calendar year from Quicken as QFX.
  2. Test-import January into a QuickBooks sandbox company.
  3. Fix account mapping once, then batch the remaining months.
  4. For PDF-only legacy years, scan isn't viable โ€” reconstruct from paper if legally required, or accept a start date at digital history begin.

Accountants sometimes keep parallel Quicken files "just in case" โ€” export those to CSV annually so you are not locked into obsolete import paths.

Credit unions frequently ship QFX with non-standard MEMO fields โ€” QuickBooks may import but drop memos you need for reconciliation. CSV from QuickBankConvert preserves description text more predictably when MEMO truncation is the issue.

When bank2qif scripts output QIF but your target is QuickBooks Online, stop โ€” QBO does not import QIF. Convert the source PDF to CSV instead or use a desktop bridge tool explicitly labeled for QBO Web Connect output.


Free vs Paid Converters

OptionCostBest for
QuickBankConvert (PDFโ†’CSV)Free tierPDF-only banks
QBO native uploadIncludedValid QFX/OFX
Desktop qboconverter utilities$20โ€“$60Broken OFX files
Manual CSV in ExcelFreeTiny statements

Paid converters make sense when you have hundreds of broken QFX files from a legacy system migration โ€” not for one monthly statement.

Quicken users migrating to QuickBooks often export years of QFX history. Import in quarterly chunks rather than one giant file โ€” QuickBooks Online performance degrades past roughly 1,000 rows per upload, and error messages become useless. If a chunk fails, isolate the date range binary-search style until you find the corrupt transaction.

When your accountant sends a QFX from their bookkeeping system, confirm it targets your bank account ID. Mismatched ACCTID fields are the silent cause of "QuickBooks imported zero transactions" support tickets.


The Bottom Line

Convert QFX to QBO is usually a native QuickBooks upload โ€” until the file fails validation. Then use bank2qif-style utilities or skip QFX entirely: convert the source PDF with QuickBankConvert, upload CSV to QuickBooks, and reconcile. The format names are confusing; the workflow is simple: structured data in, matched transactions in your register.

Frequently Asked Questions

What is the difference between QFX and QBO files?

QFX is a Quicken/OFX bank transaction format. QBO in import context means QuickBooks Web Connect bank files โ€” not to be confused with QuickBooks Online the product.

How do I convert QFX to QBO for QuickBooks?

Try uploading the QFX directly in QuickBooks Banking. If rejected, use a desktop converter utility or convert your original PDF statement to CSV with QuickBankConvert and upload CSV instead.

What is bank2qif?

bank2qif refers to tools and scripts that convert bank data into QIF format for Quicken. Modern QuickBooks workflows often use CSV or Web Connect instead.

Can QuickBooks Online import QFX files?

Yes, QBO Banking supports QFX/OFX upload for many files. Failures usually mean account mismatch, duplicates, or unsupported OFX version โ€” try CSV import as fallback.

Is there a free qfx to qbo converter?

QuickBooks includes free QFX upload. For PDF-only statements, QuickBankConvert offers free PDF-to-CSV conversion as the first step before QuickBooks import.

Ready to convert your bank statement?

Free. Private. Instant. Your files never leave your browser.

Convert Your Statement