What a Monthly TikTok Shop Journal Actually Looks Like
A Monthly TikTok Shop Journal is basically a spreadsheet or tracking document where you log everything that moves through your TikTok Shop account each month. Sales revenue, refund rates, commission deductions, ad spend, product returns, creator payout breakdowns. Most sellers end up building one themselves because the native TikTok Shop dashboard doesn't organize this the way you need it for actual decision-making. I built my first one around 2022 when I was running a mid-tier shop and trying to figure out why my profit margins kept shrinking despite revenue climbing. The dashboard showed gross sales going up, but nothing explained where the money was actually leaking. That's when I started tracking refunds separately from chargebacks, pulling creator commission rates by campaign, and noting which SKUs had the highest return-to-sales ratio.
Monthly TikTok Shop Journal Structure
The structure that actually works isn't complicated, but most people oversimplify it and end up with a document they stop using after three weeks. Here's the layout I ended up sticking with and still use today: Revenue section: Total gross sales per day, broken down by product category. Not just total sales — that number is almost useless on its own because it includes items that will be returned. Pull the net sales figure separately. TikTok calculates this automatically in your seller center, but I found it faster to export the raw data and build my own column since the platform's export sometimes drops rows or misaligns timestamps during high-volume periods.
Cost of goods section: Cost per unit for every SKU you sell. This sounds obvious until you're managing forty products across three suppliers and realize you've been quoting supplier A's price for a product that switched to supplier B six weeks ago. I caught this once because my COGS percentage jumped unexpectedly in the journal. Took me an afternoon to re-verify every SKU against current invoices. Platform fees section: TikTok takes a commission that varies by category and region. In the US it's roughly five to eight percent depending on the product vertical. Your journal needs a column for actual commission deducted per transaction, not an estimate. The estimated approach will make your numbers look fine until payout day and you'll wonder where five percent of your monthly revenue disappeared. Creator and affiliate costs: If you use TikTok's affiliate marketplace or work with creators directly, track every payout. Creator commissions are separate from platform fees and they eat into margin faster than most new sellers expect. I had a product where the affiliate commission alone was twelve percent on top of the platform cut. That product looked profitable at first glance and broke even after payouts.
Get the Full Details
Ad spend: Separate TikTok ad spend from any off-platform marketing. Track cost per click, cost per purchase, and return on ad spend by campaign. Don't lump them together. You need to know which campaigns are pulling their weight and which ones you've been funding out of habit. Refunds and returns: Log these individually by date and reason if possible. The pattern shows up over time. Certain sizes, certain colors, or products promoted by specific creators will have outsized return rates. I once had a whole product line return at forty percent because the sizing ran small and TikTok shoppers don't read descriptions. My journal flagged it after two months and I pulled the product before it became a quarterly problem. Net profit calculation: Revenue minus COGS minus platform fees minus creator costs minus ad spend minus refunds. That's your actual monthly profit. Everything else is noise.
I keep this in Google Sheets because it syncs across devices and I can set up basic automation for date sorting and pivot tables. Excel works too. Whatever you use, the important part is consistency, not the tool. I've seen people switch apps every month and never build the habit of actually reading what they tracked.
Where This Actually Falls Apart
The journal won't save you if you're not honest about the numbers. A common mistake is writing off refunds as a small percentage without logging the individual cases. Your refund rate might be ten percent overall, but if forty percent of returns are coming from one product and you average it out, you'll keep restocking something that's bleeding you dry. Another issue is timing. TikTok payouts don't arrive on the same day sales happen. There's a processing window that varies by region and seller tier. If you're trying to match journal entries to your bank account deposits, they'll never line up perfectly. Build in a lag column so you're tracking when money actually lands, not just when it gets recorded as earned. And if you sell internationally through TikTok Shop's cross-border program, currency conversion adds another layer of friction. The platform handles it automatically but the rates aren't always favorable. I stopped guessing and added a column for the actual converted amount I received versus what the sale was listed in.
How to Build One Without Wasting a Week
Export your data from TikTok Shop Seller Center first. Go to the reports section and pull your transaction history, refund records, and payout summary. You'll get CSV files. Import those into your spreadsheet software and create columns for each data point I outlined above. Most of it already exists in the exports. The work is in organizing it so the relationships between columns are clear. If you're doing this for the first time, start with just one month of data. Fill in every row. You'll immediately see what information is missing, what fields matter, and what the actual workflow looks like. Then set up recurring exports and stick to a schedule. Weekly exports during busy periods and monthly reconciliation at the end of each cycle. The whole process takes me about twenty minutes a week once everything is set up. Setting it up from scratch took me three days because I kept rearranging columns and second-guessing what to track. Don't overthink the setup. Start with the basics and add detail as you notice gaps.
