Remittance Stub Parser
Multi-format PDF extraction engine that reads Walmart, Costco, UNFI, and KeHE remittance advice, validates deductions against invoices, and surfaces what is about to expire past the dispute window before anyone reconciles it.
Supported Formats
Walmart
Remittance advice with promotional allowances, freight claims, and compliance fines. Table-heavy layout with reason codes mapped to 12 deduction categories.
Costco
Volume rebate and warehouse handling deductions. Structured two-column layout with gross/net reconciliation and multi-line item descriptions.
UNFI
Distributor chargebacks for spoilage, short-ships, and invoice discrepancies. Variable-length line items that sometimes span multiple pages.
KeHE
Promotional billbacks, new-item slotting fees, and reclamation deductions. Compact single-page format with merged header rows.
How It Works
Extract
pdfplumber reads native-text PDFs and extracts tabular deduction data. An optional LLM pass catches line items that table detection misses.
Validate
Arithmetic check confirms net + deductions = gross invoice. Reason codes are mapped against retailer configs to flag unmapped or suspicious entries.
Reconcile
Validated stubs feed a SQLite ledger. Each deduction is matched against invoice and AR records to surface unrecovered amounts before the dispute window closes.