QFX File Format: How to Open a QFX File and What Is Inside One

QFX is OFX with two Intuit tags added

Open a .qfx and a .ofx side by side and they look almost identical. Both follow the OFX 1.x SGML specification, both start with the same colon-separated header lines, and both wrap each transaction in a STMTTRN block with the same date, amount, and ID tags. The difference is a financial-institution section carrying Intuit identifiers, which is what tells Quicken the file is meant for it and which bank it came from. Everything you know about reading an OFX file structure carries over directly.

That small addition is the whole licensing story. Intuit charges financial institutions a fee to issue Web Connect files, and Quicken enforces it by checking the identifiers before it imports anything. The data format is open; the permission to use it is not.

The QFX header block

A QFX file opens with plain-text header lines before any markup. They declare the version and encoding, and Quicken reads them first. If this preamble is missing or malformed, the file is rejected before a single transaction is parsed.

The Intuit tags that make it a QFX

These two tags are the entire practical difference between a .ofx and a .qfx. They sit near the sign-on section, and Quicken checks them before it will accept the import.

QuickBooks uses the same mechanism with its own branding values, which is why a QBO file and a QFX file are structurally siblings that still cannot be swapped for one another.

The tags inside a QFX transaction

Every transaction is a STMTTRN block. These are the fields you will see, and the spreadsheet column each one becomes.

Around the transaction list sit a few blocks worth knowing: BANKACCTFROM holds the routing number, account number, and account type; DTSTART and DTEND give the statement period; and LEDGERBAL carries the closing balance with its own date. Those are the values to check a conversion against.

TRNTYPE values you will see

The OFX specification defines a fixed list of transaction types, and QFX uses the same set. Anything outside it is not valid OFX.

How to open a QFX file

Which route makes sense depends on whether you want to read the file, use it in Quicken, or get the numbers into a spreadsheet.

QFX vs OFX vs QBO vs QIF

Four extensions, one family, and a lot of confusion about which one a given program wants. This is the short version.

The practical rule: match the file to the program. Quicken wants QFX, QuickBooks wants QBO, most other software takes OFX, and QIF is the fallback when you need categories to travel with the transactions. There is a fuller walkthrough in our comparison of OFX vs QFX vs QBO.

What to check after reading a QFX file

Four quick checks catch nearly every problem before it reaches a reconciliation.

Count the rows you ended up with against the number of STMTTRN blocks in the file, since a text editor search for STMTTRN gives you the exact figure. Compare the sum of the amount column plus the opening balance to the value in the LEDGERBAL block. Confirm the dates were read as dates rather than as the raw YYYYMMDD text, which is the most common issue after any OFX-family import. Finally, check that debits came through negative, because a file where every amount is positive will reconcile to the wrong balance without ever looking wrong.

When your bank will not give you a working QFX

Plenty of banks and nearly all credit unions never signed up for Web Connect, and closed accounts stop offering downloads entirely. At that point the QFX route is closed no matter what you do to the file, and the statement PDF is what you actually have. That PDF converts to a spreadsheet, or to a QBO or OFX file, neither of which depends on a Quicken subscription or an Intuit branding list to open.

To be clear about scope: BankXLSX reads statement PDFs and images, not .qfx files, and it exports Excel, CSV, QBO, and OFX rather than a native .qfx. If Quicken specifically is the destination, the Quicken bank statement converter page sets out which formats Quicken actually accepts and where each one falls short, and the step-by-step version lives in our guide to importing bank statements into Quicken. If a spreadsheet is the real destination, the PDF bank statement to Excel converter and the main bank statement converter take the same upload.

Working the other way round, from a spreadsheet into accounting software, a CSV to QBO converter turns exported rows into an importable Web Connect file, and for business PDFs that are not statements at all a general PDF to Excel converter handles reports and tables.