Top 10 TikTok Shop Worksheet

Why Most People Build the Wrong Spreadsheet for TikTok Shop

I spent three weeks building a custom TikTok Shop management sheet before someone pointed out I was tracking the wrong metrics. My first version had columns for every possible data point I could find in the seller dashboard. It ended up being 84 columns wide and took about 20 minutes to open on a decent laptop. That's not sustainable when you're refreshing it daily to check your numbers before your afternoon live stream. The useful worksheet isn't the one with the most data. It's the one that surfaces the right numbers at the right time. The Top 10 TikTok Shop Worksheet I actually use has ten sections and about forty columns total. It changed how I manage my store from "guessing what's selling" to actually knowing which products need restocking and which ones are quietly bleeding money through returns.

Top 10 TikTok Shop Worksheet

Here's the structure. It's broken into ten functional areas that map directly to the decisions you need to make every week. If you can fill out these ten sections each Sunday evening, you'll have a clearer picture than most sellers who check their dashboard sporadically throughout the day. Section one is your core product roster. This isn't just a list of SKUs. You need product name, SKU, current inventory count, units sold this period, units returned this period, cost per unit, average selling price, and gross margin per unit. I used to skip the return column because it felt pessimistic. That changed when I realized two of my top three sellers by revenue were actually my worst performers after returns. One of them had a thirty-two percent return rate because the sizing guide on the listing was wrong. I fixed the listing and the returns dropped to eleven percent. The worksheet made that visible in a single cell. Section two tracks your commission and fee breakdown. TikTok Shop takes a commission that varies by category, plus a transaction fee, plus whatever payment processing fees apply in your region. I learned the hard way that the commission rate displayed in your dashboard isn't always the rate you're actually charged. My home and kitchen products were listed at six percent commission but I was getting billed at eight percent because the category classification was wrong. Correcting it saved me roughly four hundred dollars a month. Put the listed rate and the actual charged rate in side by side columns so you can spot discrepancies.

Section three is your affiliate and creator performance log. This is where most sellers mess up. You need creator username, number of videos posted, total views generated, conversion rate attributed to that creator, total commissions paid, and net revenue after commission. Track this weekly. I started doing this and immediately identified a creator who was generating high views but nearly zero conversions. Their audience was completely mismatched to the product. Cutting that partnership and redirecting budget to a smaller creator with a tighter audience overlap doubled my affiliate ROI within two weeks. Section four covers your live streaming metrics. Number of live streams, total hours, peak concurrent viewers, total live-generated orders, and revenue from live streams only. Live commerce behaves completely differently from regular feed commerce. The audience that converts during a live stream is not the same audience that buys from your product page. My live streams account for about sixty percent of my revenue but they skew toward lower-ticket items and impulse purchases. If you're only looking at your overall sales dashboard, you'll miss that pattern entirely. Section five is your advertising spend tracker. Campaign name, daily budget, total spend, impressions, clicks, click-through rate, cost per click, conversions, cost per acquisition, and return on ad spend. Keep this separate from your organic numbers. When I first started running TikTok ads, I was pulling my overall profit numbers and couldn't tell if a product was profitable or if I was just subsidizing everything with organic traffic. Separating paid from organic in this section made the picture clear within a single week.

Section six tracks your shipping and fulfillment costs. This one is unglamorous but critical. Order count, total shipping cost, average shipping cost per order, carrier used, any expedited shipping surcharges, and whether you're absorbing shipping or passing it to the customer. I discovered I was losing about two dollars per order on shipping because I hadn't set up my weight-based shipping profiles correctly. The platform was defaulting to a flat rate that was too low for my actual package dimensions. Fixing that took an afternoon and improved my margins across the board. Section seven is your return and refund log. Reason for return, days until return was processed, refund amount, whether the item was resellable, and final disposition of the returned item. This section saved me from a supplier problem I hadn't noticed. A batch of products from a new supplier had a defect rate that was invisible in my normal metrics because individual return reasons were varied. Aggregating them in this section showed a clear pattern. The items were arriving with missing components. I switched suppliers and the return rate for that product line dropped from twenty-four percent to five percent. Section eight handles your cash flow projection. Expected revenue, expected costs (product, shipping, fees, ads), estimated net profit, and the difference between when money comes in and when you need to pay suppliers. TikTok Shop has a payout delay that varies by region and seller tier. In my case it's roughly fifteen to twenty days after order delivery. If you're not accounting for that lag, you'll regularly find yourself short on cash to reorder inventory. I used to have three separate instances where I oversold items because I was spending revenue that hadn't actually hit my bank account yet. Now section eight flags it before I make that mistake.

Section nine is your competitor monitoring sheet. Competitor store name, their top three products, their pricing, their discount strategies, and any new product launches you've noticed. You don't need to obsess over this but ignoring it completely is worse. I spotted a competitor dropping prices on a product category I was considering entering. They were selling at a loss to gain market share. I waited three months and watched them raise prices when the novelty wore off. By then I had established my own position at a sustainable margin. Timing matters more than speed in this business. Section ten is your monthly review and action items. This is the summary section. Total revenue, total profit, best performing product, worst performing product, key decisions made this month, and the top three priorities for next month. This is the part that turns the worksheet from a data dump into an actual decision-making tool. Without this section you're just maintaining a spreadsheet. With it, you have a record of why you made certain calls and whether those calls were right. I go back to previous months' reviews constantly. It's the fastest way to catch yourself repeating mistakes. The whole thing fits in a single Google Sheets or Excel workbook. I keep mine under ten megabytes so it loads quickly on my phone between orders. If you're using Microsoft Excel, use actual tables with structured references instead of raw cell ranges. It makes the formulas significantly easier to maintain when you're adding new products or new months of data. Google Sheets works fine too if you're collaborating with a team member who needs edit access.

A few things to watch out for. The worksheet will not save you from bad product decisions. If you're selling items with thin margins and high return rates, a spreadsheet won't fix that. It will show you the problem faster than you'd otherwise see it, but the fix still requires either changing your product mix or renegotiating your supplier terms. Also, TikTok Shop's own reporting interface updates its categories and fee structures periodically. Every quarter I audit my fee calculations against the current rates published in the seller center. Last time I did that, I found they'd adjusted the commission for electronics and I was undercharging my customers on the reflected cost. Correcting it retroactively wasn't possible but going forward the worksheet absorbed the change immediately. If you want the actual file, I keep mine available as a template. It has the ten sections laid out with sample data so you can see the format before you start filling in your own numbers. The template includes basic formulas for margin calculation and monthly summaries. You'll need to adjust the formulas for your specific commission rates and payout timeline, but that takes about fifteen minutes once. The real work is in maintaining the data consistently week to week. That's where most people drop off and the whole system stops being useful.