How to Reconcile TikTok Shop Payments: Statements, Payouts, and Bank Deposits
Direct answer: reconcile TikTok Shop payments by connecting four records with stable identifiers: the order and SKU, the settlement statement and line-item transactions, the payout plus reserve activity, and the deposit posted by the bank. Do not compare dashboard GMV directly to the bank. A settlement report is statement-based, not order-creation-based, and one payout can include later adjustments, reserves, refunds, fees, commissions and FBT charges from different orders.
The order-to-bank reconciliation chain
A useful reconciliation does not ask only whether the payout total looks reasonable. It proves how each statement amount became a payout and how that payout reached the bank. Every unresolved difference receives an owner, evidence status and next action.
Collect the source records before calculating
Seller Center reports answer different questions. Combining them into one undifferentiated spreadsheet removes the status and timing information needed to explain a difference.
| Record | What it proves | Primary identifiers | Where to obtain it |
|---|---|---|---|
| Order and SKU export | What was sold, quantity, discounts, fulfillment route and order event dates | Order ID, SKU, Goods ID | Seller Center order exports or authorized Order API |
| Settlement report | Final statement line items for sales, refunds, shipping, fees, commissions, adjustments, taxes and FBT charges | Statement ID, Order ID, SKU | Finances > Statements or Payouts > Export |
| On-hold/unsettled record | Orders and estimated entries not yet in a final statement | Order ID, transaction type, estimated amount | Finance > On hold or authorized Finance API |
| Payout and reserve record | How statement amount, reserve collection/release and other activity became a payout | Payment ID, Statement ID, expected release date | Finance/Payouts and reserve exports |
| Bank statement | Amount and date actually posted by the bank | Deposit amount, ACH descriptor, posting date | Seller-controlled bank record |
| Return/refund and tracking events | Why a sale changed and which party funded the refund or shipping event | Order ID, return ID, tracking number | Orders, Returns/Refunds and logistics records |
| FBT operational records | Inbound, inventory and removal events behind FBT charges or claims | IBR, WOP/WOT, OBC, Goods ID | FBT Merchant Portal and claim records |
TikTok’s official settlement guide says reports are generated daily and provide a settlement-based perspective, not an order-creation-based view. An order can therefore appear later than its creation date, and unsettled orders should remain in a pending population rather than being forced into the current payout.
Read the settlement statement as a ledger
The statement is not one fee calculation. It is a line-item ledger whose labels can change with report versions and seller programs. Preserve TikTok’s original transaction type, then map it to your accounting category.
Fields worth preserving at import
| Field group | Keep at minimum | Why it matters |
|---|---|---|
| Statement identity | Statement ID, statement date, statement/payment status | Defines the accounting batch and whether payment processing is complete |
| Order identity | Order ID, SKU, Goods ID, quantity | Prevents totals from hiding duplicate or missing line items |
| Sales and discount | Gross/net sales, seller discount, platform discount | Separates seller-funded economics from platform-funded incentives |
| Refund | Refund amount, shipping refund, commission refund, adjustment reason | Shows which components reversed and which remained |
| Fees and commissions | Original transaction label and signed amount | Avoids applying a guessed universal percentage |
| FBT | Fulfillment fee, warehouse service fee, shipping offset and related adjustment | Connects financial entries to fulfillment operations |
| Payout bridge | Payment ID, reserve collection/release, withdrawal or payment status | Explains why statement amount and bank deposit differ |
Step-by-step TikTok Shop payment reconciliation
1. Freeze the reporting period and timezone
Record the Seller Center market, export timestamp, timezone, currency and period. A bank posting date can trail the platform’s paid date, so keep transaction date, statement date, payout date and bank date as separate fields.
2. Import without changing source labels
Keep a raw tab or immutable table for each export. Normalize IDs and dates in a separate working model. This makes it possible to reproduce every transformation after TikTok changes a report column.
3. Build the order-to-statement bridge
Match each settled transaction to Order ID and SKU. Group statement lines only after the detailed match. Orders missing from statements should be checked against On hold or unsettled records before they are treated as missing payments.
4. Recalculate the statement from signed line items
Sum each statement’s sales, shipping, fees and adjustments using the signs in the export. Compare your calculated statement total to TikTok’s statement amount. Keep taxes and informational fields separate when they are not part of the payable formula for that report version.
5. Bridge statement to payout
Join Statement ID to the payout or payment record. Add reserve collection/release and any documented payout-level movement. A payout can contain more than one statement or later activity, so Payment ID is the stronger bridge than a date-only match.
6. Match payout to the bank
Match amount, currency, ACH descriptor and posting date. TikTok’s Finance FAQ says a Paid status means TikTok sent the payout; bank posting typically takes 1-3 business days. Treat that as an operating expectation, not a guaranteed bank deadline.
7. Reconcile refunds and FBT operations
For every refund, compare the order event to the gross-sales reversal, discount reversal, shipping, commission and adjustment lines. For FBT, connect charges and credits to the Goods ID and relevant IBR, WOP/WOT or OBC record. Operational inventory records prove what happened; the settlement proves what was financially recognized.
8. Move unresolved differences to a case queue
Do not overwrite a variance with a note such as “timing.” Give it a category, amount, owner, next check date, evidence status and applicable claim deadline. This is where reconciliation becomes reimbursement recovery.
Reserves, holds, payout statuses and negative balances
On hold is not the same as missing
Orders can remain unsettled while return, delivery, risk or other conditions are unresolved. Keep an aging report for On hold transactions, but do not add estimated unsettled API amounts to a final statement. TikTok states that unsettled amounts may change and final values come from statement APIs.
Paid is not the same as bank-posted
Finance statuses include On hold, Processing, Paid and Failed, while a statement can be Pending. A Paid payout still needs a bank match. A Failed payout needs its failure reason, corrected bank/control action and subsequent payment record.
Reserve activity changes payout timing
TikTok’s June 30, 2026 Dynamic Settlement and Reserve Policy describes introductory, standard, accelerated, express and deferred settlement tiers plus three reserve levels. It does not publish one universal period or reserve percentage for every seller. The policy states that a portion of earnings for each delivered order can be retained in reserve for 30 days from delivery, with assignment subject to evaluation and account conditions.
Payout scheduling is not universal
Daily, business-day, weekly and monthly payout scheduling is documented as a feature in testing for selected sellers. Changing a payout schedule does not change whether an order has settled.
Negative balances can absorb future sales
Refunds or platform expenses can exceed revenue and produce a negative balance. TikTok documents that it can be offset by future sales or paid separately; a balance-offset transaction does not necessarily create a bank payout. Reconcile the negative-balance payment or carryforward as its own ledger event.
Build an exception queue that can become a claim
| Exception | First checks | Evidence to preserve | Disposition |
|---|---|---|---|
| Order absent from final statements | On hold/unsettled status, cancellation, delivery and return events | Order export, status history, unsettled record | Pending, corrected, or investigate missing settlement |
| Statement does not recalculate | Signs, duplicated rows, report version and adjustment lines | Original export and calculation log | Data issue, mapping correction, or support ticket |
| Payout differs from statements | Reserve collection/release, multiple statements, failed/reversed payment | Payment ID, reserve export, payout status | Explained bridge or payout investigation |
| Bank deposit missing | Paid timestamp, bank posting lag, beneficiary/account status | Payout record and bank statement | Wait within normal posting range or escalate failed/missing ACH |
| Refund economics look wrong | Who funded refund, discount and shipping; commission/refund lines | Return/refund timeline and statement detail | Correct, explain, or claim a discrepancy |
| FBT fee or credit mismatch | Goods ID, fulfillment route, IBR/WOP/WOT/OBC and applicable fee schedule | FBT operation, invoice, statement and claim record | Accept, dispute, or prepare reimbursement claim |
| Creator commission remains after refund | Commission and refund transaction lines, campaign terms, dates | Order, creator attribution and statement entries | Explain timing/terms or investigate a missing reversal |
case_id,status,market,order_id,sku,goods_id,event_type,statement_id,payment_id,expected_amount,actual_amount,variance,trigger_date,claim_deadline,evidence_status,owner,next_action,next_check_date,outcome
Keep source files immutable. The case queue records conclusions and actions, not replacements for the original exports.
Potential refund duplication deserves its own test. See how to identify duplicate TikTok Shop refunds in settlement reports. For evidence requirements, use the reimbursement policy guide and FBT evidence checklist.
Manual exports vs TikTok Shop Finance API
A spreadsheet is sufficient for a controlled first reconciliation. The Finance API helps when volume, repeatability or aging analysis makes manual downloads unreliable. API access must use TikTok’s OAuth-based authorization and the documented `seller.finance.info` scope where required.
| Method | Best for | Main control | Limitation |
|---|---|---|---|
| Seller Center exports | First audit, monthly close, human review | Save original file and export timestamp | Manual repetition, changing report columns, limited automation |
| Finance API | Daily ingestion, transaction-level joins, aging and monitoring | OAuth authorization, versioned endpoint, pagination and raw response archive | API data windows and fields do not necessarily match Excel exports |
Verified Finance API endpoints
| Purpose | Official endpoint | Important limitation |
|---|---|---|
| List statements | GET /finance/202309/statements | Filter by statement time and payment status; preserve pagination. |
| Transactions by statement | GET /finance/202501/statements/{statement_id}/statement_transactions | Order, adjustment and reserve-related transactions; `seller.finance.info`. |
| Transactions by order | GET /finance/202501/orders/{order_id}/statement_transactions | Covers sales, fees, commissions, shipping, taxes and refunds. |
| Unsettled transactions | GET /finance/202507/orders/unsettled | Estimated, changeable amounts; final values come from statement APIs. |
| Withdrawals | GET /finance/202309/withdrawals | Types include withdrawal, settlement, transfer and reverse. |
The transaction endpoints document data from July 1, 2023, with a separate limitation for some US cross-border data before April 30, 2025. Check the current endpoint page before implementation; version dates in the path are part of the contract.
Worked reconciliation example
The following numbers are illustrative and are not a TikTok fee schedule.
| Bridge line | Illustrative amount | Control |
|---|---|---|
| Net sales | $95.00 | Matched to detailed order/SKU lines |
| Shipping | +$4.00 | Matched to statement shipping entries |
| Fees | -$8.00 | Actual signed statement lines, not a guessed percentage |
| Adjustments | +$2.00 | Reason and source transaction preserved |
| Statement amount | $93.00 | $95 + $4 – $8 + $2 |
| Reserve activity | -$10.00 | Matched to reserve collection and expected release |
| Expected payout | $83.00 | Statement amount plus signed reserve amount |
| Bank deposit | $83.00 | Matched by Payment ID context, amount and posting date |
If the bank posted $75 instead, the $8 variance would remain open. The next checks would be another reserve movement, a failed/reversed payment, multiple statements in one payout, a negative-balance offset or a bank posting split. It should not be assigned to “fees” without a line-level record.
Month-end close checklist
- Every final statement recalculates from signed line items.
- Every statement is assigned to a payout/payment or a documented pending status.
- Every paid payout is matched to a bank deposit or failed/reversed event.
- Reserve collections and releases are aged to their expected dates.
- Negative balances and manual balance payments are separately identified.
- Refund, commission and FBT exceptions are connected to the original order and event.
- Open cases include evidence, owner, next action and claim deadline.
TikTok Shop payment reconciliation FAQ
Why does my TikTok Shop payout not match GMV?
GMV is not a bank-reconciliation figure. Settlement statements can include sales, discounts, refunds, shipping, fees, commissions, FBT charges, taxes and adjustments, while payout amount also reflects reserve activity and timing.
What is the most important reconciliation key?
No single ID connects every layer. Use Order ID and SKU for order-to-transaction matching, Statement ID for settlement batching, and Payment ID plus amount/date for the payout-to-bank bridge.
Does Paid mean the money is in my bank?
No. Paid means TikTok sent the payout. The official Finance FAQ says bank posting typically takes 1-3 business days, so the payout still needs a bank match.
Should unsettled API amounts be treated as final revenue?
No. TikTok says unsettled transactions are estimates that may change. Use final statement APIs or statement exports for settled values.
Is there one standard TikTok Shop fee percentage?
No. Fees and commissions can vary by category, campaign, seller status, fulfillment program and effective date. Reconcile the actual statement line and verify it against the schedule applicable to that transaction.
How often should TikTok Shop payments be reconciled?
Import statements and payout changes daily for active monitoring, then complete a controlled monthly close. Time-sensitive reimbursement cases should enter the claim queue as soon as the variance is verified.
Official sources
- How to Access Your Settlement Report, September 11, 2025. Daily reports, settlement perspective, fields and formulas.
- Finances Page FAQ, August 11, 2025. Finance statuses, bank reconciliation, minimum payout and negative carryforward.
- Dynamic Settlement and Reserve Policy, June 30, 2026. Current tier/reserve framework and account-specific evaluation.
- How to View Your Reserve Record, September 11, 2025. Reserve exports and payout bridge.
- Scheduling your payouts, August 20, 2025. Selected-seller payout scheduling test.
- How to Pay Off Negative Balances, September 12, 2025. Carryforward and separate balance payment.
- Customer Order Cancellation, Return, and Refund Policy, July 8, 2026. Current refund and return context.
- Fulfilled by TikTok (FBT), July 9, 2026. Current FBT overview.
- FBT Inbound Request Creation and Management Process, April 8, 2026. IBR operations and fees/events to reconcile.
- Finance API overview and linked official endpoint references.
- Get Statements; Get Transactions by Statement; Get Transactions by Order; Get Unsettled Transactions; Get Withdrawals.
Turn unexplained payout differences into a controlled case queue
FBTops traces orders through statements, reserves, payouts and FBT records, then separates correctly settled amounts from potential refund, fee, inventory and reimbursement exceptions.
Request a free 14-day audit Independent service. Not affiliated with TikTok. Results depend on available account records and applicable policy.