TikTok Shop Affiliate Commission and Ad Cost Planning: Calculate affiliate commission and ad costs on attributed orders, then set a defensible break-even target. The aim is a process another operator can repeat, not a one-off spreadsheet that only its author understands.
Prepare the data for TikTok Shop Affiliate Commission and Ad Cost Planning
Calculate affiliate commission and ad costs on attributed orders, then set a defensible break-even target. Start by fixing the reporting period, market, tax treatment and reporting currency. Without those four anchors, GMV, payout and profit will drift apart.
Keep the raw platform export unchanged and add readable working columns beside it. Do not merge platform fees, logistics and adjustments too early; the detail is what makes a variance explainable.
A four-step operating workflow
Use the same order of checks every month. A consistent sequence reduces omissions and makes the work easier to hand over.
- Set the order range and settlement period
- Match the market, category and rate effective at the time
- Separate VAT, platform, creator, ads, logistics and refunds
- Record the reason for each variance
Mistakes that distort the answer
The most common errors are treating VAT-inclusive GMV as revenue, applying an affiliate rate to every order, recording only the refund while ignoring reverse-logistics losses, and recalculating old orders with today's fee rate.
If actual and expected values differ, preserve the variance and investigate it. Changing a formula simply to force a match removes the evidence needed to find the cause.
What a finished reconciliation should explain
You should be able to walk from the customer's payment through platform deductions and refunds to the final payout, then from payout to the contribution retained by the business.
Mark unresolved items as estimated or pending confirmation. A visible uncertainty is more useful than hiding several unrelated amounts inside an 'other' line.
Where the numbers come from
Platform fees are sourced from official TikTok Shop seller or developer documentation. VAT defaults come from official EU guidance. If Seller Center shows a more specific category or promotional rate for your account, use that figure.
Frequently asked questions
Should I use the order date or settlement date for the fee rate?
Follow the effective-date wording in the relevant policy and retain both dates. Flag ambiguous orders rather than automatically applying today's rate.
Do I need to upload complete store data?
No. The current calculator works on a single-order scenario in the browser. Any future statement import should preserve privacy and minimise the data used.
How should multiple currencies be handled?
Keep the original transaction currency and convert to a management currency using a dated reference rate. Tax and accounting records must still follow the required local basis.