Case Study: Autonomous 3-Way Matching Pipeline Recovering ₹2.4 Crores in Vendor Leakage
How an asynchronous OCR and line-item reconciliation pipeline collapsed a 26-day invoice dispute cycle to 4 hours across 8 distribution centers without replacing the legacy ERP.
Client profile (anonymized): A high-velocity omnichannel retail and grocery enterprise operating 8 regional distribution centers, receiving 14,000 vendor line-items daily across 600 suppliers.
The Problem
Inbound receiving docks were clogged by physical delivery gatepass delays, hand-written Goods Receipt Notes (GRNs), and manual cross-referencing against enterprise Purchase Orders (POs).
Minor quantity discrepancies or price variations between physical crate counts and supplier tax invoices were routed to manual email threads, causing invoice dispute cycles to stretch to an average of 26 days.
Manual accounting sample checks covered less than 5% of incoming invoices, allowing over ₹2.4 Crores annually to leak into duplicate vendor billings, unverified price escalations, and uncaptured early-payment cash discounts.
The Approach
I was brought in to audit the receiving and settlement pipeline and build an automated reconciliation engine that could eliminate leakage without replacing the legacy SAP ERP core.
We deployed an asynchronous ingestion pipeline at the receiving docks: digital scale receipts and dock barcode scans are cross-matched in real time against authorized purchase order lines.
An automated OCR microservice extracts line-item prices, tax breakdowns, and HSN codes from incoming supplier invoices, feeding an automated 3-way matching rules engine.
Deterministic tolerance bands were codified: line items with weight variances under 1.5% are auto-cleared, while mismatches trigger an immediate, automated supplier debit note at gate receipt, settling the undisputed invoice balance instantly.
Runtime Forensic Vector Analysis
| Supply Chain Metric | Pre-Intervention Baseline | Operational Failure Mode | Post-Automation Validated State |
|---|---|---|---|
| Invoice Dispute Cycle TAT | 26 days average | Physical paperwork lost between warehouse docks and accounts | 4 hours automated resolution |
| Dock Truck Turnaround Time | 3.5 hours per vehicle | Trucks idling in yard awaiting manual physical verification | 22 minutes per vehicle |
| Invoice Audit Coverage | 4.2% manual sampling | Undetected vendor overbilling & duplicate payments | 100% real-time line-item verification |
| Annual Capital Leakage Recovered | ₹2.4 Crores lost annually | Unverified price creep and uncaptured cash discounts | ₹2.4 Crores recovered permanently |
The Outcome
Reconciliation turnaround collapsed from 26 days to under 4 hours, and dock receiving throughput improved by 78%, eliminating vehicle congestion across all 8 distribution centers.
The automated matching engine recovered ₹2.4 Crores in verified invoice leakage within the first year of operation, while strengthening supplier trust through transparent, instant debit note issuance.
Frequently Asked
Why did the client not use the built-in 3-way matching inside their ERP?
Standard ERP matching modules require clean, structured digital inputs. Suppliers were delivering physical paper invoices with inconsistent formatting, which stalled ERP batch jobs and forced staff into manual workarounds.
How are supplier disputes handled when an automatic debit note is issued?
The debit note includes high-resolution dock scale telemetry and barcode scan logs, providing undeniable cryptographic evidence that suppliers accept immediately without lengthy email arguments.