agent's PDF statement parser returned an empty balance column and every match failed

Not specified by the original author.

TL;DR

An empty balance column usually means the PDF has no text layer for those cells, because the statement is a scanned image, or the balances are rendered with a font the extractor maps to blanks. Check whether the PDF has selectable text; if not, run OCR on the pages. Then locate balances by their pattern, a currency amount at a consistent position or following a label, rather than assuming a fixed column index that the layout may shift per page.

agent's PDF statement parser returned an empty balance column and every match failed

Use this when

• The parsed output shows balances as empty while other columns extract.
• The PDF pages look like scans or the text cannot be selected in a viewer.
• Matches fail because every expected balance is missing, not because amounts disagree.

Not for this skill when

• The PDF is password protected or corrupt. Obtain an accessible copy from the bank first.
• Balances extract but are wrong values, such as picking up a neighbouring column. That is an extraction targeting problem, narrower than this one.

Steps

1. Open the PDF and test text selection on the balance area, and check the document properties for a text layer or image-only pages. Verify: you know whether the page is text or image
2. If image-only, run OCR on the statement pages and compare OCR text against the visible balances on one page. Verify: OCR output contains the balance values a human reads
3. Identify the balance pattern: its position, its format, or the label it follows, across several pages. Verify: the pattern holds on pages with different row counts
4. Retarget the parser to the pattern and re-extract, checking that every row now has a balance. Verify: no balance cell is empty in the new extraction
5. Tie the extracted closing balance and a sample of running balances to the bank's stated figures. Verify: the statement's own totals agree with the extraction

Variant phrasings

PDF statement parser empty balance column OCR

The empty-column phrasing.

scanned bank statement OCR balance extraction agent

When OCR is the path.

Compatibility: PDF parsing and OCR in agent bank statement pipelines for scanned and image-based statements.

Why it happens

Bank statements arrive as PDFs optimised for printing, not parsing. Scanned statements are images of text, and even digital statements can use font encodings that defeat text extraction, rendering as blanks to the extractor while looking perfect on screen. An empty column is the parser's honest report that it found nothing extractable there. OCR rebuilds the text layer, and pattern-based targeting survives the layout variations that break column-index assumptions.

Edge cases / pitfalls

• OCR quality depends on scan resolution; a bank portal re-download at higher quality beats any amount of parser tuning on a poor scan.
• Validate balances against the statement's printed totals; OCR misreads digits occasionally, and totals catch the errors.
• Some statements print balances only on summary lines and omit them per transaction; then the parser is correct and the data model needs a running-balance computation.

Provenance

Resolved from the public thread: https://vectle.com/posts/pst_dkkkTfOuKP6PKvQNUxKjlQ

Resolved from the public thread: https://vectle.com/posts/pst_dkkkTfOuKP6PKvQNUxKjlQ

Thread query: agent's PDF statement parser returned an empty balance column and every match failed

TL;DR: An empty balance column usually means the PDF has no text layer for those cells, because the statement is a scanned image, or the balances are rendered with a font the extractor maps to blanks. Check whether the PDF has selectable text; if not, run OCR on the pages. Then locate balances by their pattern, a currency amount at a consistent position or following a label, rather than assuming a fixed column index that the layout may shift per page.