Integration Guide
TikTok Shop Sage Integration
Connect TikTok Shop to Sage with SyncTools. Automatically sync TikTok Shop sales, referral fees, affiliate commissions, and payout settlements into Sage — accurate TikTok Shop bookkeeping without manual data entry.
Ready to automate your accounting sync?
30-day free trial. No credit card required. All features included.
TikTok Shop Sage Integration: Accurate TikTok Shop Books for Sage Users
TikTok Shop deposits net payouts — gross merchandise value minus referral fees (2–8% by category), affiliate creator commissions, TikTok Shop ad charges, and refunds — every 1–3 business days. Recording that lump sum as income in Sage misrepresents your gross revenue, hides your true selling costs, and makes it impossible to understand your actual TikTok Shop margin without a manual calculation.
TL;DR: SyncTools connects TikTok Shop to Sage — mapping gross sales, referral fees, affiliate commissions (in a separate account from platform fees), ad costs, and refunds to the correct Sage nominals automatically. UK MTD VAT handled correctly. Free 30-day trial; historical backfill up to 24 months.
SyncTools automates the translation from TikTok Shop to Sage — posting every transaction to the correct nominal accounts so your Sage P&L accurately reflects TikTok Shop profitability.
What Makes TikTok Shop Accounting Different for Sage Users
TikTok Shop combines a traditional marketplace referral fee model with a creator-affiliate commission structure. Each payout bundles:
- Gross merchandise value (GMV) — total order value across the payout period
- Referral fees — 2–8% of GMV depending on product category
- Affiliate commissions — creator-driven sale costs at seller-configured rates through the TikTok Shop Affiliate program
- TikTok Shop Ads — Spark Ads, Shopping Ads, and LIVE Shopping ad charges
- Refunds — cancellations and returns deducted from the payout
Separating referral fees from affiliate commissions is important for Sage users who want to understand content creator acquisition cost separately from platform fees. SyncTools provides that separation by mapping each fee type to its own Sage nominal.
What SyncTools Syncs from TikTok Shop to Sage
- Sales invoices — TikTok Shop gross sales posted to a Sage income nominal
- Credit notes — TikTok Shop returns and refunds as Sage credit notes
- Purchase invoices / expense entries — referral fees, affiliate commissions, and TikTok Shop ad costs mapped to dedicated Sage expense nominals
- Tax liability — Marketplace Facilitator Tax posted to a Sage tax liability nominal, not revenue
- Bank reconciliation — TikTok Shop payouts matched via a clearing account for clean Sage bank reconciliation
- COGS — cost-of-goods synced for gross margin visibility in Sage P&L
How to Set Up TikTok Shop Sage Integration
Step 1: Create TikTok Shop nominal accounts in Sage Set up nominals: TikTok Shop Gross Sales (income), TikTok Referral Fees (expense), TikTok Affiliate Commissions (expense), TikTok Shop Ads (advertising expense), TikTok Refunds (contra-revenue), Tax Liability (liability), and TikTok Shop Clearing (bank-type account).
Step 2: Connect TikTok Shop Sign in to SyncTools and authorize your TikTok Shop Seller Center account. SyncTools requests read access to order data, payout reports, and fee statements.
Step 3: Connect Sage Link SyncTools to your Sage account. Map each TikTok Shop transaction type to the corresponding Sage nominal.
Step 4: Auto-sync begins Set your sync frequency and enable the integration. SyncTools posts automatically and emails a sync summary after each payout cycle.
TikTok Shop Payout Reconciliation in Sage
Each TikTok Shop payout bundles multiple orders, fees, commissions, and refunds into a single bank deposit every 1–3 business days. In Sage, reconciling that deposit requires matching it to the transactions that explain the net amount.
SyncTools uses a clearing account: each TikTok Shop transaction posts to a TikTok Shop Clearing bank account in Sage as it occurs. When the payout hits your actual bank account, the clearing account balance matches — straightforward bank reconciliation in Sage.
TikTok Shop Fee Mapping in Sage
| TikTok Shop Transaction | Sage Record Type | Nominal Account |
|---|---|---|
| Gross sales (GMV) | Sales invoice | TikTok Shop Sales (income) |
| Referral fees | Purchase invoice / expense | TikTok Referral Fees |
| Affiliate commissions | Purchase invoice / expense | TikTok Creator Commissions |
| TikTok Shop Ads | Purchase invoice / expense | Advertising expense |
| Refunds / returns | Credit note | Contra-revenue |
| Marketplace Facilitator Tax | Tax entry | Tax Liability |
| Payout settlement | Bank transaction | TikTok Shop Clearing |
TikTok Shop and Making Tax Digital: Sage VAT Accuracy
UK TikTok Shop sellers registered for VAT use Sage for MTD VAT submissions. SyncTools applies the correct Sage VAT tax codes to each TikTok Shop transaction type — separating marketplace facilitator VAT (which TikTok Shop remits) from seller-applicable VAT — keeping your Sage VAT return accurate without manual override.
Start your 30-day free trial — no credit card required
Related integrations:
- TikTok Shop QuickBooks Online Integration — for TikTok Shop sellers using QuickBooks
- TikTok Shop Xero Integration — for TikTok Shop sellers using Xero
- TikTok Shop Dynamics 365 Business Central Integration — for TikTok Shop sellers using Business Central
- TikTok Shop NetSuite Integration — for TikTok Shop sellers using NetSuite
- TikTok Shop Zoho Books Integration — for TikTok Shop sellers using Zoho Books
- Amazon Sage Integration — sync Amazon to Sage
Related guides:
- TikTok Shop Accounting: How to Track Sales, Fees, and Taxes
- Accounting Challenges in eCommerce Business
FAQ: TikTok Shop + Sage Integration
How does SyncTools connect TikTok Shop to Sage?
SyncTools connects to your TikTok Shop Seller Center account via the TikTok Shop API and pushes structured transaction data into Sage — including gross sales as sales invoices, referral fees and affiliate commissions as purchase invoices or expense entries, refunds as credit notes, and payout settlements matched via a clearing account for bank reconciliation.
Can SyncTools separate TikTok Shop referral fees from affiliate commissions in Sage?
Yes. SyncTools maps TikTok Shop referral fees (2–8% of GMV by category) and TikTok Shop Affiliate creator commissions to separate Sage nominal accounts, giving you independent visibility into platform selling costs versus creator acquisition costs in your Sage P&L.
How does SyncTools handle sales tax for TikTok Shop sellers using Sage?
TikTok Shop is a marketplace facilitator in 46 US states and Washington D.C. SyncTools records TikTok Shop Marketplace Facilitator Tax to a tax liability nominal in Sage — separate from your revenue — so your income is accurately stated and your Sage tax accounts are audit-ready.
How are TikTok Shop payout settlements reconciled in Sage?
SyncTools posts TikTok Shop transactions to a dedicated TikTok Shop Clearing bank account in Sage as they occur. When each payout deposits to your actual bank account (typically every 1–3 business days), the clearing account balance matches — straightforward bank reconciliation in Sage without manual export or calculation.
Can I sync historical TikTok Shop data to Sage?
Yes. SyncTools supports backfilling up to 24 months of historical TikTok Shop transaction data into Sage on Standard and Plus plans, covering sales, fees, and refunds from before your SyncTools setup date.
How to Connect TikTok Shop to Sage in 5 Steps
Connecting TikTok Shop to Sage with SyncTools takes under 20 minutes and requires no developer access.
Step 1 — Connect TikTok Shop to SyncTools In SyncTools, navigate to eCommerce Platform and select TikTok Shop. Complete the TikTok Shop OAuth authorisation to give SyncTools read access to your orders, settlement reports, and platform fees.
Step 2 — Connect your Sage account In SyncTools, navigate to Accounting System and select Sage. Complete the Sage OAuth connection. SyncTools reads your chart of accounts, nominal codes, and tax codes.
Step 3 — Map TikTok Shop transaction types to Sage accounts Assign each TikTok Shop transaction component — gross sales, platform commissions, refunds, taxes, and settlement payouts — to the correct Sage account.
Step 4 — Choose your sync mode Select whether SyncTools reconciles by settlement period (one journal entry per payout — ideal for marketplace sellers) or by individual order. Settlement mode ensures your books match your bank deposit exactly.
Step 5 — Run your first sync and verify Click Sync Now. TikTok Shop data posts to Sage automatically. Check the SyncTools sync log and verify that the posted entries appear correctly in Sage with the right account mapping.
Further Reading
- TikTok Shop Accounting Guide — how to structure bookkeeping for TikTok Shop sellers
- TikTok Shop QuickBooks Integration — step-by-step walkthrough for connecting TikTok Shop to QuickBooks Online
- eCommerce Bookkeeping Fundamentals — chart of accounts setup and reconciliation principles
- Automated Reconciliation for eCommerce — how automated reconciliation works and setup in under 30 minutes
Ready to automate your accounting sync?
30-day free trial. No credit card required. All features included.