How to open a .QBO file (QuickBooks Desktop, Online, Excel or no QuickBooks)
A .QBO file is a QuickBooks Web Connect download: a bank or credit card statement written as text for QuickBooks to import. It isn't a spreadsheet, a PDF or a QuickBooks company file, so double-clicking it either starts a QuickBooks import or shows a wall of tags. This guide covers every way to open one: in QuickBooks Desktop (Windows and Mac), in QuickBooks Online, in Excel or Google Sheets, and with no QuickBooks at all.
Short answer: to get the transactions into QuickBooks Desktop for Windows, use File → Utilities → Import → Web Connect Files (or Banking → Bank Feeds → Import Web Connect Files) and pick the bank account. In QuickBooks Online, use Bank transactions → Link account ▾ → Upload from file. To see the transactions without QuickBooks, in Excel, Google Sheets or Numbers on a Mac, convert the .qbo to CSV with .QBO to CSV or .QBO to Excel and open the .csv. To read the raw file, open it in Notepad or TextEdit: it is plain text.
See a sample .QBO as a spreadsheet
Open Utilly's fictional September 2026 checking .QBO (31 transactions, 11 deposits totalling 29,597.43 and 20 payments totalling 28,575.27) in the converter and download it as a Clean CSV. Free for the sample; your own .qbo is free up to 100 rows.
1. What a .QBO file is (and isn't)
Banks offer a .QBO download for QuickBooks, usually labelled QuickBooks, QuickBooks Web Connect or .QBO on the download screen. Inside is OFX 1.02 text with two Intuit tags added: a header that starts OFXHEADER:100, a sign-on section with the bank's INTU.BID, the account, one <STMTTRN> per transaction and the ledger balance. The sample QBO file guide takes one apart tag by tag.
The name is confusing because "QBO" also means QuickBooks Online, the product, and Intuit's own help even calls the download a "QuickBooks Online data (QBO) file". A .qbo is neither a QuickBooks Online company nor a QuickBooks Desktop company file:
| You have | What it is | How to open it |
|---|---|---|
| .QBO | A Web Connect bank or card download (transactions only, no categories) | Import into QuickBooks Desktop or Online, or convert to CSV for Excel |
| .QBW | A QuickBooks Desktop company file | QuickBooks Desktop, File → Open or Restore Company |
| .QBB / .QBM | A Desktop backup / portable copy of a company file | QuickBooks Desktop, restore it |
| .QBX / .QBA | An accountant's copy (transfer file / working file) | QuickBooks Desktop Accountant |
| QuickBooks Online company | Not a file at all; it lives at Intuit | Sign in in a browser. Exports are Excel/PDF reports, not a .qbo |
A converter can't open a .QBW or .QBB: those are QuickBooks' own databases. This guide is about the .QBO bank download.
2. Open in QuickBooks Desktop for Windows
- Open the company file and sign in to your Intuit Account inside QuickBooks. Intuit says importing Web Connect files requires that sign-in.
- Choose File → Utilities → Import → Web Connect Files, or Banking → Bank Feeds → Import Web Connect Files. Double-clicking the .qbo can also start the import when QuickBooks is the program set to open .qbo files, but with several company files open in turn it may land in the wrong one, so the menu is safer.
- Select the .qbo. In Select Bank Account, choose the existing bank or credit card account (or create one) and click Continue.
- Review the transactions in Bank Feeds: add, match or ignore each one.
Two things to know before you start. Web Connect only works on a supported Desktop version: after May 31, 2026 Intuit ended online banking, including Web Connect imports, on QuickBooks Desktop 2023, so on 2023 or older use an .IIF instead (QBO to IIF, then File → Utilities → Import → IIF Files; how to open an .IIF file has the steps). And Desktop reads only .qbo: an .ofx or .qfx is refused even if you rename it. If the import fails, .QBO Web Connect import errors covers OL-222, OL-221 and "unable to verify the financial institution".
3. Open in QuickBooks Desktop for Mac
Intuit's help for QuickBooks Desktop for Mac: go to Banking → Downloaded Transactions, select Import File and choose the .qbo. Banks' own instructions (Wells Fargo's, for example) give the same import as File → Import → From Web Connect. Pick the account the transactions belong to, then assign a payee and account to each downloaded row and add it to the register.
QuickBooks for Mac remembers the transaction ID of everything it has imported. Importing the same .qbo twice gives "Nothing imported. Account up to date." That is duplicate protection, not a broken file.
4. Open in QuickBooks Online
- Go to Bank transactions (Intuit: All apps → Accounting → Bank transactions).
- Select Link account ▾ → Upload from file (or Upload from file if the account isn't connected yet) and choose the .qbo.
- Pick the QuickBooks account, map anything QuickBooks asks about, select the transactions and finish with Yes, then Done.
Intuit's limits for a transaction-list upload are 350 KB and 1,000 lines per file, in English. Split a bigger .qbo by date range at the bank, or convert it to CSV and upload it in parts.
5. Open in Excel or Google Sheets
Excel can't open a .qbo as a table. If you force it (Open With → Excel), you get the raw <STMTTRN> tags in one column, and saving from Excel can break the file for QuickBooks. Convert it first:
- Upload the .qbo to .QBO to CSV (or .QBO to Excel, the same file with Excel-first steps). The preview lists every transaction before you download.
- Download the Clean CSV and open it in Excel (Data → From Text/CSV), Google Sheets (File → Import → Upload) or Numbers.
This sample transaction from the fictional .qbo:
<STMTTRN><TRNTYPE>DEBIT<DTPOSTED>20260901120000<TRNAMT>-6420.18<FITID>20260901E26D1A27070800<NAME>ACH DEBIT GUSTO PAYROLL 0912<MEMO>ACH DEBIT GUSTO PAYROLL 0912</STMTTRN>becomes this row in the CSV:
Date,Description,Amount,Balance
2026-09-01,ACH DEBIT GUSTO PAYROLL 0912,-6420.18,Dates come out year first, money out stays negative, and the Balance column is left empty because a .qbo only carries the ending balance, not one per row. The whole sample comes out as 31 rows: 11 deposits totalling 29,597.43 and 20 payments totalling 28,575.27.
6. Open without QuickBooks (or on a Mac)
You don't need QuickBooks to see what's in a .qbo. The options, from most to least useful:
- Convert to CSV in the browser (.QBO to CSV) and open it in Excel, Google Sheets or Numbers. Works the same on Windows, Mac and Chromebook; nothing to install.
- Import it into other bookkeeping software. A .qbo has the same transaction body as an OFX file, so programs that take OFX often take it too. Xero lists QuickBooks (.qbo) files alongside OFX, QFX, QIF and CSV for statement imports; for programs that only accept .ofx, see how to open an OFX file.
- Move it to Quicken. Quicken wants QFX or QIF, not QBO. QBO to QIF writes a .qif for Quicken for Windows.
- Read the text (next section) to check dates, account and totals.
Utilly doesn't ship a separate ".qbo viewer"; the converter preview, which lists every row before you download, is the closest thing.
7. Read it in a text editor
A .qbo is plain text, so Notepad on Windows or TextEdit on a Mac opens it (right-click → Open With). Read it, don't edit it in Word. What you'll see:
- Nine header lines starting
OFXHEADER:100,DATA:OFXSGML,VERSION:102. - The sign-on block with
<FID>and<INTU.BID>: the bank ID QuickBooks Desktop checks. <BANKACCTFROM>for a bank account or<CCACCTFROM>for a card, with<ACCTID>(the account number, often only the last digits).<DTSTART>and<DTEND>: the date range the bank put in the file.- One
<STMTTRN>per transaction, with<TRNAMT>signed and a unique<FITID>. <LEDGERBAL>: the balance at the end of the file.
That is usually enough to answer "which account and which dates is this?". Intuit's own fix for one Mac duplicate problem does involve editing ACCTID in TextEdit, but in general a hand-edited .qbo is the easiest way to get an import error; convert instead when you need a different format.
8. QBO to PDF
There's no direct ".qbo to PDF" step, because a .qbo has no layout to print. To get a printable list of the transactions, convert it to CSV, open it in Excel or Google Sheets, then use File → Print → Save as PDF (Windows: Microsoft Print to PDF; Mac: PDF button in the print dialog; Sheets: File → Download → PDF). The result is a transaction list, not a copy of the bank's statement; for that, download the PDF statement from your bank.
9. Why it won't open
| What happens | Likely cause | What to do |
|---|---|---|
| Double-click opens Notepad, a browser or "choose an app" | QuickBooks isn't installed or isn't the default for .qbo | Import from inside QuickBooks, or convert to CSV to just look at it |
| Excel shows one column of tags | You opened the .qbo itself | Convert to CSV, open the .csv |
| "To download and import transactions, sign in with your Intuit account" | Desktop needs an Intuit sign-in for Web Connect | Sign in inside QuickBooks Desktop, or switch Bank Feeds mode |
| Web Connect menu missing or import refused on Desktop 2023 or older | Online banking ended for that version (2023: May 31, 2026) | QBO to IIF and import the .IIF |
| "Unable to verify the financial institution" / OL-222 | Bank ID (INTU.BID) not accepted, or a bank-side problem | See .QBO import errors |
| "Nothing imported. Account up to date." | Those transaction IDs were imported before | Nothing is missing if they're already in the register; otherwise see Intuit's steps |
| QuickBooks Online says the file is too big | Over 350 KB or 1,000 lines | Download shorter date ranges, or convert to CSV and upload in parts |
| It opens but there are no transactions | The bank exported an empty date range, or it's an investment download | Check DTSTART/DTEND in a text editor and download again |
10. Convert your own .qbo
Have the .qbo and just want the transactions somewhere useful? Pick the output. Only have PDF statements? Start from the PDF instead.
Turn a .QBO into something you can open
Free up to 100 rows with a full preview first. Files are read in memory and not stored.
Utilly isn't affiliated with Intuit or QuickBooks. Menu names change between versions; the paths above are from Intuit's help pages, checked November 8, 2026. Sources: Intuit, Fix Web Connect import errors (.qbo is the only type Web Connect reads; Intuit Account sign-in); Intuit, Import and export data in QuickBooks Desktop; Intuit, Download bank transactions in QuickBooks Desktop for Mac; Intuit, Error: Nothing imported after importing a Web Connect (.qbo) file; Intuit, Manually upload transactions into QuickBooks Online (350 KB, 1,000 lines); Wells Fargo, QuickBooks (Web Connect) (Mac File → Import → From Web Connect); Xero Central, Import a bank statement in CSV format (OFX, QFX or QuickBooks files recommended). The sample file is fictional.
FAQ
How do I open a QBO file?
A .QBO file is a QuickBooks Web Connect download, so you import it rather than open it. In QuickBooks Desktop for Windows use File, Utilities, Import, Web Connect Files; in QuickBooks Online use Bank transactions, Link account, Upload from file. To see the transactions in a spreadsheet, convert the .qbo to CSV and open the CSV in Excel or Google Sheets.
How do I open a QBO file without QuickBooks?
Convert it to CSV with a .QBO to CSV converter and open the CSV in Excel, Google Sheets or Numbers, or open the .qbo in Notepad or TextEdit to read the raw text. Bookkeeping software that imports OFX often takes .qbo too; Xero lists QuickBooks files among its statement import formats.
Can I open a QBO file in Excel?
Not as a table. Excel shows the file's OFX tags in one column, and saving it from Excel can break it for QuickBooks. Convert the .qbo to a CSV first; each transaction becomes a row with the date, description and signed amount, and the CSV opens normally in Excel.
How do I open a QBO file in QuickBooks Desktop?
Sign in to your Intuit Account inside QuickBooks Desktop, then choose File, Utilities, Import, Web Connect Files (or Banking, Bank Feeds, Import Web Connect Files), select the .qbo and pick the bank or card account. The transactions appear in Bank Feeds to add or match. QuickBooks Desktop 2023 lost Web Connect on May 31, 2026; on that version import an IIF file instead.
How do I open a QBO file on a Mac?
In QuickBooks Desktop for Mac, Intuit's help says to go to Banking, Downloaded Transactions, Import File; banks also describe it as File, Import, From Web Connect. Without QuickBooks, open the file in TextEdit to read it, or convert it to CSV and open that in Numbers or Excel.
Is a QBO file the same as a QuickBooks company file?
No. A .QBO is a bank or credit card download with transactions only. A QuickBooks Desktop company file is .QBW, with .QBB backups and .QBM portable copies, and a QuickBooks Online company isn't a file at all. QBO also stands for QuickBooks Online, which is where the confusion comes from.
Can I convert a QBO file to PDF?
Not directly, because a .qbo has no page layout. Convert it to CSV, open it in Excel or Google Sheets and print or download it as a PDF. That gives a list of the transactions, not a copy of the bank's statement; download the statement PDF from your bank for that.
Related guides
- Free sample QBO file (QuickBooks Web Connect), explained
- QuickBooks .QBO (Web Connect) import errors: OL-222, OL-221, “unable to verify the financial institution” and how to fix them
- How to open an OFX, QFX or QIF file (Excel, Quicken, text)
- How to open an .IIF file (QuickBooks Desktop, Excel or no QuickBooks)
- QBO vs IIF vs QIF: which file QuickBooks and Quicken actually need
- How to import bank transactions into QuickBooks Desktop after bank feeds stopped (2026)
Related tools
- Bank reconciliation checker: compare a bank statement to your books and list missing, duplicate and mismatched transactions.
- Receipt to CSV: turn PDF or photo receipts and invoices into CSV, Excel, or QuickBooks and Xero bill imports.
