01
Follow the money
See gross sales, reductions, settlement, reserve activity, and recorded payout in one signed trail.
Free local tool for TikTok Shop sellers
See how your TikTok Shop export gets from sales to payout.
Drop in the settlement workbook and get a plain-English trail through refunds, fees, adjustments, reserves, and the payout recorded in the export.
- No plugin
- No login
- No cloud upload
Fictional demo -- no seller dataRuns on this device
One ugly export, one readable trail
Stop hunting through workbook columns for the answer.
Payout Lens keeps the signs intact, shows the arithmetic, and separates a useful review prompt from a claim that a charge was wrong.
Try it with fictional dataPayout trail
Fictional settlement export
- 1Gross sales$12,000
- 2Refunds + discounts-$1,200
- 3Net sales$10,800
- 4Shipping+$250
- 5Fees-$1,700
- 6Adjustments-$450
- 7Settlement$8,900
- 8Reserve-$300
- 9Payout$8,600
$300.00 held in reserveJuly 15 to July 16, 2026
What it gives you
A useful answer, not a fake accounting system.
02
Find what reduced it
Group the export's largest deductions instead of scanning hundreds of workbook cells by hand.
03
Know what to review
Get row references for negative adjustments, missing reasons, unpaid items, and math differences.
Exact input
.xlsx settlement report
- Required tab
- Order details
- Maximum size
- 25 MB
Not supported: CSV, PDF, legacy .xls, Orders reports, and Sales reports.
Three clicks to the reveal
- 01
Open the tool
Launch it in your browser or save the single HTML file anywhere on your computer.
- 02
Try the fictional demo
See the complete payout reveal immediately without using real seller data.
- 03
Choose your workbook
Use a TikTok Shop settlement .xlsx that contains the Order details tab. Processing stays on your device.
Screenshot guide included
You will know what to click before using real data.
Screen 01
Start with the right export
The opening screen names the accepted file and tab before you choose anything.
Screen 02
See what moved the total
Signed amounts show what the export says added to or reduced the payout.
Screen 03
Leave with a clean review list
Export a payout summary and the exact workbook rows worth checking in Seller Center.
Local by design
Your workbook stays on your device.
The HTML file contains the interface and workbook parser. There is no account, server, analytics call, API key, or upload step.
Runs locally
Browser processing
No login
Nothing to connect
Inspectable
One HTML file
Honest boundary
What Payout Lens does not claim.
- Payout Lens explains the signed amounts and arithmetic already present in the export.
- It does not prove that a fee is wrong or inspect your bank activity, ad spend, product costs, or outside shipping costs.
- It is not affiliated with TikTok and is not accounting, tax, legal, or financial advice.
Need your own version?
This is what a useful custom tool can feel like.
If your team has a workbook, report, or handoff everyone keeps translating by hand, Sonny Automation can map the logic and package the useful part.
Map my workflowFree to use and keep