What is QFX file format and how to open it?

The QFX format is a file format used for importing and exporting financial data, such as transactions and account information. It is an open standard. Many personal finance and accounting programs support it.

Why the QFX format is used?

QFX is based on the OFX (Open Financial Exchange) format. OFX is a widely used standard for sharing data between banks and software. Like OFX, QFX files carry transactions and account details between banks and personal finance programs.

A key strength of QFX is that it's an open standard. No single bank or software company owns it. This makes it easy to share data no matter which programs you use.

QFX files can also hold other financial data, like investment and tax information. This makes QFX useful for tracking a wide range of financial records.

Use ProperConvert to access or convert transaction files from QFX and to the QFX format.

How to open a QFX file in Excel

QFX is mainly used to import data into programs like Quicken. To work with a QFX file in Excel, convert it to CSV or Excel first.

Use the ProperConvert app to convert your transaction files to CSV/Excel formats.

How to view or open a QFX file

Supported Account types

Differences for Quicken for Windows and Quicken for macOS

The main difference between Quicken for Windows and Quicken for Mac is how the Memo field from a QFX file is imported:

Quicken Sunset policy

QFX format is the format to import transactions into Quicken.

Quicken must be no more than three years old to import ".QFX" files. See the Quicken sunset policy for details.

For older Quicken versions, use QIF format or a converter that outputs QIF.

Quicken (PC or Mac) imports QFX files through File->Import->Web Connect

Learn More

Related articles