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 — and on any other once you sign in.
The .xlsx carries a second sheet, Warnings: every row whose balance does not follow from the row above, with the balance your statement shows next to the one the arithmetic expects.
Three names for nearly the same file — one document, tag by tag. 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, 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.
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. 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.
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.
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.
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.
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.