It should be CSV or Excel file.
Use CSV2QIF. IMPORTANT: CSV2QIF is now replaced with the ProperConvert app, which converts from more formats and converts to more formats.
Your CSV file should have the following columns:
The first line should be column names as specified above - CSV2QIF 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.
| 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
|