D2 Insights
TikTok Shop Fees & Settlement
An order created today may settle later. Sales performance and cash received therefore need separate time bases even when both are reconciled through the same order-level evidence.
Direct answer
The short answer
Use Orders to explain what sold in a reporting period and Settlement to explain what the platform paid or deducted. The two datasets should reconcile through stable identifiers, but their dates should not be treated as interchangeable.
Formula / operating model
A repeatable definition
Expected payout = settled order value − recorded fees − commissions − refunds/adjustments ± platform settlement adjustments
01
Orders describe the sales period
Use order data for created date, SKU, quantity, status and order-level revenue. This keeps commercial performance anchored to when the customer transaction occurred.
02
Settlement describes payout and deductions
Use Income/Settlement to inspect payout, platform fees, creator commission, refunds and other adjustments recorded by the platform. Fee names and rules can change, so settlement evidence should remain the source of truth for realized deductions.
03
Reconciliation needs a declared key and period rule
Standardize order IDs, SKU mapping, currencies and timestamps before calculating P&L or cash flow. Unmatched lines should be visible instead of silently dropped.
04
Pending settlement is not missing revenue
A valid order may still be unsettled at the end of the reporting window. Treat that as a timing difference between commerce performance and cash realization rather than automatically classifying it as a revenue error.
Evidence
Data required to support the analysis
Use the source that answers the question it was designed to answer, preserve raw evidence and keep unresolved mappings visible.
- Orders export for order identifiers, SKU, status and created date
- Settled Income / Settlement for realized payout and deductions
- On-hold or unsettled data for amounts not yet realized
- A reconciliation table that preserves unmatched records as exceptions
Decision rule
What this should change operationally
Report sales-period performance and cash settlement as two views. Reconcile them; do not collapse them into one timestamp or one revenue number.
Next step