QFX vs OFX vs QIF (and CSV)
Your bank's Download button offers four or five formats with names like Quicken, Money and QuickBooks. Here is what each one is, and which one your app takes, in its own words.
The four files
| QFX | OFX | QIF | CSV | |
|---|---|---|---|---|
| What it is | Quicken's Web Connect file: OFX plus Intuit's bank ID tag (INTU.BID) | Open Financial Exchange, the shared standard (1.x tagged text, 2.x XML) | Quicken Interchange Format, Quicken's older plain-text format | A spreadsheet table, one row per transaction |
| Account | Account number, type, currency | Account number, type, currency | Optional account name and type | Whatever columns the bank chose |
| Line ids | Yes (FITID): re-importing skips lines already in | Yes (FITID) | No | Sometimes a reference column |
| Dates and amounts | 20261031, minus = money out (most banks) | Same | 10/31/2026, 31/10/2026 or 10/31'26: the order is not written down | Any format; a sign or Debit / Credit columns |
| Ending balance | Yes (LEDGERBAL) | Yes | No | Sometimes a Balance column |
| Splits, categories | No | No | Yes | Sometimes the bank's category |
In short: pick OFX or QFX for a money app (ids stop double imports), CSV for a spreadsheet, and QIF only for an app that asks for it. The Bank File Converter turns any of them into CSV, and a CSV into OFX or QIF.
Why Quicken and QuickBooks Desktop are different
A QFX or QBO file opens in Quicken or QuickBooks Desktop as a Web Connect download only when it carries the ID of a bank that takes part in Intuit's program. A converter that writes some bank's ID into your file is pretending to be that bank; this one does not, so its OFX files will not open there as Web Connect downloads. Quicken also limits QIF import to some account types. Their own words are in the table below.
What each app imports, in its own words
| App | Imports | In its own words | With a file from here |
|---|---|---|---|
| Microsoft Excel | CSV | “If the file is a .csv file, Excel automatically opens the text file and displays the data in a new workbook.” | Download CSV. |
| Google Sheets | CSV | “You can import a spreadsheet in many file formats, like .xls, .csv, .txt, and more.” | Download CSV, then File → Import. |
| GnuCash | CSV, OFX, QFX, QIF | “QIF (.qif) Quicken Interchange format - import data from Quicken financial software; OFX/QFX (.ofx,.qfx) Open Financial eXchange format (QXF is an Intuit/Quicken proprietary version of OFX); CSV (.csv) Comma Separated Values;” | CSV, OFX or QIF all work. |
| Microsoft Money Plus Sunset | ? | Could not be read: check their page. | Its own page could not be read: check their page. |
| YNAB | CSV, OFX, QFX, QIF | “The preferred format for File-Based Import is CSV. YNAB also accepts OFX, QFX, and QIF files. YNAB is unable to read other file types for File-Based Import.” | CSV (what YNAB prefers), or OFX / QIF. |
| Banktivity | CSV, OFX, QFX, QIF, QMTF | “Banktivity can import transaction data from the following file formats:”“QFX: Quicken File Exchange, also known as Web Connect format”“The new Banktivity supports the importing of QIF, QFX, OFX, and CSV* files iOS.” | CSV, OFX or QIF. |
| HomeBank | CSV, OFX, QFX, QIF | “Supported file formats includes QIF, OFX, QFX, and CSV.” | CSV, OFX or QIF. |
| KMyMoney | CSV, OFX, QFX, QIF | “The most common of these is the Quicken Interchange Format (QIF).”“OFX files may have an extension of “OFX” or “QFX” (upper or lower case)”“In general, it is preferable to import OFX. However, not all institutions provide data in that format.” | OFX (what its handbook prefers), QIF or CSV. |
| MoneyMoney | CSV, OFX, QIF | “Exportieren Sie dazu aus Ihrem bisherigem Programm für jedes Konto die Umsatzliste jeweils in eine Datei, z.B. eine CSV-, QIF-, OFX-, CAMT-, MT940- oder Tab-Text-Datei.” | CSV, OFX or QIF. |
| Quicken | QFX, QIF | “That your bank supports a Quicken Web Connect download. If the financial institution no longer supports Web Connect in Quicken, the file cannot be authorized when importing.”“NOTE: Only a QFX file will allow you to download transactions from checking, savings, credit card, brokerage or retirement accounts; QIF files will not work with Web Connect in Quicken.”“QIF import is available only for asset and liability accounts (including house and vehicle) and cash accounts.”“QIF import isn't available for checking, savings, or credit card accounts, or for 401(k) or any other brokerage accounts, although some financial institutions offer price history download via QIF.”“QFX stands for Quicken File eXchange. It is used by many financial institution websites to transfer information from their website to Quicken.” | Not as a Web Connect download: Quicken authorizes those through your bank, and this tool writes no bank ID. QIF only into cash, asset and liability accounts. |
| QuickBooks Online | CSV, OFX, QBO, QFX | “When you go to your bank's website, choose a file type of Quicken (.qfx), QuickBooks Online (.qbo), Comma-Separated Values (.csv), or Microsoft Money (.ofx). (Do not choose a Quicken .qif file.)”“you may be able to bring bank transactions into QuickBooks if your bank supports certain types of file downloads (QFX, QBO, CSV, and OFX).” | CSV or OFX upload. |
| QuickBooks Desktop | ? | Could not be read: check their page. | Its page could not be read: check their page. This tool does not write .QBO files. |
Keeping a register on Windows? Stubbook opens these files by double-click (on the Microsoft Store). Tracking bills? Paid Up.