OFX File Format: What It Is and How to Import to QuickBooks

An OFX file (Open Financial Exchange) is a standard data format banks use to deliver transactions for accounting software. QuickBooks does not import a plain .ofx file the way it imports its own .qbo Web Connect file: QuickBooks Online's manual upload accepts QBO, QFX and CSV files (plus PDF or image statements under 350 KB, in English only), while QuickBooks Desktop only takes a .qbo Web Connect file. To use an OFX file, convert it to .qbo first, then import it through the bank feed.

OFX, QFX, and QBO all come from the same family. OFX is the open standard; QFX is the Quicken-branded version; QBO is the Intuit Web Connect version QuickBooks reads natively. The differences are small but they decide whether your file imports cleanly or throws an error. This guide explains what each format is, how to import OFX and QFX into QuickBooks Online and Desktop, why imports fail, and the fastest way to get bank activity in.

What is an OFX file in QuickBooks?

OFX stands for Open Financial Exchange, an open standard format that encodes bank and credit card transactions in a structured text file. Banks and accounting tools use it to move financial data between systems. QuickBooks is built around its own Intuit flavor of OFX called Web Connect, saved with a .qbo extension, so a generic .ofx file often needs converting before QuickBooks will read it.

What is the difference between OFX, QFX, and QBO files?

All three share the OFX structure. OFX is the open, unbranded standard. QFX is the Quicken version, which adds an Intuit identifier so Quicken accepts it. QBO is the QuickBooks Web Connect version, which carries a bank ID (INTU.BID) so QuickBooks Desktop accepts it. QuickBooks reads .qbo natively; .ofx and .qfx usually need conversion.

Can QuickBooks import an OFX file?

QuickBooks Desktop does not import a plain .ofx file; it only accepts a .qbo Web Connect file through File, then Utilities, then Import, then Web Connect Files. QuickBooks Online's manual upload accepts QBO, QFX and CSV files, and it will also read a PDF or image statement with AI extraction, but only in English and under 350 KB, which rules out most scans. So to use an OFX file in either product, the reliable path is to convert it to a .qbo file first, then import that.

How do I import a QFX file into QuickBooks?

In QuickBooks Online, go to Transactions, then Bank transactions, select the account, choose Upload from file, and pick your QFX file. In QuickBooks Desktop, a QFX usually has to be converted or saved as a .qbo first, since Desktop expects Web Connect. After upload, the transactions land in For review so you can match or add them.

How do I open a QFX file?

A QFX file opens in Quicken, the program it was built for: launch Quicken and choose File, then Open, or double-click the .qfx if Quicken is installed and associated with the format. QuickBooks does not open a .qfx as a document. In QuickBooks Online you upload it under Transactions, Bank transactions, Upload from file, and in QuickBooks Desktop you convert it to a .qbo Web Connect file first. A .qfx is really OFX text inside, so a text editor will show the raw data but not a usable statement. If you just need the transactions in QuickBooks and have no Quicken license, skip opening it and convert the file straight to .qbo instead.

How do I convert an OFX file to QBO?

An OFX file and a QBO file share the same structure, so conversion means adding the QuickBooks bank identifier the .qbo format requires and saving with the right extension. A converter tool does this in one step. Simply renaming .ofx to .qbo sometimes works but usually fails, because QuickBooks rejects a file that is missing a valid bank ID. To convert a QFX to QBO, the same rule applies: a converter rewrites the Quicken bank tags into the Intuit Web Connect format QuickBooks accepts, so the transactions import cleanly instead of erroring out.

Why won't my OFX or QFX file import into QuickBooks?

The most common causes are a wrong or missing bank identifier (the INTU.BID QuickBooks checks), a date or balance the file did not include, a corrupted download, or trying to load a .ofx straight into Desktop, which only takes .qbo. Converting the file to a proper .qbo with the correct bank ID resolves most of these errors.

Can I just rename an OFX file to QBO?

Sometimes. Renaming the extension from .ofx to .qbo works when the file already contains the bank identifier and account fields QuickBooks expects. More often the import fails with an error about an unsupported file or financial institution, because the bank ID is missing. A converter adds the required fields instead of just changing the name.

What is a Web Connect (.qbo) file?

A Web Connect file is QuickBooks' native import format, an OFX file with a .qbo extension that includes an Intuit bank ID. You download it from your bank's website or create one with a converter, then import it under File, Utilities, Import, Web Connect Files in Desktop, or upload it in QuickBooks Online. It is the format QuickBooks reads most reliably.

How do I import an OFX file into QuickBooks Online?

QuickBooks Online's manual upload accepts QBO, QFX, and CSV, not plain OFX, so convert the OFX to a .qbo first. Then go to Transactions, then Bank transactions, choose Upload from file, and select the .qbo. Keep the file at 350 KB or less and under 1,000 transactions per upload, splitting larger statements by month if needed.

Where do I get an OFX or QFX file from my bank?

Log in to your bank's website, open the account, and look for a download or export option on the transactions or statements page. Choose the QuickBooks, Web Connect (.qbo), or Quicken (.qfx) format if offered. If only OFX or CSV is available, download that and convert it to .qbo before importing into QuickBooks.

Does QuickBooks Desktop support OFX files?

No. QuickBooks Desktop only imports its own Web Connect format, a .qbo file, through File, then Utilities, then Import, then Web Connect Files. A plain .ofx or .qfx will not import directly. Convert it to a .qbo with the correct bank identifier first, and Desktop will read it like any bank download.

What if my bank only gives me a PDF statement?

If your bank does not offer OFX, QFX, or QBO downloads, or only keeps a few months online, you can still get the data in. Convert the PDF statement to a .qbo file and import it through the bank feed. This is also how you backfill older months the live bank connection refuses to pull.

How far back can I import OFX transactions?

Importing a file has no built-in date limit the way the live bank feed does, so a .qbo or QFX you build can cover any period your statements show. The limit is what your bank lets you download. For older history, convert the PDF statements instead, since most banks keep only 12 to 24 months of downloadable files.

OFX and QFX files are useful when your bank offers them, but the format that QuickBooks reads most reliably is .qbo. When your download throws an import error or your bank only hands you PDFs, you can import old bank statements into QuickBooks by converting them straight to .qbo, then match the transactions and reconcile bank statements in QuickBooks. When your bank only hands you a PDF, the fastest path is the bank statement to QBO converter, which builds a clean .qbo from the statement. If a .qbo still will not load, see why a .qbo file won't import, and if your bank only offers a spreadsheet, learn how to import a CSV file into QuickBooks or use a QuickBooks IIF file for list data. For workflows that span other tools, you can convert statements to Excel or turn a CSV into a .qbo file.