ocrsnip No uploads
.qbo · .ofx · .qfx → CSV

QBO to CSV, in this tab.

Your bank gave you a file built for accounting software, and you wanted a spreadsheet. Drop the .qbo, .ofx or .qfx and take the transactions as CSV — read here, on your computer, and never uploaded.

Free, no accountBoth OFX dialectsDates as YYYY-MM-DD
Drop a .qbo, .ofx or .qfx file The file your bank offers as “Web Connect” or “download for Quicken”. Choose file Try a sample .qbo stays on this device

Why your spreadsheet will not open it

It is a document of tagged text, not a table — and that is before the name confuses anyone.

A .qbo is not a QuickBooks file

It is a Web Connect download: a statement your bank wrote for accounting software to import. QuickBooks keeps its own books in .qbw and .qbb files, which hold a whole company rather than a list of transactions and are not what this page reads. The extension and the product share three letters and nothing else.

Excel gives you a column of tags

Open the file as it is and every line arrives in column A as <STMTTRN> and <TRNAMT>, because there are no commas to split on. Renaming it .csv changes nothing — the tags are still there. Something has to read the tags and lay the fields out in columns, which is what happens above.

Three extensions, two dialects

.qbo, .qfx and plain .ofx are the same document with a couple of branding tags between them, and each exists in two dialects: OFX 1.x is SGML whose tags are never closed, OFX 2.x is ordinary XML (a real file, tag by tag). All of it reads the same here. A strict XML parser fails on exactly the files banks hand out most often, so this page does not use one.

A brokerage file is a different animal

Investment OFX records trades, positions and income in blocks of its own and carries no bank transactions at all. It opens here and gives nothing back. If the page says the file holds no transactions, that is usually why.

What comes out

Six columns, and the one place a spreadsheet can still spoil them.

The columns, in this order

Date, Description, Amount, Type, Cheque, Id. Type is the word the file itself used — DEBIT, CREDIT, CHECK, XFER, POS — and Id is the transaction id the bank issued. Nothing is added, renamed or reordered on the way through, and rows come out oldest first whatever order the file wrote them in.

One signed amount

Money out is negative and money in positive, in a single Amount column, exactly as the file has it. The column sums to the net movement and a pivot by month needs no second step. There is no balance column, because a running balance is not in the file: it states a closing figure once, and a column repeating that on every row would look like a balance without being one. When you need balances to check against, the PDF statement is where they live.

Payee and memo in one column

The file keeps two description fields and a spreadsheet has one. When both are present and say different things they are joined with an em dash, so nothing the bank wrote is quietly dropped on the way into a single cell.

The id, and what Excel does to it

A transaction id is often a long run of digits, and Excel opening a CSV by double-click turns that into 1.2E+15 and keeps the rounded number. Import it instead with Data → From Text/CSV and set the Id column to Text, or take the same file as a workbook, where the id is already text and any zeros in front of it survive.

Questions

Something else? Write to support@ocrsnip.com.

Is this free?

Yes. No row limit, no trial, no account, and nothing is added to the file. The $4.99 pass on this site is for reading PDF statements, which is the part that takes real work; this page is not a sample of it.

Where do I get this file from my bank?

In the account's download menu it usually sits next to the CSV option, called Web Connect, “download for Quicken”, or simply QFX. Banks differ in how far back they will export, but what they hand out is this same document whichever of the three extensions they put on the end of it.

Does the CSV hold the account number or the balance?

No. The institution, account number, type and currency belong to the statement rather than to any one transaction, so they are shown above the table and not repeated down a column; the closing figure is read from the file and left out for the same reason. Copy what you need from the line above the table.

The file was read but no transactions came out.

Two things do that. An investment or brokerage OFX holds trades rather than bank transactions, and there is nothing here to list. Or the statement really is empty — open the file in any text editor and search for STMTTRN; no such tag means no transactions in it.

Can I go the other way, from a spreadsheet to a .qbo?

Yes, and it is free as well: CSV to QBO writes the file QuickBooks and Quicken import, and Excel to QBO does the same from a workbook. Sending a file out through one page and back through the other is also a reasonable way to correct one bad field.

Can I get it as .xlsx instead?

Yes — QBO to Excel is the same reader with a workbook at the end, where amounts are numbers that sum and a transaction id keeps its leading zeros. This page stays CSV-only so that a visitor who wants a comma-separated file never downloads a spreadsheet library to get one.

I do not want a spreadsheet — I want QuickBooks to accept the file.

Different page, same reader: OFX to QBO takes the .ofx or .qfx and writes it back out as the .qbo QuickBooks Desktop will open, with the bank id it checks for before reading a single row. The transactions and their ids are untouched.

Does the file leave my computer?

No. It is read in this tab and the CSV is written here too. The network panel stays empty while you convert.