How to Use CSV2QFX

This tutorial shows how to use CSV2QFX utility. IMPORTANT: CSV2QFX is now replaced with the ProperConvert app, which converts from more formats and converts to more formats.

Step by step instructions

Click the 'Download' button.

CSV2QFX Step 1: Download

And then select Windows or macOS version to download.

CSV2QFX Step 2: Windows or macOS version

Once downloaded and installed, start CSV2QFX. Read the welcome message that provides the main points about the conversion process.

CSV2QFX Step 3: Welcome message

Select a file with transactions that you would like to convert. It could be CSV or Excel file for bank or credit card transactions.

CSV2QFX Step 4: Select a file

Review transactions before converting, make sure dates are correct, expenses are negative, and payments to the account are positive.

CSV2QFX Step 5: Review transactions

Set the Account ID and Account Type. The Account ID must be digits only. You can enter the actual account number or credit card number, or a shortened number. It is important to use the same number when you convert multiple files for the same account, and use a different number, when you start converting for another account.

For example, let's start with the first file for a checking account. Convert the first file and use Account ID as 10000001. Then you convert a second file for the same checking account, keep the same Account ID 10000001.

CSV2QFX Step 6: Checking

Then you start with a credit card account. For the first file for the credit card account, change the Account ID to another number, for example, 10000002. For the second file for this credit card account, keep the Account ID as 10000002.

CSV2QFX Step 7: Credit card

When you start working with another account, make sure to adjust the account type as well.

The Account Type is important to set as Quicken allows you to import created QFX file for a credit card account only into a credit card account in Quicken and for a QFX file for a checking account, Quicken imports this file only in a bank account.

For the Quicken US edition, the currency must be US Dollar, for the Quicken Canadian edition, the currency can be US Dollar or Canadian Dollar.

CSV2QFX Step 8: Currency

INTU.BID value is another important parameter to set. This value defines the bank label you see during QFX file import in Quicken. This value does not have to match your account name in Quicken, but it has to be allowed by Quicken bank.

Some users do want the name of the bank to match the bank name in Quicken, and you can do this by selecting the appropriate INTU.BID value. But if your bank is not listed on not allowed, you can easily use any other bank label.

INTU.BID value applies to the account type. Some INTU.BID values are allowed for certain account types only.

Click the 'Lookup' button to see the list of banks.

CSV2QFX Step 9: Lookup

Search for your bank. This code (07492) can be used for credit card account only.

CSV2QFX Step 10: Code 07492

This code (03000) can be used for checking, savings, credit line, credit card, almost all account types.

CSV2QFX Step 11: Code 03000

There are some other settings that discussed in another video, we would skip these for now as you need them only in specific situations and you know when you need to change these settings.

CSV2QFX Step 12: Other settings

Set the “Open after save” checkbox if you would like the software installed on your computer to open the created QFX file. If you have Quicken installed, it would be Quicken to open this QFX file.

CSV2QFX Step 13: Open after save

Click the 'Convert' button.

CSV2QFX Step 14: Convert

And confirm the filename and the file location.

CSV2QFX Step 15: Confirm the filename

To import the created QFX file manually, in Quicken, click File, File Import, Web Connect (.QFX) file.

CSV2QFX Step 16: File Import

Select the created QFX file.

CSV2QFX Step 17: Select the created QFX

And now we select 'Create a new account' or 'Link to an existing account'. Click the 'Import' button.

CSV2QFX Step 18: Import button

Transactions are imported. Click the 'Accept All' button.

CSV2QFX Step 19: Accept All

Transactions are inside Quicken.

CSV2QFX Step 20: Transactions inside Quicken

Import created QFX file into Quicken for Windows

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 the 'Import' button.

CSV2QFX Windows Step 13: click import in Quicken

Then click the '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 this case). And have that (called "Checking" in this 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 a 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 the 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 the 'Checking' account and click 'Ok'.

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

Now transactions under the 'Checking' account. You can delete the '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 the 'Convert' button - create a 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 the Account Name. The second time you import the QFX file, with the same Account ID, Quicken will see an established link and just import transactions into the 'IMPORT' account.

CSV2QFX Windows Step 27: import again in Quicken

You can select transactions, move them to one of two accounts or your existing account. Click the first one - hold the 'Shift' button - click the 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 things unchanged and you have all your transactions. Select the account and click 'Ok'.

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

Now transactions under the 'Credit Card' account.

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

Import created QFX file into Quicken for macOS

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 have 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 the 'Checking' account. So you select a 'Checking' account.

CSV2QFX Mac Step 11: Data Account ID in Quicken

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

CSV2QFX Mac Step 12: add new Quicken account in Quicken

Or we can link to the existing account and just select a link. And then we click the '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 articles