Source: Google Gemini

If your business sells on multiple platforms, there is one number that can quietly fool you:

sales.

Sales can look beautiful.
Orders can look exciting.
Campaign dashboards can look very impressive.

Then finance checks the real margin and says:

“Very nice revenue. Shame about the fees.”

That is the problem.

For many Malaysian SMEs selling across Shopee, TikTok Shop, Lazada, Shopify, and other marketplaces, the biggest profit distortion is not always refunds, not always stock variance, and not always tax.

It is often marketplace fees.

Because each channel deducts money differently:

  • commission
  • transaction fees
  • payment processing fees
  • shipping subsidy
  • affiliate commissions
  • campaign charges
  • vouchers
  • penalties
  • service fees
  • ads and boosts

And if you do not reconcile those fees properly, you will never know your true net margin.

You may think one channel is your star performer when actually it is eating margin like a hungry buffet customer.

This guide explains how to reconcile marketplace fees properly so finance can see the real picture.

We will cover:

  • why marketplace fees distort margin so easily
  • the common fee categories across channels
  • how to reconcile gross sales to true net margin
  • the one framework that works across multiple marketplaces
  • common mistakes that make margin reporting unreliable
  • practical examples for Malaysian SMEs

Let’s stop letting “good sales” hide bad economics.

Why Marketplace Fees Distort Margin So Easily

Marketplace selling is sneaky from a finance point of view.

Why? Because the platform often shows:

  • gross order value
  • order count
  • campaign performance
  • traffic and conversion

But the actual money you keep comes only after many deductions.

That means the number your sales team celebrates may not be the number finance should trust for margin analysis.

A simple example

You sell a product for RM100.

Looks nice.

But then:

  • commission = RM8
  • payment fee = RM2
  • seller voucher = RM10
  • shipping subsidy = RM6
  • affiliate commission = RM7

Now before even talking about COGS, your remaining amount is much lower.

Your “RM100 sale” may actually behave more like a RM67 net sale before cost of goods.

That is a very different margin story.

And if your reporting only compares:

  • gross sales
    vs
  • product cost

you are not measuring real profitability. You are measuring optimism.

What “True Net Margin” Actually Means

Let’s define it properly.

Gross Margin

Usually means:
Sales – COGS

This is useful, but incomplete for marketplace channels.

True Net Margin

A more realistic marketplace view is:

Gross Sales
– Discounts / vouchers funded by seller
– Platform fees
– Payment fees
– Affiliate / marketing commissions
– Shipping subsidies borne by seller
– Refunds / returns impact
– COGS
= True Net Margin

This gives a much better answer to the real finance question:

“After all channel deductions and product cost, how much money did we actually make?”

That is the number management needs if it wants to decide:

  • which channel is worth scaling
  • which products are profitable
  • whether campaigns are worth repeating
  • whether pricing needs to change

The Common Marketplace Fee Categories You Must Separate

Different platforms use different names, but the fee logic is often similar.

Here are the main fee buckets finance should track clearly.

1. Platform Commission

This is the marketplace’s basic cut for enabling the sale.

Examples:

  • Shopee commission fee
  • marketplace service fee
  • platform selling fee

Why it matters

This is usually predictable, but if it is not tracked separately, you cannot compare channel efficiency properly.

2. Payment Processing / Transaction Fees

This covers the payment side of the sale.

Examples:

  • payment fee
  • transaction fee
  • payment gateway fee
  • processing charge

Why it matters

Many teams forget this because the fee is deducted before payout. Then the bank deposit looks smaller and nobody can explain it neatly.

3. Seller-Funded Discounts and Vouchers

This is where margin starts getting interesting.

Examples:

  • seller voucher
  • coupon discount
  • subscribe-and-save discount
  • live promo funded by seller
  • bundle discount

Why it matters

This is not a platform fee, but it still reduces what the business keeps. If it is hidden inside “sales,” your revenue quality looks better than reality.

4. Platform-Funded Discounts

Sometimes the platform funds all or part of a discount.

Examples:

  • marketplace campaign support
  • platform voucher
  • sitewide promo subsidy

Why it matters

These should be separated from seller-funded discounts. Otherwise finance may overstate the cost of discounting or misunderstand channel economics.

5. Shipping Subsidy / Logistics Charges

