ocrsnip
No uploads · runs in this tab
ocrsnip
No uploads · runs 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.
| Date | Description | Amount |
|---|
Three things a CSV never says out loud, and how each one is decided.
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.
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.
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.
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.
Something else? Write to support@ocrsnip.com.
Yes, with no row limit and no account. It is a small tool built on the reader behind the paid converters; the pass exists for turning PDF statements into spreadsheets, which is the part that takes real work.
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.
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).
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.