How to Open a QBO File (Import It, Don’t Open It)
A .qbo file is a bank statement download, not a document you open. Double-clicking it will not show you your transactions in any useful way.
You import a .qbo file into accounting software. In QuickBooks Desktop, go to File, then Utilities, then Import, then Web Connect Files. If you do not use QuickBooks, ask your bank for a CSV export instead.
The key point is this: .qbo files exist for one purpose, to feed transaction data into QuickBooks. Everything else is a workaround.
What a .qbo file actually is
Your bank generates this file when you choose “Download transactions” or a similar option in online banking. The format is called Web Connect. It is based on OFX (Open Financial Exchange), a structured text standard used widely in banking.
The file is designed to be consumed by accounting software, not read by humans. It contains transaction records, amounts, dates, and account identifiers, written in a tag-based format. There is no visual layout, no formatting, and no easy way to read it at a glance.
It is similar in spirit to a DAT file: technically a text file underneath, but structured for a specific program, not for a person.
Importing a .qbo into QuickBooks Desktop
This is what the file is built for.
QuickBooks Desktop can read a .qbo file directly through its import menu. The general path is:
- Open QuickBooks Desktop.
- Go to the File menu, then choose Utilities.
- Select Import, then Web Connect Files.
- Browse to your .qbo file and open it.
- Match the import to the correct bank account in your QuickBooks company file.
QuickBooks will then bring in the transactions for you to review and categorize.
If the import asks you to select an account and nothing matches, set up the bank account in QuickBooks first, then repeat the import.
Only import files from your own bank. A .qbo file contains real account data. Only use files you downloaded directly from your own online banking portal. Do not open .qbo files sent to you by email or from unknown sources.
What to do without QuickBooks
If you do not use QuickBooks, a .qbo file is not a practical format for you.
The simplest solution is to go back to your bank and download a CSV instead. Most banks offer CSV, Excel, or OFX export options alongside the QuickBooks-specific download. A CSV opens in any spreadsheet (Excel, Google Sheets, LibreOffice Calc) without any special software.
You do not need to convert a .qbo file. Switching to the right export format at the source is faster and more reliable.
If you want to confirm the file extension you are looking at is really .qbo and not something else, this guide to showing file extensions in Windows can help you check.
Can you read a .qbo file in a text editor?
Technically, yes. A .qbo file is plain text underneath, so Notepad or any text editor will open it.
What you will see is not useful for most purposes. The file contains raw OFX tags, account identifiers, and transaction amounts in a format meant for software to parse. It is readable if you know the OFX structure, but there is no practical reason to read it this way for everyday use.
If you are a developer or need to debug a specific transaction, opening the file in a text editor is fine. For everyone else, import it or switch to CSV.
Frequently asked questions
Common questions about .qbo files.
What program opens a .qbo file?
QuickBooks Desktop is the primary program for .qbo files. The format is designed around its import workflow. Other accounting software may support it, but QuickBooks is the intended target.
Can I convert a .qbo to CSV?
You can, but it is usually easier to go back to your bank and download a CSV export directly. That avoids conversion tools and gives you a clean file to work with.
Why does my .qbo file not import correctly?
The most common cause is a mismatch between the account in the file and the account set up in QuickBooks. Make sure you have created the corresponding bank account in your QuickBooks company file before importing.
Is a .qbo file the same as an OFX file?
They are closely related. Both use the OFX standard. QuickBooks uses the .qbo extension specifically for its Web Connect format. Some banks offer .ofx as a separate download option for other software.
Can I open a .qbo file on a Mac?
QuickBooks for Mac also supports Web Connect imports. The general steps are similar: use the import option in the File or banking menu to bring in the .qbo file.
