1. Running-balance check (the strongest test)
If the statement prints a balance after each transaction, every row must satisfy:
previous balance + amount = balance
In Excel, with Amount in column F and Balance in column G (data from row 2):
=IF(ROUND(G2+F3-G3,2)=0,"OK","CHECK") in H3, filled down.
A sign error shows up immediately because the difference is exactly twice the amount. StatementSheet runs this check automatically and fixes those sign errors for you.
2. Totals check
Most statements print total withdrawals and deposits in a summary box. Compare them with =SUMIF(F:F,"<0") and =SUMIF(F:F,">0").
3. Opening + net = closing
opening balance + SUM(Amount) = closing balance. If this holds, no transaction is missing or duplicated.
4. Count check
Spot-check the number of rows on the first and last page against the PDF, especially around page breaks where headers and “continued” lines appear.
5. Dates
For statements that show only day and month, make sure December transactions on a January statement got the previous year. Also check that 03/04 means what your bank intends (3 April vs March 4).