Bank statement PDF to Excel – with every balance proven.

Each statement is checked on its own (opening + transactions = closing). Then statements of the same account are put in date order and each one is checked against the next: the closing balance must equal the next opening balance. If they don't match and there is a gap in dates, a statement is probably missing.

If two statements cover overlapping dates, transactions that appear in both are kept once and the copy is left out of the files you import into your accounting software. The same file uploaded twice is ignored.

Reconciled means: the opening balance plus every transaction we read equals the closing balance printed on the statement, and every running balance printed next to a transaction matched our running total. If a single digit were misread, these sums would not match – so a reconciled statement is complete and correct.

Red rows are where the running balance stops matching, or something on that line couldn't be read clearly. Click a row to see that exact line on the original page, then fix the number or use one of the suggested fixes. If the statement itself really shows those numbers, choose "Statement is like this – accept".

Dates: we show how we read them. If day and month can't be told apart, you'll see a warning and a switch.

Exports always mark rows that still need review, so nothing unchecked slips into your books unnoticed.