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: