This is fictional demo data
Sample Profit Leakage Audit for a Fashion D2C Brand
A printable sample of the RTO Profit Audit a seller can review before sharing customer-level data. Brand, orders, couriers, pincodes, and SKUs below are fictional.
Printable layout: use your browser print command to save or share this sample.
1. Executive Summary
Nazrana Streetwear has 1,800 monthly orders, 72% COD, 24% overall RTO, and 31% COD RTO. Estimated monthly leakage is ₹1,83,600.
Likely main drivers: COD intent, pincode concentration, NDR rescue delay, and address quality. Recommended next step: privacy-safe summary audit, then anonymized CSV if the estimate looks useful.
2. Leakage Breakdown
COD leakage estimate: ₹1,70,748
Prepaid leakage estimate: ₹12,852
NDR-related leakage: ₹84,456
Courier/pincode concentration: ₹62,424
Address-quality leakage estimate: ₹33,048
3. Top RTO Pincode Clusters
| Pincode | Orders | RTO | RTO % | Estimated loss | Recommendation |
|---|---|---|---|---|---|
| 395007 | 148 | 52 | 35% | ₹22,100 | Verify COD orders before dispatch. For first-time buyers above ₹999, test prepaid-only or partial-prepaid policy. |
| 302001 | 126 | 36 | 29% | ₹15,300 | Add address landmark check and prepaid nudge for high-value COD. |
| 560095 | 92 | 20 | 22% | ₹8,500 | Review courier allocation and call high-value NDR cases. |
| 201001 | 88 | 24 | 27% | ₹10,200 | Confirm COD intent before dispatch and hold weak-address orders. |
| 700016 | 76 | 18 | 24% | ₹7,650 | Use pincode-specific COD confirmation and reattempt scheduling. |
4. Top Courier Issues
| Courier | Shipments | RTO | NDR | Pattern | Recommendation |
|---|---|---|---|---|---|
| Delhivery | 420 | 88 | 42 | High COD failure in 395007 | Compare alternate courier on a 14-day switchback test. |
| Xpressbees | 360 | 96 | 48 | Customer unavailable and refused cases | Run same-day WhatsApp plus call fallback for NDR. |
| Bluedart | 210 | 32 | 15 | Good metro performance, weaker COD clusters | Keep for prepaid/high-value orders; review COD clusters. |
| DTDC | 180 | 44 | 20 | Address issue concentration | Add address correction before dispatch. |
| Ekart | 220 | 45 | 26 | Late NDR updates | Track NDR-to-action latency daily. |
| Shadowfax | 160 | 38 | 18 | Door locked and unavailable | Use OFD reminder and reattempt slot confirmation. |
| Shiprocket | 250 | 62 | 31 | Mixed allocation hides courier-pincode issues | Break reports by actual courier and pincode. |
5. Top SKU / Product Leakage
| SKU | Orders | RTO | Suspected issue | Recommended action |
|---|---|---|---|---|
| DRESS-RED-S | 210 | 62 | Size expectation mismatch | ₹26,350 loss. Check product page expectation, size chart, COD customer intent, and ad campaign source. |
| SNEAK-WHT-8 | 144 | 38 | High-value COD hesitation | ₹16,150 loss. Offer prepaid incentive and clearer exchange policy before dispatch. |
| KURTI-BLU-M | 188 | 41 | Weak address and impulse COD | ₹17,425 loss. Confirm delivery intent and address landmark. |
| EARBUDS-PRO | 122 | 28 | Offer mismatch | ₹11,900 loss. Audit ad creative, landing copy, and COD confirmation message. |
| TSH-BLK-L | 176 | 30 | Fit uncertainty | ₹12,750 loss. Improve size chart and buyer expectation copy. |
6. Top NDR Reasons
| Reason | Count | Estimated loss | Rescue recommendation |
|---|---|---|---|
| customer_unavailable | 86 | ₹36,550 | Send WhatsApp + call within 30-60 minutes of first failed attempt. Ask for reattempt slot. |
| customer_refused | 64 | ₹27,200 | Confirm COD intent and product expectation before the second attempt. |
| wrong_address | 42 | ₹17,850 | Ask for landmark, house number, and alternate phone before courier cutoff. |
| phone_unreachable | 38 | ₹16,150 | Validate phone pre-dispatch and call high-value cases. |
| payment_issue | 26 | ₹11,050 | Offer prepaid link or reschedule when cash is available. |
| door_locked | 21 | ₹8,925 | Ask customer to choose reattempt time and keep package active. |
7. Example Daily Action Queue
| Group | Example orders |
|---|---|
| Confirm risky COD | NS-2024, NS-2029, NS-2041 |
| Fix weak address | NS-2018, NS-2070 |
| Push prepaid offer | NS-2035, NS-2055, NS-2081 |
| Rescue NDR | NS-2009, NS-2031, NS-2062 |
| Request reattempt | NS-2031, NS-2090 |
| Call customer | NS-2044, NS-2101 |
| Mark RTO / cancel | NS-2066 |
8. Example Order Decision Passport
Order: NS-2031 · Customer: Masked phone · Payment: COD · Value: ₹1,999 · Pincode: 395007 · Courier: Xpressbees · Risk: High
- COD order
- High-risk pincode
- Weak address
- High order value
- Courier has poor history in this cluster
Recommended action: Send COD confirmation + address correction. Offer prepaid incentive if confirmed.
Expected loss if RTO: ₹425 · Possible saving: ₹275-₹425
9. Example NDR Rescue Workflow
- 10:12 AM: NDR raised, customer unavailable.
- 10:14 AM: WhatsApp rescue queued.
- 10:21 AM: Customer selected reattempt tomorrow.
- 10:25 AM: Ops requested reattempt.
- Next day: Delivered.
Savings event: NDR rescued delivered, estimated ₹425 saved.
10. Savings Opportunity
Potential net benefit after ₹4,999 pilot fee at 20% reduction: ₹31,721.
11. Recommended 14-Day Pilot Plan
Day 1: Baseline audit and cost assumptions.
Days 2-3: Risk scoring and action queue setup.
Days 4-10: Daily COD verification, address correction, NDR rescue.
Days 11-13: Courier/pincode/SKU leakage analysis.
Day 14: Savings report and monthly plan proposal.
12. Privacy-Safe Audit Options
Option A: Summary-only review. Needs monthly orders, COD %, RTO %, shipping cost, and average order value. No customer data.
Option B: Anonymized CSV audit. Needs order ID, pincode, payment mode, order value, courier, shipment status, NDR reason, and final outcome. No customer name, phone, email, or full address.
Option C: Full 14-day pilot. Phone/address may be needed only if the seller wants actual WhatsApp and address-correction workflows.
Customer-level communication should only be used for delivery/RTO operations, not unrelated marketing.
Ready to test your own numbers?
This sample does not use real seller data.