From PDF bank statement to Excel: reconcile the closing balance
A statement can look right in Excel even when one debit is missing. Keep the original PDF open and use its printed closing balance as an independent check.
A statement can look right in Excel even when one debit is missing. Keep the original PDF open and use its printed closing balance as an independent check.
On an invoice, 000472 can be a six-character customer code. If Excel turns it into 472, the amount of a sale may still be correct while a lookup against the customer list fails.

Open the PDF and wait for the table preview. On a scanned page, check identifiers with leading zeros against the original.