Skip to content

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.

LayerHow it is computedWho usually uses it
GMV (gross revenue)Price × quantity, before any discountMarketplace dashboards, campaign reports
Revenue after discountsGMV − shop discounts − shop vouchers allocated to each lineOrder exports
Net revenueRevenue after discounts − refunds paid to buyersAccounting, P&L
PayoutNet revenue − all settled marketplace feesMarketplace 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 revenue

Three rules keep the formula from double counting:

  1. Refunds are deducted once, in net revenue. Return shipping is a separate cost, not a refund.
  2. COGS uses the cost on the order date, not the latest purchase price. A more expensive October batch must not change September's profit.
  3. 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 typeShopeeTikTok ShopLazadaLine in the formula
Category feeFixed feePlatform commissionFixed feePlatform fees
Per-transaction feeTransaction processing fee (called payment fee before 24 Apr 2026)Transaction feeOrder processing feePayment fees
Programme feesVoucher Extra, Freeship Extra (if joined)Voucher Extra (if joined)Promotion packages (if joined)Platform fees
Fixed fee per orderInfrastructure and other service fees—Technical infrastructure feePlatform fees
Shipping borne by the shopShipping differenceShipping differenceShipping differenceShipping
Return legReturn shippingReturn shippingReturn shippingReturn shipping
AdvertisingShopee AdsTikTok Ads, GMV MaxSponsored SolutionsAd 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):

MetricShopeeTikTok ShopWebsite
Net revenue397,961,000 ₫228,021,000 ₫129,572,000 ₫
Contribution margin128,090,600 ₫42,093,900 ₫54,186,700 ₫
Contribution margin / net revenue32.2%18.5%41.8%
Ad spend38,163,000 ₫55,896,000 ₫41,011,000 ₫
Profit after fees89,927,600 ₫−13,802,100 ₫13,175,700 ₫
Return rate2.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:

  1. 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.
  2. COGS has no effective date. In the sample data, the cost of MH-KT-01 is 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

Related posts

Verified dashboards from your own data, this afternoon

Free plan with no time limit · No card required · Sample workspace ready in minutes