What is a QBO file, and how do you open one?

Two different things called “QBO”

People use “QBO” for two unrelated things:

• .qbo files – Web Connect transaction files that banks offer as “QuickBooks download”. This page is about these.
• QBO = QuickBooks Online, Intuit's web product. A “QBO file” in that sense usually means your online company data, which you can't download as a single file.

A .qbo file is also not a QuickBooks company file. Company files are .QBW (working file), .QBB (backup) and .QBM (portable); those need QuickBooks Desktop.

What is inside a .qbo file

Open one in Notepad or TextEdit and you will see an OFX header followed by tags such as:

<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20260114
<TRNAMT>-42.50
<FITID>20260114001
<NAME>HARDWARE STORE
</STMTTRN>

Plus the account number, currency, the statement period, often a ledger balance, and an Intuit-specific bank ID (<INTU.BID>) that QuickBooks uses to recognise the bank.

How to open a QBO file without QuickBooks

1. Text editor – fine for a quick look at a few transactions.
2. Rename to .ofx – some personal-finance apps (e.g. GnuCash, Moneydance) import OFX. Results depend on how strict the app is.
3. Convert to Excel or CSV – open the file in Ledgermere and export Excel or CSV. You get date, payee, memo, amount, type and the bank's transaction ID per row, and several .qbo files can be merged with duplicates removed.

Importing a QBO file into QuickBooks

• Desktop: Banking › Bank Feeds › Import Web Connect Files.
• Online: Bank transactions › Link account ▾ › Upload from file. Intuit lists .qbo among the accepted types (up to 1,000 lines and 350 KB per upload).

If the bank only gives you CSV, PDF or Quicken QFX, you can convert CSV to QBO, PDF to QBO or QFX to QBO.