BankStatementDesk

BankStatementDesk home / Tools

Bank statement balance checker

Compare the running balances printed in a bank statement with the movement in each reviewed row.

Free account required to process your file. Original PDFs are read in your browser.

What to check before using the result

For a deposit account, add credits and subtract debits from the preceding balance. If $1,250.00 falls to $1,204.40 after a $45.60 debit, the row agrees. Investigate mismatches against the original statement.

Step-by-step guide

Calculate a running bank balance in Excel

Related tools

Start from a fresh export with the convert PDF bank statement to Excel tool or the bank statement to CSV converter, then close the loop with the bank statement reconciliation software.

How the balance check works

The checker starts from the opening balance printed on the statement and replays the reviewed rows in order: credits are added, debits are subtracted, and after every row the calculated total is compared with the balance printed in the PDF. When the two stop agreeing, the first mismatching row is highlighted — that is where a movement was missed, duplicated or read with the wrong sign.

A mismatch near the start of a page often means a row was lost where the statement repeats its header, while a difference equal to one transaction usually means that entry was extracted twice or skipped. Fix the row in the review step, run the check again, and only export when the calculated closing balance equals the printed one. The same method works by hand in a spreadsheet — the statement’s own balances are the proof that nothing is missing.