True Cost of a Lost Dispute: A Step-by-Step Calculator

Most sellers measure a lost dispute by the refund. The refund is the visible part, but it is often not the true cost of a lost dispute: the product may not come back in sellable condition, the shipping and packaging are already spent, fees may or may not be reversed, and someone on your team spent time on the case. This guide gives you a step-by-step formula you can put into a spreadsheet, with an illustrative worked example, so you can put a real number on each loss.

If you want the wider picture of what a lost dispute does to your shop, including account health and visibility, read our companion article on the hidden cost of losing a dispute. This guide is the calculator.

Key Takeaways

• The refund is not a cost in itself, because the buyer's money is returned. The cost is what you spent on the order and cannot recover.
• Calculate a net loss per case: goods, shipping, packaging, unreversed fees and time, minus anything you recover.
• Divide that loss by your normal profit per order to see how many good sales it takes to make it back.

Why the Refund Is the Wrong Number

On Shopee, payment for an order is held under Shopee Guarantee until the buyer confirms receipt, as the Singapore Ministry of Home Affairs' marketplace safety page describes. Lazada similarly holds payment for a confirmation period. If a dispute ends in a refund, the buyer's money goes back to the buyer. You have not "lost" that revenue so much as never received it.

What you have lost is everything you put into the order: the product, the packaging, the shipping you paid, any fees that are not reversed and the time spent handling the case. Counting the refund as a cost and also counting the product cost double-counts the loss. A clean formula avoids this.

The True Cost of a Lost Dispute: The Formula

Use this formula for each lost case:

Net loss = Goods cost + Outbound shipping you paid + Packaging + Unreversed fees + Return shipping you paid + Handling time cost − Value recovered

Then, to understand the impact on your business:

Sales needed to recover = Net loss ÷ Normal profit per order

Each line is explained below.

Step-by-Step: Filling In Each Line

Step 1: Goods cost

Use your landed cost for the item: purchase price plus inbound freight and duties per unit. If you manufacture, use your unit cost. This is your COGS for the order.

Step 2: Outbound shipping you paid

Include only the shipping you actually paid or subsidised. If the buyer paid all shipping and you paid nothing, enter zero. Check your order's transaction details, because shipping arrangements vary by programme and campaign.

Step 3: Packaging

Box, mailer, filler, tape and any inserts. For most sellers this is a small number, but it adds up across many cases.

Step 4: Unreversed fees

Marketplaces charge commission, transaction and service fees. Whether these are reversed on a refund depends on the platform, the fee type and the outcome. Do not assume either way. Open the order's transaction or income breakdown in Seller Centre after the case closes and enter only the fees that were not given back. Our guide to Shopee and Lazada seller fees explains the main fee types.

Step 5: Return shipping you paid

If the item came back and you bore the return shipping cost, enter it here. If the platform or buyer covered it, enter zero.

Step 6: Handling time cost

Estimate the time spent reading the claim, finding evidence, writing the response and checking the returned parcel. Multiply by an hourly cost for whoever did the work. If you handle cases yourself, use what your time is worth to the business. This line is easy to ignore and often surprisingly large.

Step 7: Value recovered

Subtract anything you get back:

• The resale value of the returned item if it can be sold again (full price, as a discounted "open box" item, or for parts)
• Any partial amount you kept, for example after a partial refund
• Any courier compensation you receive for damage in transit

If the item was not returned, or came back unsellable, this is zero.

Step 8: Sales needed to recover

Work out your normal profit on a completed order of the same product: selling price minus goods cost, shipping you paid, packaging and fees. Divide the net loss by this figure. The result tells you how many good orders you need to make up for one lost case.

Illustrative Worked Example

The figures below are illustrative only. They are not platform fee rates or real order data. Replace every number with your own.

Suppose you sell an item for S$60 on Shopee. Your goods cost is S$25, packaging is S$1, you subsidise S$3 of shipping, and the fees on the order come to S$6. A buyer files a damage claim, the dispute is decided in the buyer's favour, and the item comes back unsellable. You paid no return shipping. The case took you 30 minutes, and you value your time at S$20 an hour. When you check the transaction breakdown, the fees were not reversed.

