What Is a .QBO File? Web Connect Explained in Plain English
A .QBO file is a QuickBooks Web Connect file: a small text document that holds your bank transactions in a structured format QuickBooks can read and import automatically. Despite the name, it has nothing to do with QuickBooks Online. Here's everything a non-technical user needs to know.
The short answer
A .QBO file is the file format your bank would hand you if you clicked a button labeled "Download to QuickBooks." It contains a list of transactions, dates, amounts, descriptions, and a couple of account identifiers, all wrapped in tags that QuickBooks understands. When you import it, QuickBooks reads those tags and drops each transaction into the right register, often without you typing a single number.
The format is officially called QuickBooks Web Connect. The .QBO extension is just the file ending, the same way .pdf ends a PDF or .xlsx ends an Excel workbook.
.QBO does NOT mean QuickBooks Online
This trips up almost everyone, so let's be clear: the "QBO" in a .QBO file does not stand for QuickBooks Online. It is an unfortunate coincidence of abbreviations.
- QuickBooks Online (QBO) is the web-based accounting product you log into in a browser.
- A .QBO file is a bank-transaction file in the Web Connect format. You can import it into either QuickBooks Desktop or QuickBooks Online.
So when someone says "I have a QBO file," they mean the file, not the software. Both QuickBooks editions happily accept it.
What's actually inside a .QBO file
If you opened a .QBO file in a plain text editor (don't worry, you never have to), you'd see something that looks like XML with angle-bracket tags. Under the hood it carries:
- Bank and account IDs, a
BANKID(routing number) andACCTID(account number) so QuickBooks knows which register to match. - Account type and currency, checking, savings, or credit card, plus the currency code like
USD. - A date range, the start and end dates the transactions cover.
- Each transaction, a date, an amount (negative for money out, positive for money in), a description or payee, and a unique
FITIDthat prevents the same transaction from importing twice.
That last detail, the unique transaction ID, is why .QBO is the most reliable import format: QuickBooks uses it to deduplicate, so re-importing the same file won't create double entries.
Where does a .QBO file come from?
Traditionally, two ways:
- Direct from your bank. Some banks offer a "Download to QuickBooks (Web Connect)" option in online banking. Click it and you get a ready-made .QBO file.
- You make one yourself. Many banks only export CSV or Excel, with no QuickBooks option at all. In that case you convert the spreadsheet into a .QBO file. That is exactly what QBO Maker does: you drop in the CSV or Excel your bank gave you, map the date, amount, and description columns once, and download a valid Web Connect file. The conversion happens entirely in your browser, so your statement data is never uploaded anywhere.
If you also use Quicken or another accounting tool, the same source data can become a QFX file or a plain OFX file instead.
How to import a .QBO file into QuickBooks
Once you have the file, importing takes under a minute.
QuickBooks Desktop: go to File → Utilities → Import → Web Connect Files, then choose your .qbo file. QuickBooks will ask which account to link it to and then load the transactions into Bank Feeds.
QuickBooks Online: go to Transactions → Bank transactions (or Banking), click Upload transactions, pick the account, and upload the file. For a full walkthrough see our guide on importing bank data into QuickBooks Online.
One advantage worth knowing: Web Connect import is the standard way to bring in more than 90 days of history, which the live bank-feed connection often won't let you pull.
.QBO vs .QFX vs .OFX: which do you need?
All three are cousins built on the same Open Financial Exchange standard. The difference is who they're tuned for:
- .QBO, QuickBooks (Desktop and Online). Use this for QuickBooks.
- .QFX, Quicken's flavor. Use this if you're importing into Quicken.
- .OFX, the generic version that many other accounting apps (and older Microsoft Money) accept.
If your tool is QuickBooks, a .QBO file is the right choice every time. Not sure your file is well-formed before importing? Run it through our free OFX/QBO validator first to catch formatting problems early.
Frequently asked questions
Is a .QBO file the same as QuickBooks Online?
No. A .QBO file is a bank-transaction file in the Web Connect format. QuickBooks Online (also abbreviated QBO) is the web-based software. The shared abbreviation is a coincidence. The file imports into both QuickBooks Desktop and QuickBooks Online.
Can I open a .QBO file to read it?
Technically yes, in any plain text editor, since it's a structured text file. But it's not meant to be read by humans. It's meant to be imported into QuickBooks, which turns the tags into real transactions for you.
My bank only gives me CSV. How do I get a .QBO file?
Convert it. Upload the CSV or Excel export to QBO Maker, map your date, amount, and description columns, and download a Web Connect .QBO file. Everything runs in your browser, so the statement never leaves your computer.
Will importing the same .QBO file twice create duplicates?
Usually not. Each transaction carries a unique ID (FITID) that QuickBooks uses to recognize entries it has already imported, so accidental re-imports are typically skipped rather than duplicated.
Is a .QBO file safe to share with my accountant?
It contains your account number and transaction details, so treat it like a bank statement. Share it only through secure channels, the same way you'd send a PDF statement.