Glossary
What Is a QFX File?
A QFX file is a transaction download. Your bank or your broker writes out a statement with dates, amounts and payees in Intuit's own variant of the OFX format, and Quicken reads it. The data model is plain OFX. What the three letters add is ownership: the file is addressed to one product line, and that single fact explains almost everything people run into with a .qfx, from where it came from to why nothing on the computer wants to open it.
TL;DRA QFX file is an OFX statement written for Quicken, which is why your bank offers it and why little else opens it. Quicken, GnuCash and QuickBooks Online can import it; to read it anywhere else, convert it to PDF or CSV.
2 routes
Intuit puts one specification to work in two ways, OFX over a live Direct Connect link and a downloadable .qfx for Web Connect, and the route the data travelled decides which extension lands in your Downloads folder
QFX Is OFX With Intuit's Name Attached
Open a .qfx in Notepad and it looks like any other OFX download. A short header comes first, then a statement block for one account, then one entry per transaction. Nothing is compressed and nothing is encrypted. What makes the file a QFX rather than an OFX is that it is a proprietary variant, maintained by Intuit for Intuit's products and carrying tags that only those products care about.
Quicken's own help pages expand the name as Quicken File Exchange, and the import menu inside Quicken lists the same file as Quicken Transfer Format. Both names describe one thing. Neither of them is a separate way of recording money.
OFX is the specification, and its history, the older tag style and the newer XML one, and who looks after it today belong on the OFX page. QFX is what an OFX statement is called once it is written for Quicken. The parallel variant aimed at QuickBooks, along with the institution identifiers it has to carry, lives on the QBO page.
Three extensions, one family. OFX is the specification; QFX and QBO are the product-labelled versions of it. The extension names the program the file was written for, not a different way of recording a transaction.
What Is Inside a QFX File
A typical bank download is a few kilobytes of tagged text. Read top to bottom, it contains these parts:
- A plain header of key and value lines, such as
OFXHEADER:100, DATA:OFXSGML and VERSION:102, which says which edition of OFX the file follows - A sign-on block with
FI, ORG and FID, the bank's short name and number, followed by Intuit's own INTU.BID tag - The account block with the account number, the account type and the start and end of the statement period
- One
STMTTRN record per transaction. The amount sits in TRNAMT and the posting date in DTPOSTED, with the bank's id in FITID and the payee in NAME - The closing balance and the date the balance was taken
Dates are written as digits in year, month, day order, so the third of October 2026 appears as 20261003. Unlike the older QIF format, nothing about a QFX date is ambiguous. FITID is the bank's own id for each transaction. Quicken uses it to recognise a transaction it has already imported, so downloading an overlapping date range does not double the money in the register.
The same file family covers more than checking. A QFX can hold a credit card statement in a separate card block, and brokers write investment statements with positions and trades in an investment block. The older SGML files leave many tags unclosed, while files from OFX 2.x are well-formed XML. A reader has to cope with both. If a script needs a statement PDF as markup instead, write PDF content as XML and load it from there.
Where a .qfx File Comes From
Almost every .qfx starts the same way. You sign in on your bank or broker website, pick an account and a date range, and press a download button that is often labelled Quicken or Web Connect. The institution writes the file, the browser saves it, and the transfer is over.
Web Connect is the name of that route. The file itself is the delivery mechanism, and once it has been saved, nothing else needs to happen online. Quicken recommends Web Connect mainly for banks that do not support Direct Connect or Express Web Connect, and for fetching older transactions that a live connection no longer offers. Direct Connect produces no file at all, because the finance program holds the conversation with the bank and the transactions simply appear inside it. So a .qfx in the Downloads folder is the file-shaped half of a connection that was designed to finish inside Quicken.
The extension is a statement of intent, not a promise of compatibility. Renaming a .qfx to .ofx or .txt changes the label and nothing else, and it will not make a program accept a file it was refusing a moment earlier.
Why Quicken Sometimes Refuses a QFX File
QFX differs from plain OFX in one commercial detail. Its extra fields support a licensing fee that financial institutions pay to Intuit, and Quicken imports a .qfx only from an institution that is on Intuit's list. When the check fails, Quicken shows the message Quicken is currently unable to verify the financial institution information for this download. Nothing is wrong with the transactions in that case.
The same message appears in a less obvious situation. Users whose Quicken subscription has expired get it when they import files they downloaded earlier, even files that imported cleanly before. Older Quicken releases that were sold with a fixed lifetime stopped taking Web Connect files about three years after release, and Quicken 2017 was the last version sold that way. The file stays readable for years. It is the program reading it that loses the right to import.
How to Open a QFX File
Which program opens a .qfx depends on what you want from it.
- In Quicken for Windows, back up the data file and open File > File Import. Pick the Quicken Transfer Format (.QFX) File entry, then match the download to an account.
- GnuCash and Moneydance import QFX through their OFX import,, since underneath the label the data is ordinary OFX.
- QuickBooks Online accepts a .qfx on its bank upload page, but QuickBooks Desktop does not. Its Web Connect import takes only .qbo.
- Notepad or any text editor shows the raw tags, which is enough to check the account and the date range.
- A converter turns the download into a document you can read, print or send.
Double-clicking does nothing useful on a clean Windows install. No program is registered for the extension, so Windows asks which application to use.
Because the file is plain text, opening it in Notepad is a harmless way to check which account and which date range you are actually holding before you decide what to do with it.
Can You Open a QFX File in Excel?
Not directly. Excel has no importer for OFX markup, and opening a .qfx in it gives you one column of tags instead of a table. The workable route is a conversion that reads the transactions out of the file and writes them as CSV, which Excel opens as rows and columns. If the goal is a printed record rather than a spreadsheet, a PDF statement is the shorter path, because it keeps the account, the period and the closing balance on the page together.
Reading a QFX File Without Quicken
If the job is bookkeeping, the file wants an accounting program. If the job is simply to read the statement or hand a printed copy to somebody else, a converter turns the download into a document with the same transactions laid out as a table, in a format that opens on any machine. The SoftOrbits converter runs offline, so the statement stays on your PC. On Windows 10 and 11 you can also get it from the Microsoft Store to
turn bank QFX statements into PDF without a separate installer.
QFX Compared With the Other Bank Formats
The four extensions that turn up in a bank's download menu differ in who they are written for, not in what a transaction is.
- QFX is OFX written for Quicken and delivered by Web Connect, with the institution licence behind it.
- OFX is the open specification itself, which many finance programs read and which carries no product label.
- QBO is OFX written for QuickBooks, checked against the bank's identifiers before QuickBooks reads a single line.
- QIF is the older plain-text Quicken format with one letter per line, no transaction ids and no fixed date order. More on it is on the QIF page.
If a bank offers several of them, take QFX for Quicken, QBO for QuickBooks Desktop, and OFX for anything else. QIF is the fallback when nothing else is on the list.
Related Guides
Related Terms