COD Reconciliation Tracker

Per driver, per day, three numbers: COD due (sum of COD amounts on orders marked delivered), cash collected (counted at handover), and amount deposited/remitted. Due must equal collected — any gap is investigated same day against delivery statuses (was that order really delivered?) and stop-level records. Collected must reach deposited within your float window (same day or next morning for most operations). The non-negotiables: count cash at handover with both parties present, record it immediately, and never let an unexplained variance age past 24 hours — recovery rates collapse with time.

Mostly process noise: orders marked delivered that were actually refused or rescheduled (the system expects cash that was never collected), partial payments accepted at the door without a matching record, change-making errors across dozens of cash stops, swapped parcels between routes, and handover miscounts. This is why the first investigation step is always delivery-status verification, not suspicion — a 'short' driver whose route had two miscoded refusals is exactly even. Clean status discipline upstream (the failed-delivery tracker's job) removes most COD variances before they appear.

Float is revenue that exists as cash in transit — collected at doors but not yet deposited and credited. A network doing $20,000/day of COD with a 3-day collection-to-credit cycle permanently has $60,000 of working capital riding in bags, drawers and reconciliation queues: unbankable, uninsurable in practice, and shrinkage-exposed. Float is also the denominator of leakage risk — the more cash in the system and the longer it stays, the more opportunities for gaps. Daily deposit discipline and digital-payment-at-door options (UPI, cards) attack both the float and the risk simultaneously.

Layered nudges rather than removal: small prepaid discounts (the margin cost is usually below the COD failure-plus-float cost), digital payment at the door (UPI/QR or card — keeps the 'pay on delivery' trust while removing cash), partial-advance COD for high-value or high-risk orders, and COD eligibility rules by customer history and pincode (first-time, high-refusal areas get verification calls or caps). Each tactic measurably cuts refusals and float; together they typically shrink cash COD to the residual segment that genuinely needs it — which is also the segment worth the reconciliation overhead.