What is a QBO file

Updated August 2026 · 5 minute read

A QBO file is a bank statement packaged in QuickBooks' Web Connect format , a licensed flavor of the OFX standard that banks and accounting software have exchanged data with since 1997. Because the file names its own account and statement period, QuickBooks imports it with no column mapping at all, which is the whole reason the format exists.

What is inside a QBO file

Under the extension, a QBO file is an OFX document: Open Financial Exchange, the specification Microsoft, Intuit, and CheckFree published in 1997 so financial institutions and desktop software could trade transactions without screen-scraping. QBO is Intuit's flavor of that specification, built for the QuickBooks import path called Web Connect.

The file declares the institution, the account, and the statement period once at the top, then lists one entry per transaction, each with a posted date, an amount, a type, and a unique id. Those ids are what let QuickBooks recognize a transaction it has already seen, so importing an overlapping file matches rows instead of duplicating them.

That header is the practical difference from a spreadsheet. A CSV is anonymous, so QuickBooks has to ask which account it belongs to and which column means what. A QBO file answers both questions itself, and the import collapses to choosing the file and confirming.

Where do you get a QBO file

From your bank, mostly. Inside online banking, the transaction download screen usually offers several formats, and the one labeled for QuickBooks or Web Connect is the QBO. Coverage varies by institution: some offer it on every account, some only on business accounts, and nearly all limit it to the window of history their online banking keeps.

Two structural limits are worth knowing before you plan an import around the format. A QBO file holds exactly one account and one statement period, so a year of history across three accounts means a stack of files, not one. And because the format targets QuickBooks specifically, other accounting tools may not accept it even though they read the OFX family it belongs to.

QBO vs CSV vs QFX vs OFX

Four names come up around every bank download screen. They split into one spreadsheet format and three siblings from the same specification.

How QBO compares with CSV, QFX, and OFX for bank transaction imports
Format	What it is	Built for	Carries account details
QBO	Web Connect flavor of OFX	QuickBooks imports with no column mapping	Yes: institution, account, and statement period
CSV	Plain rows and columns	Anything that reads a spreadsheet, mapping done by hand	No: you tell the importer what each column means
QFX	Quicken's licensed flavor of OFX	Quicken's own download-and-import path	Yes, in Quicken's dialect of the same structure
OFX	The open 1997 specification itself	Bank connections and downloads across many finance tools	Yes: it is where the other two inherited the idea

IIF also appears in older QuickBooks Desktop documentation. It is a separate Intuit text format for Desktop lists and transactions, not part of the OFX family.

How do you create a QBO file when the bank only offers PDF

The download screen has an expiry problem. Banks serve QBO for the months their online banking still covers; older periods, and everything from a closed account, come back as PDF statements or not at all. When the account matters and the window has passed, the PDF is what you hold.

This is the case LedgerBox is built for: it converts documents into data, so a statement PDF, scan, or photo goes in, the extracted rows get checked against the printed balances, and a Web Connect QBO comes out, one file per statement, alongside two QuickBooks CSV layouts. What it will not do is read a data file. Hand it a CSV, QBO, OFX, QFX, or QIF and there is no document to extract, so the honest routing is simple: bring a statement PDF here, and bring a data file to a tool made for data files.

Questions people ask

How do I open a QBO file?

Import it into QuickBooks through the bank transaction upload, which is what the format is for. To just look inside one, open it in a text editor: it is structured OFX text, readable enough to spot the account, the period, and the transaction entries.

How do I create a QBO file?

Download one from your bank's transaction export screen when the period is still covered there. For periods the bank no longer serves, convert the statement PDF: LedgerBox extracts the rows, verifies them against the printed balances, and writes the QBO.

Can I convert a QBO file to CSV or Excel?

Not with LedgerBox, which reads documents rather than data files. Since a QBO is text underneath, technical users can parse it, and various utilities exist for the job. If the original statement PDF is available, extracting from it gets you CSV and Excel directly.

Can a QBO file contain more than one account?

No. The format declares a single account and a single statement period in its header, and everything after that belongs to them. Multiple accounts or multiple periods always mean multiple files.

What is the difference between a QBO file and a QFX file?

Same parent, different licensee: both are flavors of OFX, with QBO built for QuickBooks' Web Connect import and QFX built for Quicken's. Each product expects its own flavor, and renaming the extension does not convert one into the other.

Does QuickBooks Online still accept QBO files?

Yes. As of 2026, the QuickBooks Online upload flow takes CSV and QBO files, and QuickBooks Desktop imports QBO through Web Connect. The QBO route is the one that skips column mapping in both products.