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.
See below steps for the Windows version, followed by the Mac version.
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.
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.
Set the date format if applicable.
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.
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.
You can also put Account ID (number) as part of Mapping: 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.
Click 'Convert' button to create a QFX file.
Confirm the file name and location.
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.
Import into a new account or existing account (disconnect the account before importing).
Then click 'Import' button.
Then click 'Close' button.
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'.
They accepted and listed 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'.
Let's say you have Checking account.
Click 'Advanced Setup'.
And you don't want to mess up your existing setup and connection. Click on 'I want to enter my transactions manually'.
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.
Then right-click - 'Move transactions'.
Move transactions to Checking and click 'Ok'.
Now transactions under Checking account. You can delete "IMPORT" Account or keep importing other files there.
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'.
Convert again: click 'Convert' button - create new QFX file - import sample.qfx file.
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.
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'.
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'.
Now transactions under Credit Card account.
Let's create a new Checking account.
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.
Click 'Finish' button. Done! Now you have a Checking account.
The first line is the header. It greatly helps the Parser to understand your CSV file and find Amount, Pay, Date.
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.
You can set the date format in your CSV file, and how dates are shown inside the application.
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.
Click 'Convert' button - click 'Save' - create QFX file from the CSV file.
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 .
Data Account ID in the converter shows us the type of account. Usually, we convert for Checking account. So you select Checking account.
We can add a new Quicken account. This is gonna be a new Account Name.
Or we link to the existing account and just select a link. And then we click 'Continue' button.
We see all transactions imported.
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.