A sale appears in the report, then the customer sends the item back. Revenue changes, but expenses do not necessarily disappear with it. To understand the result, connect the events for one SKU and separate reversed amounts from costs already incurred.
Five checks after a return
1. Link the events. Identify the SKU and variant, seller account, order, sale and return. Do not merge different sizes or colors just because they share one listing. The sale and adjustments can fall into different reporting periods.
2. Check the revenue reversal. Determine which sale amount was reversed or adjusted. Do not subtract it twice from revenue that is already net of returns. A bank payout is a separate reconciliation, not profit itself.
3. Reconcile every charge. Review commission and its adjustment, outbound and return logistics, handling, storage, advertising and compensation. Every number needs a source. A missing row means “unknown until checked”, not automatically zero.
4. Establish the item's condition. It may become sellable again, need repacking or markdown, or have to be written off. Restore inventory cost only under your accounting rule and once condition is confirmed. Do not recognize a hypothetical second sale in advance.
5. Recalculate by SKU. Compare more than return rate: include cost per return, restored inventory value, unrecovered charges and the result after late adjustments.
Worked example
Before the return: price RUB 3,000, product cost RUB 1,050, commission RUB 450, advertising RUB 240 and outbound logistics RUB 180. Illustrative contribution is RUB 1,080. After the return, establish whether commission was reversed, how product cost was treated and which services remained charged. Suppose outbound logistics of RUB 180 and advertising of RUB 240 remain, with RUB 220 return logistics and RUB 90 repacking. Costs already incurred total RUB 730. This is not the final transaction loss: fees, compensation and item condition still require confirmation. The figures are educational, not a marketplace tariff or typical result.
A practical reconciliation sheet
Keep raw reports unchanged. In a separate sheet track order_id, sku, sale_date, return_date, sale_amount, reversal, fee_reversal, outbound_logistics, return_logistics, ads, item_status, cost_restored, source_period. For each difference, record the source row and a follow-up date. That prevents late charges from disappearing across month-end. This is a suggested method, not a claimed product export.
Where ProfitVena fits
ProfitVena brings sales, returns and verified expenses together. Profit Engine helps connect revenue with configured costs; Product 360 adds product-level sales and returns context. Completeness depends on connected sources, data freshness and populated unit costs. A late adjustment may change a previously reviewed period.
Technical part updated in ProfitVena. ProfitVena is part of the Wicsora ecosystem.
For the broader method, read how to calculate real marketplace profit.
