ocrsnip
No uploads · runs in this tab
ocrsnip
No uploads · runs in this tab
The transactions are already typed into a sheet — by you, by a bookkeeper, or by a bank portal that only exports Excel. QuickBooks Desktop will not take a spreadsheet, so drop the workbook here and take away the .qbo or .ofx it does take. Read on your computer, never uploaded.
| Date | Description | Amount |
|---|
A sheet carries more than its cells, and four of those things decide what you get.
Workbooks collect sheets: a month per tab, a scratch tab, a pivot someone built in March. The first sheet is read and the rest are left alone — and you are told which one that was, rather than left to wonder why the count looks wrong.
Excel keeps a date as a number — 46084 is 2 March 2026 — and shows it through a format. The text on screen is what is read here, so a sheet set to dd/mm/yyyy converts as dd/mm/yyyy. Where a whole file is ambiguous, the control above decides, and every row moves with it.
Headings win when they say something recognisable — date, payee, money out, balance, and the same words in German, Spanish or Russian. Without headings the contents decide: a column of dates is a date column, and two columns of money are debit and credit, not two amounts. Every guess is shown and can be corrected.
A sheet nearly always has room past its content — a stray space in a far cell, blank rows under the totals. Those would otherwise arrive as columns to map and rows to import; they are trimmed before anything is read. Lines without a usable date or amount — opening balances, subtotals, footers — are dropped too.
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 a CSV into QuickBooks Online directly.
One transaction per row and one heading row at the top is all it asks. A date column and either an amount column or a debit/credit pair are the parts it needs; anything else — balance, category, notes — is kept or ignored as you choose. Merged cells, a title above the table and a totals row underneath are all survivable: the headings are found where they actually are, and the totals row has no date to import.
No. A formula cell carries its last calculated value, and that value is what is read — the same figure Excel shows you. A cell showing #REF! or #VALUE! has no figure to read, so that row is dropped rather than imported as zero.
Reading .xlsx needs a library of about 700 KB, and most visitors here convert one file and leave. It is fetched the moment a workbook arrives, not before — so a CSV costs you nothing, and a phone on a slow connection pays only when it has to.
No. The workbook is read and the new file is written inside this browser tab. Open the network panel and watch while you convert: the only request is the spreadsheet library itself, and it comes from this site.