Is 99% OCR accuracy good enough for bank statements?

No, not on its own. A 99% character accuracy still means roughly one wrong digit per hundred, and a busy three-page statement can easily hold 400 to 600 digits in its amounts and balances. That's four to six wrong digits per statement, and you don't know which. What makes OCR safe for bank statements isn't a higher accuracy number; it's checking the result against totals the bank already printed. ZeraBooks does that for every statement before download.

The math people skip

Take a modest business checking statement: 80 transactions, each with an amount and a running balance, plus the summary box.

  • 80 amounts at about 6 digits each: 480 digits
  • 80 balances at about 6 digits each: 480 digits
  • Summary: about 40 digits

That's about 1,000 digits. At 99%, about 10 could be wrong. At 99.9%, about 1.

One wrong digit in the wrong place, a 1 read as a 7 in the thousands, and the month is off by 6,000.

Why the balance check catches it

A statement is a closed system. Opening balance plus every amount equals the closing balance. Each running balance equals the one before plus the row.

So a misread amount doesn't hide. The balance after it stops following, and the difference is exactly the size of the mistake. Find where the running balance first breaks, and you've found the row.

A run where every statement is proven before download

What to ask any OCR tool

  1. Does it check the result against the statement's own balances?
  2. Per account, if a PDF has more than one?
  3. Does it tell you which row broke, or just that something did?
  4. Can you see the original PDF line next to the extracted row?

If the answer to the first one is no, you're the check, row by row.

We built ZeraBooks so the statement checks itself: https://www.zerabooks.com/bank-statement-ocr. I'm the founder, so test it on your own worst statement before believing me.

Comments

Post a Comment

Popular posts from this blog

How to clean up messy books without redoing the same month twice

Image
Clean up books in this order: collect every statement , set opening balances from the last period your accountant signed off, then reconcile each account one month at a time, oldest first . Only once a month ties do you pair transfers, remove duplicates, place uncategorized lines and move owner spending out. A different order means categorizing lines you later delete. A month that doesn't tie, with the gap shown. During a cleanup you stay on that month until the gap is zero. The worked figures below belong to a fictional design studio whose books stopped being kept in February. They are illustrative only. What has to happen before any categorizing? Step 1: Build a statement grid Accounts down the side, months across the top. Tick a cell when you hold that month's statement as a PDF from the bank. Our studio has checking, savings and one card across eight months, so the grid has 24 cells. Any blank cell is a month you can't prove yet, so request it today. Activity...
Read more

How to convert a credit card statement PDF to Excel, step by step

 You need last quarter's card charges in a spreadsheet by Friday, and all you have is three PDFs from the issuer's website. To convert a credit card statement to Excel, download the PDF statement (not the activity export), run it through a converter or copy the tables out by hand, then fix three things: the signs on payments, the foreign currency detail lines, and the summary blocks. Finish by checking that your rows rebuild the printed new balance. Here's each step. Step 1: Download the statement PDF Go to the card's statements page on the issuer's site and download the monthly statement. Many issuers also offer a "download activity" CSV. Skip it for this job. It usually has no previous or new balance printed anywhere, and those two numbers are how you'll prove the spreadsheet is complete at the end. Watch the dates. A card statement ends on a closing date, not the end of the month. If you need the full quarter, you may need the statement after it too...
Read more

How to scan a bank statement so it converts to Excel cleanly

Image
To scan a bank statement so it converts to Excel cleanly, use 300 dpi and grayscale , keep pages straight, save each account's pages into a single PDF , and include the last page even if it looks empty. Then convert it and check that the opening balance plus the rows equals the printed closing balance. Most conversion problems with scanned statements are decided before the conversion starts, at the scanner. Here is how to get it right, step by step. Where a scanned PDF goes in ZeraBooks Convert: the Upload button, or drop the file on the page. Do you need to scan the statement at all? Step 1: Check online banking first Log in and look at the statements section. If the month is there, download the PDF. A downloaded statement carries the bank's own text and will always beat a scan. What scanner settings work best for bank statements? Step 2: Set the scanner Setting Use Why Resolution 300 dpi Lower loses faint digits; higher only makes bigger files Colo...
Read more