Why a high dispatch count may conceal weak margins
E-commerce sellers frequently budget against orders placed, although revenue-producing fulfilment depends on delivery, payment and subsequent product returns. COD parcels may fail before acceptance and return to origin; prepaid parcels can also fail delivery. Returned merchandise after a successful delivery requires a separate adjustment. Treating all three as a single refund percentage hides shipping waste, gateway expense, inventory impairment and collection cost. The model therefore starts with placed orders and builds a count and cost bridge through each fulfilment event.
What is the difference between RTO and a post-delivery return?
Return to origin (RTO) is a consignment that does not complete delivery to a buyer, often following failed COD acceptance. A post-delivery return happens only after the parcel is delivered and then sent back. The COD and prepaid channels each have their own failure and post-delivery return assumptions. COD collection fees are charged only against successfully delivered COD parcels. Returned-after-delivery COD parcels still attract the illustrative collection fee, which may differ under your payment service agreement.
How the completed-and-kept order bridge works
Begin with monthly orders placed and multiply by the COD mix to obtain COD orders. The remaining orders are prepaid. Delivered COD orders are placed COD orders multiplied by one minus the COD RTO rate; delivered prepaid orders use the separate prepaid failed-delivery rate. Each delivered set then loses its post-delivery return fraction. Total kept deliveries equal kept COD plus kept prepaid. Expected counts may be fractional because this is a probability-weighted forecast, not a physical parcel audit.
Commercial revenue versus bank settlement
Net sales in this model equal kept deliveries multiplied by the ticket value entered before GST. Payment gateway fees are charged here on total originally placed prepaid orders, including orders later refunded, to model a conservative non-recoverable fee. Actual merchant agreements can refund fees or impose minimum charges. There is deliberately no GST/TCS/TDS or bank settlement calculation; those are legally distinct from unit contribution and need the actual merchant platform settlement statement.
Counting product inventory losses properly
The stock cost of kept deliveries is an expense of sales. For parcels that fail delivery or are returned, the calculator does not automatically expense the entire stock cost; instead it charges only the entered unrecoverable percentage. If goods are restored to saleable inventory at full cost, enter 100% recoverable. If goods are destroyed, enter 0%. Resale discounts, sanitising costs and restocking fees may require a lower recovery. Returned inventory is not new revenue and any later resale belongs to a different order cohort.
Two-way shipping and acquisition charges
Every placed order incurs the assumed forward freight, packaging and acquisition spending. Failed deliveries and returned deliveries additionally incur reverse shipping. Some logistics companies charge both forward and reverse legs for RTO, while others apply special rates; enter the actual effective per-leg charges. The results report individual cost categories so users can compare courier invoices, advertising dashboards, packaging purchase registers and payment processor deductions. Do not also include the reverse cost in the forward rate.
Worked scenario and managerial interpretation
The example assumes 1,000 placed orders, ₹1,500 pre-GST ticket price, 65% COD and a higher COD failure rate than prepaid. Product cost is ₹620 per kept order. The result bridge shows how COD-heavy collections can reduce kept sales and still consume shipping and acquisition expense. Changing the COD share by ten percentage points is a ceteris paribus scenario: it does not assume customers will buy equally readily with prepaid payment or that acquisition conversion is unchanged.
Break-even selling price is not a price recommendation
The tool computes the ticket price that would cover the same per-order cost assumptions, holding probabilities, order volume, shipping and processing fees constant. If prepaid fees grow with selling price, they reduce the retained contribution per rupee of sales. When the retained price factor is non-positive, break-even price is deliberately unavailable. The break-even figure excludes fixed staff, warehouse rent, returns fraud prevention, financing, tax, platform subscription and capex.
Sensitivity and data checks
Recalculate after changing COD penetration, COD RTO, returns, stock recovery, reverse freight and marketing spend one at a time. Verify actual return cohorts instead of mixing order-date and settlement-date data. For each order, retain the carrier AWB, shipment status, customer refund, inventory inspection and bank settlement reference. A high returned quantity with a zero stock impairment may still be commercially unattractive because additional handling and delayed resale tie up working capital.
GST and accounting boundaries
Selling price is entered exclusive of indirect taxes so calculated revenue is not inflated by output GST collections. The taxable value, timing of credit notes, discount recognition, section 15 valuation and tax-invoice conditions must be examined using current CBIC guidance and your actual invoices. The calculation does not claim that all returned orders automatically reverse the original GST charge or that net sales equals recognised revenue under Ind AS 115. Accounting policies and evidence requirements must be reviewed separately.
Source checks and professional caution
Use actual courier service-level agreements and provider invoices for freight and remittance costs, and original platform agreements for fees and chargebacks. Official CBIC source material is linked for legal context only, not as a way to infer GST rates or treatment from a profit model. Check returns policy, consumer obligations and inventory write-down rules with the relevant professional before using these numbers in a statutory financial statement or filed tax return.
Frequently asked questions
Are the sample RTO rates official benchmarks?
No; they are fictional data for learning.
Can RTO and returns be the same event?
No; their stages and associated fees differ.
Does COD mix directly cause RTO?
The tool shows a scenario comparison, not a causal estimate.
Does it estimate cash collected?
No; it is contribution economics rather than payout timing.
Does a higher COD mix always harm profits?
Not necessarily; COD may improve conversion in some customer segments, which this constant-volume model does not capture.
Official sources and further reading
Sources explain the calculation conventions and rules referred to above. Notifications and standards change; confirm on the official site before you file, book or advise.
Educational working tool. Results follow the scope and assumptions described on this page and the figures you enter; they are not accounting, audit, tax, legal, investment or financing advice. Treatment depends on facts, contracts and the law or standard in force for the relevant period, so reconcile to your records and consult a qualified professional before you rely on a result.