What is a QFX file, and why Quicken may reject it

You clicked a download link at your bank and picked the option that wasn’t a spreadsheet. Now you have a file your computer has no idea what to do with. Here’s what’s inside it, and what it’s for.

Where the file came from

Your bank put it there. On most download screens it sits beside CSV and Excel. It’s labeled either QFX or Web Connect, which is Quicken’s name for the same thing. The letters stand for Quicken File eXchange.

It’s the fallback option rather than the main one. Quicken tells you to use Direct Connect or Express Web Connect when your bank supports either of them. Those two pull your transactions in on their own. A QFX is the manual version. You fetch the file, then you feed it in.

The license fee inside the file

A QFX is a standard OFX file with extra fields added. Those fields carry a license fee the bank pays Intuit. OFX on its own is an open standard, and it costs nothing to use. The extra tags are what make a copy of it a QFX.

That one difference explains most of the trouble people have with these files.

Quicken checks for those tags. When a bank hasn’t paid, Quicken turns the file down. It reports that it’s “currently unable to verify the financial institution information for this download.” Nothing is wrong with the transactions inside. The file simply doesn’t carry the tag Quicken looks for.

You get the same message when a Quicken subscription has lapsed. That one sends people hunting for a corrupt file that was never corrupt.

What opens one

Quicken is the app it’s built for. Back up your data file first, then open the File menu, choose File Import, and pick Quicken Transfer Format (.QFX) File. Point it at your download and the transactions land in the register.

Because a QFX is an OFX underneath, software that reads OFX can usually read it too. A spreadsheet app is the one place it doesn’t belong. The file holds tagged records rather than rows and columns, which is why double clicking it rarely does anything useful.

Two things to get right at the download screen

The date range. You pick a start and an end date before the file is built. Quicken suggests starting on the day of your last recorded transaction, or the day after it. That way you’re not pulling months you already have.

Duplicates. Quicken says to read through the register once the import finishes, and to delete one of each pair it doubled up. Overlapping date ranges are the usual reason a transaction lands twice.

Four extensions, and the app each one wants

Extension	The app that wants it
.QBO	QuickBooks Online and Desktop
.QFX	Quicken
.OFX	Xero, Moneydance, GnuCash and others
.QIF	Older versions of Quicken

All four carry the same three things: a date, a description, and an amount. Which one you need comes down to which app is waiting for it.

When your bank only gives you a spreadsheet

Plenty of banks have stopped offering the Quicken formats. You get a CSV or an Excel file, and your accounting app wants one of the four above. The download screen has nothing that bridges the two. Retyping a month by hand is one way across. Handing the statement to a converter website is the other, and a statement lists every place you spent money, how much, and when.

That gap is what FileInto was built for. It reads the spreadsheet your bank gave you and writes the QFX, QBO, OFX or QIF your app will accept. The conversion runs inside your own browser tab, so the statement is never uploaded anywhere. That counts for more here than it would on most file conversions. Every converter previews every row at no charge, and files up to 25 transactions download without an account.

We wrote up how the browser part works when it launched, and the rest of the software we run sits alongside it.