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.

When you select the QFX file, you will be offered to choose the existing account or create a new account. Either one will work - you can just have the transactions under an existing account or cut and paste transactions from a new account to another account.

QFX files have INTU.BID - QFX bank identifier - it can be any 'allowed' bank and you can change it before converting to a QFX file.

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.

QXF file format

QXF is not QFX format and cannot be used to import transactions. It is used to transfer the whole data file from one Quicken to another.