Quicken for Windows up to the latest version, supports import for QIF and QFX (Web Connect) files. Quicken 2005-2017 imports QIF files.
Use the ProperConvert app to convert your transaction files to required by your accounting software file format.
Here are the major differences between QIF and QFX (Web Connect) format when you try to import them under Quicken:
Quicken claims that the QIF format is outdated, and not supported anymore, however, still allows importing a QIF file. On the QIF import screen Quicken tells, then you can import a QIF file only under cash account, offering in the drop-down choice for account selection only cash accounts, but also âAll Accountâ as well. Guess what, unless you have Quicken Essentials for Mac, QIF files are fully supported, but not the ones your bank offers you for download. They're slightly different, âQuicken onlyâ, QIF files that Quicken for Windows imports just fine under any account. The ProperConvert app, which converts from more formats and converts to more formats - will help you create those files.
Quicken does not do any âhome callsâ during QIF imports, but it does every time you are trying to import a QFX file (yes, you need the Internet connection, your firewall must allow Quicken to go through just to import a QFX file that you have locally on your computer). Quicken checks if the bank code supplied in the QFX file is âallowedâ by Quicken for a specific bank and even more bank account type. Some banks come and go, so your bank may drop QFX support tomorrow.
Once a QFX file is imported under an account in Quicken you choose during the import, it âonline linksâ that account to bank settings supplied in that QFX file. If you have other QFX files with different settings then your currently for the account in âonline linkâ, Quicken will not allow you to import that other QFX file under the âoccupiedâ account. The cure for that is simple: edit account, click on the âOnline Servicesâ tab, and select âdeactivate online linkâ.
QFX format as extended OFX format with additional Quicken only details, but the OFX specification does not provide category or tag attribute for transactions (or anything else similar) Thatâs it; you cannot import categories and tags assigned to your transactions using the QFX (Web Connect) format. On the other hand, the QIF format still imports categories and tags just fine. There is a workaround (no great, but some) this limitation for categories: you can set ârename rulesâ in Quicken to have categories assigned to specific payee names. It should be ok for most payees, but not retailer stores, like Walmart.
The QIF format simplifies investment transactions by limiting security identification to just the security name. Thatâs it, no ticker symbol, no CUSIP numbers, just full Security name. When you import a QIF file with investment transactions under Quicken (or MS Money), Quicken will look up the security by its full name. You need to make sure your securities names do match the ones on the QIF file, but nothing more. For the QFX (OFX) case, each transaction must be accompanied by the security record with CUSIP supplied. You do need to have a CUSIP number for every security to create a proper QFX file that Quicken can import.