UK
A QBO file is QuickBooks' Web Connect format — an OFX file with a couple of Intuit-specific tags. It's designed to be imported into QuickBooks, not read in a spreadsheet, so getting it into CSV takes a deliberate step. This guide covers the routes that work and where Export Bank Statement fits. Straight away, the honest part: Export Bank Statement converts PDF statements, not QBO files — but if your transactions started as a bank PDF, it produces CSV directly and verifies the totals.
What a QBO file actually is
QBO (file extension .qbo) is the format banks hand to QuickBooks via Web Connect. Under the hood it's OFX — the same SGML transaction structure — plus Intuit's `INTU.BID` bank identifier and a few extra tags. That bank id is why QBO files are fussy: QuickBooks checks it against its directory of participating institutions, and rejects files it doesn't recognise. Because a QBO is essentially OFX, the same conversion tricks apply.
Why convert QBO to CSV
- You don't use QuickBooks but were only offered a QBO download.
- QuickBooks rejected the file (a common bank-id error) and you need the data another way.
- You want a spreadsheet to filter, total, or hand to an accountant.
- Another system needs CSV — Xero, Zoho Books, or a lender's template.
How to convert a QBO file to CSV
- Rename a copy and treat it as OFX. A .qbo is OFX inside; many OFX-to-CSV converters accept it directly, or accept it after renaming the copy to .ofx.
- Use a QBO/OFX converter that writes CSV. Free web and desktop tools read the QBO transaction list and export date, amount, description, and balance columns.
- Check your bank for a direct CSV download. If it offers CSV next to QBO, that's the simplest path.
- Import into accounting software, then export. Tools that read OFX/QBO can re-export the register as CSV.
- If you have the original PDF statement, convert that. Export Bank Statement turns the PDF into a reconciliation-checked CSV without needing the QBO at all.
Where Export Bank Statement fits — honestly
Export Bank Statement does not read QBO files. It converts PDF bank statements into Excel, CSV, JSON, and — going the other direction — it can *produce* OFX and QBO from a PDF. So if your aim is a spreadsheet and you have the PDF, convert that. If you specifically need a working QBO to import into QuickBooks, see our QuickBooks converter and Excel to QBO guides — and note the bank-id limitation that affects every QBO not issued by a registered institution.
Frequently asked questions
Can Export Bank Statement open a QBO file?
No. It converts PDF statements only. Convert a QBO with the methods above, or convert the original PDF if you have it.
Is a QBO file the same as OFX?
Almost — a QBO is OFX plus QuickBooks' Intuit tags. That's why OFX converters usually handle QBO files too. See OFX to CSV.
Why did QuickBooks reject my QBO file?
Usually the embedded bank id (`INTU.BID`) isn't one QuickBooks recognises, which triggers an OL-301 error. Converting to CSV sidesteps that by leaving QuickBooks' import path entirely.
Is it free?
Converting a PDF statement is free to start.