QBO Converter: QBO File Converter and How to Open QBO Files
No account needed for your first conversions. We never store your bank login.
A QBO file is the format QuickBooks actually wants when you hand it bank data. Get your transactions into that format and they flow into the banking review queue like a native bank feed. Get it wrong and you are back to retyping line items one at a time. This guide covers the whole subject: what the QBO format is, how to open and create QBO files, how a QBO converter turns ordinary bank statements into them, and what to do when an import refuses to cooperate.
If you came here holding a PDF bank statement, the converter at the top of this page does the job directly. Upload the statement and you get back a .qbo file whose transactions are checked against the totals printed on the statement, plus Excel and CSV copies of the same data. Everything below is the reference material.
What is a QBO file?
A QBO file is a QuickBooks Web Connect file: a structured bank transaction file that QuickBooks Online and QuickBooks Desktop import directly into their banking screens. It is built on the OFX banking standard and carries each transaction's date, amount, payee, memo, and check number, plus identifiers that tell QuickBooks which bank and account the data belongs to.
Two of those identifiers do most of the work. Each transaction has a unique ID (the FITID) that QuickBooks uses to skip duplicates, so importing overlapping date ranges does not double up your register. And the file names its financial institution, which is how QuickBooks knows which account to offer during import without making you map columns the way a CSV upload does.
| What the file carries | What QuickBooks does with it |
|---|---|
| Date and amount | Places the transaction in the register |
| Payee / description | Shows it as the downloaded description, used for matching rules |
| Memo | Kept as the bank memo on the transaction |
| Check number | Matched against checks you entered manually |
| Unique transaction ID (FITID) | Deduplicates across imports |
| Bank and account identifiers | Routes the file to the right account, no column mapping |
One naming trap: the .qbo extension does not stand for QuickBooks Online. Intuit uses QBO as shorthand for its online product, and separately as the extension for Web Connect files, which work in both Online and Desktop. When a bank or a converter offers a "QBO download," it means the Web Connect file.
How to open a QBO file
You open a QBO file by importing it into QuickBooks, not by double-clicking it. In QuickBooks Desktop the import lives under File, then Utilities, then Import, then Web Connect Files. In QuickBooks Online you upload it from the Bank transactions screen. Outside QuickBooks, the file opens in any text editor, because it is plain text underneath, but it will not look like a spreadsheet.
How to open QBO file in QuickBooks Desktop
- Open your company file in QuickBooks Desktop (Pro, Premier, Enterprise, or Mac).
- Go to File > Utilities > Import > Web Connect Files.
- Select the .qbo file, then choose whether the transactions belong to an existing account or a new one.
- Review the results in the Bank Feeds Center and add them to your register.
Desktop is fussier than Online about Web Connect files. Intuit only supports bank imports in Desktop versions from roughly the last three years, so a retired 2019 install will reject a perfectly valid file.
How to open QBO file in QuickBooks Online
- Go to Transactions, then Bank transactions.
- Click the dropdown next to Link account and choose Upload from file.
- Select the .qbo file and pick the bank or credit card account it belongs to.
- The transactions land in the For review tab, ready to categorize and match.
The full walkthrough, including what to do in the review queue afterward, is in our guide to importing bank statements into QuickBooks Online.
How to open QBO file without QuickBooks
A QBO file is plain text, so Notepad, TextEdit, or any code editor will open it. What you will see is OFX markup: angle-bracket tags wrapping each transaction's date, amount, and description. It is readable enough to spot-check a few transactions or confirm a date range, but nobody should audit a statement that way. If you need the data in readable rows and columns and you still have the original statement, convert the statement itself to a spreadsheet instead of fighting the QBO file.
How to open QBO file in Excel
Excel does not parse QBO files natively. If you open one in Excel you get the raw OFX tags dumped into cells, not a transaction table, because Excel has no importer for the format. The practical route to a spreadsheet is covered below under converting QBO to Excel, and the short version is: go back to the source statement when you can.
How to convert to QBO
To convert a bank statement to QBO, upload the statement to a converter that outputs QuickBooks Web Connect files, verify the extracted transactions against the statement totals, and download the .qbo file. With the converter on this page that takes about a minute per statement, and it accepts digital PDFs, scans, photos, and password-protected files.
- Upload the statement at the top of this page. Several statements at once is fine.
- Let the extraction run. Every transaction line is read along with the statement's own opening balance, closing balance, and totals.
- Check the reconciliation. The extracted transactions are summed and compared against the totals printed on the statement, so a misread digit shows up now instead of during month-end reconciliation.
- Download the .qbo file and import it using the steps above. Excel and CSV copies come with it.
For a deeper look at that workflow, including scanned statements and bulk catch-up projects, see the PDF to QBO converter guide.
How to download a QBO file from your bank
Many US banks will generate a QBO file for you. Look in online banking for an export or download option on the account activity page, then pick the QuickBooks or Web Connect format from the file type list. Chase, Bank of America, Wells Fargo, and most regional banks offer some version of this.
The catch is history. Banks typically limit those downloads to recent activity, often somewhere between 90 days and 18 months depending on the institution, and closed accounts usually lose the option entirely. That is exactly where a QBO converter earns its keep: the months your bank will no longer export still exist as PDF statements, and converting those PDFs is the only way to get them into QuickBooks without retyping. Catch-up bookkeeping, prior-year cleanups, and tax reconstruction work all live in that gap.
Three ways to get bank data into QuickBooks, compared
| Live bank feed | Bank QBO download | Converting statements | |
|---|---|---|---|
| Recent transactions | Yes, automatic | Yes | Yes |
| Months beyond the bank's export window | No | No | Yes, any statement you have |
| Closed accounts | No | Rarely | Yes |
| Banks without QuickBooks support | No | No | Yes |
| Effort per month of data | None once linked | A few clicks | About a minute per statement |
In practice the three are complements, not rivals. Feeds handle the future, bank downloads patch the recent past, and a converter covers everything older. Bookkeeping firms doing client onboarding tend to lean on the third, which is why our use cases skew toward bookkeepers, accountants, and tax preparers working through backlogs.
Convert QBO file to Excel
There are two honest routes from a QBO file to a spreadsheet. First: import the QBO file into QuickBooks, then export the transactions or a report to Excel from there. Second, and usually faster: if you still have the original bank statement, skip the QBO file entirely and convert the statement straight to Excel. The converter on this page produces XLSX and CSV alongside every .qbo file, so one upload covers the QuickBooks import and the workpaper copy at the same time.
QBO file to PDF
There is no meaningful QBO-to-PDF conversion, because the PDF you actually want is the bank statement itself, and you usually already have it. If you need a printable record of what was imported, run a transaction report in QuickBooks for the relevant account and date range and save that as PDF.
Troubleshooting QBO file imports
QuickBooks Desktop rejects the file or cannot verify the financial institution. Desktop validates the bank identifiers inside the file. A file from an unsupported source, a corrupted download, or a QuickBooks version more than about three years old will all trigger this. Re-download the file, confirm your Desktop version is current enough for bank feeds, and if the file came from a converter, make sure it produces genuine Web Connect output rather than renamed OFX.
Transactions are missing after import. QuickBooks silently skips transactions whose unique IDs it has already seen. That is the duplicate protection doing its job, and it usually means part of the date range was imported earlier. Check the register before assuming the file is bad.
A huge file stalls in Desktop. Web Connect imports handle months comfortably but can choke on years. Split long histories into quarterly files and import them in order. Statement-by-statement conversion gives QuickBooks clean monthly boundaries to deduplicate against, which is the tidier approach for big catch-up projects anyway.
Frequently asked questions
What is a QBO file in QuickBooks?
In QuickBooks, a QBO file is a Web Connect bank file: the format QuickBooks reads to pull bank and credit card transactions into its banking screens. It contains transaction details plus bank identifiers, imports into both QuickBooks Online and Desktop, and is the format banks mean when they offer a QuickBooks download.
Is a QBO file the same as QuickBooks Online?
No. The .qbo file extension and the QuickBooks Online product share an abbreviation and nothing else. The file format predates the cloud product and works with QuickBooks Desktop just as well. When someone says "send me the QBO," they almost always mean the Web Connect file, not access to a QuickBooks Online company.
Can Quicken open a QBO file?
No. Quicken uses its own variant of the same underlying standard, the QFX file, and each product validates its own branding inside the file. A QBO file will not import into Quicken and a QFX file will not import into QuickBooks, even though the transaction data inside them looks nearly identical.
How do I create a QBO file?
Either download one from your bank's online banking export menu, if your bank offers the QuickBooks format and the dates you need are recent enough, or convert a bank statement with a QBO converter. For anything older than your bank's export window, converting the PDF statement is the only route that does not involve manual entry.
How do I send a QBO file to my accountant?
A QBO file is a small text file, so any file transfer works mechanically. Treat it like the bank data it is, though: use your firm's secure portal or an encrypted share rather than plain email. Many accountants prefer to receive the original statements and run the conversion themselves so they control the reconciliation check.
Convert your first statement to QBO
The fastest way to judge any QBO converter is to feed it a real statement and compare the output against the paper. Upload one at the top of this page, check the reconciliation summary, and import the .qbo file into QuickBooks. If you are clearing a backlog every month, plans scale by page volume, and the same upload works whether you convert bank statements to QuickBooks Online or Desktop.