Convert OFX to QFX and import into Quicken (macOS)
Access ProperSoft tools at https://www.propersoft.net/
This tutorial shows how to convert an OFX file from your bank or credit card statement to QFX (Web Connect) and import into Quicken.
00:00 - Download OFX2QFX
00:17 - Start OFX2QFX and select a file with transactions
00:26 - Review transactions before converting
00:29 - Set the Account ID and Account Type
00:50 - Set the Currency
01:00 - Set the Bank INTU.BID
01:42 - Convert to QFX file
01:56 - Switch to Quicken
02:04 - 'Automatically improve the quality of downloaded payee names and categories' option
02:27 - Disconnect from online services before importing
03:01 - Import a QFX file
03:27 - Select the account to import data into
03:38 - Review the transactions
Step by step instructions for macOS:
Use ProperSoft OFX2QFX to convert OFX to QFX (Web Connect) and import into Quicken (Win/Mac). Download it and make sure you are using the latest version of the OFX2QFX.
Start OFX2QFX and select an OFX file.
Review transactions before converting, check that dates are correct, have the correct year, deposits and withdrawals are assigned correctly.
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.
Currency should be USD even for non-USD accounts for the Quicken US edition. For the Canadian edition, you can use USD and CAD. And for the UK edition, GBP currency must be set.
For Quicken, set INTU.BID to match your bank or keep the default value. The INTU.BID value defines the bank label shown during import. 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 the default - Wells Fargo Bank Label will be used.
Click the 'Convert' button to create a QFX file.
Confirm the file name and location.
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'.
Make sure to uncheck 'Automatically improve the quality of downloaded payee names and categories', because when this checkbox set, it could change the payee names to something unrecognizable, not what you have on QFX File.
Before converting into the specific account, make sure that the account is not connected to online services. Right-click - 'Edit' account.
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'.
Then click the 'Options' button.
Select 'Enter transactions manually' and click the 'Continue' button.
Click the 'Finish' button. This way you disconnect from direct online download and now you can 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 instead 'Add a new Quicken account'. Click the 'Continue' button.
Now your transactions are imported. You can categorize, review, delete them. They are already inside Quicken.