How To Use TikTok Shop Worksheet

Getting a Handle on the TikTok Shop Worksheet

The TikTok Shop Worksheet is basically a spreadsheet you use to track products, orders, and profits through the TikTok Shop platform. Most sellers build it themselves or grab one off a forum. It works as a central hub for everything you're selling so you aren't juggling TikTok's native analytics, your bank statements, and your inventory counts in three different tabs. I've been using these for about three years now across different product lines. The ones I've found that actually hold up are the ones that mirror the way TikTok Shop's backend reports data, because if your worksheet doesn't line up with what TikTok shows you, you'll end up with mismatched numbers every time you try to reconcile at month-end. That costs time and it causes headaches you don't need.

How To Use TikTok Shop Worksheet

Start by setting up the columns. The ones you actually need on day one are: product name, SKU, cost per unit, selling price, commission rate, TikTok ads spend allocated to that product, quantity sold that period, refund count, shipping cost per unit, and net profit. Put those in row one and freeze that header row so you don't lose it when you scroll down. Next, pull your sales data from TikTok Seller Center. Go to Orders and export the order report. It's a CSV file. Open that in your spreadsheet software and map the columns to your worksheet columns. You'll need to match order status, product ID, unit price, refund status, and any fees TikTok deducted. This mapping step is where most people mess up. The export from TikTok doesn't always label things clearly. "Settlement amount" isn't the same as "revenue." Settlement amount already has fees taken out. If you double count by adding revenue and then subtracting fees again, your profit column will be wrong by exactly the fee amount on every single order. I learned that the hard way on my first full month. I had about four thousand orders and my profit column was showing roughly thirty thousand dollars less than it should have been. I spent an entire Sunday trying to find where the money went before I realized I had subtracted the service fee twice. Once in the TikTok export and once manually in my sheet. Stupid mistake but it happens to everyone at least once.

After your initial data is mapped, build a summary sheet separate from your raw data. Use pivot tables or simple SUMIF formulas to aggregate by product, by date range, and by refund rate. You want to be able to answer quickly: which products are actually profitable after TikTok's commission and ads, which ones are generating refunds faster than they generate sales, and what your real margins look like when you factor in shipping and packaging costs. For the commission part, TikTok Shop takes a category-based commission that ranges anywhere from about five percent to twenty percent depending on what you're selling. There's also a transaction fee on each order. These numbers change sometimes. TikTok announces updates to their fee structure without much warning. I keep a separate reference tab with the current commission percentages for each category and update it whenever TikTok sends out one of those policy change emails. Last year they adjusted the commission on beauty products and I missed it for six weeks because I was using an outdated percentage. That skewed my profit data enough that I almost placed a big reorder on a product I should have dropped. One thing worksheets like this don't show well is timing. TikTok holds your payouts on a schedule that isn't consistent. Sometimes you get paid within two days. Sometimes it takes ten. Your worksheet will show revenue when the order is placed, but the money isn't in your account yet. If you're trying to figure out cash flow with this tool, you need to add a column for payout date separate from order date. Otherwise you'll think you have money coming in that week and it's sitting in TikTok's escrow. I added a payout tracking column and honestly it changed how I plan purchases. I stop buying inventory based on revenue numbers and start buying based on actual incoming cash.

There are some limitations you should know about. A static worksheet doesn't automatically update when TikTok makes changes to how they report data. You have to manually refresh your exports and remap columns if the fields shift. Another issue is refunds. TikTok processes refunds and then adjusts your settlement. If you're pulling data mid-cycle before the adjustment hits, your refund count will be low and your revenue will be high. Wait until the end of the billing cycle to do your reconciliation, or you'll be chasing ghosts. Also, if you run TikTok Ads Manager campaigns alongside organic sales, the worksheet needs a clear separation between organic revenue and paid revenue. Mixing them together makes it impossible to know whether a product is actually working or just working because you're spending ad money on it. If you're doing a lot of products, maybe over two hundred SKUs, a spreadsheet starts to slow down. The formulas lag and the file gets unwieldy. At that point you're better off moving to something like a lightweight database or a dedicated inventory management tool. The worksheet is fine for small to medium stores. It's not built for scale. The bottom line is that the TikTok Shop Worksheet is useful if you treat it as a living document, not something you set up once and forget. Update the commission rates when TikTok changes them. Separate organic from paid. Don't confuse settlement amount with gross revenue. And give yourself grace when you make a mapping error because you will. Everyone does.