Tested on, and what changed
Every release runs the same tests before it goes live. We never use real customer statements, and we never receive yours. Two kinds of test files: sample statements published by banks and public bodies, and synthetic statements we build in each bank's layout.
Sample statements published by banks and public bodies
Fictional data, downloaded on November 21 and 22, 2026 from each publisher's own website. Some are illustrations whose numbers don't add up; there the right answer is "does not balance", never "balanced".
What this proves, in numbers. 35 public PDFs from 28 publishers (20 of them banks, credit unions or finance companies). 16 are real statements with a table: the converter reads the rows of 13 of them correctly; 8 balance (7 to the cent, 1 with one limit) and the rest are flagged, never called balanced. The other 19 are guides, brochures, credit cards, an investment report and PDFs made of images: no rows, or refused. What it does not prove: that your bank's statement will convert. We have not tested statements from Citi, U.S. Bank or Capital One (no official sample found), PDFs made of images (scans and photos) are read only by an experimental OCR that we measured on five sample pages (see below), and no file has been tested with a phone photo, and no file has been imported into QuickBooks or Xero.
| Published by | What the converter said |
|---|---|
| Wells Fargo sample statement on wellsfargo.com (older layout) | Balanced to the cent · 22 rows |
| TD Bank sample checking statement in TD Bank Financial Education, Grades 9-12 Lesson 2 (td.com) | Balanced to the cent · 12 rows |
| Centris Federal Credit Union statement guide on centrisfcu.org | Balanced to the cent · 6 rows, 6 row balances checked |
| FDIC Money Smart sample checking statement (ct.gov copy) | Consistent, with one limit: 3 rows add up to the last balance printed on the rows, but the PDF has no closing-balance line, so a missing last row would not show |
| MSGCU credit union statement guide on msgcu.org | Does not balance: off by $0.04. Found that the guide's own printed balance on row 2 is 26 cents off (1,385.26 − 100.00 = 1,285.26, printed 1,285.00) |
| City of Saint Paul bank statement handout on stpaul.gov | Does not balance: off by $25.15. One amount is drawn on the wrong line of the graphic; the tool says so instead of guessing |
| Bank of America "How to read your statement" mock-up | Not verified: several layouts printed on top of each other with placeholder amounts. Never called balanced |
| Chase paperless statement sample (credit card) | Recognised as a credit card statement: out of scope, the tool says so |
| Five-Star Bank e-statement sample, Premier Checking (five-starbank.com) | Does not balance: off by $171.61. The bank prints only the first page of five: all 22 row balances chain correctly, but the closing balance comes later. Flagged, not guessed |
| Huntington National Bank sample checking statement (web.archive.org copy; the live link answers 403) | Does not balance: a one-page excerpt with a SAMPLE overlay printed over the amounts and 3 credits shown. The tool flags it and does not guess |
| Lincoln Savings Bank sample deposit statement (mylsb.com) | Does not balance: the sample shows 2 of its 10 rows. Both rows chain to the printed balances; the tool says the totals do not add up |
| Mammoth (software vendor) "Example Community Bank" sample statement, test data (mammoth.io; not a bank) | Balanced to the cent · 48 rows, 48 row balances checked |
| Universität zu Köln German "Muster Bank" statement example, decimal comma (uni-koeln.de; not a bank) | Balanced to the cent · 13 rows |
| ING-DiBa (Germany) sample Extra-Konto statement 2025, decimal comma (ing.de) | Balanced to the cent · 17 rows |
| University of Exeter example UK bank statement for visa applications, pounds (exeter.ac.uk; not a bank) | Not verified: 7 rows read, but the example prints no opening or closing balance, so nothing can be proven. Never called balanced |
| Royal Bank of Canada sample chequing eStatement, 2004 layout (rbcroyalbank.com) | Does not balance: off by $118.57. The sample prints page 1 of 2: all 5 row balances chain to the cent, and the closing balance needs the rows of page 2. Flagged, not guessed |
| Scott Credit Union statement guide on scu.org | Does not balance: off by $1,506.50. The guide's own figures do not add up (anonymised numbers); the tool says so instead of guessing |
| WCCU Credit Union statement guide on wccu.coop | Balanced to the cent · 2 rows, 2 row balances checked |
The home page counts the 15 files above that have a transaction table (7 balance to the cent, 1 is consistent with one limit, 7 are flagged). Left out of that count: the Bank of America mock-up (placeholder amounts, never called balanced) and the Chase credit card sample (recognised and refused). More public files are not in the table because they have no transaction table or are out of scope (credit cards, an investment report): the tool reports them as "no transactions found" or refuses them.
Synthetic statements, v0.3.6 (2026-11-22)
| Statement layout | Rows | Result | Test |
|---|---|---|---|
| Bank of America layout (sections, checks, daily balances skipped) | 40 | Balanced to the cent | Pass |
| chain-1-aug | 30 | Balanced to the cent | Pass |
| chain-2-sep | 30 | Balanced to the cent | Pass |
| chain-3-oct | 30 | Balanced to the cent | Pass |
| Chase layout with one row removed (must be caught) | 45 | Does not balance, row 18 found | Pass |
| Chase layout, every word placed separately | 46 | Balanced to the cent | Pass |
| Chase layout | 46 | Balanced to the cent | Pass |
| Citi-style layout, our own, modelled on descriptions (no official sample found) | 40 | Balanced to the cent | Pass |
| Sample with one row deleted (must be caught) | 29 | Does not balance, row 12 found | Pass |
| Sample statement on this site | 30 | Balanced to the cent | Pass |
| TD Bank layout (daily account activity sections, checks paid, subtotals) | 38 | Balanced to the cent | Pass |
| UK layout (date once per day, paid out / paid in, brought forward) | 38 | Balanced to the cent | Pass |
| U.S. Bank-style layout, our own, modelled on descriptions (no official sample found) | 36 | Balanced to the cent | Pass |
| Wells Fargo layout, every word placed separately | 20 | Balanced to the cent | Pass |
| Wells Fargo layout (columns, daily balance, Dec to Jan) | 20 | Balanced to the cent | Pass |
Damage test: never a false "balanced"
Before each release we damage every file that balances, one change at a time (delete a row, change an amount by one cent, flip a sign) and require the verdict to be anything but "balanced". Last run: 21 files, 1314 damaged variants, 0 called balanced by mistake; 139 flipped signs were read back to the true value from the section or the printed balance. The test is dev/mutation.mjs.
What a balance check cannot see: two errors that cancel each other out, for example two amounts swapped between rows, add up to the same totals. When your bank prints a balance on every row (Chase, Bank of America, Wells Fargo, TD Bank and many others), every row is checked as well, and that catches a swap; when it does not, the sum check is all there is. The damage test covers a dropped row, a one-cent change and a flipped sign; it does not cover everything that can go wrong in a PDF.
Several months: dev/test-chain.mjs checks three consecutive months in any order (chain complete), a missing month (two balances that do not meet, 30-day gap named), a statement that does not follow, the same statement twice, and a month that does not balance on its own. The Chain proof workbook was recalculated in Microsoft Excel for Windows and in Google Sheets.
Also checked on every release: the Excel file opens in Microsoft Excel for Windows and the Proof tab recalculates (Google Sheets: checked on 2026-11-21, Excel for the web: not tested yet); the page converts with the network switched off; no file name, amount or description is ever sent with the anonymous usage events.
Changelog
v0.3.6 · 2026-11-22 New: OCR for scans and photos, experimental. When a PDF is a picture of a statement, a button offers to read it with OCR (Tesseract.js, Apache-2.0) on your device: nothing is uploaded; the reading engine (about 15 MB) is loaded from this site only when you click. The result is labelled "Read with OCR: check the rows", also on the Proof tab of the Excel file, and OFX, QuickBooks and Xero files are not offered for it. The balance proof still only says "balanced" when the numbers OCR returned add up. Measured on 15 synthetic scans made from one page of each of five public sample statements (dev/test-ocr.mjs): clean 200 dpi scans, 70 of 96 rows right (72.9%); ordinary office scans (slight skew, light noise), 65 of 96 rows right (67.7%); poor phone-style scans (150 dpi, blur, noise, heavy compression), 3 of 96 rows right (3.1%). Two of the five pages (a 2002 sample with a SAMPLE watermark and a small-print UK example whose decimal points are lost) were not read correctly at any quality; the verdicts there were "not verified" or "does not balance", never "balanced". Not tested: real phone photos, other languages, pages with several columns of text, scans in colour.
v0.3.5 · 2026-11-22 Fixed: when a line of text sits between two amounts, it is now given to the row it belongs to when the lower row starts like the end of a phrase ("Fee Assessed" + "By Non-TD Bank" in the TD Bank sample had been swapped between two rows; amounts, dates and the balance check were already right). The support address, support@getsheetproof.com, is now on every page. All 35 public sample files are now in the automatic tests, not only the first 23. Still not supported: PDFs made of images (scans and photos), credit cards, and investment reports. Still not tested: statements from Citi, U.S. Bank and Capital One (no official sample found) and any bank outside the files listed above.
v0.3.4 · 2026-11-22 Reads more layouts, found by running the converter on public sample statements (35 files in all from 28 publishers: banks, credit unions, universities and public bodies; fictional data): column headings with units such as "Withdrawals ($)" and "In (£) / Out (£)", several rows under one date, amounts printed as ".15", dates like "July 20th", a period printed with two-digit years ("12/25/10 to 01/25/11"), and amounts with a decimal comma and a trailing + or − ("1.207,86", "90,00 +"), the last tested on two German specimens only (ING-DiBa and a university "Muster Bank" example): we make no claim about German or other European banks in general. An investment (brokerage) report is recognised and refused, like a credit card. Fixed: a period line such as "12/25/10 to 01/25/11 Credits" no longer counts as a transaction. The damage test now covers the new files (1,314 damaged variants of 21 files, none called balanced).
v0.3.3 · 2026-11-22 New download: CSV for Xero, offered like the OFX only when the statement balances to the cent. Columns follow Xero Central’s page on importing a CSV bank statement: Date (YYYY/MM/DD, one of the formats Xero lists and the one that cannot be read two ways), Amount (money out negative, no thousands separator), Description and Cheque number; no opening or closing balance column and no account number, which Xero says to remove. We have not imported it into Xero: there is no test of Xero itself yet, only a check of the file against the published instructions.
v0.3.2 · 2026-11-21 Real import test in GnuCash 5.17 (a free accounting program; not QuickBooks, not Xero): the OFX of three public samples and of one synthetic statement with awkward descriptions, and the QuickBooks-layout CSV of two of them, were imported and read back from the saved book; rows, dates, signs and final balance matched to the cent, and re-importing the Wells Fargo sample added nothing. Found and fixed: accented letters in an OFX or QuickBooks CSV description were turned into "?" (now "Cafe Creme"; curly quotes and dashes become plain ones). Scripts with no ASCII form (Cyrillic, Greek, Chinese, emoji) still show as ?, because OFX 1.x and the QuickBooks CSV are ASCII only (the Xero CSV is ASCII too, to be safe: Xero Central does not say which file encoding it reads). Not tested: QuickBooks, Xero, Excel for Mac and for the web.
v0.3.2 · 2026-11-21 New in the Excel file: dates as yyyy-mm-dd (they no longer change meaning with the language of your Excel), and two extra columns, Money in and Money out, as live formulas on the signed Amount. New download: OFX for accounting software, only for statements that balance to the cent and have their own closing-balance line; re-read by two open-source OFX parsers on every release. Fixes from an independent review: rows printed as "number, date, amount" under a Deposits heading are now read as money in (they were read as checks); a credit card statement with transactions is refused instead of being checked like an account (two different signals needed: minimum payment due, payment due date, credit limit; a PDF with Beginning / Ending balance labels is read as an account); the opening and closing balance are the amounts next to their labels, not the last amount on the line; dot leaders, split labels and asterisk headings are read (TD Bank sample). Three more public samples (Five-Star Bank, Huntington National Bank, Lincoln Savings Bank): all are cut-off excerpts or have text over the amounts, and the tool says they do not balance. The contact form has no email field and we do not reply individually.
v0.3.1 · 2026-11-21 Several months at once (up to 12 PDFs): one workbook with a Chain proof sheet, and the same check on screen. A PDF without a closing-balance line is now reported as "consistent, with one limit", in the page and in the file. TD Bank layout (also tested on the sample TD publishes), U.S. Bank and Citi on the generic reader (no official sample found), bank detected from the statement header, honest verdict when a PDF has no closing-balance line, support form, guides, 5 more bank pages, damage test.
v0.2.0 · 2026-11-21 Reads layouts found in public sample statements: amounts like $-9.00, notes printed in the margin next to the table, amounts on the last line of a wrapped description, checks printed two or three per line, several accounts in one PDF (the first account is converted, and the page says so), "Balance on" summaries, and statements whose closing balance is the last balance printed on the rows. Credit card statements are recognised and explained. New look, Excel file in the SheetProof style, sample with a missing row.
v0.1.0 · 2026-11-21 First version. Readers for Chase, Bank of America and Wells Fargo layouts, generic reader for other banks, Proof tab with live formulas, row-by-row check where the bank prints balances, CSV export, password-protected PDFs.
Who makes this
SheetProof is a small independent studio that makes spreadsheet tools which prove their own numbers. Convert is built and maintained with AI-assisted development and released only after the tests above pass. More on the About page. Support: support@getsheetproof.com.