How to Convert QIF to QFX?

AccountsComparison
4 min readSep 29, 2021

--

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

This tutorial shows the way to convert a QIF file from your bank or mastercard statement to QFX (Web Connect) and import into Quicken. We’ll use the QIF2QFX utility. IMPORTANT: QIF2QFX is now replaced with the Transactions app, which converts from more formats and converts to more formats.

convert qif to qfx

Step by step instructions for Windows

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

Make sure you’re using the newest version of QIF2QFX. Download it from the QIF2QFX download page. Start QIF2QFX and choose a QIF file.

Review transactions before converting, make sure dates are correct, have the right year, deposits, and withdrawals are assigned correctly.

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

Set INTU.BID to match your bank or keep the default value. The INTU.BID value defines the bank label shown during import. it’s to be from the allowed bank. You’ll attempt to locate your bank. Confirm a bank you select , supports the Account Type you’re converting for. You’ve got to go away it empty if your bank isn’t listed, therefore the default Wells Fargo Bank Label (3000) are going to be used.

Set the Account ID (number) and therefore the Account Type to make QFX for the proper account. For multiple accounts, use a special Account ID for every account.

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

Click the ‘Convert’ button to make a QFX file.

Confirm the file name and site

Import created QFX file into Quicken

TO convert qif to qfx Now the QFX file is made , let’s switch to Quicken and import created QFX file. Before importing a QFX file backup your file and confirm that the account isn’t connected to online services. Right-Click — ‘Edit/Delete account’.

Then click ‘Online Services’ and click on on the ‘Deactivate’ button. Then click ‘Yes’ and ‘Ok’.

To import a QFX file, select ‘File’ — ‘File Import’ — ‘Web Connect (.QFX) File’, select created QFX file.

You can select ‘Create a replacement account’ otherwise you can select ‘Link to an existing account to import transactions’. If you’re disconnected from online services, that account are going to be shown on the list. You’ll prefer to keep online services connected and import into a replacement account if you’ve got something temporary to import. You’ll import therein account, then move transactions from that account to a different account. So this manner you’ll keep the prevailing account connected to online services and you do not need to connect it back later.

Then click the ‘Import’ button.

Then click the ‘Close’ button.

Now your data is imported. You’ll accept all transactions.

Review transactions after QFX import.

Make sure you’re using the newest version of QIF2QFX. Download it from the QIF2QFX download page. IMPORTANT: QIF2QFX is now replaced with the Transactions app, which converts from more formats and converts to more formats.

Start QIF2QFX and choose a QIF file.

Review transactions before converting, make sure dates are correct, have the right year, deposits, and withdrawals are assigned correctly.

Set the Account ID (number) and therefore the Account Type to make QFX for the proper account. For multiple accounts, use a special Account ID for every account.

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

Set INTU.BID to match your bank or keep the default value. The INTU.BID value defines the bank label shown during import. it’s to be from the allowed bank. you’ll attempt to locate your bank. confirm a bank you select , supports the Account Type you’re converting for. you’ve got to go away it empty if your bank isn’t listed, therefore the default Wells Fargo Bank Label (3000) are going to be used.

Click the ‘Convert’ button to make a QFX file.

Confirm the file name and site .

Import created QFX file into Quicken

Now the QFX file is made , let’s switch to Quicken and import created QFX file. Before importing a QFX file backup your file and click on ‘Quicken’ — Preferences’ and ‘Connected Services’.

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

Before converting into a selected account, confirm that the account isn’t connected to online services. Right-click — ‘Edit’ account.

If you see, for instance , Connection Type (Web Connect), it means it’s connected. we’ve to disconnect from online services first. Click on ‘Set up transaction download’.

Then click the ‘Options’ button.

Select ‘Manual’ and click on the ‘Continue’ button.

Click the ‘Finish’ button. this manner you disconnect from direct online download and now you’ll import a QFX file into this account.

To import a QFX file, select ‘File’ — ‘Import’ — ‘Bank or Brokerage File (OFX, QFX)’, select created QFX file.

And select an existing account to import transactions rather than ‘Add a replacement Quicken account’. Click the ‘Continue’ button.

Now your transactions are imported. you’ll categorize, review, delete them. they’re already inside Quicken.

Source Page: https://accountscomparison.wordpress.com/2021/09/29/how-to-convert-qif-to-qfx/

--

--

AccountsComparison

Compare Accounting Software to choose best accounting software for your business.