How to Import investment transactions into Quicken

Required source format for your transactions

It should be a CSV or Excel file.

Output Format

Investment transactions can be converted to the QIF format only. Quicken for Windows imports QIF files. Quicken for Mac does not import investment QIF files.

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 - the converter will detect them and assign them 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  (obsolete for Quicken 2018 or later)
XOut Transfer of cash out of the account (obsolete for Quicken 2018 or later)
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
CASH Transfer cash into (positive amount) or out of (negative amount) account (for Quicken 2018 or later)
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us