QIF2QFX: Convert QIF to QFX (Web Connect)

Finally, the solution to import your transactions. Convert QIF to QFX and import into Quicken 2019, 2018, 2017, (Win/Mac). Created QFX files are regular Web Connect files for Quicken. Review transactions in a readable view before converting



What can I do with QIF2QFX (QIF to QFX Converter)?

Why should I trust QIF2QFX?

If I need any help with conversion, can you help me?

Can I try before purchasing?

Convert QIF to QFX (Web Connect) and import into Quicken 2019, 2018, 2017, 2016 (Win/Mac)

This tutorial shows how to convert a QIF file from your bank or credit card statement to QFX (Web Connect) and import into Quicken. We will use QIF2QFX 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 QIF2QFX. Download it from the QIF2QFX download page. Start QIF2QFX and select a QIF file.

QIF2QFX Windows Step 1: select a QIF file

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

QIF2QFX Windows Step 2: Review transactions before converting

Before converting select the QFX target to match your Quicken version or your accounting software: Regular QFX, Quicken 2018+, Quicken 2017, Quicken 2016, Quicken 2015, YNAB.

QIF2QFX Windows Step 3: QFX target

For Quicken, set INTU.BID to match your bank or keep the default value. INTU.BID defines bank label shown during import. It has to be from the allowed bank. You can try to locate your bank, make sure a bank you choose supports the account type you are converting for. You have to leave it empty if your bank is not listed, so default Wells Fargo Bank Label (3000) will be used.

QIF2QFX Windows Step 4: INTU.BID

Set the Account ID (number) and the Account Type to create QFX for the right account. For multiple accounts, use a different account ID for each account.

QIF2QFX Windows Step 5: Account ID and Account Type

Currency should be USD even for non-USD accounts for Quicken US edition. For Canadian edition, you can use USD and CAD. And for the UK edition, GBP currency must be set. You can also set End balance, Bank ID, Branch ID if your accounting software requires it.

QIF2QFX Windows Step 6: Currency

Click 'Convert' button to create a QFX file.

QIF2QFX Windows Step 7: click Convert

Confirm the file name and location.

QIF2QFX Windows Step 8: file name and location, save

Import created QFX file into Quicken

Now the QFX file is created, let's switch to Quicken and import created QFX file. Before importing QFX file backup your data file and make sure that account is not connected to online services. Right-Click - 'Edit/Delete account'.

QIF2QFX Windows Step 9: edit account in Quicken

Then click 'Online Services' and click on 'Deactivate' button. Then click 'Yes' and 'Ok'.

QIF2QFX Windows Step 10: deactivate in Quicken

To import a QFX file, select 'File' - 'File Import' - 'Web Connect (.QFX) File', select created QFX file.

QIF2QFX Windows Step 11: file, import, web connect in Quicken

You can select 'Create a new account' or you can select 'Link to an existing account to import transactions'. If you are disconnected from online services, that account will be shown on the list. You may choose to keep online services connected and import into a new account, if you have something temporary to import. You can import in that account, and then move transactions from that account to another account. So this way you will keep existing account connected to online services and you don't have to connect it back later.

QIF2QFX Windows Step 12: link to an existing account in Quicken

Then click 'Import' button.

QIF2QFX Windows Step 13: click import in Quicken

Then click 'Close' button.

QIF2QFX Windows Step 14: one step update summary in Quicken

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

QIF2QFX Windows Step 15: data is imported in Quicken

Review transactions after QFX import.

QIF2QFX Windows Step 16: Review transactions after QFX import in Quicken

Step by step instructions for macOS

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

QIF2QFX Mac Step 1: select a QIF file

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

QIF2QFX Mac Step 2: Review transactions before converting

Set the Account ID (number) and the Account Type to create QFX for the right account. For multiple accounts, use a different account ID for each account.

QIF2QFX Mac Step 3: Account ID

Currency should be USD even for non-USD accounts for Quicken US edition. For Canadian edition, you can use USD and CAD. And for the UK edition, GBP currency must be set. You can also set End balance, Bank ID, Branch ID if your accounting software requires it.

QIF2QFX Mac Step 4: Currency

For Quicken, set INTU.BID to match your bank or keep the default value. INTU.BID defines bank label shown during import. It has to be from the allowed bank. You can try to locate your bank, make sure a bank you choose supports the account type you are converting for. You have to leave it empty if your bank is not listed, so default Wells Fargo Bank Label (3000) will be used.

QIF2QFX Mac Step 5: INTU.BID

Click 'Convert' button to create a QFX file.

QIF2QFX Mac Step 6: Click Convert

Confirm the file name and location.

QIF2QFX Mac Step 7: Confirm the file name

Import created QFX file into Quicken

Now the QFX file is created, let's switch to Quicken and import created QFX file. Before importing a QFX file backup your data file and click 'Quicken' - Preferences' and 'Connected Services'.

QIF2QFX Mac Step 8: preferences in Quicken

Make sure to uncheck 'Clean up payees. Automatically improve quality of downloaded payee names', because when this checkbox set, it could change the payee names to something unrecognizable, not what you have on QFX File.

QIF2QFX Mac Step 9: clean up payees in Quicken

Before converting into specific account make sure that account is not connected to online services. Right-click - 'Edit' account.

QIF2QFX Mac Step 10: edit settings in Quicken

If you see, for example, Connection Type (Web Connect), it means that it is connected. We have to disconnect from online services first. Click on 'Set up transaction download'.

QIF2QFX Mac Step 11: Set up transaction download in Quicken

Then click 'Options' button.

QIF2QFX Mac Step 12: Options button in Quicken

Select 'Manual' and click 'Continue' button.

QIF2QFX Mac Step 13: manual in Quicken

Click 'Finish' button. This way you disconnect from direct online download and now you can import a QFX file into this account.

QIF2QFX Mac Step 14: account added,finish in Quicken

To import a QFX file, select 'File' - 'Import' - 'Bank or Brokerage File (OFX, QFX)', select created QFX file.

QIF2QFX Mac Step 15: file, import in Quicken

And select an existing account to import transactions instead 'Add a new Quicken account'. Click 'Continue' button.

QIF2QFX Mac Step 16: select an existing account in Quicken

Now your transactions are imported. You can categorize, review, delete them. They are already inside Quicken.

QIF2QFX Mac Step 17: data imported in Quicken