Anatomy of E-commerce Platform Statements: Orders, Settlements, Service Fees and Commissions
Why Statements Are Hard to Read at First Sight
Every platform designs its statement around its own funds logic: some issue line-by-line per order, others aggregate over a settlement cycle. The same "commission" is called an operations support fee on JD, a technical service fee on Douyin, and a referral fee on Amazon. The first step of reconciliation is not comparing numbers — it is translating statement structures into a unified financial language.
Statement Composition Across Major Platforms
JD POP settles monthly, with the settlement statement separated from the JD Wallet cash flow; the two must be tied together. Revenue is the merchandise payment; deductions include the operations support fee (category-based commission), Jingdou credits, platform usage fees, Jingzhuntong advertising, shipping insurance and reverse logistics fees on aftersales.
Douyin Shop settles each order after delivery confirmation, on a schedule tied to the store's experience score. The technical service fee equals a settlement base multiplied by the category rate — and the base includes the buyer's actual payment (shipping included) plus livestream coupons, platform coupons and payment subsidies. Influencer commissions are deducted separately.
Pinduoduo charges a base technical service fee of (buyer payment + platform coupon amount) × rate — commonly 0.6% — plus category-specific fees for certain verticals. Since September 2024, the base fee is refunded proportionally on refunded orders.
Amazon produces a Settlement Report roughly every 14 days in Flat File V2 or XML, with rows grouped by transaction type: Order lines (Principal, Shipping, GiftWrap, ItemTax), Refund lines, and service fees such as the referral commission and FBA fulfillment fees. Storage fees appear as periodic charges, and advertising is billed separately.
Three Calibers That Commonly Go Wrong
- The service-fee base is not the list price. On Douyin, coupons and subsidies may still count into the base, so verifying against the item price never reconciles.
- Commission and advertising are separate lines. Mixing ad spend into the commission caliber distorts margin analysis.
- Fee reversal rules on refunds differ per platform: recalculated at settlement (Douyin), refunded proportionally (Pinduoduo), or appearing as later Refund rows (Amazon). You must know whether fees are recognized at order time or settlement time.
A Minimal Unified Field Set
Normalize every statement row to: platform and store code, business order number (with sub-order number), line type (goods payment, service fee, commission, ad fee, shipping insurance, refund, adjustment), amount at Decimal(20,4) precision with income positive and expense negative, currency, business timestamp, and a raw-row snapshot so any normalized value traces back to the original statement line. Maintain the mapping as scripted, testable, rollbackable assets — when a platform changes its statement layout, you respond in hours, not weeks.