Use CSV2QIF to import CSV as QIF into Quicken 2013

Use CSV2QIF to import CSV as QIF into Quicken 2013

This tutorial shows how to import a CSV file to Quicken 2013 by converting to QIF file. We will use CSV2QIF utility.

To download CSV2QIF go to https://www.propersoft.net/products/csv2qif. You can purchase on the product page, you can download the trial. Also if you purchase before, you can use this link to download as well and register with your registration code. And there is also Mac download. At the product page, there is a sample CSV file, you can download, that will help you to try the application or if you need to know, how the CSV/Excel file should look like, you can download this file, open in Excel. It'll give you a ready idea of how the transactions should look like in your CSV file before you convert them.

Use CSV2QIF to import CSV as QIF into Quicken 2013 Step 1: sample csv file

Now we will import a QIF file into Quicken 2013. This application imports QIF files, correctly prepared QIF files into all account types and we will import into 'Royal Bank Chequing' Account.

Use CSV2QIF to import CSV as QIF into Quicken 2013 Step 2: royal bank

When you start CSV2QIF, point to your CSV file.

Use CSV2QIF to import CSV as QIF into Quicken 2013 Step 3: open sample

When you open a CSV file in CSV2QIF, look for things like Date, Amount, Payee, Check number, Memo, Category. They are all in the proper columns. The transactions Tab shows how the converter understands your file. So, if Amount is not in place or Dates are not expected, or Payee not assigns, click Review Mapping and reassign those columns.

Use CSV2QIF to import CSV as QIF into Quicken 2013 Step 4: review csv2qif

The Amount should be negative for expenses and positive for deposits. Some Credit Card Companies supply CSV files with expenses as positive numbers and payments to the account as negative numbers. For those files, you can use the button 'Change +/-' once per file to reverse the Amounts. So when you click it, make sure, that the Amounts for expenses are negative and for payments to the account are positive. In this case, we have to revert it, just for example purpose.

Use CSV2QIF to import CSV as QIF into Quicken 2013 Step 5: change button

Another thing before converting is to select the QIF Target. For Quicken 2013 we have to select Quicken 2014 or earlier. It's important to select this specific Target, because it creates different QIF files, depending on QIF Target. The file for Quicken 2015-2016 is the different file for Quicken 2014 or MS Money file. There are different date formats, different sections and this selector is provided easier for you to choose an application to import into.

Use CSV2QIF to import CSV as QIF into Quicken 2013 Step 6: target

Another important thing is the Account Name. You have to enter Account Name as the Account Name you have in Quicken.

Use CSV2QIF to import CSV as QIF into Quicken 2013 Step 7: account name

So if you want to import into 'Royal Bank Chequing' Account and you have to get this name and enter it in the converter, click 'Edit/Delete account'.

Use CSV2QIF to import CSV as QIF into Quicken 2013 Step 8: edit account

Just select Account Name and right-click - 'Copy'. Go back to the converter and paste the Account Name. This is the name, that will be used in the QIF file. So in Quicken it will find account name and will try to find an account that matches, as that account.

Use CSV2QIF to import CSV as QIF into Quicken 2013 Step 9: copy name

Click the 'Convert' button.

Use CSV2QIF to import CSV as QIF into Quicken 2013 Step 10: convert

And save a QIF file.

Use CSV2QIF to import CSV as QIF into Quicken 2013 Step 11: save qif file

Switch to Quicken and click 'File' - 'File Import' - 'QIF File'.

Use CSV2QIF to import CSV as QIF into Quicken 2013 Step 12: file import

Click 'Browse' and select a QIF file. Then select 'All Accounts' (ignore the message "Don't see your account?") and click 'Import'.

Use CSV2QIF to import CSV as QIF into Quicken 2013 Step 13: all account

It shows that QIF import successful. Click 'Done'.

Use CSV2QIF to import CSV as QIF into Quicken 2013 Step 14: data imported

We have four imported transactions under 'Royal Bank Chequing' Account, as expected. The transactions have to be accepted, you can review them here, as well. Payee, (Memo is not shown now), Date, Check number, Withdrawal, Deposits. Click 'Accept All'.

Use CSV2QIF to import CSV as QIF into Quicken 2013 Step 15: accept all

Now you can see Deposit, Payment, Memo, Payee, Check number and Category.

Use CSV2QIF to import CSV as QIF into Quicken 2013 Step 16: review imported transactions

Related articles