How to convert CSV/Excel file to QIF and import into Quicken 2017 for PC

This tutorial shows how to convert CSV/Excel file with transactions (with categories) to the QIF format and import directly into bank or credit card account in Quicken 2017 for PC. We will use CSV2QIF utility.

When you open CSV2QIF for the first time it will ask you to get a trial license. And your conversion with a trial license is limited to ten transactions per file. To convert without limits, please purchase for the license, but you can try before purchasing on the limited number of transactions (up to 10 transactions) and this video shows how to convert small CSV file to QIF format and import into Quicken 2017 for PC. Select a sample.csv file.

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 1: sample file

It has four transactions: three expenses and one deposit. And this is like transactions look after parsing.

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 2: review transactions

This is how the Source file looks like, it has column names: Date, Amount, Payee, Memo, Check #, Type, Category.

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 3: source

CSV looks like a text file.

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 4: raw view

What can you do here? You can change Mapping on your CSV file, reassign columns if you like. The converter tries to read your CSV file, tries to read your column names. And if it says 'Date' column, 'Payee', 'Amount', 'Memo', it will find those columns and assign them automatically. But you can change them. You can say, this is gonna be Payee or this is gonna be Memo. You can change all that and save as new Mapping.

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 5: mapping

Importing for Credit Cards: sometimes Credit Card Company supplies CSV files with the reverse sign for Amounts (we can see it in this example: expenses are positive and payments to the account are negative). For Quicken, for QIF file, or for QFX file, or Quickbooks, expenses have to be negative and payments/deposits to the account have to be positive. Click 'Charges +/-' button and it has to look like this: the Amount is negative for expenses and positive for the deposits.

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 6: charges

There is an important moment - Target. The QIF file has different flavors. So you have to select the flavor of accounting software, you're gonna import into. In our case, it gonna be Quicken 2017 for PC. Account Type gonna be Bank for Checking Account or Savings Account. For Credit Card, you have to select CCard.

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 7: target

Another important thing is Account Name: you can name as IMPORT or RBC Bank. You have to enter the actual account name, you have in Quicken. How to get this Account Name?

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 8: account name

Let's say you enter Account Name. Click 'Tools' - 'Add Account'.

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 9: add account

You say, that it is gonna be a Checking Account.

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 10: checking account

Click 'Advanced Setup'.

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 11: advanced setup

Then select 'I want to enter my transactions manually' and click 'Next'.

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 12: enter my transactions manually

Let's say the Account Name/Nickname is RBC Bank. This is the actual name, copy it and click 'Next'.

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 13: actual Name

Statement ending date, for example, 10/18/2016. Click 'Next' and 'Finish' button.

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 14: statement ending date

Now we have RBC Bank.

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 15: RBC

If you already have an account, click 'Tools' - 'Account List'.

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 16: tools, account list

And this is the Account Name. In our case, RBC Bank.

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 17: account list

Or you can click 'Edit' and copy the Account Name.

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 18: copy account name

Let's go back to Converter. And paste the Account Name. The tins, like Encoding, Amounts, Shares, Dates at the right panel, you can change them unless you exactly know, that you need to change them, otherwise you can leave them at least. For Quicken this tins as default, especially dates. Dates have to be as MM/DD'YYYY. If you select Quicken 2017, or 2015, or 2014, or 2007, for all these Quickens the Date format will be ignored. It will be used like MM/DD'YYYY. But whatever you say here, it will not be used for this Quicken QIF Target.

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 19: paste account name

QIF file can import the Categories, this is the adventure of QIF file over Web Connect file, QFX file.

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 20: category

Click the 'Convert' button and create a QIF File.

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 21: category

Come back to Quicken. Click 'File' - 'File Import' - 'QIF File'. Then click 'Browse' and select a QIF file, which was just created. Select 'All account' (it's important!) and click 'Import'.

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 22: file import

Done! We see 4 items imported.

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 23: import successful, checking

We see the transactions at the bottom, we can 'Accept All'.

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 24: accept all, checking

Here they are: Checking Account, imported Data.

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 25: imported transactions, checking

Let's say, we want to create Credit Card. So the Account Type: CCard, Account Name: Capital One. The expenses have to be negative and payments to the Account have to be positive. We don't change anything also, click the 'Convert' , name, as a new file (sample1.qif).

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 26: convert, credit card

Come back to Quicken. Click 'File' - 'File Import' - 'QIF File'. Click 'Browse' and select that sample1.qif, click 'Open'. Then select 'All Account' and click 'Import'.

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 27: select sample 1

We entered 'Capital One' (Account Name), but in Quicken there is no 'Capital One'. So if you don't enter the exact account name and you don't have this account in Quicken, you will get prompt from Quicken: Capital One account does not exist. Quicken will use the located account or ask to create a new account. So we click 'Yes' (add new Account).

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 28: add new account, capital one

Done! Four items successfully imported. Click 'Accept All'.

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 29: capital one, data imported

Review transactions after import.

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 30: capital one, review after import

What you have to do, if you see the message: 'QIF import is not available for checking, savings, credit cards,401(K) and all other brokerage'. Don't read this, ignore this message. Do, as I did. But don't forget to select 'All account', behind this message.

How to convert CSV or Excel file to QIF and import into Quicken 2017 for PC Step 31: ignore message

Related artciles