SheetProofConvert
Guide · bank statement PDF → Excel & CSV

How to check a converted bank statement is complete.

Converters rarely tell you when they drop a row. This is the check that does, by hand in Excel or automatically here.

Drop your statement PDF

Chase, Bank of America, Wells Fargo, TD Bank and other banks (generic reader)

Several months? Select them together: you also get a month-to-month check.

No statement handy?
10 free pages a dayWorks with Wi-Fi off

Chase, Bank of America, Wells Fargo and TD Bank: tested on synthetic statements in their layouts and on the sample statements Wells Fargo and TD Bank publish, not yet on customer statements. U.S. Bank and Citi: no official sample exists that we could find, so they use the generic reader. Every file shows whether it balanced. How we test

sample-statement - SheetProof.xlsx · Proof tab · Microsoft Excel
The Proof tab of the converted sample statement, opened in Microsoft Excel: opening balance 3,842.15, money in 4,316.00, money out -3,351.52, calculated closing 4,806.63, closing on the statement 4,806.63, difference 0.00, balanced to the cent
Real screenshot: Microsoft Excel showing the Proof tab of the sample on this page (fictional data). Your file gets the same tab.

The rule

Opening balance + every credit − every debit = closing balance. All three numbers are printed on your statement, so you do not need to trust the converter: you can check its work.

By hand in Excel

  1. Put the opening balance in a cell. Sum the Amount column (credits positive, debits negative).

  2. Add them, and compare with the closing balance on the statement. The difference should be exactly 0.00.

  3. If your bank prints a balance on each row, add a column with the running total and compare it down the page: the first row where they differ is where a line was lost or misread.

Automatically

SheetProof Convert does this on every file and builds the Proof tab with live formulas, so the check is in the spreadsheet you hand to your accountant. Drop a statement above, or try the sample with a row missing to see how a failure looks.

Questions

What if the difference is a few cents?

A digit was misread or a row was split in two. Look at the row the check names and compare it with the PDF.

What if the statement has no closing balance?

Then the check can only compare the rows with each other. The result says so instead of calling it balanced.

Does this prove the transactions are correct?

It proves the rows add up to the printed balances. It cannot catch an error that cancels out, such as two swapped amounts, so skim the descriptions too.