QBO: A QBO file is OFX with Intuit's header.
QuickBooks Web Connect files hold an ordinary OFX statement underneath, plus a line naming the bank in Intuit's registry. QuickBooks checks that line before it reads a single transaction, which is why it accepts a QBO and rejects the identical data as a plain OFX.
Runs in your browser · Nothing uploaded · No account
- OFX underneath
- QuickBooks only
- Carries the bank's Intuit id
Export transactions
Choose the scope, format, fields, and column order.
Scope
Selected transactions (40)Exports only the currently selected rows.
Format
QuickBooks (Web Connect)A Web Connect file for QuickBooks.
Fixed field set
OFX/QuickBooks files always carry date, description, and signed amount.
Row order
Match current viewFields
Fixed by the OFX/QuickBooks format
Preview
1,284 matching transactions
| Date | Description | Amount |
|---|---|---|
| 2025-10-24 | STRIPE PAYOUT 4af2c9 | 4820.00 |
| 2025-10-23 | AWS EMEA SARL us-east-1 | -1204.00 |
| 2025-10-22 | WHOLE FOODS MKT #214 | -112.88 |
1,284 rows · 3 columns
Export QuickBooks (Web Connect)QuickBooks refuses more QBO files than it accepts.
The transactions are almost never the problem. What fails is the header: an INTU.BID naming an institution QuickBooks does not recognise, an OFX version the running release stopped accepting, a statement period that ends in the future, or an account block that does not match the account you are importing into. Each produces the same unhelpful refusal, and each is visible in the first ten lines of the file if you look.
How it works
How to open a QBO file
- 1
Read the header before anything else
A QBO is text. The top of the file carries OFXHEADER, VERSION, and INTU.BID, and those three lines explain most rejections on their own.
- 2
Import it into QuickBooks
In QuickBooks Online: Transactions, then Bank transactions, then Upload from file. In Desktop: File, then Utilities, then Import, then Web Connect Files. Both route the file through the bank feed review screen rather than posting it straight to the ledger.
- 3
If it is refused, check the institution id
The INTU.BID has to be one QuickBooks knows. A file written by a converter that invented an id, or one taken from a bank you no longer hold the account with, is refused whatever the transactions say.
- 4
If the destination is not QuickBooks, convert it
Quicken wants QFX, and Xero, Sage, Wave and GnuCash want plain OFX. All three are the same document with a different header, so it is a rewrite of a few lines rather than a re-read of the statement.
What is inside a QBO file
INTU.BID: the bank's Intuit id
A numeric id from Intuit's directory of financial institutions. QuickBooks Desktop refuses a file whose id it cannot find there, which is the single most common cause of a rejected import.
An OFX 1.02 body
Below the Intuit lines sits SGML, not XML: tags are opened and never closed. A strict XML parser fails on it, which is normal rather than a sign of corruption.
An FITID per transaction
Each transaction carries a unique id from the bank, so QuickBooks can recognise a row it has already imported instead of duplicating it when two files overlap.
A stated statement period
DTSTART and DTEND bound the period, and DTASOF dates the closing balance. A period ending in the future is rejected, which catches files whose dates were written in the wrong timezone.
The account it belongs to
A bank id, account number, and account type, which QuickBooks matches against the account you chose on the import screen.
Not the same as QFX
QFX carries Quicken's identifiers instead. The two files look nearly identical and each program refuses the other's, so renaming one to the other never works.
Why QuickBooks rejected the file
The five causes worth checking, in the order they occur.
| What is wrong | Where to look |
|---|---|
| Unknown institution id | The INTU.BID line. QuickBooks Desktop matches it against Intuit's directory. |
| Wrong OFX version | The VERSION line in the header. QBO files are OFX 1.02, not 2.x. |
| Statement period ends in the future | DTEND and DTASOF, usually a timezone or clock problem in whatever wrote the file. |
| Account mismatch | BANKACCTFROM against the account selected on the import screen. |
| Truncated download | The end of the file. A complete QBO closes with </OFX>. |
QuickBooks Online is more forgiving about the institution id than Desktop, so a file Desktop refuses can still import online.
FAQ
Common questions
What is a QBO file?
A QuickBooks Web Connect file: an OFX 1.02 statement carrying an Intuit header that identifies the bank to QuickBooks. It holds one account's transactions for one period, each with a unique id, plus the closing balance.
How do I open a QBO file?
Import it into QuickBooks through Upload from file in QuickBooks Online, or Web Connect Files in Desktop. To look at the contents without QuickBooks, open it in a text editor or read it as a table in a viewer, since the file is plain text.
What is the difference between QBO and OFX?
The transaction data is identical. A QBO adds Intuit's header, principally INTU.BID identifying the bank. QuickBooks requires it and refuses plain OFX, while Xero, Sage, Wave and GnuCash want the plain OFX and ignore the Intuit fields.
Why does QuickBooks say my QBO file cannot be read?
Most often the INTU.BID names an institution QuickBooks does not recognise. After that: an OFX version the release no longer accepts, a statement period ending in the future, an account that does not match the one selected, or a download that was cut short.
Can Excel open a QBO file?
Not as a table. Excel shows the markup rather than the transactions. Convert it to CSV or XLSX first, which puts one transaction per row with dates and amounts in their own columns.
Can I rename a QBO file to .qfx for Quicken?
No. Quicken checks the identifiers inside the file, not the extension, and QBO carries QuickBooks' rather than Quicken's. The header has to be rewritten for Quicken to accept it.
Keep exploring
QIF Files
Quicken's oldest text format: what is inside one, and what still reads it.
QFX Files
Quicken's Web Connect file, and why a plain OFX will not do instead.
OFX Files
The banks' interchange format, its two incompatible versions, and what imports it.
IIF Files
QuickBooks Desktop's tab-delimited import, and the accounts it creates by accident.
Bank Statement Converter
What a converter has to get right, and what the file looks like when it does.
Read the file, then fix what QuickBooks objected to.
Open a QBO, QFX, OFX, or QIF in the browser and save it as CSV, check why QuickBooks refused one, or convert a statement PDF straight to a QBO that imports.