SEA Profit Calculator

Guides · Malaysia seller fees

TikTok Shop Settlement Report: How to Reconcile It (Malaysia Sellers)

TikTok Shop Settlement Report: How to Reconcile It, Column by Column

If the total on your TikTok Shop settlement statement does not match the sales figure in your dashboard, you are usually looking at three different clocks running at once — and none of them is wrong.

This page is the reconciliation guide: the one formula the statement is built on, what every column in the export actually means, and the three reasons a MY seller's own spreadsheet will not tie out. Every fact carries its source and the market that source applies to, because TikTok Shop publishes some of this documentation per market and the definitions do differ.

The one formula the whole statement hangs on

TikTok Shop's own finance guidebook states it directly:

Settlement Amount = Net Sales − Shipping − Fees + Adjustments

And then the sentence that explains most "wrong" totals:

Your settlement amount is calculated by settlement time (when an order finishes its payout cycle), not by order time. That's the single biggest reason your statement total won't match your daily GMV — they measure different things on different clocks.

So a month of statements is not a month of sales. It is the money that finished its payout cycle in that month, whichever month those orders were placed.

Source: TikTok Shop — Guidebook: Understanding Financial Statements (18-06-2026), published on TikTok's UK seller site; the formula is generic to the platform, the wording is not MY-specific.

The four buckets

Every line in the export rolls up into one of four buckets. Once you know which bucket a line belongs to, most reconciliation questions answer themselves.

Bucket What it holds Watch out for
Net sales What customers paid for goods, after discounts you chose to fund. Includes gross sales, seller discount (negative), and paired refunds of both Platform-funded vouchers and discounts do not appear here — they are already netted into what the buyer paid
Shipping TikTok Shipping fee (base owed to the carrier), customer-paid shipping fee, TikTok shipping incentive (a capped subsidy), return shipping fee, 3PL shipped-by-seller service fee A shipping incentive refund is charged back when a refund is the seller's fault
Fees Platform commission, affiliate and partner commissions, campaign fees, shipping-related service fees, tax-related fees Affiliate commission is not refunded after the creator has been settled; before settlement it reverses in full
Adjustments Money settled outside a single sale: carrier-fault logistics reimbursement, platform-fault reimbursement (for example a refund without return), and deductions such as policy violation deduction or negative balance recovery This bucket can be positive or negative, and it is where most "why did money leave my balance?" surprises live

Source: same guidebook (18-06-2026). Affiliate fee refund rules are stated in the guidebook's fee tables.

Where to export it, and what is inside

The settlement report is generated daily according to your settlement period, and the export contains several spreadsheets — the important one is the order-details sheet, which is broken down at SKU level.

Step Where
Export statements Seller Center → Finance → Statements → Export (payout records: Finance → Payments → Export)
Pick a date range The dialog takes a custom range — export one settlement period at a time while you are learning the format
Retrieve the file Export History → Download
Unsettled orders They are not in the statement at all — they sit under Finance → On hold

The order-details sheet columns, as TikTok Shop documents them:

Column Meaning
Statement Date The date the order settles — build your reconciliation on this column, not on the order date
Statement ID / Payment ID The settlement group, and the payout TikTok Shop initiated
Status pending, processing, paid or failed — a statement can exist before the payout succeeds
Type order or adjustment — this is how you tell a sale from a correction
Order/adjustment ID, SKU ID, Quantity, Product name, SKU name The SKU-level identity of the line
Order created date / Order delivery date The other two clocks — useful for spotting orders that took a long time to deliver
Total settlement amount Equals net sales + shipping + fees + adjustment, the four buckets above

Inside that amount, net sales is itself defined as gross sales + gross sales refund + seller discount + seller discount refund, and the shipping block lists the carrier fee, the customer-paid fee, the incentive, and any incentive refund separately.

Source: TikTok Shop — How to Access Your Settlement Report (09-11-2025) and Finances Page FAQ (08-11-2025), both published on TikTok's US seller site. Column names are platform-wide, but confirm the sheet layout in your own MY Seller Center: TikTok ships finance features per market.

Why your numbers do not match: the three real reasons

1. Timing — settlement time versus order time

Payout is initiated 1 to 31 days after the delivery date, under the Dynamic Settlement Policy. That single fact stretches every reconciliation: an order delivered on 28 March can settle in April, and a slow delivery can push an order a full settlement period later than you expect.

