Import Quicken QFX files into Excel

This tutorial shows how to convert Quicken QFX to CSV/Excel. It uses an older utility, but applicable to the current converter app (click on CSV tab on the right sidebar to convert to CSV). See this tutorial as a video at https://www.youtube.com/watch?v=Qjo1pUlo5uE

We will use a sample QFX file.

This file has four transactions.

You can see how the file looks like, what transactions it has and how the Parser transforms that QFX file to one transaction per line spreadsheet, you can see all these details.

Before converting, you can select which flavor of CSV you would like: Regular CSV will be copied to CSV or Excel file. Or if you have a specific software CSV format, like CSV Quickbooks Online, then fewer columns will be saved, but the file will be compatible with Quickbooks Online. So, Quickbooks Online imports that file without any issues. Or you would import it without selecting columns during import because it will say only columns, that Quickbooks Online needs. Or CSV Xero, which will save an additional reference column, that this software imports.

You can decide, which Date format will be in your CSV file. Like typically Quickbooks Online imports as MM/DD/YYYY or DD/MM/YYYY.

You can set 'Duplicate Payee as Memo when missing' in your QFX file if you like.

Set 'Open after conversion' if you want to open a CSV file after a conversion, using your default application in the system, like Excel.

To complete the conversion you just click the 'Convert' button.

Choose a name for your CSV file, you can also change the folder, where the file is saved. And then click 'Save'.

The software tells you to open Xero and import the CSV file.

It shows you how a CSV file looks like: Date, Amount, Payee, Description, Reference, Check Number, and how Xero can import those columns in a CSV file.

If you choose Target, for example, CSV Quickbooks Online, it imports fewer columns. In this case, it will be just the Date, Amount, and Description.