How do I open a QBO file without QuickBooks?

A .qbo file is plain text, so a text editor opens it, but what you see is a column of tags such as and rather than a table. Dropping it here reads those tags into rows you can search and save as CSV.

How do I convert a QBO file to Excel?

Open it here and choose “Download all rows as CSV”. Excel opens the CSV directly. Pick the date style that matches your Excel's locale first, so 03/04 is read as the day you meant.

What is the difference between QBO, QFX, and OFX?

OFX is the open format banks use for statement downloads. QBO is OFX with an Intuit institution id added so QuickBooks accepts it, and QFX is the same for Quicken. The transactions inside are written identically, which is why one viewer reads all three.

Why are some amounts negative?

OFX signs amounts from the account holder's side: money out is negative, money in is positive, on a credit card as well as a bank account. The CSV keeps those signs, so a sum of the amount column is the net change.

The viewer shows fewer transactions than I expected.

A file only holds the date range it was downloaded for, so check the period shown above the table. If transactions were left out because a date or amount could not be read, the viewer says how many and which.

Can I edit the file here?

Not the transactions. To change the header fields QuickBooks refuses, such as the institution id or account number, use the QBO Bank ID Fixer, which rewrites those and leaves the transactions alone.

Bankflow

Free tool

Open a QBO file without QuickBooks.

Open a .qbo, .qfx, .ofx, or .qif file as a table and save it as CSV.

Drop the file you want to openor browse a file from your device.qbo.qfx.ofx.qifUp to 20 MB per file · One file at a time

Read in your browser. Never uploaded.

What you see, and what you can take away

Every transaction, as a table

Date, payee, memo, transaction type, the bank's transaction id, and the signed amount, in the order the file lists them or sorted by date.

The account the file describes

Whether it is a bank account or a credit card, the account number, the period the file declares, its currency, and the closing balance the bank wrote into it, when it wrote one.

Totals you can check

Money in, money out, and the net, summed to the cent. Search narrows the table and the totals together, so “how much went to AWS” is one query.

A CSV that opens anywhere

Download every row, or only the rows your search matched, with dates written year first, month first, or day first so a spreadsheet in your locale reads them correctly.

Four formats, one reader

QBO and QFX are the OFX format with Intuit's header added, so all three read the same way, in both the old SGML dialect and the newer XML one. QIF, Quicken's older line-by-line format, is read too.

Nothing leaves the page

The file is read by your browser and never uploaded. That matters for a file holding a year of someone's bank activity.

Questions

How do I open a QBO file without QuickBooks?: A .qbo file is plain text, so a text editor opens it, but what you see is a column of tags such as <TRNAMT> and <DTPOSTED> rather than a table. Dropping it here reads those tags into rows you can search and save as CSV.
How do I convert a QBO file to Excel?: Open it here and choose “Download all rows as CSV”. Excel opens the CSV directly. Pick the date style that matches your Excel's locale first, so 03/04 is read as the day you meant.
What is the difference between QBO, QFX, and OFX?: OFX is the open format banks use for statement downloads. QBO is OFX with an Intuit institution id added so QuickBooks accepts it, and QFX is the same for Quicken. The transactions inside are written identically, which is why one viewer reads all three.
Why are some amounts negative?: OFX signs amounts from the account holder's side: money out is negative, money in is positive, on a credit card as well as a bank account. The CSV keeps those signs, so a sum of the amount column is the net change.
The viewer shows fewer transactions than I expected.: A file only holds the date range it was downloaded for, so check the period shown above the table. If transactions were left out because a date or amount could not be read, the viewer says how many and which.
Can I edit the file here?: Not the transactions. To change the header fields QuickBooks refuses, such as the institution id or account number, use the QBO Bank ID Fixer, which rewrites those and leaves the transactions alone.

More free tools

All free tools

Only have the PDF?

Bankflow reads a statement PDF into transactions, reconciles them against the balances printed on it, and exports CSV, Excel, QBO, QFX, OFX, or QIF.

Convert a statement free Statement to CSV

50 free page credits · No card