What a QFX file is
QFX stands for Quicken Financial Exchange. It is the file format banks use to export transactions for import into Quicken, the personal and small-business finance program made by Quicken Inc.
Under the hood, QFX is based on OFX (Open Financial Exchange), an open standard for moving financial data between banks and software. A QFX file is essentially an OFX file with a few extra Quicken-specific pieces added, including identifiers that tie the file to a particular financial institution.
A QFX file typically contains a header section followed by tagged transaction data. You will see things like account type, account number, statement date range, and a list of individual transactions with dates, amounts, descriptions, and reference numbers. It is plain text, so it opens in any text editor, but it is not formatted for easy reading.
How QFX differs from QBO, OFX, and QIF
These formats look similar and are easy to confuse. QFX is the Quicken version. QBO is the QuickBooks version, also based on OFX, and is meant for import into QuickBooks rather than Quicken. The two are not interchangeable even though their structure is nearly identical.
Both QFX and QBO rely on institution identifiers. Banks that support these formats register with the software vendor and include codes such as a financial institution ID in the file. This is why a file downloaded as QBO is intended to import cleanly into QuickBooks, while a QFX is intended for Quicken.
OFX is the underlying open standard that both build on. A plain OFX file is more generic and is used by various programs. QIF (Quicken Interchange Format) is an older, simpler text format that Quicken once used; it is still accepted in some places but has been largely replaced by QFX for bank downloads.
How to open a QFX file
The intended way is to open it in Quicken. With Quicken installed, double-clicking a .qfx file usually launches an import process that asks which account the transactions belong to. This is the cleanest path if Quicken is your accounting tool.
If you only want to read the contents, you can open the file in any text editor such as Notepad or TextEdit. You will see the raw tags and values. This is useful for checking what is inside but is not practical for bookkeeping or analysis.
If you do not use Quicken, or you need the data in a spreadsheet, you will need to convert the file. QFX does not open directly in Excel in a usable way because Excel does not understand the tag structure. You can convert a QFX into CSV or Excel so the transactions land in clean columns: date, description, amount, and balance.
Statemently can take a QFX file and produce a CSV or Excel file with the transactions parsed into rows and columns, which you can then review, edit, or import into another tool.
Common problems and how to handle them
A frequent issue is a bank file that imports into the wrong program or refuses to import at all. Because QFX is tied to Quicken and QBO is tied to QuickBooks, downloading the wrong format from your bank is a common cause. Check your download options and pick the format that matches your software.
Another issue is a file that opens but shows duplicate or missing transactions. This usually comes from overlapping date ranges in repeated downloads, not from the file format itself. Compare the statement date range in the header before importing.
If you need the data outside Quicken entirely, treat the QFX as a source file and convert it. Once it is in CSV or Excel, you can map the columns to whatever your accounting system expects, including imports into QuickBooks Online, Xero, or Wave.