What a QBO file actually is
A QBO file contains bank or credit card transactions formatted for QuickBooks Web Connect. Under the hood it is a text file based on OFX (Open Financial Exchange). If you open it in a plain text editor, you will see tags like STMTTRN, DTPOSTED, TRNAMT, and NAME describing each transaction.
The file also carries identifiers that tie it to a financial institution: a bank ID, an account ID, and often an INTU.BID (Intuit bank ID) tag. QuickBooks uses these to match the file to the correct account in your company file.
Because it is bank-feed data, a QBO file is meant to be imported once into a specific account. It is not a report or a backup of your books.
Import a QBO file into QuickBooks
In QuickBooks Desktop, use File, then Utilities, then Import, then Web Connect Files. Select your QBO file and choose the account to import into, or create a new account when prompted. The transactions land in the Bank Feeds center for review before you add them to the register.
In QuickBooks Online, go to the Transactions or Banking area, choose the account, then use the Upload from file option. QuickBooks Online accepts QBO along with CSV, QFX, and OFX. After upload, you map the file to the correct account and review each transaction before accepting.
In both versions, importing does not automatically finalize the transactions. You still confirm, categorize, and match them against existing records. Review carefully so you do not create duplicates.
Read a QBO file without QuickBooks
If you only want to see what is inside, open the QBO file in any plain text editor such as Notepad or TextEdit. Right-click the file, choose Open With, and pick the editor. You will see the raw OFX tags and can read dates, amounts, and descriptions directly.
To work with the data in a spreadsheet, you need to convert it. A QBO file is not a spreadsheet, so opening it in Excel directly gives you a wall of tags rather than tidy columns. Converting the transactions to CSV or Excel first gives you rows and columns you can sort, filter, and total.
This is useful when you want to reconcile, share numbers with someone who does not use QuickBooks, or archive statement data in a readable format.
Fix common QBO import errors
Error OL-301, OL-221, or a generic import failure often means the file's bank ID or INTU.BID does not match what QuickBooks expects for that account. Confirm you are importing into the correct account, and that the account is set up for the right financial institution.
Date-range and duplicate warnings appear when the file overlaps transactions you already imported. QuickBooks flags likely duplicates during review, but check manually, since a repeated import can double your ledger.
If QuickBooks rejects the file as invalid, open it in a text editor and check that it starts with proper OFX headers and is not truncated. A file that was edited, partially downloaded, or corrupted will fail. In that case, download a fresh copy from your bank, or rebuild a clean QBO from your statement data.