On top of that, money can be held before it ever reaches a statement. Reserve amounts sitting in the platform's collecting phase are visible under Finance → On hold, and TikTok added a downloadable Reserve Details sheet (for transactions after 25 September 2025) precisely because sellers were trying to reconcile against money that had not been released yet.

Fix: reconcile on Statement Date, and treat the difference between "delivered" and "settled" as a queue, not an error. Our payout-timing guide maps the settlement tiers.

2. Refunds and reversals that arrive after the fact

A refund does not edit the original line — it arrives as a paired reversal in a later statement. Three consequences catch sellers out:

Fix: never reconcile a refund against the original order's statement period. Returns cost structure walks through what comes back and what does not.

3. Deductions and negative balances — where "settlement suspended" comes from

The adjustments bucket is where TikTok Shop recovers money: policy violation deductions and negative balance recovery both land there. A negative balance means your account sits below zero — outstanding fees exceed your balance — and TikTok Shop's published policy takes enforcement action when that persists:

Criteria (as documented by TikTok Shop) Enforcement
Negative balance for 10 consecutive calendar days Suspension of seller benefits
Negative balance exceeding the equivalent of US$100 Suspension of seller benefits; payment settlement period may be extended to 31 calendar days
Negative balance for 5 consecutive days and above that threshold Warning ticket first

The documented causes are mundane, not exotic: mispriced products, product weight entered inaccurately so shipping is undercharged, a promotion configured wrongly, too many creator samples, or a return rate high enough that refunds outrun sales.

Source: TikTok Shop — Negative Balance (04-08-2026), published on TikTok's UK seller site. The policy centre is platform-wide, but the numeric thresholds are stated in the seller's own currency — check the version shown in your MY Seller Center before you rely on the figure.

Fix: if payouts stop, read the adjustments lines before you open a ticket. Payout failed or on hold covers the resolution path.

Do not copy another market's reconciliation template

This one is worth saying plainly, because it silently breaks spreadsheets built from a US or UK blog post.

TikTok Shop's UK finance guidebook gives the commission formula as:

((Net Sales + customer paid Shipping Fee) − (Net Sales Refund + customer shipping paid Refund)) × Commission Fee Rate

The customer's shipping payment is inside the commission base. TikTok Shop MY's own fee page defines the MY commission base differently — item price minus seller discount, with shipping and platform-funded discounts excluded.

So a template copied from the US or UK formula will be systematically too high on MY, by roughly your commission rate × the shipping fee you charged. Reconcile using the MY definition, and our TikTok Shop MY fee breakdown prints both the rate and the base to compare against a statement line.

A reconciliation workflow that finds the gap in 15 minutes

  1. Pick one settled order, not the month. Filter the order-details sheet by Order/adjustment ID.
  2. Compute what the order should have produced — item price, your discount, commission by category, the 3.78% transaction fee, and the RM0.54 Platform Support Fee. The Shopee commission calculator shows the same fee-layer arithmetic on the Shopee side, and the worked example is useful for sanity-checking order-of-magnitude.
  3. Walk the statement lines in bucket order — net sales, shipping, fees, adjustments. Nine times out of ten the unexpected line is in adjustments.
  4. If it still will not tie out, look at three suspects in order: a seller-discount rounding on a multi-item order, a shipping incentive (or its clawback), and a reversal belonging to an earlier period.
  5. Then build the monthly view on Statement Date, keeping on-hold and reserve amounts in a separate column, so the queue stops looking like a discrepancy.
Statement line Where it comes from How to verify
Platform commission Category rate × (item price − seller discount), SST-inclusive on MY Compare with the category table on the MY fee page
Transaction fee 3.78% (3.5% + 8% SST) on the buyer's paid amount Check it moves when the buyer pays shipping, and not when your price does
Platform Support Fee RM0.54 per successfully delivered order — per order, not per item Appears once for a 3-item order; stays charged on a later return
Shipping incentive refund Clawback on seller-fault refunds If present, first check the return was your fault
Negative balance recovery Offsetting an earlier deficit Trace it to the statement period that created the deficit, not this month

Run the numbers on your own product. Six fee layers, live market price band, no sign-up.

Open the calculator

Sources

All sources fetched and checked on 2026-10-11.