Quicken 2017 for PC imports QIF files with categories. Quicken 2015 and Quicken 2016 had issues with a direct QIF import, but Quicken 2017 for PC does not have this issue anymore. Quick video below shows the full process using CSV2QIF.
QIF files are a great format to import transactions with categories and tags. CSV2QIF converts CSV and Excel files to QIF format ready to import into Quicken 2017 for PC, as well as Quicken 2016, Quicken 2015, Quicken 2014 and earlier versions. Also, you can create QIF files for Quicken 2007 for Mac, and other personal finance applications like MS Money, You need a Budget (YNAB), NetSuite, etc.
Important details for successful conversion from CSV to QIF and import into Quicken or other accounting software are the following:
- Check that expenses are negative and payments to the account are positive. Some credit card companies supply amounts on CSV files in opposite way (expenses are positive, and credit card payments are negative). Use “Change +/-” button on the sidebar to reverse the amount signs for the whole file in a single click
- Make sure to select correct QIF target (which accounting or personal finance software are you importing into)
- Make sure to select correct account type (BANK vs CCARD vs INVST)
- Make sure to enter the account NAME exactly as you have in Quicken for direct import into that account. Quicken reads the account name from the QIF file and locates the account before importing. If the account name is not found, Quicken prompts to create new account
- Date format is ignored if QIF target is Quicken – Quicken expects only one date format and CSV2QIF uses expected format
- Quicken 2015, 2016 do not import QIF files directly into bank or credit card account. Use proxy cash account to import your transactions and then move transactions to another account.
If you have PDF file from your bank or converted PDF file to CSV file, try PDF2QIF.