The profit that vanishes after the sale: cancellations and returns
The sale was approved, the margin showed green on the dashboard — and three weeks later came the return. The problem is that, for most systems, the profit from that sale remains the approval profit. It never “corrects” the real loss. Let’s talk about the money that disappears in the post-sale.
The real profit of a canceled or returned sale is not the same as what appeared when the order was approved. To calculate the real margin order by order, you must replace the approval financials with the cancellation financials — considering who bore the refund, how much of the shipping was retained, and whether the return has been finalized. Without this adjustment, your monthly P&L may be inflated with profits that never entered your cash flow.
Every multi-channel seller knows the frustration: the order is paid, logistics flow, and weeks later a complaint, mediation, or return appears. The product comes back (or not), the money is refunded, and in many cases, you still bear the outbound and return shipping costs. Yet, in traditional reports, that sale is still accounted for with the original profit — as if nothing happened. The result is a misleading sense of performance, hiding silent losses and distorting the business's profit intelligence.
To turn this feeling into numbers, you need to scrutinize each cancellation and separate what is a real loss from what is just a scare covered by the marketplace.
Not all cancellations are equal
Cancellations have different natures, and their financial impact varies radically. A buyer who regrets before shipping causes operational hassle, but the cost is usually low. However, a complaint that escalates to mediation, with a product in transit and shipping involved, can significantly bleed the margin. Therefore, it makes sense to focus attention on cancellations that went through mediation — these have the greatest potential to erode real profit.
Within this group, the question that separates loss from non-loss is: who benefited from the complaint resolution?
- If Mercado Livre (or another marketplace) covered the refund out of its own pocket, your original sale still stands. You didn't lose the product money. It's a "covered" cancellation.
- If the buyer was benefited at your expense, then you truly lost. It's a "loss."
This distinction doesn't appear in an obvious "canceled yes/no" field. It's hidden in the detail of the complaint resolution — and it's exactly the kind of information that a profit intelligence system needs to investigate order by order to deliver the right number. Without this separation, you might be treating as a loss something that never left your pocket, or worse, considering as profit a sale that has already become a hole.
Return shipping: the cruelest hidden cost
If mediation cancellation is already a villain, return shipping is its silent accomplice. In a return, there can be two shipping costs working against you: the outbound shipping (already paid in the original operation) and the return tariff (charged when the product comes back). The decisive question here is: was this shipping retained from you or refunded?
Not every shipping amount that appears in a return transaction stays with the marketplace. Part may be refunded back to the seller, depending on the applied policy and the reason for the return. Therefore, the real shipping loss is not "everything that appeared in the transaction" — it's only the portion that was effectively retained and doesn't come back. Summing everything overestimates the loss; ignoring everything underestimates it. The right number is the net retained amount.
A good transfer audit practice: when the retained shipping value is not yet confirmed (because the return is in progress or the analysis hasn't been completed), this field should remain blank, never treated as zero. "I don't know yet" is completely different from "it cost zero" — and treating one as the other is the loophole through which loss hides in reports.
Beware of the "not yet finished"
There's a temporal detail many sellers ignore: while the returned product is still in transit, the retained value can change. After the item arrives at the distribution center and is reviewed, the marketplace may adjust how much was actually deducted — for example, if the product arrived damaged, with missing parts, or not as described. Closing the number of an order whose return is still traveling is nailing down a loss that will still change.
The correct approach is to mark these orders as "in transit" and reassess them when the return is finalized. Only then does the month's profit reflect the cash reality, not a provisional snapshot that may prove wrong days later.
What to take from this article
- The profit of a canceled sale is not the approval profit. It needs to be recalculated with the real cancellation financials.
- Not every cancellation is a loss: when the marketplace covers from its own pocket, the original sale stands; when you pay, it's a loss.
- Return shipping is only a loss in the retained portion — the refunded part doesn't count.
- Unconfirmed value should remain blank, never treated as zero.
- Return in transit means a provisional number; reassess when finalized.
Jodda is evolving to record the real financials of cancellations and returns — separating loss from coverage, calculating net retained shipping, and respecting what is still in transit. This way, your "monthly profit" stops being the approval profit and becomes what actually entered your cash flow. Because profit intelligence is about decisions based on reality, not assumptions.