Line	Amount (S$)
Goods cost	25.00
Outbound shipping you paid	3.00
Packaging	1.00
Unreversed fees	6.00
Return shipping you paid	0.00
Handling time (0.5 h × S$20)	10.00
Value recovered	−0.00
Net loss	45.00

Normal profit on a completed order of this item is S$60 − S$25 − S$3 − S$1 − S$6 = S$25.

Sales needed to recover = S$45 ÷ S$25 = 1.8 orders.

In other words, in this illustration, one lost case wipes out the profit from nearly two good sales.

Variation A: the item comes back sellable

If the returned item can be resold at full price, value recovered is the goods cost of S$25. The net loss drops to S$20, or 0.8 orders. This is why inspecting and photographing returns on arrival matters: it tells you which line you are in.

Variation B: the fees are reversed

If your transaction breakdown shows the S$6 of fees returned to you, the net loss in the main example falls to S$39. Always check rather than assume.

Costs This Formula Leaves Out

Some effects of a lost dispute are real but hard to price per case, so they are better tracked separately than guessed:

• Account health. On Shopee, MHA's summary of the seller penalty system says orders "cancelled, returned or refunded due to seller fault" count towards a non-fulfilment standard, and accumulated penalty points can lead to removal of privileges such as campaign eligibility or listing visibility.
• Ratings and reviews. A buyer who felt unheard may leave a poor review.
• Repeat claims. A loss with no evidence can leave you with nothing to learn from, so the same gap repeats.

Track these as counts alongside your monetary loss. If you want a single figure, add a clearly labelled estimate of your own, and keep it separate from the hard costs.

Your Calculator Checklist

Set up a spreadsheet with one row per lost case and these columns:

• Order number, platform, date closed, dispute reason
• Goods cost
• Outbound shipping you paid
• Packaging
• Unreversed fees (from the transaction breakdown)
• Return shipping you paid
• Handling minutes and hourly cost
• Value recovered
• Net loss (formula)
• Normal profit per order (formula)
• Sales needed to recover (formula)
• Evidence available (yes or no for dispatch photos and video)

Review it monthly. Sort by net loss and look at the top cases first.

Using the Number to Decide What to Fight

The formula is not only for counting losses. It helps you decide where effort pays off.

If your typical net loss on a product is small and your evidence is weak, accepting the return may cost less than a long defence. If a product's losses are large and keep recurring, that product deserves better dispatch evidence: continuous packing video, weighed parcels and serial numbers. Our packing station evidence collection SOP is a practical place to start.

Compare the column "evidence available" against outcomes over a few months. If cases with dispatch video lose less often, you can put a value on filming more parcels.

Frequently Asked Questions

Should I count the refund as a cost?

Not on top of goods cost. The refund returns the buyer's payment, which was held by the platform. Your cost is what you spent on the order and could not recover. Counting both double-counts the loss.

Are platform fees refunded when a buyer gets a refund?

It depends on the platform, the fee type and the outcome, and rules change. Check the order's transaction breakdown in Seller Centre after the case closes and use what it shows.

How do I value my own time if I run the shop alone?

Use a consistent hourly figure that reflects what your time is worth to the business, and apply it to every case. Consistency matters more than precision.

What if the returned item is only partly sellable?

Enter the realistic resale value, such as an open-box price or the value of usable parts, as value recovered.

How is this different from your hidden-cost article?

That article explains the full range of consequences of a lost dispute. This one is a calculator: a formula and spreadsheet you can apply to each case.

Put a Number on Every Loss

The true cost of a lost dispute is rarely the refund. It is goods, shipping, packaging, unreversed fees and time, minus what you recover. Once you calculate it per case, it becomes clear which products need better evidence and which cases are not worth fighting.

Hail Pilot helps you keep each case, its evidence and its outcome together by order, track dispute deadlines and capture dispatch photos at the packing table. Learn more at https://hailpilot.com.