TikTok Shop Dashboard: ติดตามยอดขาย ค่าธรรมเนียม และกำไรจริง 2026
Sold 100,000 THB on TikTok Shop but don't know actual profit? A common problem is sellers see revenue in Seller Center but don't know true costs after fees.Having a dashboard to track sales, fees, and net profit shows your real monthly profit.
Data from Thai TikTok Shop sellers shows 60% don't know their true profit after all fees. This article covers how to build a professional TikTok Shop Dashboard with 7 daily metrics and a free Excel template that calculates profit automatically. If you need full-service TikTok Shop managementor an online fee calculator, check out our services.
What you will learn
- 7 daily metrics to track on TikTok Shop Dashboard
- How to calculate net profit after all fees
- Free Excel/Sheet template with auto profit calculation
- Dashboard examples from real stores (500K+ THB/month)
Why do you need a TikTok Shop Dashboard?
TikTok Shop Seller Center shows total sales but not net profit. Sellers must calculate themselves how much remains after fees. The more you sell, the more confusing costs become.
| Data | Seller Center | Pro Dashboard |
|---|---|---|
| Total Sales (GMV) | ✓ | ✓ |
| Commission Fee | ✓ | ✓ |
| Payment Fee | ✗ | ✓ |
| Shipping Cost | ✗ | ✓ |
| Returns | ✗ | ✓ |
| Net Profit | ✗ | ✓ |
Insight: Stores with professional dashboards increase profit by 25% because they know which products lose money to fees.
7 Daily Metrics to Track on Dashboard
Key Metrics for TikTok Shop
Orders
Today's sales vs monthly target
GMV (Gross Merchandise Value)
Total product value before fees
Commission Fee
4-10% depending on category (Beauty 5%, Fashion 10%)
Transaction Fee
3.21% of every order (VAT included)
Shipping Cost
Actual shipping cost (may differ from customer charge)
Return Rate
% of orders returned (avg 5-8% in Thailand)
Net Profit
GMV - all fees - product cost - shipping
TikTok Shop Profit Formula
The correct formula for calculating TikTok Shop net profit:
Calculation Formula
Gross Profit = GMV - Commission Fee - Transaction Fee
Net Profit = Gross Profit - Product Cost - Actual Shipping - Packaging
Profit % = (Net Profit / GMV) × 100
| Item | Amount (THB) |
|---|---|
| GMV (ยอดขายรวม) | 100,000 |
| Less: Commission (5%) | -5,000 |
| Less: Transaction Fee (3.21%) | -3,210 |
| Less: Product Cost (40%) | -40,000 |
| Less: Shipping + Packaging | -15,000 |
| Net Profit | 36,790 |
| Profit % | 36.79% |
* Example based on 100,000 THB sales, 5% commission category
Free TikTok Shop Dashboard Template
We created an Excel/Google Sheets template that calculates profit automatically. Just enter sales, costs, and expenses and the system calculates net profit with detailed fee breakdown by product category.
Template Features
- Auto profit calculation from TikTok Shop sales
- Category-specific fees (4-10%)
- Daily sales tracker table
- Automatic net profit calculation
- Sales and profit goal settings
Case Study: Cosmetics Store 800K THB/month
A Hypelive client, a cosmetics store selling on TikTok Shop with high sales but unknown actual profit. After using a tracking dashboard, found some popular products were actually losing money due to high shipping costs.
| Before Dashboard | After Dashboard |
|---|---|
| Only knew total sales, not per-product profit | Know profit per SKU, adjusted unprofitable products |
| Wrong shipping charges, hidden 8K THB/month loss | Adjusted shipping, profit increased 12% |
| Didn't know return rate | Reduced returns from 12% to 7% |
| Spent 2 hrs/day calculating in Excel | Auto dashboard, 5-min summary view |
* Data from actual Hypelive client (name changed for privacy)
Download Free Template
Excel/Sheets template with auto profit calculation, summary dashboard, product category settings, and complete fee calculation formulas.
Want a TikTok Shop Dashboard for your store?
Hypelive offers complete TikTok Shop Dashboard services combining sales, fees, and net profit in one dashboard with daily automated reports.
View Dashboard DemoRelated articles
Professional TikTok Shop Management
Let us help you from store setup, inventory management, marketing planning to data analysis for increased sales
