COD/RTO guide

How to Use Your Last 100 COD Orders to Find Profit Leaks

A practical guide showing COD sellers how to use their last 100 orders to calculate confirmation rate, delivery success, RTO cost, net revenue, break-even CPA, and COD-adjusted ROAS.

COD ecommerce sellers, Shopify sellers, Meta Ads usersUpdated May 25, 2026
Check COD/RTO ProfitView Sample Report

Short answer

Your last 100 COD orders can show where profit is leaking before you scale ads.

You do not need perfect analytics to start. Export or list the last 100 orders, mark each order as confirmed, cancelled, dispatched, delivered, or RTO, then add courier fees, COD deductions, product cost, packaging, and ad spend.

This gives you a practical COD profit snapshot based on your own data.

Why this matters

Many COD sellers guess their profit.

They say:

I got 100 orders.

But the better question is:

Out of 100 orders, how many became paid cash after costs?

The last 100 orders can reveal:

  • weak confirmation
  • high cancellation before dispatch
  • poor delivery success
  • high RTO
  • courier cost problems
  • COD deduction problems
  • low-margin products
  • ad spend that is too high
  • cash stuck in remittance

This is better than using random benchmarks.

COD/RTO funnel explanation

Take the last 100 COD orders and split them into a funnel:

100 Placed COD Orders
→ Confirmed Orders
→ Dispatched Orders
→ Delivered Orders
→ RTO Orders
→ Net Cash Remitted
→ Profit After Costs

Each step answers a different question.

Placed orders

Did the ad or store generate demand?

Confirmed orders

Were the orders real and reachable?

Dispatched orders

How many orders were sent to courier?

Delivered orders

How many orders became paid revenue?

RTO orders

How many parcels created cost without revenue?

Net remittance

How much cash actually came back?

Profit

Was the batch worth scaling?

Calculation logic

Start with counts:

Confirmation Rate = Confirmed Orders ÷ Placed Orders
Dispatch Rate = Dispatched Orders ÷ Confirmed Orders
Delivery Success Rate = Delivered Orders ÷ Dispatched Orders
RTO Rate = RTO Orders ÷ Dispatched Orders

Then calculate paid revenue:

Paid Revenue = Sum Of Cash Collected From Delivered Orders

Then calculate cost:

Product Cost = Sum Of Product Cost For Delivered Orders
Forward Shipping = Sum Of Forward Shipping For Dispatched Orders
RTO / Reverse Shipping = Sum Of RTO Charges For Returned Orders
Packaging Cost = Sum Of Packaging Cost For Dispatched Orders
COD Fees = Sum Of COD Deductions
Ad Spend = Ad Spend Used To Generate These Orders

Then calculate profit:

COD Profit = Paid Revenue
- Product Cost
- Forward Shipping
- RTO / Reverse Shipping
- Packaging Cost
- COD Fees
- Discounts
- Refunds / Adjustments
- Ad Spend

Break-even CPA:

Break-even CPA = Profit Before Ads ÷ Placed Orders

A stricter COD view can calculate CPA on confirmed, dispatched, or delivered orders too. But for ad decisions, placed-order CPA is useful because ads usually generate placed orders first.

COD-adjusted break-even ROAS:

COD-adjusted Break-even ROAS = Gross Placed Order Value ÷ Maximum Safe Ad Spend

Only use this if you clearly understand whether the numerator is placed order value, delivered revenue, or net collected revenue.

What data the seller needs

Create a simple sheet with these columns:

  • order ID
  • order date
  • product or SKU
  • order value
  • product cost
  • ad source or campaign
  • confirmation status
  • cancellation reason
  • dispatch status
  • courier name
  • tracking number
  • delivery status
  • RTO status
  • cash collected
  • forward shipping fee
  • reverse or RTO fee
  • COD fee
  • packaging cost
  • discount
  • refund or adjustment
  • remittance date
  • net remitted amount
  • notes

You can start manually. Perfect tracking can come later.

Common mistakes

1. Taking the last 100 placed orders only

The last 100 placed orders are useful, but you must track what happened after placement.

2. Mixing different time periods

Use a closed batch where most orders already have final status. If many parcels are still in transit, mark them separately.

3. Ignoring pending COD remittance

Delivered does not always mean cash is already in the bank. Track remittance date.

4. Using average product cost for mixed products

If the last 100 orders include different SKUs, use SKU-level product cost where possible.

5. Treating all RTO as one problem

Split RTO reasons if possible:

  • customer refused
  • unreachable
  • wrong address
  • delayed delivery
  • price mismatch
  • damaged parcel
  • courier issue
  • duplicate/fake order

This helps fix the right leak.

How SellMira helps

SellMira can turn the last 100 COD orders into a clear profit leak report.

The report can show:

  • placed to confirmed drop
  • confirmed to dispatched drop
  • dispatched to delivered drop
  • RTO cost
  • forward and reverse shipping
  • COD fees
  • product margin
  • ad spend
  • break-even CPA
  • COD-adjusted break-even ROAS
  • cashflow delay

This gives the seller a practical decision:

Scale, fix, or stop?

Check your COD/RTO profit before scaling ads

Add forward shipping, reverse/RTO cost, COD fee, packaging, and ad spend to see whether placed COD orders are turning into collected cash.

Open COD/RTO Calculator

See a sample COD Profit Leak Report

Review how SellMira separates placed-order ROAS, collected COD ROAS, RTO loss, break-even CPA, and the first fix before scaling.

View Sample COD Report

Need a human check before increasing spend?

Request a one-time operational review of your COD funnel, RTO loss, courier fee logic, break-even CPA, and COD-adjusted ROAS.

Request Human COD Profit Audit

FAQ

Why 100 orders?

It is small enough for a seller to prepare manually and large enough to reveal basic patterns. If you have fewer orders, start with what you have.

Should I include pending orders?

Mark pending orders separately. Do not treat them as delivered or RTO until the final status is clear.

Should I calculate by campaign?

Yes, if the data is available. A campaign-level view is better than one blended store average.

Should I calculate by product?

Yes. COD profit can vary heavily by product because product cost, weight, price, and return behavior can differ.

What is the main number to look at?

Start with net profit after ad spend. Then look at which step caused the leak: confirmation, delivery, RTO, courier cost, COD fee, margin, or CPA.

Source notes and caveats

This guide uses no countrywide RTO benchmark, AOV, COGS, CPA, confirmation rate, or delivery rate.

It is designed around seller-owned data:

  • order export
  • courier report
  • remittance sheet
  • product cost sheet
  • ad spend report
  • manual confirmation notes

The last 100 orders should be recent enough to reflect current ads, products, courier process, and offer quality.