Xargaar ToolsTurn a TikTok Shop settlement report into a monthly summary and a payment check.
Drop in your Settlement report (the .xlsx file, or its Order details sheet as CSV). Every row is checked against TikTok Shop's own formula for Total settlement amount. See each month's net sales, shipping, fees and adjustments, and each Payment ID added up so you can compare it with what your bank received. The pack gives you a journal CSV. Nothing is uploaded.
Tested only on made-up files, never on a real TikTok Shop export. Column names come from TikTok Shop's own column definitions, so the tool stops with a message if a needed one is missing. Only rows with Status Paid are counted. A payout can also include a reserve amount, so a difference from your bank is a reason to look, not a verdict. It does not check your TikTok Shop account or your bank.
Set these to match your files before you drop them. Nothing is guessed. Limits: 20 files, 40 MB each, 200 MB in total, 60,000 rows per file and 300,000 in total.
What it does
Every row must satisfy TikTok Shop's formula: Total settlement amount = Net sales + Shipping + Fees + Adjustment amount. A row that does not stops the file with its row number.
Each month gets net sales, shipping, fees, adjustments and total settlement from the Paid rows, with a Type breakdown.
Paid rows added up by Payment ID, with a box to type what your bank received.
Pay once. Work through all your settlements.
- All months and payments in your files instead of the first 3.
- One journal CSV covering the months that pass the checks, with an account for each amount group that you choose, plus CSVs by Type and for every payment with your typed bank amounts.
- One folder that opens in your browser with no internet. Your TikTok Shop data stays on your computer.
Questions
Which file do I use?
In Seller Center, go to Finance, then Statements or Payments, and click Export. The settlement report is an Excel file with several sheets. The tool reads the sheet called Order details. You can also save that sheet as CSV. It needs the columns Statement Date, Status, Type, Net sales, Shipping, Fees, Adjustment amount and Total settlement amount (TikTok Shop's definitions: seller-us.tiktok.com/university, "How to Access Your Settlement Report"). Payment ID is used for the payments table when it is in the file.
Why are there settings?
Number and date styles depend on your account. You tell the tool the currency, the number and date format, how empty amounts are shown, and how many lines come before the header, so nothing is guessed. Dates stored as Excel dates are read as they are.
Does it prove my payout is right?
No. TikTok Shop says payout amount is the statement amount plus a reserve amount. The table shows the Paid rows' total next to what you type, so a difference can be a reserve or a timing gap.
Is the journal entry accounting advice?
No. It is a starting point built from the month's totals and the accounts you type. Your accountant decides how TikTok Shop items are booked. The tool makes no tax or accounting claims.
Is anything uploaded?
No. The file is read on your device, including the .xlsx.