Your weekly report showed a profit. Days later, the buyer returned the item and a correction appeared. Looking only at the original sale date or the return date can double count revenue or hide costs that remain. Here is a practical way to reconcile one transaction.
1. Match the return to the sale
Record the order identifier, SKU, buyout date and return transaction. Marketplace reports do not all use the same structure: a direct link may exist, or you may need several fields to match the records. A matching amount and date alone are weak evidence.
Keep both periods visible: when the sale was recognized and when the return was reported. They answer different questions about profit and cash flow.
2. Inspect each amount
For the matched pair, list sale revenue, refund, commission and any adjustment, outbound and return logistics, advertising, compensation, deductions and purchase cost. A blank field is not necessarily zero; mark it unknown until you check the source report and marketplace terms.
Illustrative example: an initial view shows 200 RUB profit for one SKU. A late return does not mean you can simply subtract the item price. First establish which amounts were reversed, which costs remain and whether the item returned to saleable inventory. Only then revise the result. This is a teaching example, not a marketplace tariff or customer outcome.
3. Separate profit from payout
The return can affect a different payout from the original sale. Maintain two views: transaction economics and cash movements by period. Our previous guide to orders, buyouts and payouts explains why these figures cannot be equated. A late return makes the difference clearer.
4. Preserve the correction trail
For every amount, record its source, report download date and the rule used to revise profit. If the marketplace issues a new file version, keep both versions and the changed rows. Then a revised profit number has an explanation rather than appearing to be an analytics error.
ProfitVena helps compare available marketplace data, returns, configured costs and supported Excel/CSV imports at SKU level. Completeness depends on sources, product mapping and accounting rules; verify disputed amounts against the marketplace's original documents. The technical side has been updated in ProfitVena. It is part of the Wicsora ecosystem.
The check is complete when each late return has a linked sale, an explicit set of adjustments and a revised profit figure, while payouts are reconciled separately.
