Import investment transactions into Quicken

Modified on Wed, Jun 30, 2021 at 6:13 PM

Required source format for your transactions

It should be CSV or Excel file.

Converter to use

Use CSV2QIF. IMPORTANT: CSV2QIF is now replaced with the Transactions app, which converts from more formats and converts to more formats.

Required columns on your CSV/Excel file

Your CSV file should have the following columns:

date
amount
price
quantity
full security name
investment action (BUY, SELL, etc.)
commission (optional)

The first line should be column names as specified above - CSV2QIF will detect them an assign to appropriate columns.

The Security Name column should have the security NAME as you have it in Quicken. Quicken will use the name supplied on the QIF file to locate or create the security record. It is not a ticker symbol or a CUSIP number.

Investment action codes

Code	Description
Buy	A security Buy
BuyX	A security Buy and transfer of cash from another account
Sell	A security Sell
SellX	A security Sell and transfer of proceeds from another account
CGLong	Long-term capital gains
CGLongX	Long-term capital gains and transfer of proceeds to another account
CGMid	Mid-term capital gains
CGMidX	Mid-term capital gains and transfer of proceeds to another account
CGShort	Short Term Capital Gains
CGShortX	Short-term capital gains and transfer of proceeds to another account
Div	Dividend
DivX	Dividend and transfer to another account
IntInc	Interest Income
IntIncX	Interest Income and transfer to another account
ReinvDiv	Dividend reinvested
ReinvInt	Interest Income Reinvested
ReinvLg	Long-term capital gains Reinvested
ReinvMd	Mid- term capital gains Reinvested
ReinvSh	Short-term capital gains Reinvested
XIn	Transfer of cash into the account
XOut	Transfer of cash out of the account
MiscExp	Misc Expense
MiscExpX	Misc Expense covered by another account
MiscInc	Misc Income, optionally associated with a security
MiscIncX	Misc Income and transfer from another account