If you have ever asked what is a QBO file, you probably ran into one while trying to get bank data into QuickBooks. A QBO file is the format QuickBooks uses to import transactions, and it is built for software to read rather than people. This guide explains what a QBO file actually is, how it relates to the formats around it, how to open or read one, and how to create a QBO from the statement your bank gave you.
What a QBO file is
QBO stands for QuickBooks Web Connect. A QBO file is a structured document that contains a set of bank or credit card transactions along with the information QuickBooks needs to import them: the account, the financial institution identifiers, the dates, the amounts, and a unique ID for each transaction. The file extension is .qbo, and QuickBooks recognizes it specifically as a Web Connect import.
Under the hood, a QBO file is written in SGML, the same markup family that OFX uses. It looks like a series of tagged fields rather than the comma-separated rows you would see in a CSV. That tagged structure is exactly what lets QuickBooks load the data reliably and avoid duplicates.
How a QBO file relates to OFX and QFX
QBO does not exist in isolation. It is one of a small family of formats built on the same OFX foundation:
| Format | Target software | Base |
|---|---|---|
| OFX | Open standard, many tools | Open Financial Exchange |
| QBO | QuickBooks (Web Connect) | OFX with QuickBooks identifiers |
| QFX | Quicken (Web Connect) | OFX with Quicken identifiers |
The data inside is similar across all three. What differs is the identifiers each one carries, which is why QuickBooks wants a QBO specifically and Quicken wants a QFX. We compare them in detail in the guide on OFX vs QFX vs QBO.
How to open a QBO file
A QBO file is meant to be imported, not opened and read. The normal way to use one is:
- In QuickBooks Desktop, use File, then Utilities, then Import, then Web Connect Files.
- In QuickBooks Online, use Transactions, then Bank transactions, then Upload from file.
If you only want to see what is inside, you can technically open the .qbo in a plain text editor, but you will see raw SGML tags, not a tidy table. The readable way to inspect the transactions is to convert the QBO into a spreadsheet. You can convert a QBO file to CSV and open it in Excel, which turns the tagged structure into plain date, description, amount, and balance columns.
How to create a QBO file
This is the part most people actually need. Banks rarely hand you a QBO directly. They give you a PDF, a CSV, or sometimes an OFX or QFX export. To get a QBO, you convert. BankConvert reads your source file, extracts the transactions, and builds a valid QBO with unique transaction IDs and correctly formatted dates and amounts. Depending on what you start with, you can:
- Convert a PDF statement to QBO when your bank only provides a PDF.
- Convert a CSV to QBO when you have a bank CSV export.
- Convert an OFX file to QBO when your existing OFX needs to go into QuickBooks.
In each case the result is a Web Connect QBO that QuickBooks Online and Desktop accept.
Common QBO import problems
Most QBO trouble is about the file, not QuickBooks. Watch for:
- Duplicate or missing transaction IDs, which cause duplicate warnings or rejections.
- A wrong financial institution identifier, which QuickBooks may refuse.
- Dates or amounts formatted incorrectly inside the file.
- A file that is really an OFX or QFX when QuickBooks expected a QBO.
A properly built QBO avoids all of these, which is the whole point of using a converter rather than editing tags by hand.
Security and scope
A QBO carries your real transactions, so handle the source files carefully. BankConvert encrypts files, processes them only to convert, then discards them, and never stores or sells your data, as described on the security page. And remember that BankConvert converts data rather than offering accounting advice, so review the transactions before you import them into your books.
Bottom line
A QBO file is QuickBooks Web Connect: an OFX-based, SGML file carrying transactions and the identifiers QuickBooks needs. You import it rather than read it, and you create one by converting whatever your bank gave you. With a clean QBO, getting a month of activity into QuickBooks is a single upload instead of a stack of manual entries.
Create a QBO file from any statement
Convert a PDF, CSV, or OFX into a valid QuickBooks Web Connect QBO, ready to import in one step.
See how the converter works step by step on the how it works page.
BankConvert // Get started
Convert your statements
Upload any statement in any format, pick your output, and download a clean file ready for QuickBooks, Xero, or Excel. Files are encrypted and never stored or sold.