What is a QBO file?
By the FileInto team · Updated November 12, 2026
Quick answer
A QBO file is a bank statement file in Intuit's Web Connect format. Banks offer it so you can import transactions into QuickBooks. Inside, it's an OFX file with one extra Intuit tag that names the bank.
What a QBO file is for
Intuit calls a .qbo file a QuickBooks Bank Statement file. You download it from your bank’s website and import it into QuickBooks, and the transactions land in your bank register or bank feed. The import method is called Web Connect.
QuickBooks Desktop’s Web Connect reads only .qbo files. QuickBooks Online is more flexible: its manual upload accepts QBO, QFX, OFX and CSV files, and Intuit suggests QBO.
What’s inside a QBO file
A QBO file is plain text. It’s an OFX (Open Financial Exchange) statement, the same format many finance apps use, plus one Intuit tag: INTU.BID, the ID of the bank that issued the file. QuickBooks uses that tag to decide whether it trusts the file.
Here is the start of a QBO file FileInto made from a sample bank CSV:
OFXHEADER:100
DATA:OFXSGML
VERSION:102
...
<FI>
<ORG>Wells Fargo
<FID>3000
</FI>
<INTU.BID>3000
...
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20261003120000
<TRNAMT>-5.75
<FITID>FI8bd338a14c55a4f6
<NAME>PURCHASE AUTHORIZED ON 10/02 STA
</STMTTRN>Each transaction sits in a STMTTRN block with a type, a date, a signed amount, a payee and a FITID. The FITID is a unique ID for that transaction, and it’s how QuickBooks spots a transaction it has already imported.
QBO, QFX, OFX and CSV compared
| Format | Made for | Notes |
|---|---|---|
| .qbo | QuickBooks Desktop and Online | OFX plus Intuit’s INTU.BID bank tag. The only file Desktop’s Web Connect reads |
| .qfx | Quicken | Also OFX with an Intuit bank tag. QuickBooks Online accepts it too |
| .ofx | Xero, GnuCash, Moneydance and others | Plain OFX, no Intuit tag |
| .csv | Spreadsheets, QuickBooks Online uploads | Columns of text. QuickBooks Online asks you to match the columns when you upload |
How to get a QBO file
- Sign in to your bank’s website and open the account.
- Look for Download, Export or Download account activity.
- Choose the QuickBooks or Web Connect format and a date range.
Tip: If your bank only offers CSV or Excel, which is common now, convert that file. FileInto’s CSV to QBO converter does it in your browser, without uploading your file, and shows every row before you download.
How to import a QBO file
- QuickBooks Online: go to Bank transactions, open the Link account menu and choose Upload from file. See how to import bank transactions into QuickBooks Online.
- QuickBooks Desktop: go to Banking, then Bank Feeds, then Import Web Connect Files. See QuickBooks Web Connect. In Advanced bank feeds mode, Intuit requires you to be signed in to your Intuit Account first.
Note: Intuit’s limit for a QuickBooks Online upload file is 350 KB, so split a big file into shorter date ranges.
Can you open a QBO file in Excel?
You can open it in any text editor to look at it, but Excel won’t show it as a neat table, because it isn’t a spreadsheet. To get the transactions in a spreadsheet, turn the file into a CSV with FileInto’s QBO to CSV converter, or see how to open a QBO, QFX or OFX file.
When QuickBooks rejects a QBO file
The most common error in QuickBooks Desktop says it can’t verify the financial institution. That’s about the bank tag described above. See how to fix “QuickBooks is unable to verify the financial institution”.
Sources