A TikTok Shop profit spreadsheet usually breaks in the same few places: payouts that mix orders from different weeks, refunds that land after you've closed the month, product costs that changed partway through, and fee lines that don't map to your columns. Seller Sync replaces the copy-and-paste part and keeps the part you like, which is Excel. Every report it generates is an Excel workbook, and you can make it your own template.
Here's where the spreadsheet method goes wrong, when it's still the right call, and what changes if you automate it.
How the spreadsheet version usually works
- Export the settlement report from Seller Center, Finances → Statements → Export.
- Export orders for the same period.
- Pull ad spend from Ads Manager or the GMV Max tab.
- Paste everything into a master sheet and look up each SKU's cost from a costs tab.
- Subtract, sum and hope the totals match your bank.
It works. It also has to be redone from scratch every period, and the result is only as good as the last paste.
Where it breaks
Payouts don't belong to one week. TikTok pays an order after it's delivered and its settlement period has passed, which can be anything from 1 to 31 days depending on your tier (Dynamic Settlement and Reserve Policy). A single statement mixes orders from several weeks. If your sheet groups by statement date, your weekly profit is really "what happened to settle that week".
Refunds arrive later. A refund on an order that already paid comes out of a later payout. Close September on October 1 and some September refunds will show up in October's numbers instead.
Costs change. When a supplier raises a price, the honest way to handle it is to use the old cost for old orders and the new cost from the change date. A single costs tab with one price per SKU quietly rewrites your past margins every time you update it.
There are a lot of fee lines. The settlement export itemizes the referral fee, refund administration fee, affiliate commission, shipping, taxes and adjustments (settlement report guide). Seller Sync's P&L breaks TikTok fees into about ten lines and affiliate commission into seven. Each one is a chance for a column to land in the wrong bucket.
Samples count. Free samples sent to creators cost you product even though they bring in no revenue. They're easy to leave out of a sheet that starts from sales.
The data is in three places. Orders and payouts come from Seller Center, ad spend from Ads Manager and commission detail from the Affiliate Center. Every source is another export to keep in step.
When a spreadsheet is the right call
If you have one shop, a few dozen orders a week and stable costs, a monthly spreadsheet from the settlement export is fine. Do it after TikTok has closed the month's payouts, so the figures have stopped moving, and keep a column for the statement ID so you can trace every number back.
What Seller Sync changes
Seller Sync pulls orders, settlements, adjustments and ad spend through TikTok's official APIs every day, re-pulling the last 28 days each time so late refunds and settlements land on the right orders.
- Costs with dates. Enter a cost per SKU, or import a CSV of up to 20,000 rows. Each change applies to all orders, from today or from a date you pick, and every SKU keeps its cost history. A Needs a cost filter shows SKUs you haven't costed, and a coverage bar shows what share of units sold has a cost.
- Fixed costs. Add payroll, software or rent as one-time, daily, weekly or monthly expenses, and they come off net profit.
- A P&L that's already itemized. Gross sales, promotions, advertising, shipping, refunds, TikTok fees, affiliate commission, adjustments, cost of goods with samples separate, gross profit, expenses and net profit. Days whose orders are still settling are marked, so you know which numbers can still move.
- Excel when you want it. Every report downloads as an
.xlsxwith a Dashboard sheet, a Raw Data table and field definitions. Download the template, rebuild the Dashboard your way in Excel, upload it, and every future run fills your version with fresh data. Your formulas survive because they point at the Raw Data table, not at pasted ranges. - On a schedule. Run the report weekly or monthly without anyone pressing Export, and get a Slack message when it's done.
Seller Sync plans start at $49 a month after a 7-day free trial. If the spreadsheet takes you an afternoon a month, that's the trade to weigh.