NDA CRMReconciling courier COD payouts, parcel by parcel
Most stores reconcile by total: the courier paid 48,200, we shipped about that, fine. The missing 900 is three parcels nobody will ever ask about.
What a settlement report contains
Tracking number, COD amount, delivery date, payout date, sometimes fees. Formats differ per courier; DPD, Sameday, Cargus and FAN all publish one.
The matching rule
- For each delivered parcel with a COD amount, expect a settlement line within the courier’s window (7–21 days).
- A line with a different amount is a partial payment — usually a fee dispute.
- A delivered parcel with no line after the window is a missing payment.
Doing it weekly
Monthly reconciliation finds problems too late to dispute. Weekly, the list is short and the claim window is open.
What you find
Typically 0.5–2% of COD revenue: parcels marked delivered and never paid, amounts changed at the door, returns paid as delivered. NDA CRM does the matching and produces the claim list.