Free converter · QBO → Excel

Convert a .QBO file to Excel

Convert a QuickBooks Web Connect .QBO bank or card download to a CSV that opens in Excel: Date, Description, Amount and Balance. Free up to 100 transactions.

Free up to 100 rowsColumns detected automaticallyFiles deleted after 1 hour
Processed in memory, never stored
No file handy? See the result on a fictional one first:

Only have a PDF statement? Use the PDF statement converter.

Why Excel?

Excel won't open a .QBO as a spreadsheet. A Web Connect file is OFX tags with Intuit bank IDs, so double-clicking it opens QuickBooks and opening it in Excel shows markup. Utilly reads each transaction and writes a CSV laid out for Excel, the same columns as our .QBO to CSV download.

.QBO import failing with OL-222, OL-221 or "unable to verify the Financial Institution"? See QuickBooks .QBO Web Connect import errors.

How to convert a .QBO file to Excel

  1. Get the Web Connect download. On your bank's site pick QuickBooks Web Connect / QuickBooks (.qbo) and save the file. Opening it by double-click starts a QuickBooks import instead.
  2. Drop it in the upload above. Posted date, signed amount and payee are read from each STMTTRN. Checking/savings files are told apart from credit card ones.
  3. Review the preview. Spending should show as negative. When a bank truncated the payee at 32 characters, switch Description to the Memo column if the full text lives there.
  4. Download the CSV and open it in Excel (File → Open, or double-click). Dates and amounts come through as real dates and numbers. Use File → Save As → Excel Workbook if you want a .xlsx.

.QBO file or QuickBooks Online?

"QBO to Excel" is also typed by people who want a report out of QuickBooks Online. Those are different jobs:

You haveWhat to do
A bank-issued .qbo (Web Connect) downloadDrop it in the upload above. The file holds one account's transactions for QuickBooks import; we turn those rows into a spreadsheet.
A report, register or list already inside QuickBooks OnlineStay in QuickBooks Online. Each report has its own Export control that writes Excel or CSV — Utilly never signs into your company file.
Only a PDF statement, no Web Connect downloadStart from the bank statement PDF to Excel converter, which ties every row to the statement balances before you download.

From .QBO tags to Excel columns

A .qbo is OFX 1.x text plus Intuit's INTU.BID bank ID. One deposit from our sample Web Connect file:

<STMTTRN><TRNTYPE>CREDIT<DTPOSTED>20260901120000<TRNAMT>3184.27
<FITID>202609019B6B1ED70CD300<NAME>STRIPE TRANSFER ST-K2M8Q4</STMTTRN>

lands in the Excel CSV as:

Date,Description,Amount,Balance
2026-09-01,STRIPE TRANSFER ST-K2M8Q4,3184.27,
.QBO fieldExcel CSV column
DTPOSTEDDate as YYYY-MM-DD (time of day dropped) so Excel sorts and filters correctly.
TRNAMTAmount as a signed plain number: deposits positive, withdrawals negative. No $ or thousands commas.
NAME (MEMO when NAME is empty)Description; OFX entities such as &amp; become a plain &.
LEDGERBALCopied onto the last row when the bank ships a usable ledger balance; otherwise left blank.
FITID, INTU.BID, BANKID, ACCTIDOmitted — useful for QuickBooks duplicate checks, not for a spreadsheet.

Which .QBO files work

  • Checking, savings and credit card Web Connect downloads, including .qbo files produced by other converters.
  • Multi-account files: one preview tab and one CSV per account, plus a combined CSV whose first column is Account.
  • Investment / brokerage Web Connect downloads are refused.
  • Free up to 100 transactions per file; hard cap 20,000.

Common problems

ProblemFix
Double-click launches QuickBooks or "unable to verify the Financial Institution"That's an import attempt. Save the .qbo, then upload it here — Utilly never talks to Intuit.
Excel shows raw <STMTTRN> tagsYou opened the .qbo. Open the converted .csv (Data → From Text/CSV, comma delimiter).
Dates look like text, or day and month swappedImport with Data → From Text/CSV and set the Date column type. Our dates are year-first (YYYY-MM-DD).
Card payments show as chargesChoose Credit card as the account type in the preview; tick Flip signs if they are still backwards.
"No transactions found in that OFX/QFX/QBO file"Empty date range, or an investment file. Re-download with a wider range.
Balance column is emptyExpected when the .QBO has no usable LEDGERBAL. Add a running-balance formula in Excel, or reconcile against the statement.

Other conversions

Pricing

Free for files up to 100 transactions, which covers a typical month of activity. Larger files (a year of catch-up, a client's full history) use 1 credit from the same $9 pack of 5 as our PDF statement converter, or unlimited on Pro at $19/month. The preview is always free.

FAQ

Questions

Is it free?

Yes for files up to 100 transactions: no sign-up, no watermark. Bigger files (multi-month catch-up work) use 1 credit from the same $9 / 5-credit pack as our PDF converter, and the preview is always free.

Is my file stored?

No. Files are processed in memory and deleted after 1 hour. We never use your data for AI training.

Can I try it without uploading my own file?

Yes. Click a sample button under the upload box. It opens a made-up export from a fictional bank in the same preview your own file gets, and every format is free to download, so you can test an import in a test or backup company file first. Don't import a sample into your real books.

Do I get an .xlsx file?

You get a CSV laid out for Excel: Date, Description, Amount and Balance, one transaction per row. Excel opens it directly with real dates and numbers; use File → Save As → Excel Workbook to keep it as .xlsx.

I meant exporting from QuickBooks Online to Excel. Is this that?

No. "QBO" also means QuickBooks Online, whose reports and lists export to Excel from the Export button on each report. This page converts a .qbo file, the Web Connect download your bank gives you for importing into QuickBooks.

Does it work with a credit card .QBO?

Yes. Card downloads are detected. Charges and fees come out negative; payments and credits positive. You can also choose Credit card as the account type in the preview.

Will the Balance column be filled in?

Yes when the .QBO carries a ledger balance we can use. Otherwise the Balance cells are blank and you reconcile against your statement.

Are the transaction IDs (FITID) kept?

No. A CSV has no standard column for them, so they are dropped. If you need them to stop duplicates in QuickBooks, import the original .QBO instead of the CSV.

Can I convert an OFX or QFX file the same way?

Yes. They are the same format underneath. The OFX / QFX to Excel converter takes .ofx, .qfx and .qbo files alike.

Other converters

More bookkeeping tools