Tomorrowish

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

QFXOFXQIFCSV
What it isQuicken'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 formatA spreadsheet table, one row per transaction
AccountAccount number, type, currencyAccount number, type, currencyOptional account name and typeWhatever columns the bank chose
Line idsYes (FITID): re-importing skips lines already inYes (FITID)NoSometimes a reference column
Dates and amounts20261031, minus = money out (most banks)Same10/31/2026, 31/10/2026 or 10/31'26: the order is not written downAny format; a sign or Debit / Credit columns
Ending balanceYes (LEDGERBAL)YesNoSometimes a Balance column
Splits, categoriesNoNoYesSometimes 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

AppImportsIn its own wordsWith a file from here
Microsoft ExcelCSV
“If the file is a .csv file, Excel automatically opens the text file and displays the data in a new workbook.”
Import or export text (.txt or .csv) files | Microsoft Support, fetched 2026-11-15
Download CSV.
Google SheetsCSV
“You can import a spreadsheet in many file formats, like .xls, .csv, .txt, and more.”
Import data sets & spreadsheets - Computer - Google Docs Editors Help, fetched 2026-11-15
Download CSV, then File → Import.
GnuCashCSV, 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;”
6.16. Importing Transactions from Files, fetched 2026-11-15
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.
YNABCSV, 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.”
File-Based Import in YNAB, fetched 2026-11-15
CSV (what YNAB prefers), or OFX / QIF.
BanktivityCSV, OFX, QFX, QIF, QMTF
“Banktivity can import transaction data from the following file formats:”
Banktivity | Documentation, fetched 2026-11-15
“QFX: Quicken File Exchange, also known as Web Connect format”
Banktivity | Documentation, fetched 2026-11-15
“The new Banktivity supports the importing of QIF, QFX, OFX, and CSV* files iOS.”
Importing QIF, OFX, QFX, and CSV files in the new Banktivity on iOS | Support Articles, fetched 2026-11-15
CSV, OFX or QIF.
HomeBankCSV, OFX, QFX, QIF
“Supported file formats includes QIF, OFX, QFX, and CSV.”
HomeBank Features | Free, easy finance software, personal money management for everyone, fetched 2026-11-15
CSV, OFX or QIF.
KMyMoneyCSV, OFX, QFX, QIF
“The most common of these is the Quicken Interchange Format (QIF).”
Importing financial data from other applications, fetched 2026-11-15
“OFX files may have an extension of “OFX” or “QFX” (upper or lower case)”
OFX Importer, fetched 2026-11-15
“In general, it is preferable to import OFX. However, not all institutions provide data in that format.”
CSV Importer Plugin, fetched 2026-11-15
OFX (what its handbook prefers), QIF or CSV.
MoneyMoneyCSV, 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.”
MoneyMoney | Hilfe & FAQ, fetched 2026-11-15
CSV, OFX or QIF.
QuickenQFX, 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.”
Web Connect Troubleshooting | Quicken, fetched 2026-11-15
“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.”
Web Connect Troubleshooting | Quicken, fetched 2026-11-15
“QIF import is available only for asset and liability accounts (including house and vehicle) and cash accounts.”
How do I import data into Quicken for Windows? | Quicken, fetched 2026-11-15
“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.”
How do I import data into Quicken for Windows? | Quicken, fetched 2026-11-15
“QFX stands for Quicken File eXchange. It is used by many financial institution websites to transfer information from their website to Quicken.”
Importing files from your bank | Quicken Windows Help | Quicken Help, fetched 2026-11-15
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 OnlineCSV, 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.)”
Common questions about uploading bank files, fetched 2026-11-15
“you may be able to bring bank transactions into QuickBooks if your bank supports certain types of file downloads (QFX, QBO, CSV, and OFX).”
How to upload bank transactions, fetched 2026-11-15
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.

Open the Bank File Converter

Keeping a register on Windows? Stubbook opens these files by double-click (on the Microsoft Store). Tracking bills? Paid Up.