How to convert OFX to QFX (Web Connect) and import into Quicken

How to convert OFX to QFX (Web Connect) and import into Quicken

This tutorial shows how to convert OFX to QFX and import into Quicken. We will use OFX2QFX utility.

We will use a sample OFX file.

How to convert OFX to QFX (Web Connect) and import into Quicken Step 1: sample OFX file

You can review transactions before converting and then you just click the 'Convert' button to create a QFX file.

How to convert OFX to QFX (Web Connect) and import into Quicken Step 2: convert

There are other settings, like INTU.BID value, which corresponds to bank label, you can leave it as '3000' ("Wells Fargo Bank") or change to the another Bank, it doesn't matter.

How to convert OFX to QFX (Web Connect) and import into Quicken Step 3: INTU.BID

Click the 'Convert' to create a sample.qfx file.

How to convert OFX to QFX (Web Connect) and import into Quicken Step 4: create qfx

Then switch to Quicken. Click 'File' - 'File Import' - 'Web Connect (.QFX) File' and 'Open'.

How to convert OFX to QFX (Web Connect) and import into Quicken Step 5: file import

We see here 'Create a new account' or 'Link to an existing account'.

How to convert OFX to QFX (Web Connect) and import into Quicken Step 6: import downloaded transactions, create

You can import into Proxy account, called 'Import' and then move transactions to another account, which is a good way to import things if you have already existing account, which directly downloaded from your Bank. So, you don't change things, as they are. If you need to import transactions for the previous month, you don't change anything existing, you just go back, import into a new account and just move transactions to another account. You can also choose 'Link to an existing account'. This account must be deactivated from direct download because Quicken will not be listed. Click the 'Import' button.

How to convert OFX to QFX (Web Connect) and import into Quicken Step 7: import downloaded transactions, link

Now we see imported transactions. Click 'Accept All'.

How to convert OFX to QFX (Web Connect) and import into Quicken Step 8: accept all

If you have more accounts, let's say, that you have 'Checking' account.

How to convert OFX to QFX (Web Connect) and import into Quicken Step 9: accepted transactions

And you want transactions there, then you click on the first transaction, click on the last transaction - they are selected. Then right click - 'Cut transaction(s)'. In Quicken 2015-2016 there is a manual item, called 'Move transaction(s)'.

How to convert OFX to QFX (Web Connect) and import into Quicken Step 10: cut transactions

Let's create new Account: click 'Tools' - 'Add Account'.

How to convert OFX to QFX (Web Connect) and import into Quicken Step 11: add account

Let's say it will be 'Checking' account.

How to convert OFX to QFX (Web Connect) and import into Quicken Step 12: checking

Maybe setup, as your Bank or setup manually, or it already exists. Click 'Advanced Setup'.

How to convert OFX to QFX (Web Connect) and import into Quicken Step 13: choose bank

Then select 'I want to enter my transactions manually', enter the name you'd like to use for this account in Quicken, enter ending date and balance from your latest statement and click 'Finish'.

How to convert OFX to QFX (Web Connect) and import into Quicken Step 14: enter transactions manually

Switch to the 'Checking' account, right-click - 'Paste transactions'.

How to convert OFX to QFX (Web Connect) and import into Quicken Step 15: paste transactions

Now transactions are under 'Checking' account, pasted from the 'Import' account.

How to convert OFX to QFX (Web Connect) and import into Quicken Step 16: moved transactions

Now 'Import' account doesn't have these transactions anymore. 'Import' is a good proxy approach because this is like your temporary place. If you are cutting, pasting transactions or whatever is left, you can still review, you can delete, you know, that transactions are imported here. So, whatever you see here - is only here. What you choose to move to your actual account - you move after import.

How to convert OFX to QFX (Web Connect) and import into Quicken Step 17: import account

Related articles