1. Start with shipped orders
Build the expected COD population from orders actually handed to the courier.
2. Separate delivery outcomes
Delivered, failed-delivery and return-to-origin shipments should not be mixed.
3. Match collected amounts
Compare successful deliveries with courier-reported collections.
4. Match merchant payouts
Compare collected amounts with payouts received after fees and adjustments.
5. Track unresolved exceptions
Keep outstanding items open by courier and settlement period until resolved.
Build an exception queue
Instead of rechecking every order, isolate mismatches such as delivered without collection, collection without payout, payout shortfall or duplicated settlement. This turns reconciliation into exception management.
Close each settlement period
A period should only be considered closed when expected collections, deductions, payouts and unresolved exceptions are documented. This creates a repeatable finance control instead of a spreadsheet exercise.
Every event should remain connected to the product, contact or transaction that created it. That is what lets ERP explain a number instead of only displaying it.