Skip to main content
AxonRow Core

Profit Tracking & Fee Anatomy

The 5-bucket settlement model, per-order profit calculation, and SKU-level margin analysis.

The Problem

Ask a TikTok Shop seller what their profit margin is and most will give you a number based on selling price minus product cost. That number is wrong — usually by 15–30%.

The reality is that money flows through five buckets between your gross revenue and your actual payout: what you Earned, what was Taken before payout (platform fees, affiliate commissions, shipping), what you Spent post-payout (ad spend, COGS), and what was Lost to refunds and shrinkage. Most sellers only track one or two of these. The rest silently erode their margins until a "profitable" month somehow does not translate into cash in the bank.

The problem gets worse at scale. When you have 50 SKUs and 500 orders per day, you cannot afford to calculate profit manually. And store-wide averages hide the fact that 5 of your SKUs are bleeding money while the other 45 carry the business.

The Manual Way

Without tooling, profit tracking typically looks like this:

  • Export orders from Seller Center as CSV
  • Add a "COGS" column and manually enter product costs
  • Subtract a flat "fee percentage" (usually just the referral fee) from revenue
  • Ignore tax, affiliate commissions, small order fees, and handling fees
  • Calculate a store-wide average margin and hope for the best

This approach systematically overstates profit because it misses the majority of deductions. A seller who thinks they are running at 40% margin may actually be at 18% once every fee is accounted for.

The AxonRow Way

Settlement-First, Always

AxonRow uses TikTok's Finance API settlement data as the single source of truth. When an order settles (typically 7–15 days after delivery), the exact payout amount — with every fee already deducted — is recorded. No estimation required.

For recent orders still pending settlement, AxonRow shows a directional estimate based on the product's historical settlement rate (30-day average). These numbers carry a visible confidence badge so you always know what's confirmed vs. what's projected.

The True Profit Formula

Kept = Earned − Taken − Spent − Lost
Earned = Revenue + Platform Subsidies
Taken = Commission + Referral Fee + Transaction Fee + Affiliate Commission + FBT Fee + Shipping + Seller Discount
Spent = Ad Spend + COGS
Lost = Refunds + Shrinkage + FX Loss
Kept = Net payout to bank

The settlement amount comes directly from TikTok's Finance API. It already accounts for every platform fee, referral fee, transaction fee, affiliate commission, shipping cost, and adjustment. You do not need to estimate any of these — TikTok has already calculated them.

SKU-Level Aggregation

Per-order profit is useful, but the real power is rolling it up by SKU. AxonRow aggregates profit data at the product level so you can see:

  • Which SKUs are your cash cows (high volume, healthy margin)
  • Which SKUs are bleeding money (high affiliate rates eating the margin)
  • Which SKUs have margin compression over time (supplier price increases)

Common Pitfall: Buyer-Paid Fees

TikTok's Order API includes fields like shipping_fee, distance_fee, and shipping_insurance_fee. These are paid by the buyer, not deducted from your settlement. If you subtract them from your revenue, you are understating your profit. AxonRow correctly identifies which fees are seller-borne and which are buyer-paid.

Ad Analytics

AxonRow integrates with TikTok's Marketing API to track ad performance alongside profit data:

  • Ad ROI and ROAS per campaign: See return on ad spend at the campaign level, not just store-wide averages.
  • Ad Attribution: Bidirectional SKU to campaign mapping — see which campaigns drive which SKU sales, and which SKUs each campaign is promoting.
  • Ad Funnel: Impressions to Clicks to Conversions to GMV with campaign-level drilldown. Identify where your funnel leaks.
  • ACoS (Ad Cost of Sales): Track ad cost as a percentage of attributed revenue per campaign and per product.

What-If Scenarios

Adjust ASP, COGS, ad spend, and units to explore how changes affect net profit on any SKU. Useful for price testing and budget planning — but remember, the numbers shown are projections, not settled reality.

Checklist

  • Stop calculating margin as "selling price minus product cost" — it misses 15–30% of deductions
  • Use True Net Profit (settlement-based) for settled orders — it accounts for every fee automatically
  • Use estimated profit for unsettled orders as a directional guide
  • Aggregate by SKU to find loss-making products
  • Snapshot COGS at order time — do not use current supplier prices for historical orders
  • Do not subtract buyer-paid fees (shipping, insurance) from your revenue — they never touch your settlement
  • Use the free profit calculator for quick estimates before listing new products