Convert non-importable QIF files to importable QIF and import into Quicken PC 2005-2019, Quicken 2007 Mac, LessAccounting, YNAB, NetSuite, MYOB, AceMoney

Convert non-importable QIF files to importable QIF and import into Quicken PC 2005-2019, Quicken 2007 Mac, LessAccounting, YNAB, NetSuite, MYOB, AceMoney

This tutorial shows how to convert QIF to correct QIF and import into Quicken 2017. We will use FixMyQIF utility.

Step by step instructions for Windows

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

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

FixMyQIF Windows Step 1: select a QIF file

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

FiMy2QIF Windows Step 2: review transactions before converting

Select the QIF Target to match your Quicken version or your accounting software.

FixMyQIF Windows Step 3: QIF Target

Set the Account Name and the Account Type to create a QIF file for the right account.

FixMyQIF Windows Step 4: Account name and the Account type

Set expected date format for your accounting software.

FixMyQIF Windows Step 5: date format

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

FixMyQIF Windows Step 6: click convert

Confirm the file name and location.

FixMyQIF Windows Step 7: file name and location, save

Import created QIF file into Quicken 2017

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 a new QIF file.

FixMyQIF Windows Step 8: file import in Quicken

And select a Quicken account to import or 'All account' for Quicken 2017, 2014 or older.

FixMyQIF Windows Step 9: all accounts in Quicken

Then click the 'Import' button.

FixMyQIF Windows Step 10: click import in Quicken

Then click the 'Done' button.

FixMyQIF Windows Step 11: QIF import successful in Quicken

Now your data is imported. You can accept all transactions.

FixMyQIF Windows Step 12: data is imported in Quicken

You can review transactions after import. They are now inside Quicken.

FixMyQIF Windows Step 13: Review transaction after import in Quicken

Step by step instructions for macOS

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

FixMy2QIF Mac Step 1: select a QIF file

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

FixMyQIF Mac Step 2: review transactions before converting

Select the QIF Target to match your Quicken version or your accounting software.

FixMyQIF Mac Step 3: QIF Target

Set the Account Name and the Account Type to create a QIF file for the right account.

FixMyQIF Mac Step 4: Account Type

Set expected Date format for your accounting software.

FixMyQIF Mac Step 5: date format

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

FixMyQIF Mac Step 6: convert

Confirm the file name and location.

FixMyQIF Mac Step 7: 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 a created QIF file.

FixMyQIF Mac Step 8: import transactions in Banktivity

Select a Quicken account to import.

FixMyQIF Mac Step 9: select account in Banktivity

Then click the 'Continue' button.

FixMyQIF Mac Step 10: import results in Banktivity

Now your data is imported. Review transaction after import.

FixMyQIF Mac Step 11: data is imported in Banktivity

Related articles