Skip to content
BookkeepKit

Convert QFX (Quicken) Files to QBO for QuickBooks

Your bank offers a Quicken download but not a QuickBooks one? Convert the .qfx file into a .qbo Web Connect file, with the bank's own transaction IDs preserved.

Drop a QFX file here

Quicken Web Connect (.qfx). OFX, CSV, Excel and PDF work too.

Processed in your browser. Your files never leave your computer.

Pro and Business: drop several statements at once to convert them in one go.

How it works

  1. 1

    Drop the .qfx file

    The Quicken Web Connect download from your bank or card issuer.

  2. 2

    Check the transactions

    Account, period, balances and every transaction, editable before export.

  3. 3

    Download QBO

    Import into QuickBooks Online or Desktop like any bank download.

QFX and QBO: almost the same file

Both are OFX underneath: a header, a sign-on block identifying the bank, and a statement with one block per transaction. Quicken reads QFX; QuickBooks reads QBO. Many banks, especially smaller ones, only produce the Quicken version, or only for some account types. The transactions inside are exactly what QuickBooks needs; only the packaging differs.

What the conversion changes

  • The header is written as OFX 1.0.2, the version QuickBooks Web Connect expects.
  • The bank identification (ORG, FID and INTU.BID) is set to values QuickBooks accepts.
  • Payee names longer than the 32 characters allowed are shortened, with the full text kept in the memo.
  • Special characters are escaped, and accents are converted to plain letters to match the declared character set.

What doesn't change: dates, amounts, signs, check numbers and the bank's transaction IDs. The ledger balance reported by the bank is carried over too.

Importing the result

QuickBooks Online

  1. Go to Transactions > Bank transactions.
  2. Choose Link account > Upload from file and select the .qbo file.
  3. Pick the matching account and review the transactions.

QuickBooks Desktop

  1. Choose File > Utilities > Import > Web Connect Files.
  2. Select the file and link it to the right account.

Switching a client from Quicken to QuickBooks

If a client has a history of QFX downloads, convert each one and import them in date order. Because the bank's transaction IDs are kept, overlapping downloads won't create duplicates in QuickBooks. To check what a file contains before importing, open it in the QBO file viewer or export it to a spreadsheet with QFX to CSV.

Frequently asked questions

Can't I just rename .qfx to .qbo?

Sometimes it works, often it doesn't. The two formats share the OFX structure, but QuickBooks checks the Intuit bank identifier and header, and a Quicken file may carry values QuickBooks doesn't accept. Converting rewrites those parts properly.

Are the bank's transaction IDs kept?

Yes. The FITID from your bank is kept for every transaction, so QuickBooks can still recognize transactions it already imported from the same bank.

Why does QuickBooks show a different bank name during import?

QuickBooks displays the bank linked to the file's INTU.BID. The converter uses a widely accepted default, so the label may not match your bank. It has no effect on the data: you choose the QuickBooks account the transactions go into.

Does it work with credit card QFX files?

Yes. Card files stay card files in the QBO output, so import them into a credit card account.

Can I convert several QFX files at once?

One file at a time for now. Batch conversion is part of the Pro plan.

What if my QFX file won't open at all?

Inspect it with the QBO file viewer, which reads QFX too and explains what's wrong with the file.

Guides

    Statements from a specific bank: Chase statement converter · Bank of America statement converter

    Related tools