Quicken uses the account name on the QIF file to locate an investment account by name and imports transactions there. When you convert CSV to QIF, you must specify the account NAME in Quicken for the QIF file and specify the account type as Invst. investment action (BUY, SELL, etc., see the full list of codes below).When you convert CSV or Excel file into QIF format, your CSV/Excel file must have the following details: If one of the listed details is missing, QIF file is treated as regular cash transaction into an investment account. Investment transactions have an important difference from bank and credit card accounts: they need quantity, price, commision, investment action and full security name for each transaction. You cannot cut and paste transactions from one account and paste under investment account (unlike bank and credit card accounts, where you can cut, paste and move transactions easily between accounts). Investment accounts are different from bank and credit card accounts. Use the following sample CSV file for investment accounts if you are entering or formatting data in Excel or would like to know how your CSV/Excel file should look like:
INPORT CSV TO QUICKEN HOW TO
How to convert investment transactions from CSV to Quicken Compatible formatĬSV2QIF converts CSV or Excel files with investment transactions into importable QIF files.