Seller Profit Guard

Return window loss worked example for a resellable item

Last updated: 2026-07-29

Written and reviewed by Seller Profit Guard Editorial Team.

For a $30 sale with $12 product cost, $5 fulfillment, 9% fees, an 18% return rate, $5 lost outbound shipping, $6 return shipping, $3 handling, 40% recovery, and a 20% target, expected return loss is $3.82 per order and adjusted contribution is $6.48.

What are the resellable-return inputs?

Use a public dummy $30 home-decor order. Product cost is $12, ordinary fulfillment is $5, and the combined fee assumption is 9%. The cohort returns 18% of orders. A returned order retains $5 outbound shipping, requires a $6 return label and $3 inspection, cleaning, repackaging, and support work. Forty percent of product cost is recovered through resale.

The scenario is one product, one currency, one policy period, seller-funded return label, ordinary condition on receipt, and no replacement shipment. It excludes tax, advertising, fixed overhead, inventory carrying time, and legal-policy analysis. The 40% recovery is an operating assumption supported by completed resale outcomes, not 40% of the original retail price.

Record why the item is considered resellable: it passes inspection, needs limited cleaning, retains required components, can be safely offered again, and has a documented markdown or recovery path. If those conditions are not met, route it to the unsellable scenario rather than forcing optimistic recovery.

How does the example calculate $21.20 loss per return?

Unrecovered product value is $12 × (1 − 0.40) = $7.20. Add $5 lost outbound shipping, $6 return shipping, and $3 handling. Loss per returned order is therefore $21.20. Multiply by the 18% return rate: expected return loss is $3.816 per original order, displayed as $3.82.

Fees are $30 × 9% = $2.70. Contribution before returns is $30 − $12 − $5 − $2.70 = $10.30. Subtract $3.816 expected return drag to obtain $6.484 adjusted contribution, displayed as $6.48. Dividing by $30 produces a 21.61% adjusted margin.

The 20% target requires $6 contribution. Pre-return headroom above that target is $10.30 − $6 = $4.30. Divide by $21.20 loss per return: the maximum return rate is about 20.28%. The entered 18% passes by only 2.28 percentage points, so small source errors are decision-relevant.

What stress test makes the apparent pass unsafe?

If recovery falls from 40% to 20%, unrecovered product value rises from $7.20 to $9.60 and loss per return rises to $23.60. At an 18% return rate, expected loss becomes $4.248 and adjusted contribution falls to $6.052, only $0.052 above the $6 target.

If return shipping also rises by $1, incident loss becomes $24.60, expected loss becomes $4.428, and adjusted contribution falls to $5.872, below target. The representative scenario passes, but a plausible combined change fails. The correct decision may be to improve evidence, narrow the policy, change packaging, reduce handling, or add price headroom.

Do not change multiple live levers without preserving a baseline. If listing clarity is the suspected cause, improve the product page and observe the same product cohort. If label cost is the driver, review carrier service or responsibility rules. A lower return rate does not prove which intervention caused it.

How should the worked example become an operating decision?

Classify the current result as a narrow pass with weak headroom. Keep the price and policy unchanged while validating recovery and return-label samples, or select a conservative stress assumption before a broader change. Assign an owner and review date; preserve the old inputs and expected outputs as a regression fixture.

Track frequency and severity separately. A lower number of returns can be offset by worse product recovery, while improved recovery can hide a rising return rate. Report returned-order loss, expected per-order loss, adjusted contribution, and target-safe ceiling together. Do not celebrate one metric while another deteriorates.

After any change, compare equivalent cohorts and record mix shifts. Search traffic or conversion may change simultaneously, but same-day movement does not validate the return formula. Close the loop only when authoritative inputs, repeated calculations, and observed outcomes agree within the chosen tolerance.

Which records support this resellable-return example?

Use a product-level return-rate cohort, not a shop-wide percentage copied from memory. Reconcile completed sales, returns, exchanges, cancellations, cases, refunds, fee credits, return labels, replacement shipments, inspection work, restocking outcomes, markdowns, and write-offs for the same analysis period. The calculator needs aggregate operating values; it does not need buyer identity or a raw order file.

Separate platform evidence from seller assumptions. Etsy's current guidance explains return-policy requirements, agreements, fee credits, cancellations, Purchase Protection, and regional legal boundaries. It does not supply a universal return rate, resale recovery percentage, product cost, labor rate, or shipping loss for a particular shop. Those values must come from controlled seller records or be labeled as provisional.

Freeze the source period, currency, product cohort, policy version, calculation version, inclusion rules, exclusions, and fingerprints. Reperform one public dummy fixture by hand. A matching fingerprint proves that a file did not change; it does not prove the cohort represents future orders. Recalculate after a product, package, carrier, policy, marketplace, or fee-scope change.

