What is a QBO file? Web Connect, explained properly
Published August 31, 2026 · Updated October 14, 2026
QBO means two different things in accounting. It is short for QuickBooks Online, Intuit's cloud product, and it is also the .qbo file extension for bank downloads. This guide is about the file.
A .qbo file is a Web Connect file: bank transactions in the OFX format (the 1.02 SGML flavor, not modern XML) plus Intuit-specific tags, most importantly an institution ID called INTU.BID. QuickBooks treats importing one exactly like receiving a download from your bank. That's its power (transactions arrive in the bank feed, with duplicate detection) and its brittleness (get the wrapper slightly wrong and QuickBooks rejects the whole file).
The format family, side by side
| Format | What it is | Imports into |
|---|---|---|
.ofx | The open banking-data standard the others build on | Xero, GnuCash, many tools; QuickBooks Online's manual upload in some regions; not QuickBooks Desktop |
.qbo | OFX 1.02 + Intuit tags ("Web Connect") | QuickBooks Desktop and Online, as a bank download |
.qfx | The same idea, licensed for Quicken | Quicken; QuickBooks Online's manual upload also takes it in the US, Canada and Australia |
.csv | Plain rows — no IDs, no bank identity | Nearly everything, with per-product column rules |
CSV is the least fussy way in and the easiest to review, but it carries no FITIDs, so duplicate protection falls on QuickBooks' fuzzier date/amount matching — and its column rules have their own traps, covered in QuickBooks CSV import errors. The .qbo route is stricter to produce but arrives as first-class bank-feed data.
Importing an OFX file into QuickBooks
It depends on which QuickBooks you use. In QuickBooks Online, go to Transactions → Bank transactions → Upload transactions. Intuit recommends .qbo, and depending on your region the upload also accepts .qfx, .ofx or CSV, so try the file you have first. In QuickBooks Desktop, the import (File → Utilities → Import → Web Connect Files) reads only .qbo, so a plain .ofx has to become a .qbo first. The transaction data stays the same; the file gains the Intuit header and a bank ID (INTU.BID) QuickBooks recognises. Renaming .ofx to .qbo by hand usually fails on that missing bank ID. If you have the original statement, convert it straight to .qbo with the PDF to QBO converter. If your bank gives you CSV, use CSV to QBO.
QBO, QBW, QBB, QBX: the other QuickBooks extensions
"QBO" is overloaded. It is the name of the product (QuickBooks Online) and the Web Connect file extension, and the two have nothing to do with each other: a .qbo file imports into QuickBooks Desktop just as well as into QuickBooks Online. The Desktop product also has its own family of file types, none of which carry bank data:
| Extension | What it is |
|---|---|
.qbw | The company file itself — the working database QuickBooks Desktop opens every day |
.qbb | A full backup of the company file, restored through File → Open or Restore |
.qbm | A portable company file — compressed, for moving between machines, not a backup |
.qbx | An Accountant's Copy transfer file — a snapshot sent to the accountant to work on while you keep entering |
.qby | The accountant's changes coming back, imported into the company file |
.qba | The Accountant's Copy working file on the accountant's side |
.qbo | Bank transactions (Web Connect) — the only one on this list that is a bank download, and the only one QuickBooks Online also accepts |
So if a bank or converter hands you a .qbx and calls it a bank file, something is wrong; and if you are looking for "the QuickBooks file" to send your accountant, it is a .qbx or .qbb, not a .qbo. The rest of this guide is about the .qbo only.
Why QuickBooks rejects QBO files
- The INTU.BID doesn't resolve. QuickBooks validates the file's bank ID against institutions enabled for Web Connect. A missing or unknown ID produces the "bank not enabled" class of errors — which is why a good generator lets you pick the institution (ours does, at export).
- Wrong OFX generation. QuickBooks Desktop expects OFX 1.02 SGML — the older format with a plain-text header and unclosed tags. Files generated as OFX 2.x XML look more modern and parse nowhere.
- Structural nits. Missing required tags, malformed dates, or an account-type mismatch (credit card data declared as a checking account) fail the import before any transaction is read.
FITIDs: the part worth understanding
Every transaction in a .qbo carries a FITID — the ID banks use so that downloading overlapping date ranges never duplicates a transaction. When a converter generates the file, it must invent these IDs, and how it invents them matters: if the FITID is derived deterministically from the transaction itself (date, amount, description), re-converting the same statement and re-importing is harmless — QuickBooks skips what it already has. If the converter stamps random or time-based IDs, every re-import duplicates the whole statement. This is invisible in any feature grid and very visible in your books.
Getting a QBO file when the bank won't give you one
Banks only offer Web Connect downloads for recent history, and many smaller institutions never offer it at all. For anything older — past the 90-day feed window, closed accounts, or cleanup years — the path is PDF statement → PDF to QBO conversion, or the bank's CSV export → CSV to QBO. Whatever generates the file, hold it to the two standards above: a bank ID you chose on purpose, and deterministic FITIDs — verified against the statement's printed balances before it goes anywhere near the books.
Questions people ask
- Can I open a QBO file in Excel?
- Not directly — a .qbo isn't a spreadsheet, it's a tagged text format (SGML). You can read it in any text editor, and Excel can be coaxed into parsing it, but the practical route is the other way around: keep a CSV/Excel copy for review and use the .qbo only as the import vehicle into QuickBooks.
- What's the difference between QBO and QFX files?
- Same family, different consumer. Both wrap OFX data with Intuit extensions; .qbo is Web Connect for QuickBooks, .qfx is Web Connect for Quicken. QuickBooks Desktop's Web Connect import takes only .qbo, and Quicken refuses .qbo. QuickBooks Online is more lenient: its manual upload accepts .qfx in the US, Canada and Australia.
- Why does QuickBooks say my QBO file isn't valid or my bank isn't enabled?
- Usually one of three things: the file's bank identifier (the INTU.BID tag) doesn't match an institution QuickBooks recognizes, the file is OFX 2.x XML when QuickBooks Desktop expects the older SGML flavor, or a tag QuickBooks requires is missing. It's rarely about your actual transactions — the wrapper, not the data, fails the check.
- Will importing the same QBO file twice duplicate my transactions?
- Each transaction carries a FITID — a unique ID QuickBooks uses to skip transactions it has already imported. That only works if the file's FITIDs are deterministic: the same transaction must produce the same FITID every time the file is generated. Converters that stamp random FITIDs break deduplication, and re-imports duplicate everything.
This guide is about file conversion and bookkeeping tooling — it isn't tax, accounting, or legal advice. Verify converted data against the source statement before filing or posting it.