Convert QFX to CSV 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 the CSV: Date, Description, Money out, Money in, Amount, Balance and Category columns, which open cleanly in Excel, Numbers and Google Sheets. Excel, Xero CSV, a QuickBooks CSV and a .qbo are offered on the same page.

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.

A CSV is a flat text table: one line per transaction, fields separated by commas, semicolons or tabs, usually with a header row. Which column holds the date, the description, the amount (or money out and money in) and whether a running balance is present varies by bank, and nothing in the file says which date order it uses. Every spreadsheet and most accounting packages read CSV; QuickBooks Desktop does not.