ocrsnip
No uploads · runs in this tab
ocrsnip
No uploads · runs in this tab
The transaction history is one table — and the balance column is filled in once a day, not once a transaction. That detail breaks naive converters quietly, and it is the one this reader was taught to handle.
Ending daily balance is not a balance per row, and the difference matters.
Date, cheque number, description, deposits and credits, withdrawals and debits, ending daily balance. Unlike the sectioned statements of some other banks this really is one chronological list, which makes it one of the friendlier documents to convert.
On a date with four transactions, three lines have an empty balance cell and the fourth carries the day's closing figure. A converter that checks each printed balance against its own line alone will call three days out of four wrong — not because the statement is wrong, but because it asked the wrong question.
Every printed balance is compared with the last printed balance plus everything that happened in between. A day that adds up is confirmed as a whole; a day that does not is highlighted, with the figure the arithmetic expected, so you know which day to look at rather than which line.
The number sits to the left of the description. It is kept with the row rather than dropped, because for anyone reconciling cheques it is the only thing that identifies the payment.
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.
The workbook 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. It says so plainly when there is nothing to check.
Convert the PDF when the PDF is what you have.
In online banking, open the account and choose to download the activity. You get a spreadsheet file or a Quicken/QuickBooks file for the period still held online, with no reading step. For recent months that is the better route and we would rather say so.
The months past the download window, and the statement as the bank issued it — which is what a landlord, a lender or a visa office asks for. Those arrive as PDFs, and this page turns one into a sheet without it leaving your computer.
Statement to QBO builds the .qbo or .ofx directly. If you already have a spreadsheet instead, Excel to QBO does the same from a workbook.
Statements change, and yours may not look like this. Drop it anyway: the reader works from the layout in front of it rather than from a template per bank, and the balance check reports what it actually found.
Something else? Write to support@ocrsnip.com.
Because the statement prints none for them. Inventing one would be worse than leaving it blank: it would look like a fact when it was a guess. The rows are all there, in order, with their own amounts, and the day's closing balance sits on the last of them exactly as on the paper.
Yes, and arguably more than on a statement with a balance on every line. Each printed balance has to match the previous one plus every transaction since, so a whole day is verified at once. If OCR misread one digit inside that day, the day fails and is highlighted.
Yes, and there is a column preset for it. QuickBooks Online and Wave want one signed Amount column; Xero wants its own three-column layout. Both are in the preset list, and dates are written yyyy-mm-dd in every preset, which no import wizard can read backwards.
A statement of up to about forty pages, and several files at once — a year of statements can go in together. Each file keeps its own balance check, and the sheet carries a column naming the file each row came from.