COD reconciliation: recovering money already lost

There is a category of COD loss that never appears in any RTO statistic: money from successful deliveries that never fully reaches you. Couriers remit COD collections in batches, net of deductions. Without order-level matching, the difference between what was collected and what arrived is invisible.

Short remittances. A batch arrives ₹4,000 light. Which orders were underpaid? Without matching each remittance line to each delivered order, nobody knows, and nobody follows up. Base.com's COD guide lists these discrepancies as a recoverable loss that manual reconciliation consistently misses.

Weight disputes. Couriers reweigh parcels and charge the difference. Aggregator dashboards have entire workflows for this: Shiprocket's weight-discrepancy process lets you accept the courier's claimed weight or dispute it with photos of the packed parcel. The trap is the default: if you do not act, the courier's weight is auto-accepted. Brands that never open the discrepancy tab pay every claim, true or not, forever.

RTO and handling fees applied wrongly. Rate cards are complicated: different fees by zone, weight, payment mode, sometimes by whether an order was returned. Fees applied to the wrong bucket, at the wrong rate, or on orders that qualify for a waiver accumulate quietly.

The ghost tail. Orders marked delivered months ago whose COD amount never appeared in any batch. Individually small; in aggregate, real money.

The failure is structural, not lazy. Courier statements, aggregator reports and your store's order list are three datasets with different identifiers, different date conventions and different definitions of "delivered". Matching them in a spreadsheet takes hours a week at modest volume, so it slips, and the slippage is exactly where the leakage lives.

1. 1Export three files monthly: orders marked delivered (store), shipment and charge detail (aggregator or courier), and the actual remittance credits (bank).
2. 2Match on tracking ID first, order ID second. Anything unmatched on either side is a queue to investigate, not noise.
3. 3Tally the deductions by type: weight, RTO fees, COD fees. Dispute the weight claims with evidence; challenge fees that do not match the rate card.
4. 4Age the unmatched deliveries. Anything delivered but unremitted past 30 days gets escalated in writing.

The first proper pass is where discrepancies tend to surface. After that it becomes hygiene: an hour or two a month that keeps the leak closed.