D2 Insights
TikTok Shop Files Required for P&L
You do not need every Seller Center export to build an initial P&L. You need the right source for sales, payout, Ads and product cost, connected by consistent identifiers and period rules.
Direct answer
The short answer
For an initial TikTok Shop P&L, start with four evidence groups: Orders, Settlement/Income, Ads spend and a SKU cost master. Add on-hold settlement and other variable-cost sources when the reporting objective requires cash reconciliation or more complete contribution analysis.
Formula / operating model
A repeatable definition
Minimum evidence set = Orders + Settlement/Income + Ads + SKU cost master
01
1. Orders
Use Orders for created date, SKU, quantity, status and sales-period revenue. Preserve the raw export so future rule changes can be traced back to the original platform evidence.
02
2. Income / Settlement
Use settled and on-hold data to distinguish money already paid from amounts still pending and to inspect recorded deductions. Keep sales-period P&L separate from payout timing.
03
3. Ads
Use campaign data for Ads spend and performance within the same reporting scope. Declare the time zone and period so spend is not compared against a mismatched sales window.
04
4. COGS and off-platform costs
Map COGS by SKU and effective date. Add packaging or other variable costs separately when the reporting objective requires them, rather than hiding them inside an unexplained average margin assumption.
05
5. Exception log
Maintain a list of unmapped SKUs, unmatched settlements, missing cost records and other unresolved items. A transparent incomplete report is safer than a complete-looking report built on silent assumptions.
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 for created date, SKU, quantity, status and sales-period revenue
- Settled and on-hold Income / Settlement for payout timing and recorded deductions
- Campaign Overview or equivalent Ads source for spend in scope
- COGS master plus packaging or other off-platform variable costs when applicable
Decision rule
What this should change operationally
Choose each source based on the question it answers. Preserve raw files, document mappings and surface exceptions before automating the final P&L view.
Next step