When a courier's cash-on-delivery remittance does not match your orders, line them up in a simple sheet: what you should have received for each delivered order, what the courier actually remitted, and the difference. Refused orders should show no cash due, short-paid ones show a gap, and delivered orders missing from the remittance are the ones to chase.
Why do COD remittances go out of step?
The courier collects cash at the door and passes it to you later, often in batches. In between, things happen: a customer refuses the parcel, pays less than the amount, or an order is delivered but not yet included in the batch. The courier may also deduct a COD fee or other charges. Check your agreement or shipping terms for what is deducted and how often money is remitted.
How do you build the sheet?
Use one row per COD order with these columns: order number, status, cash to collect, amount remitted and the gap. Fill the first three from your own order records, and the remitted figure from the courier's remittance report.
| Order | Status | Cash to collect | Remitted | Gap |
|---|---|---|---|---|
| 1 | Delivered | ₹799 | ₹799 | ₹0 |
| 2 | Delivered | ₹1,299 | ₹1,299 | ₹0 |
| 3 | Delivered | ₹549 | ₹499 | ₹50 short |
| 4 | Delivered | ₹999 | ₹999 | ₹0 |
| 5 | Delivered | ₹699 | ₹0 | ₹699 not yet remitted |
| 6 | Delivered | ₹1,499 | ₹1,499 | ₹0 |
| 7 | Refused | ₹899 | ₹0 | No cash due; parcel returning |
These figures are made up. Cash expected on delivered orders is 799 + 1,299 + 549 + 999 + 699 + 1,499 = ₹5,844. Remitted is 799 + 1,299 + 499 + 999 + 1,499 = ₹5,095. The gap is 5,844 - 5,095 = ₹749, which is the ₹50 short payment plus the ₹699 order missing from the remittance.
What do you do with each kind of gap?
- Missing order: check the tracking for the delivery date and whether the remittance is still within the courier's remittance cycle. If it is past, raise it with the order number and delivery proof.
- Short payment: ask the courier what the customer paid. A deduction for a fee may explain it; if not, ask for a correction.
- Refused order: no cash is due, but follow the parcel back. If it never returns, that is a separate claim.
- Duplicate or unknown line: ask for details, since it may belong to another order.
Is the remittance late or just not due?
Read the remittance cycle in your terms. If it says money is passed on a few days after delivery, an order delivered yesterday is not late. Add a due date column, just as you would for a marketplace payout, and chase only orders past it.
What does the monthly summary show?
At month end, make a short list: total COD expected, total remitted, short-paid amounts and orders still unremitted, with how many days each has waited. Carry the unremitted ones into next month's sheet so they are not forgotten. A growing list with one courier is useful evidence in a conversation about service.
Where does the cash show up?
The remittance reaches your bank account as a credit, usually without the order-level detail. If you import the bank statement into SpendixAI, the credits appear with their dates for review, which helps you tick off remittances in your sheet. The order-by-order matching comes from the courier's report.
Keep the courier's proof of delivery, such as a delivery scan or signed slip, linked to each order number. When a remittance goes missing, the first thing the courier will ask for is the proof, and having it ready shortens the conversation. For refused orders, note the reason the customer gave, since a pattern of refusals for one product or area tells you something about your listing or your delivery area.
Weekly routine
- Download the courier's remittance report.
- Mark each COD order paid, short or missing.
- Raise tickets for anything past the cycle.
- Note the ticket number and follow up on the date given.
- Record refused orders and track the return.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

