ocrsnip No uploads
CSV → .qbo · .ofx

CSV to QBO, in this tab.

You already have the transactions in a spreadsheet, but QuickBooks Desktop wants a bank file. Drop the CSV and take away a .qbo or .ofx — the columns are read here, on your computer, and nothing is uploaded.

Free, no accountAny column orderBoth date conventions
Drop a CSV of transactions Comma, semicolon or tab. With or without a heading row. Choose file Try a sample CSV stays on this device

What the reader does with your columns

Three things a CSV never says out loud, and how each one is decided.

Which column is which

Headings win when they say something recognisable — date, payee, money out, balance, and the same words in German, Spanish or Russian. When a bank exports without headings, the contents decide: a column of dates is a date column, and two columns of money without headings are debit and credit, not two amounts.

Day first or month first

03/04/2026 is two valid dates and no file says which. A day above twelve settles it by itself; when the whole file is ambiguous, the choice is yours in the control above — and every row changes with it, so you can see the answer rather than guess.

1.234,56 or 1,234.56

The decimal separator is the last one that leaves one or two digits behind it. Parentheses, a trailing minus and DR all mean money out. Nothing is rounded on the way through.

What is thrown away

Lines without a usable date or amount — opening balances, page footers, totals. They are dropped rather than exported as empty transactions your accounts would have to absorb.

Getting the file accepted

Writing the file is the easy half. These four things decide whether your accounting program takes it.

The id QuickBooks checks

QuickBooks Desktop does not just read a .qbo file — it checks the institution id inside it against its own list and refuses anything it does not recognise, even when every transaction is correct. That is the single most common reason a converted file is rejected. Put your bank's id in the field above the download buttons; it is the one piece of information the file cannot invent.

Which program takes which file

QuickBooks Desktop wants .qbo, which is what the first button makes. Quicken expects .qfx and often refuses a plain .ofx holding the same rows — that is the second button. QuickBooks Online accepts .csv, .qbo, .qfx and .ofx on its upload screen, so any of them works there. Xero and GnuCash read the plain .ofx. All three files this page writes are the same document with different branding tags.

Importing the same month twice

Every transaction is written with an id derived from its own date, amount and description, so the same row produces the same id on every run. Programs that use that id — QuickBooks and Quicken among them — recognise what they already have and skip it. Convert the file again after fixing a column and you are correcting an import, not doubling it.

Checking account or credit card

The account type is written into the file so your program files the transactions under the right kind of account rather than guessing. Pick credit line for a card and checking for a current account. Leaving the fields blank still produces a valid file; it just arrives with less to go on.

Questions

Something else? Write to support@ocrsnip.com.

Is this free?

Yes. No row limit, no trial, no account and nothing added to the file. It is a small tool built on the reader behind the paid converters; the $4.99 pass exists for turning PDF statements into spreadsheets, which is the part that takes real work. This page is not a sample of that — it is the whole thing.

QuickBooks refuses the file. What now?

Almost always the institution id. QuickBooks Desktop checks it against its own list and rejects a file it does not recognise, even when the transactions are fine. Put your bank's id in the field above. If you cannot find it, use the .ofx file in another program, or import the CSV into QuickBooks Online directly.

My CSV has one Amount column with plus and minus. Is that alright?

Yes — that is the simplest case. Money out is negative, money in positive, and the file is written accordingly. Separate debit and credit columns work too; so does a single column where money out is written 45.00- or (45.00).

Does QuickBooks Online take a .qbo file?

Yes. On its upload screen QuickBooks Online accepts .csv, .qbo, .qfx and .ofx, so either file this page produces will do. If it still refuses, import the original CSV there instead — Online is far less fussy about the institution id than Desktop is.

Will Quicken take the .ofx?

Often not, and that is why there is a .qfx button beside it. Quicken expects its own extension and the two Intuit tags inside, then checks the institution id against its own list — so fill that field in before downloading, the same way QuickBooks needs it.

If I import the same file twice, do I get duplicates?

Not in a program that uses the transaction id. Each row is written with an id derived from its own contents, so the same transaction carries the same id every time the file is built, and QuickBooks and Quicken skip what they already hold. Fix a column, convert again, and you are correcting the import rather than doubling it.

I have the opposite problem — a .qbo I want as a spreadsheet.

That is the same reader run backwards, and it is free too: QBO to CSV takes the .qbo, .qfx or .ofx your bank gave you and hands back the transactions as columns.

I need it for QuickBooks Desktop, which wants an IIF.

A .qbo is the better route when the account has a bank feed — QuickBooks previews it and the import can be undone. When it has none, or the rows are journal entries rather than a statement, CSV to IIF builds the tab-separated file Desktop imports from the same spreadsheet, and shows what the import will do before you download it.

What I actually have is a Quicken .qif file.

Then skip the spreadsheet step: QIF to QBO reads it directly and writes the same .qbo, .qfx or .ofx, free and with no row limit.

My bank gives me MT940 or CAMT.053, not a CSV.

Then you have a statement rather than a spreadsheet, and it carries balances a CSV does not: MT940 and CAMT.053 to Excel reads both, checks every movement against the opening and closing balance your bank wrote, and hands back .xlsx, .csv or .qbo.

Do you see my transactions?

No. The file is read and the new one is written inside this browser tab. Open the network panel and watch while you convert: nothing is sent.