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.
Only have a PDF statement? Use the PDF statement converter.
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.
STMTTRN. Checking/savings files are told apart from credit card ones..xlsx."QBO to Excel" is also typed by people who want a report out of QuickBooks Online. Those are different jobs:
| You have | What to do |
|---|---|
A bank-issued .qbo (Web Connect) download | Drop 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 Online | Stay 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 download | Start from the bank statement PDF to Excel converter, which ties every row to the statement balances before you download. |
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 field | Excel CSV column |
|---|---|
| DTPOSTED | Date as YYYY-MM-DD (time of day dropped) so Excel sorts and filters correctly. |
| TRNAMT | Amount as a signed plain number: deposits positive, withdrawals negative. No $ or thousands commas. |
| NAME (MEMO when NAME is empty) | Description; OFX entities such as & become a plain &. |
| LEDGERBAL | Copied onto the last row when the bank ships a usable ledger balance; otherwise left blank. |
| FITID, INTU.BID, BANKID, ACCTID | Omitted — useful for QuickBooks duplicate checks, not for a spreadsheet. |
| Problem | Fix |
|---|---|
| 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> tags | You opened the .qbo. Open the converted .csv (Data → From Text/CSV, comma delimiter). |
| Dates look like text, or day and month swapped | Import with Data → From Text/CSV and set the Date column type. Our dates are year-first (YYYY-MM-DD). |
| Card payments show as charges | Choose 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 empty | Expected when the .QBO has no usable LEDGERBAL. Add a running-balance formula in Excel, or reconcile against the statement. |
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.
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.
No. Files are processed in memory and deleted after 1 hour. We never use your data for AI training.
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.
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.
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.
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.
Yes when the .QBO carries a ledger balance we can use. Otherwise the Balance cells are blank and you reconcile against your statement.
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.
Yes. They are the same format underneath. The OFX / QFX to Excel converter takes .ofx, .qfx and .qbo files alike.
Free converter →
Free converter →
Free converter →
Free converter →
Free converter →
Free converter →