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

Please use this page as the most up-to-date for investment action codes:

https://en.wikipedia.org/wiki/Quicken_Interchange_Format

Learn More

QIF - What is QIF file/format and how to open it?
Quicken - How To Import QIF or QFX into Quicken