Refund and Aftersales Reconciliation: Matching the Reverse Cash Flow

Why Reverse Cash Flows Are Hard to Match

The forward flow is simple: the buyer pays, the platform deducts fees, the remainder settles to the merchant. Aftersales reverses the flow — untidily. A refund may land before settlement (offsetting the current cycle) or after (clawed back next cycle); partial refunds must reverse fees proportionally; exchanges may spawn an entirely new order. The core of reverse reconciliation is a complete chain: original order ↔ aftersales case ↔ funds clawback.

Funds Impact of the Three Aftersales Forms

Refund only (no return). The buyer is refunded in full or in part; statements either reduce the settlement amount directly or show a refund row later. With partial refunds, verify that fees were reversed proportionally. Return and refund. The merchandise payment goes back, possibly with reverse logistics fees; the warehouse receipt and the refund happen at different times, so both inventory and cash sides must be tracked. Exchange. The original order is refunded or closed and a new order settles separately — the two order numbers must be linked to prevent double-counting revenue.

Platform Refund-Fee Rules to Verify

On Douyin, technical service fees and influencer commissions are computed on the amount that finally participates in settlement — refunds before settlement naturally shrink the fee base, so the real work is verifying full reversal when a refund happens after settlement. On Pinduoduo, since September 2024 the base technical service fee is automatically refunded in proportion to the refunded amount; treat the fee refund as its own reconcilable line rather than watching only the merchandise refund. On JD POP, reverse shipping fees, shipping-insurance payouts and refunded merchandise are separate fee items scattered across the statement, and insurance payouts travel a separate channel. On Amazon, refunds appear as Refund transactions in later settlement cycles, with the referral fee returned proportionally (mind the refund administration fee rules) — cross-cycle matching is the norm.

A Reverse-Reconciliation Checklist

One hundred percent of aftersales cases must link back to an original order number; investigate the sync pipeline for any that cannot. Partial refunds must verify against the original amount. When merchandise is refunded, confirm the corresponding service fees and commissions are reversed or returned, verified per platform rules. Where an invoiced order is refunded, check the red-letter invoice is issued promptly and the invoice side agrees with the funds side. At period end, keep a parked list of refunded-but-unsettled and settled-but-unrefunded documents that auto-clears against the next cycle. Duplicate refund rows for one aftersales case go straight into the disputed-variance process.

Alignment with Revenue Recognition

Whether a refund offsets revenue in the period it occurs or the period originally recognized must align with accounting policy — e-commerce practice usually offsets current-period revenue with red-letter invoicing. The reconciliation system should support reporting under both calibers so business reconciliation and ledger treatment never contradict each other. Done well, reverse reconciliation makes aftersales costs truly visible: how much margin each platform's refund rate eats and what each aftersales type costs in reverse logistics — numbers that drive operating decisions.