The PDF says 1,286. The worksheet says 1,268. Both look plausible, and a total could include either without producing an error. A second pass has to compare the original number with the cell, not simply scan the spreadsheet for numbers that look unusual.
Keep a short reconciliation ledger
For a small table, make a staging sheet with columns for PDF page, printed row label, displayed value, second reading and status. Use the label as well as the page. “Page 4, Supplies” still points you to the right number if a different edition shifts the layout.

Example reconciliation ledger. The Supplies row stays open while the two readings disagree.
On the second pass, read the PDF again with the first transcription covered or out of sight. Enter that reading beside the first. If the readings differ, return to the source and resolve the row before using it. For a fuzzy scan, record the row as unresolved and ask for a clearer copy instead of inferring a digit from the total.
Normalize only after matching the source
A number can be copied correctly and still land in the workbook at the wrong scale. When a heading says USD thousands, retain the raw 1.28 and its unit. In a separate calculation column multiply by 1,000 to get 1,280 dollars. Keep a genuine dash or blank distinct from a zero unless the document defines them as equivalent.

Example unit conversion. Keep the original 1.28 visible beside the normalized value.
As a final check, filter the staging sheet for unresolved entries and compare any printed subtotal with the corresponding confirmed rows. A matching total is helpful, but it cannot detect two mistakes that cancel each other out. Keep the source references when handing off the workbook.



