How to calculate true profit when selling on Shopee, TikTok Shop and Lazada
A step-by-step formula from listed price to profit after marketplace fees, cost of goods, returns and ads, with a worked example on three channels and a self-check list.
By The DataxLand team· · 6 min read
Ask a seller on three marketplaces "how much profit did you make last month?" and the answer is usually a revenue number. Revenue is the biggest figure on every seller dashboard, but between revenue and the money that actually stays with you there are at least seven deductions — and each marketplace takes them in its own way, at its own time. This post walks through every deduction, gives one formula that works for Shopee, TikTok Shop and Lazada, and applies it to a concrete data set so you can see how large the gap is.
All numbers in this post come from the DataxLand sample data: a simulated scented-candle and essential-oil shop selling on Shopee, TikTok Shop and its own website from 1 August to 29 October 2026. They are not a real customer's numbers.
Four layers of "revenue"
Most confusion starts with which revenue you are talking about.
| Layer | How it is computed | Who usually uses it |
|---|---|---|
| GMV (gross revenue) | Price × quantity, before any discount | Marketplace dashboards, campaign reports |
| Revenue after discounts | GMV − shop discounts − shop vouchers allocated to each line | Order exports |
| Net revenue | Revenue after discounts − refunds paid to buyers | Accounting, P&L |
| Payout | Net revenue − all settled marketplace fees | Marketplace settlement |
In the sample data, three-month GMV is 831,421,000 ₫, but net revenue is only 755,554,000 ₫: 75.9 million ₫ went to discounts, vouchers and refunds before a single fee was charged. Plan purchasing on GMV and you are planning on a number about 10% too high.
One formula for every marketplace
Fee names differ, but the structure of profit is always the same. DataxLand uses exactly this chain for its profit after fees metric (a versioned definition — see the metrics reference):
Net revenue = Σ (price × qty − line discount − allocated order voucher) − refunds
Contribution margin = Net revenue − COGS − platform fees − payment fees − shipping − return shipping
Profit after fees = Contribution margin − allocated ad spend
Net margin (%) = Profit after fees ÷ Net revenueThree rules keep the formula from double counting:
- Refunds are deducted once, in net revenue. Return shipping is a separate cost, not a refund.
- COGS uses the cost on the order date, not the latest purchase price. A more expensive October batch must not change September's profit.
- Ad spend is allocated to orders with a fixed, written-down rule (for example by product revenue within the channel).
What each marketplace deducts
Fee names and rates change several times a year, so the table describes fee types, not a rate card. Always check your own Seller Centre for current rates; they vary by category, shop type (Mall or standard) and the programmes you join.
| Deduction type | Shopee | TikTok Shop | Lazada | Line in the formula |
|---|---|---|---|---|
| Category fee | Fixed fee | Platform commission | Fixed fee | Platform fees |
| Per-transaction fee | Transaction processing fee (called payment fee before 24 Apr 2026) | Transaction fee | Order processing fee | Payment fees |
| Programme fees | Voucher Extra, Freeship Extra (if joined) | Voucher Extra (if joined) | Promotion packages (if joined) | Platform fees |
| Fixed fee per order | Infrastructure and other service fees | — | Technical infrastructure fee | Platform fees |
| Shipping borne by the shop | Shipping difference | Shipping difference | Shipping difference | Shipping |
| Return leg | Return shipping | Return shipping | Return shipping | Return shipping |
| Advertising | Shopee Ads | TikTok Ads, GMV Max | Sponsored Solutions | Ad spend |
The key point: no marketplace sends you a profit number. The settlement tells you your payout, but it does not know your cost of goods, does not know you run Facebook Ads for your website, and does not know which orders get returned later.
Worked example: three channels, three stories
Applying the formula to the sample data (1 Aug – 29 Oct 2026):
| Metric | Shopee | TikTok Shop | Website |
|---|---|---|---|
| Net revenue | 397,961,000 ₫ | 228,021,000 ₫ | 129,572,000 ₫ |
| Contribution margin | 128,090,600 ₫ | 42,093,900 ₫ | 54,186,700 ₫ |
| Contribution margin / net revenue | 32.2% | 18.5% | 41.8% |
| Ad spend | 38,163,000 ₫ | 55,896,000 ₫ | 41,011,000 ₫ |
| Profit after fees | 89,927,600 ₫ | −13,802,100 ₫ | 13,175,700 ₫ |
| Return rate | 2.7% | 12.4% | 3.2% |
The shop as a whole made 89,301,200 ₫ on 755.6 million ₫ of net revenue — a net margin of about 11.8%. But the total hides three things:
- Shopee earns almost all of the profit: high contribution margin, moderate ad spend.
- TikTok Shop loses money after ads. It is the second channel by revenue, but a 12.4% return rate (more than four times Shopee's) drags contribution margin down to 18.5%, and ad spend is larger than the whole contribution margin. With this structure, every extra TikTok Shop sale deepens the loss.
- The website has the best margin because there are no marketplace fees, but ads eat almost three quarters of it.
None of the three seller dashboards would show you "TikTok Shop is losing 13.8 million ₫". You only see it when cost of goods, settled fees, returns and ad spend for every channel go through the same formula.
Profit by product: where totals lie
At SKU level the error gets bigger. In the sample data, product MH-NEN-03 brings in 52,741,533 ₫ of net revenue but has a
contribution margin of −7,697,340 ₫: it loses money before advertising. This is the "best seller that loses money" — good sales,
pushed by ads, but every order makes the shop poorer.
Two mistakes hide such SKUs when you work by hand:
- Order-level vouchers are not split across lines. An order with a 300,000 ₫ essential oil and a 60,000 ₫ candle uses a 50,000 ₫ voucher. Split by line value, the oil carries 41,667 ₫ and the candle 8,333 ₫. Without the split, one SKU looks better than it is and another looks worse.
- COGS has no effective date. In the sample data, the cost of
MH-KT-01is 260,000 ₫ until 30 September and 285,000 ₫ from 1 October. Use one cost for the whole quarter and either September is understated or October is overstated.
Self-check before you trust a profit number
Whether it comes from a spreadsheet, software or an AI, ask these eight questions:
- Is the revenue GMV or net revenue?
- Are order-level vouchers allocated to product lines?
- Are refunds deducted twice (in revenue and again as a cost)?
- Is COGS taken at the order date or the latest purchase price?
- What share of revenue has a cost? (Sample data: 92.35%; the rest is effectively costed at zero.)
- Are the fees settled or still provisional? (Sample data: 12.36% of fees are still provisional.)
- Is ad spend for the website, Facebook and TikTok assigned to the right sales channel?
- Are cancelled and unpaid orders kept out of valid orders?
If you answer "don't know" to three or more, the profit number you are using is almost certainly off.
Spreadsheet or system
You can do all of this in a spreadsheet: export orders per marketplace, export fee settlements, export ad spend, keep a dated COGS sheet and join on order ID and SKU. The problem is redoing it every week, export formats changing, and nobody re-checking the formulas after the tenth edit.
DataxLand runs the same chain automatically. You upload files or connect sources; Si, the DataxLand AI, proposes how to read your data — which column is cost, which order status means returned, which fee is provisional — and you approve before anything is built. Then you can ask Si "which channel loses money after ads this quarter?" and get an answer with its sources, matching the dashboard. See Si, the DataxLand docs, or the retail finance dashboard template.
Summary
- Net revenue = GMV − discounts − allocated vouchers − refunds. Do not plan on GMV.
- Profit after fees = net revenue − COGS − platform fees − payment fees − shipping − return shipping − ad spend.
- Compute it per channel and per SKU: totals often hide a losing channel or product.
- Check two data-health numbers first: the share of revenue with a cost, and the share of fees still provisional.
Read next: Break-even ROAS · Profit after marketplace fees