• Keep refund amount, fee credit, and retained operating cost on separate lines.
• Segment resellable, markdown, damaged, lost, exchanged, and abandoned returns.
• Use actual label and handling evidence where available.
• Treat Purchase Protection as conditional, never guaranteed recovery.
• Verify legal, tax, and accounting treatment separately.

Privacy boundaries for resellable-return example

Return analysis can be completed with aggregate counts, rates, product costs, shipping costs, handling costs, and recovery outcomes. Buyer names, email addresses, phone numbers, postal addresses, order IDs, tracking numbers, messages, personalization, payment data, and case narratives are unnecessary. Replace individual examples with public dummy fixtures and aggregate outcome categories.

Return reasons and messages may reveal health details, family events, protected traits, disputes, or other sensitive context. Do not paste them into the calculator, article, analytics event, ticket, email draft, or community post. Keep controlled evidence under the existing retention policy, redact exports, and use non-reversible fingerprints when proving that an input package remained unchanged.

Seller costs, defect rates, carrier adjustments, recovery percentages, and policy exceptions are commercially sensitive even without buyer data. Public pages should use rounded fictional examples. Seller Profit Guard performs this quick calculation in the browser and does not require Etsy credentials, but the operator remains responsible for handling any source files privately.

How to use the calculator for this resellable-return example

Enter sale price, product cost, fulfillment cost, combined percentage fee assumption, expected return rate, lost outbound shipping, return shipping, restock or support cost, resale recovery percentage, and target margin. The tool calculates unrecovered product value, adds the three incident costs, multiplies loss per returned order by return rate, and subtracts that expected drag from contribution before returns.

The primary output is expected return loss per original order, not loss per retained order and not the buyer's refund amount. The tool also reports loss per returned order, contribution before returns, adjusted contribution, and the maximum return rate that still meets the entered target. It does not model tax, legal eligibility, case outcomes, cash timing, inventory aging, or every fee-credit rule.

Run representative, adverse, and clearly out-of-scope scenarios. Reconcile the displayed values by hand, compare headroom with input uncertainty, and record a bounded use, hold, redesign, or rollback decision. A score is only a convenience signal; it is not an Etsy rating, probability of a return, accounting opinion, or promise of profit.

1. Define one product, period, market, policy, and outcome cohort.
2. Enter evidence-backed costs and clearly labeled assumptions.
3. Reperform loss per return and expected loss per order by hand.
4. Stress-test recovery, shipping, return rate, and target margin.
5. Record owner, decision, exception, next review, and rollback.

Sources and further reading

• Etsy Help: Refunds, Returns, and Exchanges for Sellers: Current Etsy seller guidance on listing return policies, return agreements, replacements, and Purchase Protection boundaries.
• Etsy Help: How to Cancel a Sale: Official workflow distinguishing a refund from cancellation and explaining related Etsy fee credits.
• Etsy Fees & Payments Policy: Current policy for transaction, payment-processing, listing, advertising, regulatory, and other seller charges.
• Etsy Seller Policy: Seller obligations, July 2026 return and case boundaries, buyer-data privacy, and region-specific legal responsibilities.
• Seller Profit Guard calculation methodology: Definitions for contribution, evidence hierarchy, editable assumptions, privacy, uncertainty, and non-advice limits.

Related Seller Profit Guard tools

• Open the Return Window Loss Calculator: Estimate loss per return, expected loss per order, adjusted contribution, and a target-safe return rate.
• Review refund fee impact: Separate buyer refund, fee credits, retained costs, cancellation, and operating loss.
• Calculate break-even ROAS and return loss: Connect expected incident loss to contribution, CPA, and ROAS decisions.
• Use the Etsy profit calculator: Reconcile actual order revenue, SKU cost, shipping, fees, and contribution evidence.
• Read the local-first methodology: Understand formula scope, source quality, privacy, and interpretation limits.
• Return Loss Formula: 10 Inputs Explained: Continue the return-loss evidence, calculation, and decision workflow.
• Return Loss for an Unsellable Item: Continue the return-loss evidence, calculation, and decision workflow.
• 12 Return Loss Calculator Mistakes: Continue the return-loss evidence, calculation, and decision workflow.
• Return Loss Data: 8 Reliable Sources: Continue the return-loss evidence, calculation, and decision workflow.
• Set a Safe Return Loss Threshold: Continue the return-loss evidence, calculation, and decision workflow.

Next step: Open the Return Window Loss Calculator.

This is operational planning help, not tax, accounting, legal, financial, or platform-policy advice. Review the Terms and disclaimer, and verify current platform rules and fee assumptions before changing prices.