COD vs prepaid profit calculator
A COD order usually earns far less than a prepaid one, because COD orders come back much more often and each return costs shipping both ways. Compare one order of each, before ad cost, to see what moving a buyer to prepaid is worth.
- Prepaid earns more by
- ₹174
- Profit per COD order
- ₹314
- Profit per prepaid order
- ₹488
The formula
- Margin = order value × (1 − product cost)
- Profit per COD order = (1 − COD RTO) × (margin − shipping − COD fee) − COD RTO × (shipping + return shipping)
- Profit per prepaid order = (1 − prepaid RTO) × (margin − shipping − payment fees) − prepaid RTO × (shipping + return shipping)
Rates are shares between 0 and 1: 30% is 0.3. Returned products are assumed to go back into stock.
Worked example
Orders average ₹1,000, product cost is 40%, and shipping costs ₹60 each way.
COD orders pay a ₹40 COD fee and 30% come back. Prepaid orders pay 2% in payment fees and 5% come back.
A COD order earns ₹314 on average and a prepaid order ₹488, so each buyer who pays online instead is worth ₹174 more.
Questions
Should I turn off COD?
Usually not. Most Indian shoppers still choose cash on delivery, so turning it off costs sales. Use the difference here to decide how much a prepaid nudge is worth.
How big a prepaid discount can I afford?
Less than the difference this shows, because the discount also goes to buyers who would have paid online anyway. Start small, such as ₹50 or 5%, and check whether your share of prepaid orders moves.
Why is ad cost left out?
The ads that win an order cost the same whichever way the buyer pays, so they don't change the difference. To see whether the ads themselves pay, use the break-even ROAS calculator.
Should I enter order value with or without GST?
Use order value after GST is taken out, because the tax isn't yours to keep. Counting it makes every ROAS look better than it is. Keep product cost, fees and ad spend on the same basis.