TikTok Shop Dashboard: ติดตามยอดขาย ค่าธรรมเนียม และกำไรจริง 2026
Sold 100,000 THB on TikTok Shop but do not know actual profit? Many sellers find sales look good but profit is less than expected because they do not account for fees, shipping, and returns.
Data from Thai TikTok Shop sellers in 2026 shows an average of 23% of sales is deducted as various fees. This article teaches how to build a dashboard tracking key metrics, with an Excel template for automatic profit calculation. Need full TikTok Shop managementor automated store management? We can help.
What you will learn
- All TikTok Shop fees you need to know
- How to calculate net profit from sales
- Excel template with auto calculations
TikTok Shop Fees to Deduct from Sales
TikTok Shop has various fees deducted from sales before paying sellers. Understanding these costs helps price products appropriately.
| Fee Type | Rate | Note |
|---|---|---|
| Commission | 2-5% | Depends on product category |
| Payment fee | 2-3% | Deducted from every payment |
| Shipping fee | 35-65 บาท | Or by weight/size |
| Return fee | 10-20% | Of product value |
* Numbers may change according to latest TikTok Shop policies
TikTok Shop Net Profit Formula
Calculation Formula
Net Profit = Sales - COGS - Total Fees - Shipping
Total Fees ≈ 5-10% of sales
Example: Sell product for 1,000 THB, cost 400 THB
| Item | Amount (THB) |
|---|---|
| Sales | 1,000 |
| Product cost | -400 |
| Commission (3%) | -30 |
| Payment fee (2%) | -20 |
| Shipping | -45 |
| Net Profit | 505 |
Key Metrics to Track in Dashboard
| Metric | Description | Target |
|---|---|---|
Total Sales | Revenue before deductions | Monthly target |
Net Profit | After all expenses | ≥ 20% of sales |
Profit Margin | Profit per sales % | 30-40% |
Also track return rate, ad costs (if any), and average order value to adjust store strategy.
Download Excel Template
This template auto-calculates profit. Just enter sales and costs, the system calculates fees and profit instantly.
TikTok Shop Profit Calculator
Excel Template (.xlsx)
Frequently Asked Questions
Q: When does TikTok Shop deduct fees?
A: Fees are automatically deducted before transferring to seller account, typically 7-14 days after shipping.
Q: What profit margin should I set?
A: Recommend at least 30-40% after deducting costs and fees, as there are other hidden expenses.
Need full TikTok Shop management system?
Our expert team helps set up systems, analyze numbers, and increase your store sales.
Free ConsultationProfessional TikTok Shop Management
Let us help you from store setup, inventory management, marketing planning to data analysis for increased sales