TikTok Shop Xero Integration: Complete Setup Guide (2026)
TikTok Shop settlements combine gross sales, referral fees, affiliate commissions, TikTok Ads spend, and refunds into one net payout that is never equal to your revenue. This guide covers the correct Xero chart of accounts, step-by-step SyncTools integration, VAT handling for UK sellers, and how to reconcile TikTok Shop payouts cleanly in Xero.
TikTok Shop reached more than 500,000 US sellers within its first year of launch and has expanded rapidly into the UK, where social commerce is growing faster than any other retail channel. UK sellers — who overwhelmingly use Xero as their accounting system — face a specific problem: TikTok Shop has no native Xero integration, and the platform’s settlement structure is more complex than any other marketplace most of them have dealt with.
A TikTok Shop payout is not your revenue. It is gross sales minus referral fees, minus affiliate commissions paid to creators who drove sales, minus TikTok Ads spend charged in the period, minus refunds — all collapsed into one net deposit. Record that deposit as income in Xero and your P&L misrepresents your margins from the first week you sell. This guide covers how to set it up correctly.
TL;DR: TikTok Shop settlements combine gross sales, referral fees, affiliate commissions, TikTok Ads spend, and refunds into one net payout — a number that is never equal to your revenue. Recording the deposit as income misrepresents your Xero P&L and hides every fee as an invisible deduction. SyncTools connects TikTok Shop to Xero in 15–30 minutes, posting each settlement component to the correct account automatically — no CSV exports, no manual journals, no reconciliation spreadsheets.
Using QuickBooks Online instead of Xero? See the TikTok Shop QuickBooks integration guide.
Related: TikTok Shop accounting guide — chart of accounts, payout anatomy, and fee structure for TikTok Shop sellers before connecting any integration.
Why TikTok Shop Sellers on Xero Have an Accounting Problem
Xero’s bank reconciliation tools are purpose-built for the way UK accounting works — VAT returns, bank feeds, and the matching workflow are excellent. The problem is that TikTok Shop’s settlement structure defeats Xero’s default reconciliation model before you’ve synced a single transaction.
When a Xero bank feed receives a TikTok Shop payout deposit, it sees one number. It does not see:
- Gross GMV — the total value of all sales in the settlement period
- Referral fees — typically 2–8% of GMV depending on product category
- Affiliate commissions — 5–20% of GMV on creator-driven sales through TikTok Shop Affiliate, already deducted before the deposit
- TikTok Ads spend — Spark Ads, Shopping Ads, and LIVE Shopping Ads charged against your payout balance
- Refunds — returns processed in the period, reducing your payout
- VAT collected — marketplace facilitator VAT that TikTok remits directly to HMRC (not your income, but often booked incorrectly)
A UK seller doing £20,000 per month GMV with a 5% referral fee, 10% affiliate commission rate on half their sales, and £800 in TikTok Ads spend is absorbing more than £2,800 per month in costs that disappear into the net payout. Those costs are invisible to a Xero P&L that records only the net deposit as income.
Here is what distinguishes TikTok Shop from other platforms UK sellers deal with: affiliate commissions are already deducted from your payout before the money arrives in your bank, and they are not itemised on the settlement report in the same prominent way as referral fees. If you are not specifically mapping affiliate commissions from the settlement report to a separate Xero expense account, you will understate your selling costs and overstate your gross margin on TikTok-sourced revenue every single period — without any obvious reconciliation error to flag it.
Citation capsule: Xero has more than 4.2 million subscribers globally, with dominant market share in the UK, Australia, and New Zealand (Xero Annual Report 2024). TikTok Shop is the fastest-growing social commerce marketplace in those same markets — and offers no native Xero integration as of 2026.
Related: Xero eCommerce accounting guide — the full automation playbook for Shopify, Amazon, and WooCommerce sellers on Xero.
TikTok Shop Xero Integration Options
Three approaches exist for getting TikTok Shop data into Xero:
| Method | Real-Time Sync | Fee Separation | VAT Handling | Affiliate Commission Tracking | Best For |
|---|---|---|---|---|---|
| Manual CSV Export | No | Manual only | Manual only | Manual only | Under 20 orders/month |
| Third-Party CSV Importer | No | Partial | Partial | Rarely | Low-volume, simple setups |
| Dedicated Sync App (SyncTools) | Yes | Full | Full (liability account) | Full (separate expense line) | Most growing stores |
Manual CSV Export
TikTok Shop Seller Center provides payout reports and fee statements. Xero accepts CSV bank statement imports. At very low volume — under 20 orders per month — manual export is possible, but requires extracting affiliate commissions and referral fees from separate settlement report sections and manually posting VAT to a liability account. Most UK sellers outgrow this within their first few months of selling on TikTok Shop.
Third-Party CSV Importers
Some accounting add-ons accept TikTok Shop CSV exports and map them to Xero. These improve on raw import but rarely separate affiliate commissions from referral fees as distinct expense lines, and they don’t produce the clearing account structure needed for clean Xero bank reconciliation.
Dedicated Sync App (SyncTools)
SyncTools connects directly to the TikTok Shop API — no CSV downloads, no manual steps. Every order, referral fee, affiliate commission, TikTok Ads charge, refund, and payout settlement syncs to Xero automatically. The clearing account model means each TikTok Shop payout deposit matches a cleared Xero account balance in one click. The rest of this guide covers the setup.
Setting Up Your Xero Chart of Accounts for TikTok Shop
Build the right account structure in Xero before connecting the integration. Retrofitting your chart of accounts after syncing three months of data is significantly more work than configuring it correctly up front.
Recommended TikTok Shop Accounts in Xero
Revenue accounts:
- TikTok Shop Gross Sales — full GMV at the order amount, before any fees or refunds
- TikTok Shop Shipping Income — shipping charges collected from customers (if you want to track separately; many sellers fold it into gross sales)
Contra-revenue accounts:
- TikTok Shop Refunds — returns and cancellations, reducing gross sales to net revenue
Direct cost / expense accounts:
- TikTok Referral Fees — platform fees (2–8% of GMV by category), best categorised as Direct Costs
- TikTok Affiliate Commissions — creator commissions from the TikTok Shop Affiliate program (Direct Costs or Sales Expense depending on how your accountant classifies creator-driven acquisition costs)
- TikTok Shop Ads — Spark Ads, Shopping Ads, and LIVE Shopping Ads spend (Advertising Expense or Marketing Expense)
Liability accounts:
- VAT Payable — for UK sellers: VAT collected by TikTok Shop on your behalf and remitted directly to HMRC. If you already have a VAT Payable account in Xero, use it; just ensure TikTok-collected VAT is separated from VAT you collect yourself on other channels.
Clearing accounts (bank-type in Xero):
- TikTok Shop Clearing — the transit account that holds the gross breakdown until your TikTok Shop payout arrives in your bank feed. This is the account that makes Xero bank reconciliation one-click rather than a manual matching exercise.
Why the Clearing Account Matters
TikTok Shop deposits a net amount to your bank every 1–3 business days. Without a clearing account, every deposit arrives in Xero as an unexplained lump sum.
With a clearing account: SyncTools posts gross sales, referral fees, affiliate commissions, TikTok Ads charges, and refunds to TikTok Shop Clearing as each transaction occurs. By the time the net deposit hits your Xero bank feed, the clearing account balance equals that deposit exactly — Xero matches them automatically. One click per payout cycle, no manual journal.
Step-by-Step: Connecting TikTok Shop to Xero with SyncTools
Step 1 — Set Up Your Xero Chart of Accounts
In Xero, navigate to Accounting → Chart of Accounts and create the accounts listed above. Use the account types as described — revenue for gross sales, direct costs or expense for fees, bank for the clearing account, and current liability for VAT Payable. Do not create these as sub-accounts of existing accounts unless your accountant specifically requests it.
Step 2 — Connect TikTok Shop to SyncTools
- Create a SyncTools account at app.synctools.ai/on-boarding
- Click Add Integration and select TikTok Shop
- Authorize access via OAuth in TikTok Shop Seller Center
- SyncTools reads your order history, payout reports, referral fee statements, affiliate commission records, and TikTok Ads spend data
SyncTools never writes to or modifies your TikTok Shop store, listings, or settings. It has read-only access.
Step 3 — Connect Xero to SyncTools
- In SyncTools, click Add Accounting System and select Xero
- Complete Xero’s OAuth flow — select your Xero organisation
- SyncTools requests read/write access to contacts, invoices, credit notes, and bank transactions
No API keys or developer credentials are required. Authorization takes approximately 60 seconds.
Step 4 — Map Transaction Types to Xero Accounts
SyncTools reads your Xero chart of accounts and pre-fills a recommended mapping. Review and confirm:
| TikTok Shop Transaction Type | Recommended Xero Account |
|---|---|
| Gross product sales | TikTok Shop Gross Sales (revenue) |
| Shipping collected | TikTok Shop Shipping Income (revenue) |
| TikTok referral fees | Direct Costs: TikTok Referral Fees |
| Affiliate commissions | Direct Costs: Creator Commissions |
| TikTok Ads spend | Advertising Expense |
| Customer refunds | TikTok Shop Refunds (contra-revenue) |
| VAT collected (UK sellers) | VAT Payable (current liability) |
| Payout deposit | TikTok Shop Clearing (bank-type) |
Step 5 — Configure VAT Settings (UK Sellers)
In SyncTools settings, confirm:
- Marketplace facilitator VAT is set to post to a liability account (VAT Payable), not a revenue account
- Xero tax rate applied to TikTok-collected VAT is set to 20% (VAT on Income) for standard-rated goods
TikTok Shop collects and remits this VAT to HMRC directly. It appears in your payout report as a line item, but it is never your income and should not appear in Box 1 of your Xero VAT return as output tax you owe — TikTok already settled it.
For Australian GST (10%) and New Zealand GST (15%), SyncTools applies the correct Xero tax rate so your GST return populates automatically from TikTok Shop sales data.
Step 6 — Run Your First Sync and Verify
Click Sync Now to import recent TikTok Shop transactions. Open Xero and verify:
- Gross sales appearing in TikTok Shop Gross Sales (not the net deposit amount)
- Referral fees appearing as a separate Direct Costs line
- Affiliate commissions appearing as a separate expense (not hidden in gross sales or the deposit)
- VAT Payable balance matching TikTok-collected VAT for the period
- TikTok Shop Clearing account balance matching your pending TikTok Shop payout
When your next payout arrives in the Xero bank feed, SyncTools auto-matches it to the clearing account — one click to reconcile.
Understanding the TikTok Shop Settlement Report
TikTok Shop issues settlement reports every 1–3 business days. Each report covers a payout period and includes:
Gross GMV — total order value including all items sold in the period, before any deductions
Referral fees — TikTok’s platform commission by product category. Electronics typically sit at 2–3%, fashion at 5–6%, beauty and personal care at 6–8%. Rates change periodically — SyncTools reads the fee amounts directly from your settlement report rather than applying a fixed percentage.
Affiliate commissions — the amount paid to TikTok Shop Affiliate creators who drove sales in the period. This line is easy to overlook because it’s itemised separately from referral fees and does not appear prominently in the Seller Center dashboard. It is often the largest single cost item for sellers who have grown through the TikTok Shop Affiliate program.
TikTok Ads spend — total spend on Spark Ads, Shopping Ads, and LIVE Shopping Ads charged against your payout balance during the period
Refunds — completed return amounts deducted from your payout
VAT (UK sellers) — marketplace facilitator VAT collected and remitted to HMRC by TikTok, shown as a line item but not your income
Net payout — gross GMV minus all of the above
SyncTools reads each line item from the settlement report API and posts it to the correct Xero account. You do not need to download or interpret the settlement report manually.
VAT Handling for UK TikTok Shop Sellers
TikTok Shop is a marketplace facilitator under UK VAT law. This means TikTok collects VAT from UK buyers and remits it directly to HMRC — the seller does not need to include this VAT on their own VAT return.
The correct Xero treatment for UK sellers:
- VAT collected by TikTok → VAT Payable (current liability) — because TikTok remits this, the liability clears automatically and does not appear in Box 1 of your VAT return as output tax you owe
- Input VAT on TikTok fees and ads → recoverable input tax in your Xero VAT return, as normal
- Your own VAT-registered sales on other channels (if applicable) → handled separately, as normal
This is different from running a direct-to-consumer BigCommerce or WooCommerce store, where you collect and remit VAT yourself and it appears in Box 1. If you sell on both TikTok Shop and a self-hosted store, SyncTools separates the two VAT streams by source.
Reconciling TikTok Shop Payouts in Xero
Each TikTok Shop payout should produce a one-click reconciliation in Xero when you use the clearing account model.
The reconciliation flow:
- TikTok Shop order placed → SyncTools posts gross sale to TikTok Shop Clearing and TikTok Shop Gross Sales
- Referral fee deducted → SyncTools posts referral fee to TikTok Referral Fees expense and reduces TikTok Shop Clearing by the same amount
- Affiliate commission deducted → SyncTools posts to Creator Commissions expense and reduces TikTok Shop Clearing
- TikTok Ads charged → SyncTools posts to Advertising Expense and reduces TikTok Shop Clearing
- Refund processed → SyncTools posts to TikTok Shop Refunds and reduces TikTok Shop Clearing
- Net payout deposits in your bank → Xero bank feed imports the deposit → SyncTools auto-matches to TikTok Shop Clearing → one click to reconcile
At step 6, the clearing account balance should equal the net payout deposit exactly. If there is a discrepancy, SyncTools flags it with a per-line trace showing which transaction type produced the gap.
Common TikTok Shop Xero Setup Mistakes
Recording the net payout as revenue. The single most common error. The net deposit is not your revenue — it is gross sales minus four or five different cost categories. Recording it as income understates gross sales, hides fees, and produces a P&L that cannot tell you your actual TikTok Shop gross margin.
Not separating affiliate commissions from referral fees. Both are TikTok-side costs, but they have different economic drivers. Referral fees are fixed by category and non-negotiable. Affiliate commissions are a variable cost you control through commission rates and creator selection. If they’re lumped together in Xero, you can’t see the ROI of your affiliate strategy.
Mapping VAT collected to income. TikTok-collected VAT is a liability, not revenue. Mapping it to income overstates your P&L by the full VAT amount every period.
Skipping the clearing account. Without a clearing account, each TikTok Shop payout arrives in Xero as an unexplained bank deposit. Reconciliation requires manually tracing gross sales, fees, and refunds to the deposit amount — a process that takes 20–60 minutes per payout period and produces errors.
Using a fixed referral fee percentage instead of reading from the settlement report. TikTok Shop referral fee rates change, vary by category, and can be discounted for promotional periods. Hardcoding a percentage produces fee amounts that drift from actuals every time TikTok adjusts its fee schedule.
Internal Links
- TikTok Shop accounting guide — chart of accounts, payout anatomy, and fee structure
- TikTok Shop QuickBooks integration — same guide for QuickBooks Online users
- Xero eCommerce accounting guide — Xero setup for Shopify, Amazon, and WooCommerce
- BigCommerce Xero integration — Xero integration guide for BigCommerce sellers
- eCommerce bookkeeping guide — accounting fundamentals behind every marketplace integration
Frequently Asked Questions
Does TikTok Shop have a native Xero integration?
TikTok Shop does not offer a built-in Xero integration as of 2026. SyncTools bridges the gap — syncing TikTok Shop orders, referral fees, affiliate commissions, VAT, and payouts into the correct Xero accounts automatically.
How long does the TikTok Shop Xero setup take?
Most sellers complete the initial setup in 15–30 minutes using SyncTools. Both platforms use OAuth authorization — no API keys required. The account mapping step takes the most time; the sync runs automatically once mapping is confirmed.
Can SyncTools backfill historical TikTok Shop data into Xero?
Yes. SyncTools supports historical backfill of up to two years of TikTok Shop data on Standard and Plus plans — useful when migrating from manual spreadsheets or setting up Xero mid-year.
What is the correct way to record TikTok Shop affiliate commissions in Xero?
Record the full affiliate-driven GMV as gross sales, then post the affiliate commission to a Creator Commissions expense account. Never net the commission against gross sales. This is the only method that shows the actual ROI of your TikTok Shop Affiliate program in Xero.
Which Xero plan do I need for TikTok Shop?
The Xero Growing plan or higher. Xero Starter limits invoices and bills, which constrains sellers processing more than five TikTok Shop orders per month. UK sellers selling into multiple EU currencies need Xero Established for native multi-currency support. SyncTools works on all Xero plans — the plan restriction is Xero’s, not SyncTools’.
Does TikTok Shop Xero integration work for Australian and New Zealand sellers?
Yes. SyncTools applies the correct Xero GST rate (10% for Australia, 15% for New Zealand) to TikTok-collected GST, and posts it to a GST liability account so your GST return populates automatically. TikTok Shop remits GST directly to the ATO and IRD in both markets.
Ready to connect TikTok Shop to Xero? Start your free SyncTools trial — setup takes 15–30 minutes and no developer work is required.
Related guides:
- TikTok Shop accounting guide — payout anatomy, fee structure, and chart of accounts before connecting any integration
- TikTok Shop Sage integration — same payout reconciliation approach for Sage 50 and Sage Business Cloud, with MTD VAT handling
- TikTok Shop QuickBooks integration — same approach for QuickBooks Online
- Xero eCommerce accounting guide — the full automation playbook for eCommerce sellers on Xero
See the integration page
TikTok Shop Xero Integration
Ready to automate your accounting?
Connect Shopify, WooCommerce, or Linnworks to QuickBooks, Xero & more. Setup in minutes.