Someone sends you a QBO file. Or your bank offers one for download. You have no idea what it actually is. This file format shows up constantly for one simple reason. QuickBooks holds about 66.58% of the accounting software market, far ahead of Sage 50 and Xero. Here is a plain answer, plus how to open one even without QuickBooks installed.
What a QBO File Actually Contains
A QBO file is a file format QuickBooks uses to import bank and credit card transactions. Banks generate it. Or you convert one yourself from a CSV, Excel, or PDF bank statement. QuickBooks reads it in without you typing each transaction by hand.
Under the hood, QBO is Intuit's own variant of OFX (Open Financial Exchange). Microsoft, Intuit, and CheckFree jointly built OFX in the late 1990s. Early OFX files used SGML. Newer ones use XML. Either way, the file is plain structured text. Nothing is encrypted or locked away.
Open a QBO file in any plain text editor, and you will see it broken into blocks. Each transaction sits inside a tag called STMTTRN. It carries a date, an amount, a description, and a unique ID. The file also carries account-level details near the top. A bank ID, an account number, and an account type. ProperSoft's own explanation covers the same structure. QBO files hold transactions, account balances, and bank records. Everything is arranged so QuickBooks and similar programs can read it without manual entry.
This structure is also why a QBO file generated for the wrong account type causes real problems. A checking account and a credit card account use different tags internally. Import one as the other, and QuickBooks reads every amount with the wrong sign.
That account number detail matters. QBO files carry real account numbers and institution identifiers in plain text, with no encryption built into the format itself. Treat a QBO file the same way you would treat a bank statement. Do not forward it casually, and delete it once you no longer need it.
What Application Opens a QBO File
QuickBooks is the obvious answer, both Desktop and Online. QuickBooks imports a QBO file through a feature called Web Connect. Intuit's own documentation is specific here. Web Connect only works with QBO files. A QFX file or a QIF file will not work through the same import path. This holds even though all three formats look similar on the surface.
Quicken opens some related formats, though not QBO itself without conversion first. Beyond dedicated accounting software, a QBO file is just text. Any text editor technically opens it. Reading it comfortably is a separate question, covered next.
How to Open a QBO File Without QuickBooks
A QBO file usually has no line breaks. Open it in Notepad, and you get one extremely long line, or a handful of them, packed with tags. This counts as open. It does not count as readable.
Two better options exist if you do not have QuickBooks installed:
- A code editor with find and replace. Search for
</STMTTRN>and replace it with the same text followed by a line break. This splits the file into one line per transaction. Any plain text editor becomes readable this way. - A free online QBO viewer. Tools like this one read a QBO file in your browser. They show the transactions in a normal table: date, amount, description. No QuickBooks, no installation. The file stays on your device the whole time.
Either approach works for a quick look. Sometimes a quick look is not enough, though. If you need the data somewhere else, like a spreadsheet, converting the QBO file to CSV works better. It beats reading raw tags by eye.
Maybe your bank sent you a QBO file, and you actually need it as a spreadsheet instead. That conversion runs the opposite direction from what most tools focus on. qbosync handles both directions. Bank statement to QBO, and QBO back to a clean CSV or Excel file, from the same account.
Try qbosync on your own bank statement. Your first conversion is free, whichever direction you need it.
Try qbosyncFAQ
What is a QBO file?
A QBO file is QuickBooks' own format for importing bank and credit card transactions, based on the older OFX standard. It holds structured data like dates, amounts, and descriptions. This lets QuickBooks read transactions in automatically, instead of you entering them by hand.
What application can open a QBO file?
QuickBooks Desktop and QuickBooks Online both open QBO files through a feature called Web Connect. A QBO file is plain structured text underneath, so any text editor can technically open it too. The contents are hard to read without adding line breaks first.
How do you open a QBO file without QuickBooks installed?
Use a code editor to add a line break after each transaction block. Or use a free browser-based QBO viewer that displays the transactions in a normal table, with nothing to install.
Can you view what's inside a QBO file before importing it?
Yes. A free online viewer shows every transaction, its date, amount, and description, before you import anything into QuickBooks. This is a safer way to check a file looks right, especially one you did not generate yourself.