Tracking Shopee / TikTok Profit in Excel: A Working Template Structure (and Where It Breaks)

Short answer: A per-order spreadsheet absolutely works at low volume, and it is the fastest way to see real net profit the platform dashboards hide. You need one row per order and columns for GMV, every platform fee, COGS, allocated ads, affiliate and returns, updated on a fixed cadence. It breaks at four predictable points: actual settlement drifting from your estimates, bundles corrupting COGS, rising volume, and reconciling two platforms by hand.

Net profit column = GMV − (commission + transaction + support fee + programme fees) − COGS − allocated ads − affiliate − returns impact

What columns does the sheet actually need?

One row per order. Do not summarise at the SKU or day level first — you lose the detail that makes the numbers trustworthy. These are the columns that carry their weight:

The two columns sellers skip are the two that matter most: allocated ads (you must split total ad spend down to individual orders, not just look at the monthly total) and returns impact (a refunded order can lose you fees that never come back). Skip them and your sheet flatters you.

What cadence keeps it honest?

• Daily or every few days: paste new orders, fill COGS, tag returns. Little and often beats a monthly marathon you will abandon.
• Weekly: allocate the week's ad spend across orders, and reconcile affiliate payouts.
• Monthly, after settlement lands: replace your estimated fees with the actual settled fees from the payout report. This is the step that turns a guess into a P&L.

For the fee percentages to plug in, see TikTok Shop seller fees and Shopee seller fees, and model a single order with the profit margin calculator.

Where the spreadsheet breaks

Excel does not fail loudly. It quietly stops being accurate.

1. Actual settlement drift. Your sheet uses rate-card estimates; the real payout differs because of promotions, instalments, adjustments and refunded fees. Over a month the gap between "estimated profit" and "settled profit" grows into a number you cannot ignore. See TikTok settlement explained and Shopee escrow explained.
2. Bundles corrupt COGS. The moment you sell "buy 2 free 1" or a mixed bundle under one price, splitting fees and product cost across components by hand becomes error-prone, and one wrong split poisons every SKU in the bundle.
3. Volume. Manual entry is fine at 100 orders a month and painful at 1,000. The sheet does not break — your discipline does, and a half-updated sheet is worse than none because you trust it anyway.
4. Two platforms. TikTok Shop and Shopee export different columns with different names and different fee structures. Reconciling them into one comparable P&L by hand is the chore most sellers silently give up on.

The honest verdict

If you sell a few hundred orders a month on one platform with simple pricing, a disciplined spreadsheet is genuinely enough — build the columns above and keep the cadence. Automation is not a moral upgrade; it is a response to a specific bottleneck. You have crossed the line when the time spent entering and reconciling exceeds the time the numbers save you, or when settlement drift and bundles mean your sheet is confidently wrong.

The Inseller angle

Inseller is what the spreadsheet becomes when the four break-points arrive. It connects Shopee and TikTok Shop, pulls orders automatically, and computes real net profit per order and per SKU from actual reconciled settlement fees — the manual paste, the ad allocation and the estimated-vs-actual step, done for you. It was built by a seller who ran the exact sheet above until two platforms and settlement drift made it impossible to keep honest.