Quick answer
COD reconciliation means matching every delivered cash-on-delivery order to the money your courier sends you, minus their charges. Do it weekly: export delivered COD orders, compare them with the courier's remittance report and bank credits, list anything missing or short, and raise it with the courier quickly. Refused parcels and partial deliveries need their own column.
Reconciling cash on delivery means checking that every COD order marked delivered has been paid to you by the courier, in full, minus the charges you agreed. Couriers collect cash at the door, hold it for a period, and send it to you in batches, often several orders at a time with fees deducted. Without a simple weekly routine, missing or short payments go unnoticed for months. With one, you catch problems while they are still easy to fix.
This guide gives you a routine that works with a spreadsheet, explains the usual mismatches and what to do about them, and shows how your store's reports help.
How does COD money reach you?
The flow is usually:
- A customer orders with cash on delivery.
- You ship through a courier or shipping aggregator, which records the COD amount to collect.
- The delivery person collects cash (or sometimes a UPI payment at the door) and marks the parcel delivered.
- The courier holds the collected amount for its remittance cycle, which varies by courier and plan.
- The courier remits a batch of COD amounts to your bank, with a remittance report listing the orders, and may deduct shipping or COD fees.
Each step is a place where a rupee can go missing: a parcel marked delivered but not paid, a wrong amount collected, a fee deducted twice, or a remittance that never arrives.
What do you need to reconcile?
Three lists, side by side:
- Your orders: every COD order, with order number, amount, AWB (tracking) number, ship date and status.
- The courier's remittance reports: the orders they say they have paid, amounts, fees and the batch or UTR reference.
- Your bank statement: the credits that actually arrived, with dates and references.
In UpMinutes, the Orders section has a COD tab listing cash on delivery orders, and order statuses move along automatically when Shiprocket tracking updates arrive. The reports section shows sales, tax and payment mix for any dates, which you can download as CSV or PDF.
What is a simple weekly reconciliation routine?
Pick a fixed day. Thirty to sixty minutes a week is usually enough for a small store.
- Export delivered COD orders for the period, with order numbers, AWB numbers and amounts.
- Download the courier's remittance reports for the same period.
- Match by AWB or order number in a spreadsheet. A simple lookup formula does this quickly.
- Check each remittance total against the matching bank credit.
- List the gaps in a separate sheet: delivered but not remitted, remitted short, remitted but not in the bank.
- Raise disputes with the courier for anything past its normal remittance cycle, with the AWB numbers and amounts.
- Mark reconciled orders so you do not check them again next week.
What should your reconciliation sheet look like?
| Column | Example |
|---|---|
| Order number | 1043 |
| AWB number | From the courier label |
| COD amount | ₹1,450 |
| Delivered on | 12 August |
| Remitted on, and reference | Date and batch or UTR |
| Amount received | ₹1,450 |
| Fees deducted | As per the courier report |
| Status | Matched / Pending / Short / Disputed |
What are the common mismatches?
Delivered, but not paid
The parcel shows delivered, but the order is missing from every remittance. Often it is simply still within the remittance cycle. If it is past the cycle, raise it with the AWB number and delivery date. If the customer says they never received it, ask the courier for proof of delivery.
Paid short
The remitted amount is less than the COD amount. Check whether a fee was deducted from the remittance rather than billed separately, or whether the order amount was changed after shipping. Compare with your courier's rate card.
Refused or returned parcels
A parcel refused at the door (RTO, return to origin) brings no cash, and you usually pay shipping both ways. Mark these separately, and check the returned item when it arrives. UpMinutes flags RTO and undelivered courier statuses and can send delivery-problem emails, so you know which orders to follow up. Our guide to reducing COD returns and RTO covers prevention.
Remitted, but not in the bank
The courier's report shows payment, but your bank does not. Ask the courier for the UTR or transaction reference; your bank can trace it.
Paid by UPI at the door
Some delivery staff accept UPI instead of cash. Those payments still flow through the courier's remittance, but check that they are not missing or double counted.
What if your own staff deliver COD orders?
Many shops deliver locally with their own delivery person. Then there is no courier remittance, but there is still cash to account for. Give each rider a daily run sheet listing orders and amounts, collect the cash and any UPI payment screenshots at the end of the day, and count it against the sheet before the rider leaves. Mark each order delivered and paid in your dashboard the same evening, not at the end of the week. UpMinutes lets you share a live-map link for your own delivery person with the customer, and charge local delivery by distance from your store. A simple daily habit here prevents most arguments later.
How do you handle COD refunds?
When a COD customer returns an item, there is no card or UPI payment to reverse. You refund them directly, usually by UPI or bank transfer. In UpMinutes, the customer can give their UPI ID in the return form, and you can choose to refund by UPI, bank, cash or store credit. Record each refund against the order so your reconciliation and your accounts agree. Our post on refunds and credit notes covers the accounting side.
How does COD affect your accounts and GST?
A COD sale is still a sale on the invoice date, even though the money arrives later, and GST is usually due based on the invoice, not on when the courier pays you. Refused parcels that come back may need a credit note or cancellation in your records. Every UpMinutes order gets a GST invoice, and tax reports and bulk invoices help your accountant match sales to receipts. Ask your CA how to treat RTOs and fees in your books. See GST basics.
How can you reduce the reconciliation burden?
- Shift some customers to prepaid. UPI and card payments arrive through your gateway with clear settlement reports, which are easier to match. A small incentive for prepaid orders helps.
- Set a COD limit by order value, so large amounts are prepaid.
- Allow or refuse COD per delivery zone, switching it off where refusals are frequent.
- Confirm COD orders before shipping, for example with the COD confirmation email UpMinutes can send.
- Use one courier or aggregator for COD where you can, so you have one remittance report to check.
Our guide to UPI, cards or cash on delivery helps you find the right balance.
A COD reconciliation checklist
- Fixed weekly reconciliation day.
- Export of delivered COD orders with AWB numbers.
- Courier remittance reports for the same period.
- Bank statement credits with references.
- A gaps sheet with status and follow-up date.
- Separate tracking for RTO parcels.
- Monthly review with your accountant.
More on payments and tax is in the payments and GST category.
Frequently asked questions
How long do couriers take to remit COD money?
It varies by courier, aggregator and plan, from a few days to a couple of weeks after delivery. Check the cycle in your agreement and chase anything older.
What is a COD remittance report?
A list from your courier showing which COD orders they have paid you for in a batch, the amounts, any deductions and the bank reference. It is the key document for reconciliation.
Do I pay GST on a COD order before the courier pays me?
GST is generally linked to the invoice date, not when cash reaches you, but timing rules have detail. Ask your CA how this applies to your returns.
How do I refund a cash on delivery customer?
Refund by UPI or bank transfer to an account the customer gives you, or offer store credit if your policy allows. Record the refund against the original order.
