Free local-file tool

Reconcile a TikTok Shop payout before it becomes a spreadsheet mystery.

Use the exported settlement data you already have. No Seller Center login, account connection or financial-data upload required.

Private, local-file analysis

Reconcile your TikTok Shop payout.

No account required
How this works

Your file stays in this browser. Nothing is uploaded or stored.

Important: This tool explains the numbers it recognizes. It does not determine whether TikTok made an error or create a dispute case.

Settled gross sales$12,000.00Revenue visible in the uploaded or example report
Known fees$2,961.00Referral, affiliate, shipping and refund-admin fees
Expected payout$8,401.00Before cost of goods, ads and operating expenses
Payout difference−$180.00Bank payout minus expected payout

Payout bridge

Where the settlement moved.

Settled gross sales
$12,000.00
Seller-funded discounts
−$420.00
TikTok-funded discounts
$180.00
Referral fees
−$720.00
Affiliate commission
−$1,800.00
Shipping fees
−$396.00
Shipping subsidies
$160.00
Refunds
−$540.00
Refund administration fees
−$45.00
Taxes withheld
−$0.00
Adjustments
−$18.00
Expected payout
$8,401.00

What it checks

From settled sales to expected cash.

The tool maps familiar columns for revenue, discounts, referral fees, affiliate commission, shipping, refunds, withholding and adjustments. It then shows the expected payout and any difference with a recognized payout amount.

It is intentionally conservative: unknown fields remain unknown. A clean result means the recognized data adds up; it is not a claim that a platform error did or did not occur.

Read the reconciliation workflow →