Convert CSV/Excel to QFX (Web Connect) and import into Quicken

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

CSV2QFX Windows Step 1: select a CSV file

Review transactions before converting. Check that dates are correct, have a correct year (Date), amount, withdrawals and deposits are shown in corresponding columns, check number (Doc/Check#) is assigned. Reassign columns to QFX fields if needed. 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.

CSV2QFX Windows Step 2: QFX target

Expenses must be negative and payments to the account must be positive. Your credit card file may have expenses positive on your Source file. Adjust CSV Mapping if needed. Click 'Charges/Withdrawals' are positive if expenses are positive on the CSV file.

CSV2QFX Windows Step 3: Charges

Set the date format if applicable.

CSV2QFX Windows Step 4: date format

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 will be used.

CSV2QFX Windows Step 5: 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.

CSV2QFX Windows Step 6: Account ID and Account Type

You can also put Account ID (number) as part of Mapping: Output Account ID.

CSV2QFX Windows Step 7: Output Account ID

When you create a Mapping for certain Bank and then you include Account ID and Account Type as part of Mapping. So when you change Mapping, your CSV file will have to be mapped this way, and Account Type and Account ID have to be used as well.

CSV2QFX Windows Step 8: currency

Click 'Convert' button to create a QFX file.

CSV2QFX Windows Step 9: click Convert

Confirm the file name and location.

CSV2QFX Windows Step 10: 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 a QFX file make sure to backup your data. To import a QFX file, select 'File' - 'File Import' - 'Web Connect (.QFX) File', select created QFX file.

CSV2QFX Windows Step 11: file import in Quicken

Import into a new account or existing account (disconnect the account before importing).

CSV2QFX Windows Step 12: import downloaded transactions in Quicken

Then click 'Import' button.

CSV2QFX Windows Step 13: click import in Quicken

Then click 'Close' button.

CSV2QFX Windows Step 14: one step update summary in Quicken

All transactions are imported here, they showed in the bottom part. You can review transactions and use Renaming Rules if you like. Then click 'Accept All transactions'.

CSV2QFX Windows Step 15: accept all transactions in Quicken

They accepted and listed in Quicken.

CSV2QFX Windows Step 16: review transactions in Quicken

You need to disconnect the account before importing from direct download to import QFX files into that account. For Quicken there is an easy way not to touch that account, just import into the new account (called "IMPORT" in these case). And have that (called "Checking" in these case) account untouched.

For example, let's say you have another account. Click 'Tools' - 'Add Account'.

CSV2QFX Windows Step 17: another account in Quicken

Let's say you have Checking account.

CSV2QFX Windows Step 18: checking account in Quicken

Click 'Advanced Setup'.

CSV2QFX Windows Step 19: Click Advanced Setup in Quicken

And you don't want to mess up your existing setup and connection. Click on 'I want to enter my transactions manually'.

CSV2QFX Windows Step 20: I want to enter my transactions manually in Quicken

You can review transactions here, like your special separate place and then you select the transactions, click first one - hold Shift Button - click last one.

CSV2QFX Windows Step 21: select transactions in Quicken

Then right-click - 'Move transactions'.

CSV2QFX Windows Step 22: move transactions in Quicken

Move transactions to Checking and click 'Ok'.

CSV2QFX Windows Step 23: click ok to move transactions to Checking in Quicken

Now transactions under Checking account. You can delete "IMPORT" Account or keep importing other files there.

CSV2QFX Windows Step 24: transactions under Checking in Quicken

For example, let's say you have another one Credit Card account. Click 'Tools' - 'Add Account' - select 'Credit Card' - 'Add Manual Account' - click 'Next' - 'Finish'.

CSV2QFX Windows Step 25: add Credit Card Account in Quicken

Convert again: click 'Convert' button - create new QFX file - import sample.qfx file.

CSV2QFX Windows Step 26: convert again

Select 'File' - 'File Import' - 'Web Connect (.QFX) File', select created QFX file. We didn't change Account Name. The second time you import QFX file, with the same Account ID, Quicken will see established link and will just import transactions into import account.

CSV2QFX Windows Step 27: import again in Quicken

You can select transactions, move them to one of two accounts, one of your existing account. Click first one - hold Shift Button - click last one. Then right-click - 'Move transactions'.

CSV2QFX Windows Step 28: select transactions again in Quicken

Just move your transactions to another account. This way you keep all those teens unchanged and you have all your transactions. Select account and click 'Ok'.

CSV2QFX Windows Step 29: Move transactions to Credit Card in Quicken

Now transactions under Credit Card account.

CSV2QFX Windows Step 30: transactions under Credit Card Account in Quicken

Step by step instructions for macOS

Let's create a new Checking account.

CSV2QFX Mac Step 1: create new account in Quicken

Important! Your account must be connected to any bank account. Click on 'My bank is not in the list', then click on 'Add Manual Account' button.

CSV2QFX Mac Step 2: Add Manual Account in Quicken

Click 'Finish' button. Done! Now you have a Checking account.

CSV2QFX Mac Step 3: Checking account in Quicken

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

CSV2QFX Mac Step 4: Start CSV2QFX

The first line is the header. It greatly helps the Parser to understand your CSV file and find Amount, Pay, Date.

CSV2QFX Mac Step 5: source file

And when you load the CSV file, the left sidebar, allows you to adjust a mapping. You can change the selection, if you have several applicable columns, or if the Parser did not choose a correct field, or your CSV file has no header. You can reassign these columns and the Transaction Tab shows how this file is parsed. The left sidebar allows you to adjust a mapping. You can change the column if you have several columns and the Parser did not choose a correct column or you have no column names in the CSV file. You can reassign these columns and Transaction Tab shows how it parsed.

CSV2QFX Mac Step 6: reassign columns

You can set the date format in your CSV file, and how dates are shown inside the application.

CSV2QFX Mac Step 7: date column

It's important to use different Account ID's when you convert for multiple accounts. So Quicken knows where to import the transactions. If you have CSV file from your bank, you just have to review it and click 'Convert' button to convert.

CSV2QFX Mac Step 8: Account ID

Click 'Convert' button - click 'Save' - create QFX file from the CSV file.

CSV2QFX Mac Step 9: Click Convert

Import created QFX file into Quicken

Now the QFX file is created, let's switch to Quicken and import created QFX file. Click 'File' - 'Import' - 'Bank of Brokerage File (OFX, QFX)', open sample.qfx file we just saved .

CSV2QFX Mac Step 10: open sample qfx in Quicken

Data Account ID in the converter shows us the type of account. Usually, we convert for Checking account. So you select Checking account.

CSV2QFX Mac Step 11: Data Account ID in Quicken

We can add a new Quicken account. This is gonna be a new Account Name.

CSV2QFX Mac Step 12: add new Quicken account in Quicken

Or we link to the existing account and just select a link. And then we click 'Continue' button.

CSV2QFX Mac Step 13: link to the existing account in Quicken

We see all transactions imported.

CSV2QFX Mac Step 14: transactions imported in Quicken

There is no category. This category is assigned by Quicken. This is not from the CSV file. QFX files do not have categories. You can change the category. And Quicken will use that choice next time you import.

CSV2QFX Mac Step 15: category is assigned in Quicken

Related artciles