StatementHarborWhat is a QBO file?
A QBO file is a QuickBooks Web Connect file: bank transactions (dates, amounts, payees) in a text format QuickBooks imports natively, filing rows under the right account automatically. Think of it as a CSV with instructions attached.
Reviewed by the StatementHarbor team · September 2026
What's inside a QBO file?
Despite the mystery, a QBO file is plain text (OFX SGML format). Open one in Notepad and you'll see blocks like this:
STMTTRN
TRNTYPE DEBIT
DTPOSTED 20260315120000
TRNAMT -142.77
NAME CON EDISONEach STMTTRN block is one transaction: type, date, signed amount, and name. The header identifies the bank and account, which is why QuickBooks files the rows without asking you to map anything.
QBO vs CSV vs OFX
| Format | Opens in | Import behavior in QBO |
|---|---|---|
| CSV | Excel, Sheets, anything | Manual column mapping; rows land in Review |
| QBO | QuickBooks only | One-click import; auto-assigned to the account in the file header |
| OFX | Quicken, many tools | QBO's cousin — same family, XML-style header |
When to use a QBO file
- Recurring monthly imports into the same ledger — the automation saves real time.
- Client files where rows must land in the right account without manual mapping mistakes.
- QuickBooks Desktop, which prefers QBO over CSV for bank data.
When CSV is better
- You want to inspect, filter, or edit rows before import.
- You're importing into Google Sheets for analysis rather than a ledger.
- QBO's import complains about the file — CSV mapping is the easier debug.
How to get a QBO file from a statement
Convert the statement PDF with the StatementHarbor converter and press Download QBO. The parser generates the Web Connect format in your browser — no server involved. Then import via Banking → Link account ▾ → Import transactions. Full steps: import guide.
FAQ
What is a QBO file?
A QBO file is a QuickBooks Web Connect file — a small text file containing bank transactions (dates, amounts, descriptions) wrapped in a structure QuickBooks Online and QuickBooks Desktop import natively, assigning rows to the right account automatically.
QBO file or CSV: which should I import into QuickBooks?
Use a QBO file when you want a one-click import filed under the correct bank account automatically. Use CSV when you want to review every row on the import screen before it lands. Both carry the same transaction data.
Are QBO files safe to open?
Yes. They're plain-text transaction lists, not executables. The only risk is importing the wrong rows into a ledger, which the Review screen catches.