Financial & Accounting Utilities

The utility computes sequential rolling balances `(Previous Balance + Credits - Debits = Current Balance)` on every transaction row; any missing transaction or calculation gap is flagged with exact line coordinates.

Usually one of four things, all of them formatting rather than accounting. Negative amounts written in accounting style as `(1,250.00)` instead of `-1250.00`. Thousands separators and decimal marks swapped, so `1.250,00` reads as 1.25. A currency symbol or trailing `CR`/`DR` marker glued to the number. Or a debit column that is already negative being subtracted again. Check the flagged row against the source statement before assuming a transaction is missing.

No — it means the statement is internally consistent. A running balance check proves that every row follows from the one before it, which catches dropped rows, transposed digits and truncated pages. It cannot tell you that a transaction which appears on the statement should not be there, or that one which never appeared is missing from the bank's own records. It is a completeness check on the document, not an audit of the account.

Extract the tables first, then reconcile. Use PDF to Excel to turn the statement into rows — with Auto-Stitch it joins the pages that continue the table into one continuous sheet rather than one block per page, whether or not each page repeats the header — and bring that result here. Going straight from a PDF loses the column structure the balance check depends on, and multi-page statements are exactly where a dropped row is easiest to miss by eye.