Account for returned orders in a planning scenario

Returned orders can create costs beyond the refunded selling amount. Model transport, inspection, packaging and the condition of the returned product separately.

Use your own evidence where available. The numbers here are hypothetical scenarios, not a prediction of your return rate or legal guidance on return rights.

Separate the events

A cancellation before dispatch, an undelivered parcel and a customer return after receipt are different events. Their costs and stock outcomes may differ.

Do not apply one blended percentage without understanding what it includes.

Keep the applicable customer policy and legal obligations separate from the cost model. A calculation does not determine whether a return must be accepted.

Define an incremental cost scenario

Suppose a returned item can be resold and the additional reverse transport, inspection and repacking cost totals ₹120.

If a planning scenario assumes five such events per one hundred dispatched orders, the incremental cost is ₹600 across that group, or ₹6 per dispatched order.

This only models the stated incremental costs. It does not by itself account for lost revenue, original delivery expense or a damaged product.

Handle refunded revenue correctly

If the sale is refunded, do not keep the original revenue in the model as though the transaction remained completed.

Likewise, do not count the full product cost as permanently lost if the item returns to usable stock and your accounting treatment recognises that recovery.

Use a consistent method and seek accounting advice where needed. The aim is to avoid both optimistic omission and double counting.

Separate resellable and unsellable outcomes

A returned unopened item may differ from a personalised or damaged one. Create separate scenarios when the difference is material.

Record realistic recovery value rather than assuming every return is either worthless or fully recoverable.

Inspection and repacking may still be required even when the product can be sold again.

Use observed data carefully

A small number of orders may not provide a stable rate. Label the observation period and event count.

Do not import an industry percentage from another product category and present it as your expected result.

When evidence is limited, use a range of scenarios to understand exposure rather than choosing a precise figure that looks authoritative.

Inspect the cause

Wrong product information, packing errors and delivery failure may need different remedies. A cost allowance should not replace investigation.

If one variant repeatedly returns because its dimensions are unclear, improving the page may be more useful than increasing every price.

Keep customer information limited to what is needed for the operational review.

Include timing

Cash may leave before returned stock becomes available again. A later resale does not eliminate the temporary cash and inventory effect.

Track when refunds, transport charges and restocking occur if timing matters to the business.

A contribution model and a cash plan answer related but different questions.

Compare offers with the same return assumptions

If you evaluate a discount or new channel, keep the return-cost boundary consistent. Do not make one option appear better by ignoring its potential reverse costs.

At the same time, do not assume the new arrangement has the same rate without evidence.

Record uncertainty and review the result after enough relevant activity.

Reconcile the allowance periodically

Compare the planning allowance with the actual event costs over a relevant period. A difference is a prompt to inspect assumptions, not a reason to alter records to match the model. Separate a change in event frequency from a change in transport or repacking cost so the next estimate has an explainable basis.

Keep the model transparent

List event type, assumed frequency, incremental cost, revenue treatment and stock recovery. A reviewer should be able to identify what is included.

Use the model to plan capacity and investigate product information, packaging and fulfilment. Do not use it to justify unfair or unclear treatment of customers.

Returns are part of the operating picture. A useful cost scenario makes their consequences visible without pretending that one generic percentage describes every order.