What Is a QBO File? How to Open, View & Convert It Free

What Is a QBO File?

A QBO file (extension .qbo) is a QuickBooks Web Connect file — a structured data file that QuickBooks uses to import bank transactions from your bank into your accounting books. When you log in to your bank's website and download transactions in QuickBooks format, the file you get is a QBO file.

Under the hood, a QBO file is a plain-text file based on the OFX 1.02 standard (Open Financial Exchange). OFX is an open specification for exchanging financial data between institutions and applications. Intuit extended OFX with a proprietary header field (INTU.BID — Intuit Bank ID) that tells QuickBooks which financial institution the file belongs to. This is the only real difference between a QBO file and a standard OFX file.

What Does a QBO File Look Like Inside?

A QBO file is plain text — you can open it in any text editor (Notepad on Windows, TextEdit on Mac, or VS Code). Here is what a typical QBO file looks like:

The key fields in each transaction (STMTTRN) are:

• DTPOSTED: Transaction date in YYYYMMDD format
• TRNAMT: Amount — negative for debits, positive for credits
• FITID: Unique transaction ID used by QuickBooks to prevent duplicate imports
• NAME: Payee / merchant name
• MEMO: Additional transaction description
• TRNTYPE: Transaction type — DEBIT, CREDIT, CHECK, ATM, etc.

QBO vs OFX vs QIF vs QFX — What's the Difference?

Where Do QBO Files Come From?

QBO files are generated in two ways:

1. Downloaded directly from your bank

Most major US banks offer QuickBooks Web Connect download. Log in to your bank's online banking, go to the download or export section, select QuickBooks (.qbo) or QuickBooks Web Connect as the format, and choose a date range. Banks that support QBO download include Chase, Bank of America, Wells Fargo, US Bank, TD Bank, Capital One, Citibank, PNC, and most credit unions.

2. Generated by a converter from PDF or CSV

If your bank doesn't offer QBO download, or you have a PDF bank statement you want to import into QuickBooks, a converter like Bank Statement Engine generates the QBO file for you. Upload your bank statement PDF and download a QuickBooks-ready QBO file.

How to Open a QBO File

Option 1: Open in QuickBooks (to import transactions)

QuickBooks Online: Go to Transactions → Banking → Upload from file → select your QBO file → map to an account → import. Transactions appear in the For Review tab.

QuickBooks Desktop: File → Utilities → Import → Web Connect Files → select your QBO file → choose existing account → OK. Transactions load in the Banking Centre.

Option 2: Open in a text editor (to read raw content)

Right-click the QBO file → Open with → Notepad (Windows) or TextEdit (Mac). You'll see the raw OFX/SGML content. This is useful for debugging or inspecting what the file contains.

Option 3: Convert to Excel or CSV (to view as a spreadsheet)

Upload the QBO file to Bank Statement Engine's QBO to CSV converter. The converter parses all transactions and outputs a clean spreadsheet with Date, Description, Amount, and Balance columns — no QuickBooks subscription needed.

How to Import a QBO File Into QuickBooks

QuickBooks Online — step by step

1. Log in to QuickBooks Online
2. Go to Transactions in the left menu
3. Click Banking (or Bank transactions in newer UI)
4. Click Upload from file (top right corner)
5. Select your .qbo file and click Open
6. Select which QuickBooks bank account to import into
7. Click Next — QuickBooks shows a preview of transactions
8. Click Import — transactions appear in the For Review tab
9. Review, categorise, and match each transaction

QuickBooks Desktop — step by step

1. Open QuickBooks Desktop
2. Go to File → Utilities → Import → Web Connect Files
3. Browse to your QBO file and click Open
4. Choose Use an existing QuickBooks account and select the bank account
5. Click Continue — transactions load into the Banking Centre
6. Review transactions in the Banking Centre and accept or match them

Can I Open a QBO File Without QuickBooks?

Yes — in two ways:

• Text editor: QBO files are plain text. Open with Notepad, TextEdit, or VS Code to read the raw OFX data. The structure is readable but not formatted as a table.
• Convert to Excel: Use the QBO to CSV converter to turn the QBO into a clean spreadsheet you can open in Excel or Google Sheets. Free, no QuickBooks subscription.

How to Create a QBO File from a Bank Statement PDF

If you have a PDF bank statement and need a QBO file for QuickBooks import:

1. Upload your bank statement PDF to bankstatementengine.com
2. The converter extracts all transactions with balance verification
3. On the results page, click Download QBO
4. Import the QBO file into QuickBooks using the steps above

This works with any bank — US, UK, Indian, Australian, Canadian, or any other country. The QBO output is compatible with QuickBooks Online and QuickBooks Desktop.

QBO File Troubleshooting

QuickBooks says "This file type is not supported"

Ensure the file extension is .qbo (not .ofx or .txt). QuickBooks Online is strict about the file extension even though the content is the same as OFX.

"No new transactions to import" after uploading QBO

QuickBooks uses the FITID field to detect duplicates. If all transactions in the QBO already exist in QuickBooks (same FITIDs), it considers the file fully imported. Try a different date range or check if the transactions are in the For Review tab already.

QBO file imports to the wrong account

QuickBooks matches the QBO to an account using the BANKID and ACCTID fields. If these don't match a linked account, QuickBooks asks you to choose. Make sure to select the correct bank account during import.

Transactions import with wrong currency or amounts

Check the CURDEF field in the QBO file header. If the currency doesn't match your QuickBooks company currency, amounts may be converted or rejected. The QBO file must use the same currency as your QuickBooks company.

Frequently Asked Questions