How to Reconcile Your TikTok Shop Settlement Report
What reconciling actually means (and what it doesn't)
Reconciling your TikTok Shop settlement report means proving two things: (1) each order's Total settlement amount equals its sales minus every disclosed fee, and (2) the total of all settled orders for a period matches the money that actually landed in your bank — once you account for the reserve (a temporary held balance), not theft.
Be honest with yourself before you start: a typical seller nets roughly two-thirds of GMV after fees. That ~33% gap is overwhelmingly by design — referral commission, transaction fees, refund admin fees, and affiliate payouts. Reconciliation is not a treasure hunt to "recover hundreds." It's a control check: it confirms the platform charged the rate it published and catches the occasional real deviation (a referral fee billed at 9% when your category is 6%, a refund admin fee on an order that never shipped, a duplicate adjustment). Want the big-picture explanation first? Read why TikTok Shop is paying you less than your sales and try the built-in calculator there.
Step 1 — Download the settlement report (Order details sheet)
In TikTok Seller Center, go to Finances > Statements, choose the statement period you want to reconcile, and export it. The download is a spreadsheet (XLSX/CSV) with multiple sheets. The one you reconcile against is the Order details sheet — one row per order or adjustment.
Make sure your export covers a closed period that has already paid out, so there is a matching bank deposit to compare against. For transactions after September 25, 2025, also export the Reserve Details sheet — that's where held balances are itemized, and it explains most settlement-vs-payout gaps.
Step 2 — Understand the columns you'll match on
The Order details sheet contains the columns that make reconciliation possible. The ones that matter most:
| Column | What it is |
|---|---|
| Gross sales / Net sales | Item revenue before / after buyer-side discounts and tax handling. |
| Referral fee | TikTok's commission. ~6% US (5% jewelry), 9% UK (5% Electronics/Beauty), 9% EU, 1–10% banded in Indonesia. |
| Transaction fee | Payment processing, ~2% of order value. |
| Refund administration fee | 20% of the referral fee, capped at $5/SKU, only on completed post-ship refunds. |
| Affiliate commission | Creator payout if the order came through an affiliate. |
| Adjustment amount | Corrections, claims, promotions funded by you, chargebacks. |
| Total settlement amount | The bottom line for that row — what feeds your payout. |
| Type / Order ID | Whether the row is an order, refund, or adjustment, and its unique ID. |
Rates change by region and category, so treat the figures above as guidance and confirm yours in Seller Center > your fee schedule. For a deeper walkthrough of each line, see TikTok Shop seller fees explained, and for UK-specific bands read TikTok Shop seller fees UK 2026.
Step 3 — Reconcile each order (the per-row math)
For every order row, the identity you're verifying is simple:
Total settlement amount = Net sales − Referral fee − Transaction fee − Refund administration fee − Affiliate commission ± Adjustment amount
In a spreadsheet, add a check column that computes the right-hand side and subtracts the reported Total settlement amount. Every row should be 0 (allow a cent or two for rounding). Any row that isn't zero is your shortlist to investigate. Then run three rate checks:
- Referral fee % = Referral fee ÷ Net sales. It should match your category's rate. A US general-category order showing 9% instead of ~6% is a flag.
- Transaction fee % = Transaction fee ÷ order value, should sit near ~2%.
- Refund admin fee should appear only on completed post-ship refunds, should equal 20% of that order's referral fee, and should never exceed $5 per SKU. See how the TikTok Shop refund administration fee works if a row looks off.
Step 4 — Match the period total to your bank deposit
Now zoom out. Sum the Total settlement amount across every row in the period, then compare to what hit your bank. They usually won't be identical, and that's normal: payout = settlement ± reserve. TikTok may hold part of your settlement as a reserve (and release prior reserves), so:
Bank payout = Settlement total − new reserve held + reserve released
Pull those held/released figures from the Reserve Details sheet (for transactions after Sep 25, 2025) and the gap should close. If your payout is far below settlement and the reserve doesn't explain it, your funds may simply be on hold — see why your TikTok Shop payout is on hold. If a settlement total itself is negative, fees and refunds outran sales for the window: read how to fix a negative settlement on TikTok Shop.
Step 5 — Let the free auditor do it in seconds
Doing the per-row math by hand works, but it's slow and easy to fumble across hundreds of orders. The free TikTok Shop Payout Auditor ingests the exact same Order details export, recomputes every row's settlement identity, derives each fee percentage, and flags only the lines where a fee deviates from your category's published rate or a refund admin fee was charged on an order that shouldn't carry one. It runs 100% in your browser — your statement never leaves your device, and nothing is uploaded to a server.
Pair it with the TikTok Shop fee calculator 2026 to forecast take-home on new products before you list them. Selling in Southeast Asia? Indonesia uses category bands from 1–10% — the rules differ, so check biaya TikTok Shop seller 2026. The honest expectation: most months the auditor confirms everything reconciled correctly, and that confirmation — knowing your numbers are clean — is the real value.
Audit your whole month in seconds
Drop your TikTok Shop settlement export into the free auditor — it reconciles every order and flags anything that breaks TikTok’s own fee rules. 100% private, runs in your browser.
Open the free auditor →Where do I download the TikTok Shop settlement report?
In TikTok Seller Center, go to Finances > Statements, select the statement period, and export it. Reconcile against the "Order details" sheet, and for transactions after September 25, 2025, also export the "Reserve Details" sheet to explain any settlement-vs-payout gap.
Why doesn't my settlement amount match my bank deposit?
Because settlement amount is not the same as payout. Payout = settlement total minus any new reserve TikTok holds, plus any prior reserve released. Check the Reserve Details sheet to reconcile the difference. If the gap still doesn't close, your payout may be on hold for a verification or balance reason.
What formula should each order row satisfy?
Total settlement amount should equal Net sales minus Referral fee, Transaction fee, Refund administration fee, and Affiliate commission, plus or minus any Adjustment amount. Build a check column for this; rows that aren't ~0 (after rounding) are the ones to investigate.
Will reconciling help me recover money?
Usually not large amounts. Most of the gap between your sales and your payout is fees working as designed — a typical seller nets about two-thirds of GMV. Reconciliation mainly confirms each fee was applied at the correct published rate and catches the rare real error, such as a wrong referral-fee percentage or a refund admin fee on an order that never shipped.