ZZZ Digital Lab

Back to PDF tables to sheets

Sample client deliverable: $25 PDF extraction diagnosis

SYNTHETIC CASE. Engineering with AI coding tools, tests and written handoff. This limited diagnostic inspects two representative layouts and proposes acceptance controls. It does not include bulk conversion or a guarantee for unseen PDFs. It is narrower than the separate $75, up-to-five-page extraction pilot.

Finding Observed synthetic evidence Risk Fix plan
Incomplete page handling Baseline extracts 3/6 invoice rows and 4/8 statement rows Silent data omission Read every page, repeat headers and compare declared row counts
Space-split columns Multiword descriptions spill into columns Wrong field mapping Use known ruled-table boundaries with exact header validation
Ambiguous numeric source Baseline changes O5.00 to 05.00 Invented financial value Strict decimal parser; blank uncertain output; retain raw text and provenance for review
No reconciliation Baseline has no row or total control Plausible-looking incorrect sheet Decimal totals, line products and running-balance checks
No traceability Baseline has no source page/row Slow verification Page and table-row provenance on every output record

The repaired example returns 14 rows across 4 pages. Invoice quantity 13 and subtotal 550.50 reconcile. Statement credits 1450.00 and closing balance 2170.25 agree. One debit remains unresolved; its column sum and net-movement control are INCOMPLETE. Overall status is REVIEW_REQUIRED. All 20 regression tests pass, including rejection of an incorrect source total and an unknown layout.

Suggested acceptance: agreed schema and layout sample; all declared rows present; row/page provenance; no numeric guessing; machine-readable and human-readable controls; source-based review of every uncertain required cell. A wrong control must remain visible and block automatic acceptance.

Conditional estimate for one similar bounded pilot: 2-4 engineering hours for up to 5 representative text-PDF pages, plus client review of exceptions. Example pilot quote $75; a separately scoped small batch starts at $325 after pilot acceptance. These are proposed service terms, not market or turnaround guarantees. Scans/OCR, handwriting, new layouts and manual transcription are excluded pending a new estimate.

Required client decisions: which fields must be exact, source ownership/processing permission, representative hard pages, acceptable review workload, control totals and batch size. Processing remains local; no client document is sent to an online service.