ocrsnip
No uploads · runs in this tab
ocrsnip
No uploads · runs in this tab
QuickBooks, Quicken and most accounting programs import a bank file directly — no column mapping, no import wizard guessing which column is the amount. Drop the PDF your bank gave you and take the .qbo or .ofx away.
No column headings were found, so the columns were identified from the running balance alone. Check a few rows before you rely on it.
| Date | Description | Debit | Credit | Balance |
|---|
They are already read and checked in this tab. A pass unlocks every row of every file you convert over the next 7 days, in this browser.
Three names for nearly the same file. The difference is who is meant to open it.
The open format, and the safe default. Quicken, GnuCash, Xero, MoneyWiz and most banks' own import read it. If you are not sure, take this one.
The same document with two tags QuickBooks Desktop looks for: the id of your financial institution and a user id. Web Connect refuses a file whose institution id it does not recognise, which is why the field is yours to fill in.
Quicken's variant of the same thing. We do not produce it: Quicken opens plain .ofx, so a third file would add a name without adding a capability.
For your own spreadsheet, or for QuickBooks Online and Xero, which import CSV and ask you to map the columns. The presets above put the columns in the order each one expects.
Routing number and account number are printed on the statement. They tell QuickBooks which account these transactions belong to.
QuickBooks Desktop matches the institution id in the file against its own list. Your bank's number appears in QuickBooks when you set up Web Connect for that account, or in the file your bank itself exports.
File → Utilities → Import → Web Connect Files, then pick the account. QuickBooks shows the transactions for review before anything is recorded.
Rows that failed the balance check on this page are the ones worth comparing with the PDF. Everything else was verified by arithmetic.
Something else? Write to support@ocrsnip.com.
Almost always the institution id. QuickBooks Desktop checks the id in the file against its own list of banks and refuses anything it does not recognise, even though the transactions inside are perfectly valid. Put your bank's id in the field above and import again. If you cannot find it, import the .ofx into a different program, or use the CSV route through QuickBooks Online.
QuickBooks Online prefers CSV: Banking → Link account → Upload from file. Use the QuickBooks · Wave preset above, which gives it the three columns it expects with money out as a negative number. The .qbo route is for QuickBooks Desktop and its Web Connect import.
No. Every transaction carries an id derived from the row itself — same date, same amount, same description, same id — so a program that has seen it before recognises it. That is what the id field in an OFX file is for.
Yes. A scan goes through OCR in this tab first and then through the same reader. OCR can misread a digit; when it does, the row fails the balance check and is highlighted, so a wrong figure does not quietly reach your books.
Yes — OFX is text, and it is written in this tab from the rows you can see on screen. Open your browser's network panel and watch: converting and downloading add no requests at all.
Reading, checking and viewing every row is free, and so is exporting the first 25 rows in any format. A $4.99 pass unlocks every row of every file for 7 days — one payment, no subscription, no account.