A TikTok Shop week can triple sales and lose money in the same seven days, because the two costs that scale with a creator-driven spike, affiliate commission and returns, scale faster than the contribution the spike brings in. Analyzing the channel means reading the settlement at the SKU level, with commission and refunds on the same line as the sale, and comparing a spike week to a normal one rather than to last week. An AI on reconciled TikTok Shop data can do that comparison and isolate which cost line turned the week. It cannot tell you which video will go viral next, and no tool can.
Amazon demand moves with search rank and seasonality. TikTok Shop demand moves with content. One creator's video can send three weeks of volume into two days, and the same product sells at a fraction of that rate the week after. Four features of the channel turn that volume swing into a profit swing.
Affiliate commission is a cost line, and a large one. TikTok Shop's seller documentation defines affiliate commission as the product price, excluding tax and after seller discount, multiplied by the commission rate the seller set. The settlement report's fee section, per the same documentation, includes referral fee, refund administration fee, affiliate commission, affiliate partner commission, and affiliate shop ads commission as separate items. A spike driven by creators is, by construction, a spike in orders that carry commission.
Returns run high on impulse categories. A purchase made 20 seconds into a video is returned at a different rate than one made after a week of comparison shopping. TikTok Shop's documentation states that on a refund or return the platform refunds the referral fee minus a refund administration fee of 20 percent of that referral fee, capped at $5 per SKU since May 15, 2025. Affiliate commission is a different story: for orders created after April 15, 2025, commission is paid to the creator about 15 days after delivery, and if the refund happens after that payment, the commission is non-refundable to the seller.
Settlement follows delivery. TikTok Shop settles an order after it is delivered and no refund or return request is open, per the referral fee documentation, and the seller's settlement period can be as short as delivery plus one day or as long as delivery plus 31 days. Cash from a viral Tuesday arrives across the following weeks, while refunds keep landing through the return window.
The referral fee is on the settlement, at 6 percent. Since April 1, 2024, TikTok Shop's documentation puts the referral fee at 6 percent of customer payment plus platform discount minus tax, for most categories. It is the smallest of the platform costs on a creator-driven order.
Illustrative numbers. Take a seller of a kitchen gadget listed at $24.99 with a 10 percent seller discount, so the customer pays $22.49. A creator's video sends 3,000 units in one week. The seller offers a 25 percent affiliate commission, ships via TikTok Shipping at an illustrative $4.20 per unit with free shipping to the buyer, and has a landed cost of $6.50. Return rate on the spike is 18 percent; 60 percent of returned units are resellable. Half the refunds arrive after the 15-day commission payment.
Seventy-five thousand dollars of gross sales, and the week lost $1,475. Commission alone took 27.7 percent of net sales after refunds. Returns took $12,145 off the top and then cost another $1,890 in return shipping, $1,404 in unsellable inventory, and $1,518 in commission paid on units that came back.
Now a normal week on the same product: 400 units, affiliate commission on 40 percent of them (the rest from the seller's own content and organic), a 9 percent return rate, no samples.
The normal week earned $1,922 on $9,000 of sales. The viral week lost $1,475 on $75,000. The difference is two cost lines, commission at 25 percent on nearly every order and a return rate that doubled, and the seller who compares the viral week to the one before it sees revenue up eightfold and never looks further.
The same spike at a 15 percent commission saves $6,140 across kept and late-refunded units and turns the week positive by about $4,700. The same spike at a 10 percent return rate keeps 240 more units: $5,398 less refunded, $840 less return shipping, $624 less unsellable stock, and $674 less commission on returned units, against $1,349 of commission and $1,560 of COGS on the units now kept, and the week ends about $2,900 positive. Commission rate and return rate are the two levers, and both are set before the video is posted. The settlement setup that puts these lines in the books is in TikTok Shop to Xero setup.
Crunch, the analytics AI inside ConnectBooks, reads reconciled TikTok Shop data alongside Amazon, Shopify, Walmart, and eBay. Ask what last month's creator-driven spike did to margin on this SKU after commissions and returns, and it runs its chain: what changed across sales, pricing, ads, fees, returns, storage, inventory, and margins; comparing the spike week to a baseline week rather than the week before; on which SKUs; why; and what to do next. On the example above it returns the commission line and the return rate as the causes, with the arithmetic, because ConnectBooks reconciles TikTok Shop settlements into QuickBooks or Xero with commission, refund administration fees, shipping, and landed cost on the SKU line in the profit reports.
It cannot predict virality. No history of this SKU's sales says which creator, which video, or which week will spike. It reads the spike after the settlement records it.
It cannot see the content. Whether the video showed the product in a way that set up returns is a question for whoever watched it.
It cannot know return reasons TikTok Shop does not put in the settlement. It sees refunded units and amounts.
It cannot fix a commission rate you set. It can show that 25 percent lost money and 15 percent would not have. The rate change, the creator outreach, and the sample budget stay with you.
It cannot compute on landed cost you did not record. Sample units shipped to creators that were never expensed make every week look better than it was.
Run the viral-week arithmetic on your own last spike. If the answer surprises you, the surprise is the reason to have the commission and return lines on the same row as the sale before the next video lands.
Running an e-commerce business comes with plenty of challenges, but ConnectBooks is here to make your life easier. With real-time insights, seamless integrations, and detailed tracking of your profitability and inventory, you can stay ahead of the game. Whether you’re selling on Amazon, Shopify, Walmart, TikTok or eBay, ConnectBooks helps you manage your finances with 100% accuracy and confidence, so you can focus on growing your business.
Ready to level up? Start making smarter, data-driven decisions every step of the way. Try ConnectBooks Free Today or Schedule a Demo
