QFX File: What a QFX File Is, How to Open One, and How It Differs from OFX

A QFX file is Quicken's Web Connect format: a standard OFX financial file with extra Intuit identifiers added so Quicken can tie it to a specific bank. It stores bank, credit card, and investment transactions as text, and Quicken imports it directly as a statement feed. The .qfx extension is what your bank hands you when its site offers a "download to Quicken" button, and it is the format Quicken trusts over the plain, unbranded alternatives.

QFX stands for Quicken Financial Exchange. Under the hood it is OFX, the Open Financial Exchange format that banks and finance apps have used since the late 1990s, with two Intuit-specific tags bolted on: an INTU.BID that names the financial institution and an INTU.USERID that ties the file to an account. Those tags are why Quicken accepts a QFX and, in many versions, refuses a plain OFX that carries the exact same transactions.

What is a QFX file used for?

A QFX file moves transactions from your bank into Quicken without a live connection. Banks that support Quicken Web Connect let you download recent activity as a .qfx, which you then import into the matching Quicken account. It is the fallback when Direct Connect (a live, two-way link) and Express Web Connect are not available for your institution, which is common at smaller banks and credit unions. The comparison of Direct Connect and Web Connect explains how the two differ and why banks charge for one of them. The file is one-directional: it carries statement data into Quicken and nothing back out.

How do I open a QFX file?

Open a QFX file by importing it into Quicken: File then File Import then Web Connect File, then pick the account it belongs to. Double-clicking a .qfx on a machine with Quicken installed usually launches the same import. If you only want to inspect it, a QFX file is plain text, so any text editor will show its OFX structure, though the tagged SGML markup is not meant for reading by eye. You cannot open a QFX as a spreadsheet without converting it first.

What is the difference between QFX and OFX?

QFX is OFX plus Intuit branding. A plain OFX file is the open, free standard with no vendor tags, and it imports into Quicken for Mac, Banktivity, MoneyDance, GnuCash, and many other apps. A QFX file is that same OFX structure with the INTU.BID and INTU.USERID identifiers added, which banks pay Intuit a licensing fee to include. The practical effect is that Quicken for Windows generally imports QFX but rejects a generic OFX, while non-Quicken apps happily read OFX and may choke on the Intuit tags. Same transactions, different wrapper.

What is the difference between QFX and QBO?

QFX and QBO are siblings: both are OFX with Intuit identifiers, but QFX targets Quicken and QBO targets QuickBooks. A .qbo file, also called a QuickBooks Web Connect file, carries the tags QuickBooks looks for and imports into the QuickBooks banking review queue as a bank feed. A .qfx carries the tags Quicken looks for. They are not interchangeable by renaming, because each app validates its own identifiers. If you need the file in QuickBooks, you want QBO; for Quicken, you want QFX.

Can I convert a QIF file to QFX?

Yes. If you have an old Quicken QIF export and need a QFX that a current Quicken build will import, the QIF to QFX converter reads the QIF tags and writes a valid QFX with the right structure, dates, and amounts. This is a common move for people migrating off an old Quicken file or importing history a bank no longer offers as a Web Connect download. The converter reconciles the transaction total against the source file before you download, so nothing is silently dropped.

Can I open a QFX file in Excel?

Not directly. A QFX is OFX markup, not rows and columns, so Excel shows a tangle of tags rather than a ledger. To get a spreadsheet, convert the underlying transactions to CSV or Excel. If your data started as a QIF, the QIF to Excel converter and QIF to CSV converter both produce clean, one-row-per-transaction files. Once the transactions sit in a spreadsheet, categorizing and summarizing them, or feeding them into software that reads and categorizes every expense, becomes straightforward.

How do I create a QFX file?

Most people get a QFX by downloading it from their bank: look for a "download" or "export" option on the transactions screen and choose Quicken or Web Connect (.qfx) as the format. The same screen is usually where the QuickBooks version lives, and our guide on how to download a QBO file from your bank shows where ten major banks hide it. If your bank does not offer QFX, or only offers CSV, you cannot conjure the Intuit identifiers by hand, but you can build a valid QFX from data you already have. Converting a Quicken QIF export to QFX with the QIF to QFX converter is the usual route when a bank has stopped offering Web Connect downloads for older statements and you still need the history in Quicken.

Is it safe to open a QFX file?

A QFX file is plain text containing your transactions, so it carries no macros or executable code the way a spreadsheet or document can. The realistic risk is not malware but mismatched identifiers: a QFX built for one bank can fail or import into the wrong account if the INTU.BID does not line up with how your app expects that institution to be identified. Download QFX files only from your own bank's site, and when a file will not import, the fix is usually to convert the transactions into the format your app actually expects rather than to force the mismatched file.

Why does my bank give me a QFX instead of a CSV?

Banks offer QFX because it is the format Quicken imports without any cleanup: the transactions land in the right account with dates, payees, and amounts already mapped. A CSV would need you to map columns by hand every time. The tradeoff is that a QFX is locked to the app it was built for, so if you are not a Quicken user, that convenience turns into a compatibility problem, and a converter that rewrites the data into the format your app expects saves the round trip.

QFX in one line

Think of QFX as OFX wearing a Quicken badge. It carries ordinary bank transactions, but the Intuit identifiers inside decide which software will accept it. When the file and the app do not match, converting the transactions into the right format, QBO for QuickBooks, OFX for most other tools, or a spreadsheet for a human, is faster and safer than fighting the import. For a look at the older sibling of this format, read what a QIF file is.