Shipping is one of the most annoying areas in marketplace reconciliation.

You may have:

  • customer-paid shipping
  • seller-paid shipping
  • platform subsidy
  • logistics deduction
  • free shipping campaign cost

Why it matters

If shipping-related deductions are buried inside general fees, channel margin becomes hard to understand.

A Shopee order and a Shopify order may have similar sales value but very different shipping economics.

6. Affiliate and Creator Commissions

This is especially important in TikTok Shop, but it can affect other channels too.

Examples:

  • affiliate commission
  • creator fee deduction
  • collaboration payout linked to order

Why it matters

This can quietly turn a high-volume campaign into a low-margin campaign. If you lump affiliate fees into general marketing, you lose visibility on order-level profitability.

7. Advertising and Boosting Costs

These are usually not deducted from individual payouts in the same neat way, but they still matter when analysing true net margin by channel.

Examples:

  • Shopee ads
  • TikTok ads
  • marketplace boosts
  • keyword bidding

Why it matters

For channel-level profitability, these costs should be included in a deeper net margin view, even if not deducted directly from settlement.

Think of this as:

  • settlement net margin
    vs
  • fully loaded channel net margin

Both are useful. Just do not mix them carelessly.

8. Refund-Related Costs and Chargebacks

A refund is not just lost revenue. It may also involve:

  • non-refundable payment fees
  • return shipping
  • damaged stock
  • chargeback cost
  • affiliate reversal timing problems

Why it matters

Refund-heavy channels may look good at gross sales level but weak at true margin level.

9. Penalties and Adjustments

These are often small individually and irritating collectively.

Examples:

  • late shipment penalty
  • dispute adjustment
  • compensation deduction
  • manual platform adjustment

Why it matters

If you ignore these, unexplained differences start piling up. And small unexplained differences are how “close enough” reports become unreliable over time.

The One Reconciliation Framework That Works Across Channels

The easiest way to reconcile true net margin is to stop thinking by platform label and start thinking by financial flow.

Here is the framework.

Step 1: Start With Gross Sales

For each channel, summarise:

  • gross order value
  • shipping charged to customer if treated separately
  • tax if relevant

This gives you the commercial top line.

Example:

  • Shopee gross sales = RM120,000
  • TikTok gross sales = RM80,000
  • Shopify gross sales = RM60,000

Good start. But not yet useful for real margin.

Step 2: Deduct Seller-Funded Discounts

Now reduce the sales by discounts the business actually funded:

  • vouchers
  • coupons
  • promo support
  • bundle discount cost borne by seller

This gives a better net sales before platform charges view.

Step 3: Separate Platform and Payment Fees

Now record:

  • platform commission
  • service fees
  • transaction fees
  • payment processing fees

Do not bury these into one vague number.

Better reporting example

  • Shopee commission = RM9,500
  • Shopee payment fee = RM2,300
  • Shopee logistics deductions = RM4,100

This tells a much better story than:

  • Shopee deductions = RM15,900

Step 4: Add Shipping and Logistics Impact

Now include:

  • seller shipping subsidy
  • logistics cost deducted by platform
  • free shipping participation cost
  • shipping refunds if material

Shipping often looks small order by order, but it becomes very material when reviewing true margin by channel.

Step 5: Add Affiliate / Promotional Selling Costs

Especially for TikTok Shop, this may include:

  • affiliate commissions
  • creator-linked fees
  • campaign deductions

If you want a true channel margin, this cannot be ignored.

Step 6: Reflect Refunds and Returns Properly

Use:

  • refund processed date
  • original order ID
  • refund amount
  • stock outcome if available

Why processed date? Because the original sale and the refund often sit in different periods. Finance needs a consistent rule.

Refunds should reduce margin for the period in which they are processed, unless you are making specific accrual adjustments.

Step 7: Subtract COGS

Now only after all these marketplace-side deductions do you compare against:

  • product cost
  • landed cost
  • packaging if included in policy

This gives a realistic product or channel margin view.

A Practical Example

Let’s use a simple example from a TikTok Shop campaign.

Gross order sales

RM50,000

Seller-funded discounts

RM5,000

Platform / payment fees

RM4,200

Shipping subsidy borne by seller

RM2,000

Affiliate commissions

RM3,800

Refunds processed this month

