Skip to content
Convertube

QBO to Excel converter

Convert a QBO (QuickBooks Web Connect) file to Excel in your browser, to review or work on the transactions before or without QuickBooks. Nothing is uploaded.

Runs on your deviceFree, unlimited

Drop files here

or

Accepts .ofx, .qfx, .qbo · Up to 20 files at a time · up to 1.4 GB each "Upload" and "download" here mean your browser reading a file from this device and writing one back to it. Your file is never sent to a server — open your browser's network panel and watch: no request carries your file.

Tested against two open-source readers

Short answer: Opened in Excel, dates are real dates and amounts are numbers: summing a 10,000-row Amount column gave exactly the total of the test file. 85 OFX files from the test suites of six open-source projects — checking, credit-card and brokerage statements, which the projects label as coming from Fidelity, Vanguard, American Express, Nubank and others — were read here and by the Python libraries ofxparse and ofxtools. Where those libraries could read a file, 1,209 of 1,212 fields across 202 transactions came out identical.
What was checkedResult
Files both reference libraries read44 files, 202 transactions: 1,209 of 1,212 fields identical (date, amount, payee, memo, transaction ID, quantity, price)
Files both libraries refused22 files — a missing header, an empty balance, a date or amount they could not parse — all read here, 75 of 76 transactions identical to a plain text search of the file
Synthetic statement with a known answer10,000 transactions, every field exact

The three differing fields are one brokerage file whose trades are stamped 20:20 Eastern time: ofxparse converts that to UTC and moves each trade to the next day, while this page keeps the date the bank wrote. The one difference in the refused files is an amount written $120, read here as 120.00 where the text search keeps the dollar sign. The other 19 of the 85 files hold no transactions at all — balance-only downloads, sign-on replies, and the damaged files libofx keeps to test for crashes — and are reported as such rather than turned into an empty table.

QBO to Excel FAQ

What is a QBO file?

The file banks provide for QuickBooks’ Web Connect import. Like Quicken’s QFX, it is OFX inside — the standard statement format — with an Intuit bank identifier added so QuickBooks knows which bank it came from. It holds the transactions for a date range, not a running ledger, and it is meant for QuickBooks alone.

Why would I want a QBO file in Excel?

To see what you are about to import before QuickBooks matches and categorises it; to hand a client’s transactions to someone who does not use QuickBooks; or to reconcile a period against another source in a spreadsheet. The Excel file is a copy to work with — the QBO itself is untouched and can still be imported.

Why are my credit-card purchases negative?

Because that is how the file signs them. OFX states every amount from the account holder’s side: a purchase on a card reduces what you have, so it is negative, and a payment to the card is positive. The amounts come across with the sign the bank wrote, so the column adds up to the period’s net change.

Can I edit the spreadsheet and turn it back into a QBO?

Not here yet. Writing a QBO that QuickBooks accepts means supplying a bank identifier from Intuit’s list, and a wrong one gets the file refused on import. This page goes in one direction only, and says so rather than producing a file that looks right and fails on import.

Are the dates and amounts real Excel values?

Yes. Dates are Excel dates, displayed 2024-01-31; amounts are numbers with their two decimal places shown. Sort, filter, SUM and pivot tables work without converting anything. On a 10,000-transaction test file, Excel’s SUM of the Amount column matched the file’s total to the cent.

What if the QBO holds several accounts?

Each account gets its own sheet, named after the account type and number in the file. A single-account file gives one sheet called Transactions. Columns no transaction in the file fills are left out, so a card account usually comes out as Date, Payee, Memo, Amount, Type and Transaction ID.

Is the result a XLSX file?

Yes. It is saved as .xlsx, which opens in any program that opens XLSX files.

Is it really free?

Yes — every conversion on this site, with no account, no watermark and no daily cap. The work happens on your own device, so there is no server bill for us to pass on to you.

Do I need to install anything?

No. It runs in any modern browser, on Windows, macOS, Linux, Android and iOS. There is nothing to install and nothing to sign up for, and once you have converted a file on the page it keeps working with the network switched off.

Related guides

Related converters

About QBOAbout Excel