TikTok Shop Seller Profit Tracker Excel — products & pricing, sales log, expenses, and a monthly P and L dashboard. Know what every line actually pays — and whether the month actually made money. Built for TikTok Shop…
About this template
TikTok Shop Seller Profit Tracker Excel — products & pricing, sales log, expenses, and a monthly P and L dashboard. Know what every line actually pays — and whether the month actually made money. Built for TikTok Shop sellers who see a sales number in the seller center but cannot tell which products actually made money after product cost, shipping, samples, ads, and refunds.
$49
Excel & Google Sheets template — instant download on Etsy
Products & Pricing — Every product: gross sales, orders, revenue per order, add-on revenue from live sessions and bundles, total revenue, and direct product and shipping cost. Change a price and the per-order rate and totals update.
Sales Log — Every product line: date, product, entry, orders, rate pulled from sheet 1 by formula, amount, and whether it was billable. Add-on rows are priced per entry, and refund handling is logged as non-billable.
Expenses — every overhead cost by category (Ads, Software, Equipment, Supplies, Packaging, Fees, Other), with quantity, cost per unit, and a monthly cost for each.
Monthly P and L — revenue, direct cost, ads, software, equipment, supplies, packaging, fees, other and other expenses by month, Jan-Dec, with net profit and margin. Revenue is a formula from the Sales Log; direct cost is a formula from sheet 1.
Dashboard — total revenue, products, units, billable vs non-billable units, units vs target, average revenue, direct cost, expenses, net profit and margin, best and weakest lines, revenue by line, costs by category, and units by line.
Cover and How to Use — start here. Yellow cells are the only ones you edit.
Try the headline numbers for a typical month. The full template does this job by job with a monthly P&L and dashboard.
Frequently asked questions
What does the TikTok Shop Seller Profit Tracker track?
The TikTok Shop Seller Profit Tracker tracks Products & Pricing; Sales Log; Expenses; Monthly P and L; Dashboard.
What do the example numbers show?
The included example shows: 12 lines; gross revenue 25,545; add-on revenue 475; total revenue 26,020; direct cost 15,100.
Does it work in Excel and Google Sheets?
Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.