Convert QFX files to QIF and import into Quicken (QFX2QIF)

Need to import bank or credit card transactions in a QFX file into Quicken for Windows or other QIF importing software or online service, but cannot seem to make it work? The problem is that your bank only provides transactions in a QFX format that Quicken for Windows or other QIF importing software or online service cannot read.

The Solution: try ProperConvert (QFX2QIF) app. It can convert your transactions into a format from QFX to QIF.

Pricing Download

Convert QFX bank or credit card transaction files to QIF

How can I use ProperConvert to convert transactions from QFX format?

Always Backup your accounting software company data file

Before importing any files into your accounting software, make sure to backup your company data file. Apps like QuickBooks or Quicken provide easy to use and fast backup options that will take few seconds and save you lots of lost time in case of incorrect import. Import data with confidence you can easily rollback to previous state. Do backups for major changes like disabling online services as well.

Many accounting software packages like QuickBooks Desktop (any edition like QuickBooks Pro or QuickBooks Premier or QuickBooks Accountant) provide a buffer zone (bank feeds center) to review imported transactions and delete (ignore) or add to the register. Online solutions like Xero or QuickBooks Online have similar interface to review and match imported transactions.

Use the ProperConvert app to convert QFX to QIF. Other formats are supported as well.

Step by step instructions for Windows

This tutorial shows how to convert a QFX file from your bank or credit card statement to QIF and import into Quicken. If your Quicken is no longer imports QFX (web connect) files, convert them to QIF format and import.

Follow the steps below for the Windows version, followed by the Mac version.

Make sure you are using the latest version of QFX2QIF. Download it from the QFX2QIF download page. Start QFX2QIF and select a QFX file.

QFX2QIF Windows Step 1: select a QFX file

Review transactions before converting, check that dates are correct, have the correct year, deposits, and withdrawals are assigned correctly.

QFX2QIF Windows Step 2: Review transactions before converting

Select the QIF Target to match your Quicken version or your accounting software: Quicken 2018+, Quicken 2017 or earlier, Banktivity, Microsoft Money, NetSuite, MYOB, Reckon, YNAB, Quicken UK, AccountEdge, old Microsoft Money non-US, Quicken 4, Quicken French 2015.

QFX2QIF Windows Step 3: QIF Target

Set the Account Name (must be matched as you have in Quicken) and the Account Type (must be matched as you have in Quicken) to create a QIF file for the right account. Set 'Output dates' if applicable.

QFX2QIF Windows Step 4: Account name and the Account type

Click the 'Convert' button to create a QIF file.

QFX2QIF Windows Step 5: click convert

Confirm the file name and location.

QFX2QIF Windows Step 6: file name and location, save

Import created QIF file into Quicken

Now the QIF file is created, let's switch to Quicken and import created QIF file. Before importing a QIF file make sure to backup your data. To import a QIF file, select 'File' - 'File Import' - 'QIF File', select created QIF file.

QFX2QIF Windows Step 7: file import in Quicken

For Quicken 2017 or earlier, it is important to select ''All Accounts''. For Quicken 2018 or later, you have to select the actual account.

QFX2QIF Windows Step 8: all accounts in Quicken

Then click the 'Import' button.

QFX2QIF Windows Step 9: click import in Quicken

Then click the 'Done' button.

QFX2QIF Windows Step 10: QIF import successful in Quicken

Now your data is imported. Click 'Accept All' transactions - 'Done'.

QFX2QIF Windows Step 11: data is imported in Quicken

Review transactions after import.

QFX2QIF Windows Step 12: Review transaction after import in Quicken

See this Windows tutorial as a video:

Step by step instructions for macOS

Make sure you are using the latest version of QFX2QIF. Download it from the QFX2QIF download page.

QFX2QIF Mac Step 1: select an OFX file

Review transactions before converting, check that dates are correct, have the correct year, deposits, and withdrawals are assigned correctly.

QFX2QIF Mac Step 2: review transactions before converting

Make sure to set the Account Name and the Account Type to create a QIF file for the right account. Set the Date format if applicable.

QFX2QIF Mac Step 3: Account name and Account Type

Select the QIF Target to match your Quicken version or your accounting software: Quicken 2018+, Quicken 2017, Quicken 2015-2016, Quicken 2014 or earlier, Banktivity, Microsoft Money, NetSuite, MYOB, Reckon, YNAB, Quicken 2007 for Mac, Quicken UK, AccountEdge.

QFX2QIF Mac Step 4: QIF Target

Click the 'Convert' button to create a QIF file.

QFX2QIF Mac Step 5: click Convert

Confirm the file name and location.

QFX2QIF Mac Step 6: confirm file name and location

Import created QIF file into Banktivity

Now the QIF file is created, let's switch to Banktivity and import created QIF file. Before importing a QIF file make sure to backup your data. To import a QIF file, select 'File' - 'Import transactions'. Then click 'Import File' and select the created QIF file.

QFX2QIF Mac Step 7: import transactions in Banktivity

Select a Quicken account to import.

QFX2QIF Mac Step 8: select account in Banktivity

Then click the 'Continue' button.

QFX2QIF Mac Step 9: import results in Banktivity

Now your data is imported. Review transactions after import.

QFX2QIF Mac Step 10: data is imported in Banktivity

See this macOS tutorial as video:

Related articles