TikTok Shop reconciliation

Why TikTok Shop is hard to reconcile

TikTok Shop is one of the fastest-growing sales channels in ecommerce, and one of the hardest to reconcile. It combines the bundled-payout problem of every marketplace with a fee structure that's deeper and less transparent than most:

• Lump-sum settlements. TikTok settles many orders in a single deposit. The amount that hits your bank is net of everything below, so it never matches the gross revenue in your order system.
• A multi-layered fee stack. Commission, referral fees, affiliate and creator commissions, and platform promotions or subsidies are all netted out before you're paid. Each layer has to be identified and booked to the right account.
• Promotions and subsidies. Platform-funded discounts and seller-funded promotions hit the settlement differently and are easy to misclassify as lost revenue or margin.
• Payout timing. Settlements lag the sale, so revenue and cash land in different periods.
• Refunds and returns. These arrive on their own schedule, often disconnected from the originating order.
• Duplicate orders and transactions. Depending on your fulfillment and reporting setup, TikTok Shop orders often also flow through Shopify, creating duplicate orders or transactions that overstate revenue if they aren't caught.

The result is the same as every other channel, only worse: the settlement is a "mystery number," and matching it back to orders by hand is a slow, error-prone monthly exercise, especially when TikTok Shop is only one of several channels you're closing.

How to reconcile a TikTok Shop settlement (the three-way match)

At its core, TikTok Shop reconciliation is a three-way match, the same model that works across every channel:

1. Order: the sale recorded in TikTok Shop (what the customer bought).
2. Settlement / statement: what TikTok actually settled, net of commission, referral, affiliate, and promotion adjustments.
3. Payout / bank deposit: the lump-sum cash that landed in your bank.

Reconciliation ties order → settlement → payout, accounts for every fee, promotion, and refund in between, and posts the correct entry to your general ledger so the books reflect reality instead of a bundled deposit.

How Blue Onion automates TikTok Shop reconciliation

Blue Onion connects directly to TikTok Shop and imports your orders, settlement statements, fees, and payouts automatically. It categorizes TikTok's multi-layered fee structure and reconciles each lump-sum bank deposit back to the underlying transactions across the full chain: bank → settlement → order. When TikTok Shop orders also flow through Shopify because of how your fulfillment and reporting are set up, Blue Onion identifies and resolves the resulting duplicate orders and transactions directly, so revenue is counted once and tied to the right payout.

On that reconciled foundation, the Close module performs the order → settlement → payout three-way match across systems and posts daily summary journal entries to NetSuite, QuickBooks, or Xero with a full audit trail, turning a multi-day reconciliation into a quick daily review. Late refunds and re-cleared settlements are auto-detected and booked to the right period, and because TikTok Shop is reconciled in the same source of truth as your other channels, closing a multi-channel brand stops being a per-channel spreadsheet project.

Who needs automated TikTok Shop reconciliation

If TikTok Shop is a meaningful and growing share of your revenue, and especially if you're also selling on Shopify, Amazon, or other channels, manual settlement matching won't keep up. Blue Onion is built for growing and mid-market ecommerce brands, typically $10M–$500M+ in annual revenue, closing in NetSuite, QuickBooks, or Xero. If your team spends days each month untangling TikTok settlements in spreadsheets, that's the signal you've outgrown manual reconciliation.

FAQ

Why doesn't my TikTok Shop payout match my sales?

TikTok deposits a single settlement that's net of commission, referral fees, affiliate and creator commissions, promotions, and refunds. The deposit is net; your order revenue is gross, so the two never match until the settlement is broken back down and reconciled to the underlying orders.

What fees does TikTok Shop take out before paying me?

TikTok nets out a multi-layered fee stack that can include platform commission, referral fees, affiliate and creator commissions, and platform or seller-funded promotions, along with refunds and adjustments. Each has to be booked to the right account for revenue and margin to be accurate.

Can TikTok Shop reconciliation be automated?

Yes. Blue Onion connects directly to TikTok Shop, imports orders, settlement statements, fees, and payouts, categorizes the fee structure automatically, and reconciles each lump-sum deposit back to individual orders, then posts daily entries to NetSuite, QuickBooks, or Xero.

How do I reconcile TikTok Shop in NetSuite, QuickBooks, or Xero?

Match each settlement to its orders and fees, then post an entry that books revenue, fees, promotions, and refunds correctly. Blue Onion does this automatically and posts daily journal entries to your ERP with a full audit trail.

Why do TikTok Shop orders show up twice in Shopify?

Depending on how your fulfillment and reporting are configured, TikTok Shop orders can also flow through Shopify, creating duplicate orders or transactions that overstate revenue. Blue Onion identifies and resolves these duplicates directly, so each sale is counted once and reconciled to the correct payout.