Refunds distort profit
Community signal
Refund timing and type quietly change which SKU is winning. A late refund overstates last period; a damaged return is a pure loss.
In real life: Sold in one month, refunded the next; last month looked profitable, this month carries the hit.
Shopify / DTCShopeeTikTok ShopLazada
Data you need
- requiredRefund amount and date. To book it in the right period.
- optionalRestocked vs damaged flag. Restock recovers COGS; damaged does not.
Formula
Net revenue after refunds
Gross Revenue - Refunds (in the correct period)COGS is recovered only if the item is restocked.
Key insight
- Period mismatch overstates the selling month.
- Damaged returns lose COGS twice: no resale, paid shipping.
Action checklist
- 1Book refunds in the correct period · medium · 30 min
Match the refund to the sale month. - 2Split restocked vs damaged returns · medium · 30 min
Recover COGS only when resold. - 3Review SKUs with high return rate · easy · 20 min
They may be silent losers.
Money impact · Protect margin
Stops refund timing and type from hiding the SKUs that actually lose money.
Common mistakes
- Always recovering COGS, even on damaged returns.
- Ignoring which period a refund belongs to.
How Okiela helps
Refund-aware waterfalllive
Okiela subtracts refunds in the engine and keeps margins reconciled.
Trust & sources
- Community signalRefund accounting is a known accuracy trap
Last reviewed 2026-06-22 · Confidence 4/5