ocrsnip No uploads
Bank statement → .qbo · .ofx

PDF bank statement to QBO, without uploading it anywhere.

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.

Text & scanned PDFsReconciled row by rowFirst 25 rows free
Drop a bank statement PDF here One file or a whole year at once. Text or scanned, opened in this tab — nothing is uploaded. Choose file Try a sample PDF · Try a scanned one PDF · up to 40 pages · stays on this device
After you drop a file

Read, then checked, then yours

QBO, OFX, QFX — which one do you want?

Three names for nearly the same file — one document, tag by tag. The difference is who is meant to open it.

.ofx

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.

.qbo

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.

.qfx

Quicken's variant of the same thing, and the button next to the others makes it. Quicken checks the extension before it checks the contents and often refuses a plain .ofx holding exactly these rows, so the name is the capability.

.csv / .xlsx

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.

Getting it into QuickBooks

Four steps, and what usually goes wrong

  1. Fill in the account details

    Routing number and account number are printed on the statement. They tell QuickBooks which account these transactions belong to.

  2. Find your bank's id

    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.

  3. Import the file

    File → Utilities → Import → Web Connect Files, then pick the account. QuickBooks shows the transactions for review before anything is recorded.

  4. Check the highlighted rows first

    Rows that failed the balance check on this page are the ones worth comparing with the PDF. Everything else was verified by arithmetic.

Questions

Something else? Write to support@ocrsnip.com.

QuickBooks says the file cannot be imported. Why?

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.

Does QuickBooks Online take a .qbo file?

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.

Will importing the same statement twice duplicate everything?

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.

My statement is a scan. Does that work?

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. The scan is read in English unless you pick another language in the drop zone — eleven are available, and changing it reads the same file again on the spot.

My bank offers MT940 or CAMT.053 as well as PDF. Which should I use?

The machine-readable one, every time: a PDF has to be read off the page, while MT940 and CAMT.053 state the amounts exactly and carry an opening and a closing balance to check them against. MT940 and CAMT.053 to Excel is the page for those, and it produces the same .qbo this one does.

My bank sends the statement with a password. Does that work?

Yes. Drop the locked PDF and the page asks for the password, the way your PDF reader would. It is used in this tab to open the file and then forgotten: it is not sent anywhere, not saved in the browser, and never written into the spreadsheet. A year of statements locked with the same password is asked once, not twelve times — and if you would rather not type it, skipping the file leaves everything else intact.

Is the file really built here?

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.

What is free and what needs the pass?

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.

Written up bank by bank

The reader is the same on every page. What differs is the document: five of the statements people drop here most often, and what each one does to the balance check.