Quicken formats: QFX vs QIF vs QXF vs CSV Mint
To import transactions in Quicken Classic, you may use the following formats:
- QFX (web connect) - works for Quicken Classic for Windows, and Quicken Classic for macOS
- QIF - works for Quicken Classic for Windows
- CSV Mint - works for Quicken Classic for macOS
- QXF - is not used to import transactions, but used to transfer data from one Quicken to another
QFX (Web Connect) File Format
Make sure to use different account ID for mutliple accounts
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 fix for that is simple: edit account, click on the “Online Services” tab, and select “deactivate online link”.
Categories and tags are set after import
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. 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.
Non-USD accounts
Use the QIF format, non-USD currencies are not supported by Quicken to import QFX files. A workaround: create a proxy account with USD currency, import transactions there, then select all transactions there and then cut and paste transactions under the intended non-USD account.
QIF File Format
This format does not have currency (import under any account), supports categories and tags. If you are comfortable with your computer, the QIF format should easier overall for Quicken for Windows.
CSV Mint file format
This is specifically formatted CSV file that Quicken for macOS imports into a new account. Categories are supported, unlike QFX format.
After transactions are imported, open the new account, select transactions there and drag them with your mouse to the intended account on the right sidebar. Delete create temporary account after.