RM1,500

COGS

RM22,000

True net margin

RM50,000
– RM5,000
– RM4,200
– RM2,000
– RM3,800
– RM1,500
– RM22,000
= RM11,500

Now compare that to the lazy method:

RM50,000
– RM22,000
= RM28,000 gross margin

Very different story.

Same sales.
Very different truth.

That is exactly why fee reconciliation matters.

Why Channel Comparison Is Often Misleading

A common management mistake is comparing channels only using:

  • sales
  • gross profit
  • order volume

That is not enough.

Example

Shopee may produce:

  • higher sales
  • lower average order value
  • more seller voucher cost
  • more shipping subsidy burden

Shopify may produce:

  • lower sales
  • better pricing control
  • fewer platform fees
  • stronger net margin

TikTok Shop may produce:

  • viral order growth
  • but heavy affiliate deductions and refund spikes

Without fee-level reconciliation, the business may invest more in the wrong channel.

That is how “top-line growth” can quietly become “bottom-line disappointment.”

The GL Structure That Helps

To reconcile true net margin properly, your accounting should not dump everything into one account called “online sales” and another called “marketplace fees.”

A more useful structure would include:

Revenue Accounts

  • Sales Revenue – Shopify
  • Sales Revenue – Shopee
  • Sales Revenue – TikTok

Contra Revenue / Adjustment Accounts

  • Sales Discounts – Seller Funded
  • Sales Returns & Refunds

Expense Accounts

  • Marketplace Commission
  • Payment Processing Fees
  • Affiliate / Creator Commissions
  • Shipping Subsidy Expense
  • Platform Adjustments / Penalties
  • Advertising Expense

Clearing Accounts

  • Shopify Clearing
  • Shopee Clearing
  • TikTok Clearing

This structure gives finance much better visibility and makes management reporting far more useful.

Common Mistakes That Distort Net Margin

Let’s make these very clear.

Mistake 1: Treating net payout as revenue

This hides fee types and weakens margin analysis.

Mistake 2: Mixing seller-funded and platform-funded discounts

Then promo cost looks wrong.

Mistake 3: Ignoring shipping-related deductions

This is a very common hidden leak.

Mistake 4: Posting affiliate costs into general marketing only

Then order-level profitability becomes invisible.

Mistake 5: Ignoring refund timing

Then channel margin looks artificially strong in one period and weak in another.

Mistake 6: Comparing channels using different logic

If Shopee includes shipping deductions but Shopify does not, the comparison is already flawed.

A Practical Monthly Workflow for Malaysian SMEs

Here is a finance workflow that works well.

Weekly

  • review payout reports by channel
  • flag unusual deductions
  • review refund spikes
  • scan major campaign cost impact

Monthly

  • summarise gross sales by channel
  • classify fee categories by channel
  • separate seller-funded discounts
  • record refunds and returns
  • reconcile clearing accounts
  • calculate net margin by channel
  • compare current month to prior month trend

Quarterly

  • review fee percentages by channel
  • review pricing vs cost
  • assess whether campaign channels are actually profitable
  • test a few orders end-to-end:
    • order
    • discount
    • fee
    • refund if any
    • payout
    • GL impact

This gives a much stronger finance view than a single “online sales profit” number.

A Good Management Report Should Show This

If you want channel decisions to improve, management should see a report like this by channel:

  • Gross Sales
  • Seller-Funded Discounts
  • Platform Fees
  • Payment Fees
  • Shipping Subsidy Cost
  • Affiliate Cost
  • Refunds
  • Net Sales After Channel Deductions
  • COGS
  • True Net Margin
  • True Net Margin %

That report tells the truth.

Not always a pleasant truth.
But a very useful one.

Final Thoughts

Marketplace fees are not a side detail.

They are one of the biggest reasons businesses misunderstand profitability across channels.

If your finance team is not reconciling:

  • seller-funded discounts
  • platform fees
  • payment charges
  • shipping subsidies
  • affiliate commissions
  • refunds
  • and cost of goods

then you are not measuring true net margin.

You are measuring a friendlier version of reality.

And friendly numbers are not always helpful numbers.

The businesses that scale well across channels are usually the ones that stop asking,
“How much did we sell?”
and start asking,
“How much did we actually keep after each channel took its share?”

That is the real margin question.