What Is a QFX File? How to Open and Create One

TL;DR: A QFX file is a Quicken specific version of the OFX format, Open Financial Exchange with an Intuit branding tag added so Quicken accepts it as a Web Connect import. It stores bank or credit card transactions as structured text, each with a date, amount, description, and unique ID, so Quicken can load them straight into the right account. You open a QFX file by importing it into Quicken through File then File Import then Web Connect File, or you can read its raw contents in any text editor.

What is a QFX file?

QFX stands for Quicken Financial Exchange. It is Intuit's variant of the open OFX standard, and the two files look almost identical inside. The difference is a small block of tags that identify the file as coming through Quicken's Web Connect service, including an Intuit institution ID. Quicken uses that block to decide whether to trust and import the file. A plain OFX file usually lacks it, which is why Quicken sometimes refuses an OFX but accepts the same data as a QFX.

A QFX file is not a spreadsheet and not a PDF. Open it in a text editor and you see tagged, SGML style text: an account block, a sign on block, and a list of transaction blocks. Each transaction carries a posted date, a transaction amount, a name or memo, and a financial institution transaction ID that keeps Quicken from importing the same line twice. If you have a PDF statement and need this format, a PDF to QFX converter reads the statement and writes the QFX for you.

QFX vs OFX vs QBO: what is the difference?

All three come from the same OFX standard, and they differ mainly in which software they are branded for. OFX is the plain, unbranded format that many finance programs read, including MS Money, GnuCash, and Moneydance. QFX is the Quicken branded version with the Intuit Web Connect tags. QBO is the QuickBooks branded version, built for importing into QuickBooks rather than Quicken. Choosing the wrong one is a common reason an import fails.

If your books live in QuickBooks rather than Quicken, you want the QBO version instead, and a dedicated QuickBooks import file saves the trouble of a rejected format. For Quicken, stay with QFX.

How do I open a QFX file?

You open a QFX file by importing it into Quicken, not by double clicking it into a spreadsheet. In Quicken for Windows, go to File, then File Import, then Web Connect File, and select the QFX. In Quicken for Mac, use File then Import and choose the QFX. Quicken reads the account block, matches it to an account you pick, and adds the transactions to that register. If you only want to read the contents, open the file in Notepad or any text editor and you will see the raw tags.

What you cannot reliably do is open a QFX directly in Excel. Because it is tagged text, Excel shows the markup rather than clean rows. To get the transactions into a spreadsheet you convert the file first: an OFX to CSV converter handles QFX too and gives you a spreadsheet with date, description, amount, and balance columns.

Why does Quicken reject my QFX file?

The usual causes are a mismatched or missing institution ID, an expired Web Connect branding, or a date and amount format Quicken does not like. Quicken checks the Intuit tags before it imports, and a file exported by a third party without a valid financial institution ID can trigger an OL-220 or similar error. A well formed QFX writes the tags Quicken expects, uses the correct DTPOSTED date stamps, and keeps debits negative so the register balances. When a bank hands you only a CSV, converting that CSV to a QFX with the right fields is what makes the import succeed.

Can I create a QFX file myself?

Yes, though you do not write the tags by hand in practice. You start from whatever the bank gives you, a PDF statement, a CSV export, or an existing OFX, and convert it to QFX. The converter builds the account and sign on blocks, formats each transaction with a posted date and a signed amount, and assigns the unique transaction IDs Quicken uses for deduplication. From a PDF, the PDF to QFX converter does this in one upload. From a general statement, see how to convert a bank statement to Quicken.

QFX file questions, answered

Is QFX the same as OFX? Almost. QFX is OFX with Intuit Web Connect branding tags added so Quicken accepts it. The transaction data is structured the same way.

What program opens a QFX file? Quicken opens QFX files through its Web Connect file import. A text editor will show the raw contents, and a converter turns it into CSV or Excel for spreadsheets.

Does QuickBooks open QFX? No. QuickBooks uses the QBO variant. Feeding QuickBooks a QFX usually fails, so convert to QBO for QuickBooks and keep QFX for Quicken.

Why is my QFX file so small? QFX is plain text, so even a few hundred transactions make a tiny file. Size is not a sign of a problem. A failed import is almost always about the tags, dates, or amount signs, not the file size.

Where do QFX files come from?

Historically, you downloaded a QFX straight from your bank's website through a Quicken linked button, or Quicken pulled it automatically over Web Connect. That is still how it works at banks that support Quicken directly. The catch is that Intuit charges banks to keep Web Connect active, so many smaller banks, credit unions, and newer online banks never offered it or dropped it. When that happens you are left with a PDF statement or a CSV export and no native QFX to import.

That gap is why conversion matters. If your bank gives you a PDF, you upload it and the tool reads every transaction into a properly tagged QFX. If your bank gives you a CSV, or you keep your own spreadsheet, you map the date, description, and amount columns and the converter writes the Web Connect file Quicken expects. Either way you skip the manual entry that turns a month of transactions into an evening of typing. For a full walkthrough of loading transactions into Quicken from any starting point, see convert bank statement to Quicken.

How to read a QFX file without Quicken

You do not need Quicken installed to see what is in a QFX. Open it in any plain text editor and you will find a readable structure: a sign on block near the top, an account block that names the account type and institution, and a series of transaction blocks. Each transaction has a DTPOSTED date, a TRNAMT amount, a NAME or MEMO, and a FITID unique identifier. Reading the raw file is a quick way to confirm the dates and amounts look right before you import, which saves cleanup later.

The short version

A QFX file is Quicken's branded flavor of OFX: the same structured transaction text with Intuit Web Connect tags that let Quicken import it cleanly. Open it by importing through Web Connect, not by opening it in Excel. If you have a PDF or a CSV instead, convert it to QFX first, and if your accounting lives in QuickBooks rather than Quicken, reach for the QBO format instead. Get a Quicken ready file from a statement with the PDF to QFX converter.