Convert QFX to Excel Free.
In your browser, nothing uploaded.

1. 1Open the free OFX / QFX to CSV tool and drop the .qfx. Both the SGML layout of OFX 1.x and the XML layout of OFX 2.x are read; the header block is not required, and the file is not uploaded.
2. 2Check the currency, account id and ledger balance shown above the table. They come from CURDEF, ACCTID and LEDGERBAL in the file; the account type follows whether the file uses the bank or the credit-card message set.
3. 3Look over the rows. Each STMTTRN becomes one line with DTPOSTED as the date, NAME and MEMO joined as the description and TRNAMT as a signed amount, money out negative. Edit a row if a description is cut short or a sign looks wrong.
4. 4Download Excel. The workbook has a Transactions sheet with Date, Description, Money out, Money in, Amount, Balance and Category, and a Summary sheet whose totals by category are live formulas. CSV and Xero CSV are offered beside it.

A QFX file is an OFX file with INTU.BID, and sometimes INTU.USERID, added to the sign-on block for Quicken. INTU.BID is a number from the directory of institutions licensed for Quicken’s Web Connect, and Quicken checks it online at import time, refusing a plain .ofx and any .qfx whose number it does not recognise. The transaction list inside is ordinary OFX, which is why other software reads .qfx and .ofx alike.

An .xlsx workbook holds typed cells, so amounts can be numbers rather than text and dates can be dates, which is what makes SUM, pivot tables and lookups work. The workbook written here has a Transactions sheet with Date, Description, Money out, Money in, Amount, Balance and Category, and a Summary sheet whose totals by category are live formulas, so relabelling a category updates the totals.