TikTok Shop Dynamics 365 Business Central Integration: Automated TikTok Shop Accounting for Microsoft ERP

TikTok Shop deposits net payouts — gross merchandise value minus referral fees (2–8% by category), affiliate creator commissions, ad charges, and refunds — as a single lump sum every 1–3 business days. For businesses running Dynamics 365 Business Central, that net number must be disaggregated into the correct G/L accounts, VAT posting groups, and Business Central dimensions before the P&L accurately reflects TikTok Shop activity.

TL;DR: SyncTools connects TikTok Shop to Dynamics 365 Business Central — mapping gross sales, referral fees, affiliate commissions (in a separate G/L from platform fees), ad costs, and payouts to the correct accounts, VAT posting groups, and dimensions automatically. Free 30-day trial; sandbox testing available.

SyncTools automates that translation — connecting TikTok Shop Seller Center to Business Central and posting structured transactions that reconcile cleanly within your Microsoft ERP.

What Makes TikTok Shop Accounting Complex for Business Central Users

TikTok Shop has a distinctive fee structure that sets it apart from traditional marketplaces. Each payout bundles:

Gross merchandise value (GMV) — the total selling price across all orders
Referral fees — 2–8% of GMV depending on product category
Affiliate commissions — creator commissions paid through the TikTok Shop Affiliate program (rates set by the seller)
TikTok Shop Ads — Spark Ads, Shopping Ads, and LIVE Shopping Ad charges
Refunds — order cancellations and returns deducted from the payout

Separating referral fees from affiliate commissions is particularly important for Business Central users who want to understand creator acquisition cost independently from platform fees. SyncTools maps each to a distinct G/L account.

What SyncTools Syncs from TikTok Shop to Dynamics 365 Business Central

Sales invoices — TikTok Shop gross sales as Business Central invoices or journal entries
Credit memos — TikTok Shop returns and refunds as Business Central credit memos
Vendor invoices — referral fees, affiliate commissions, and TikTok Shop ad costs as Business Central purchase invoices mapped to separate G/L expense accounts
VAT / tax posting — Marketplace Facilitator Tax mapped to Business Central VAT posting groups
Bank reconciliation — TikTok Shop payouts matched to Business Central bank ledger entries via a clearing account
COGS — cost-of-goods synced for gross margin visibility in Business Central P&L
Dimension assignments — fulfilment type and sales channel mapped to Business Central dimensions

How to Set Up TikTok Shop Business Central Integration

Step 1: 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 2: Connect Dynamics 365 Business Central Link SyncTools to your Business Central environment. Provide API credentials and configure the company to receive TikTok Shop data.

Step 3: Map G/L accounts, VAT groups, and dimensions Assign each TikTok Shop transaction type to the corresponding Business Central G/L account. Keep referral fees and affiliate commissions on separate G/L accounts for independent margin analysis.

Step 4: Go live Set your sync mode, frequency, and enable the integration. SyncTools posts automatically and emails a sync summary after each run.

TikTok Shop Payout Reconciliation in Business Central

Each TikTok Shop payout bundles multiple orders, fees, commissions, and refunds into a single bank deposit every 1–3 business days. In Business Central, reconciling that deposit requires matching it to the underlying transaction lines.

SyncTools uses a clearing G/L account: each TikTok Shop transaction posts to a dedicated TikTok Shop Clearing account in Business Central as it occurs. When the payout deposits to your bank, the clearing account balance matches — enabling clean reconciliation in Business Central’s payment reconciliation journal.

TikTok Shop Fee Mapping in Business Central

TikTok Shop Transaction	Business Central Record	G/L Account
Gross sales (GMV)	Sales invoice / journal	TikTok Shop Sales (income)
Referral fees	Vendor invoice / journal	TikTok Referral Fees
Affiliate commissions	Vendor invoice / journal	TikTok Affiliate Commissions
TikTok Shop Ads	Vendor invoice / journal	Advertising expense
Refunds / returns	Credit memo	Contra-revenue
Marketplace Facilitator Tax	VAT entry	VAT posting group
Payout settlement	Bank payment entry	TikTok Shop Clearing

TikTok Shop vs. Traditional Marketplaces: Business Central Accounting Differences

TikTok Shop’s creator-affiliate model means a significant portion of selling cost is affiliate commission rather than a fixed platform fee. Business Central users need this separated from referral fees to accurately report content marketing ROI and compare creator-driven sales to organic or paid traffic. SyncTools provides that separation by design, giving your Business Central P&L the granularity needed for data-driven channel decisions.

Start your 30-day free trial — no credit card required

Contact sales for enterprise or multi-entity setup

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 NetSuite Integration — for TikTok Shop sellers using NetSuite
TikTok Shop Sage Integration — for TikTok Shop sellers using Sage
TikTok Shop Zoho Books Integration — for TikTok Shop sellers using Zoho Books
Amazon Dynamics 365 Business Central Integration — sync Amazon to Business Central

Related guides:

FAQ: TikTok Shop + Dynamics 365 Business Central Integration

How does SyncTools connect TikTok Shop to Dynamics 365 Business Central?

SyncTools connects to your TikTok Shop Seller Center account via the TikTok Shop API and posts structured transaction data to Dynamics 365 Business Central — including sales invoices for gross merchandise value, vendor invoices for referral fees and affiliate commissions, credit memos for refunds, and bank payment entries to match each TikTok Shop payout against your Business Central bank ledger.

Can SyncTools separate TikTok Shop referral fees from affiliate commissions in Business Central?

Yes. SyncTools maps TikTok Shop referral fees (2–8% of GMV by category) and TikTok Shop Affiliate program creator commissions to separate Business Central G/L expense accounts, giving you independent visibility into platform selling costs versus creator acquisition costs in your Business Central P&L.

How does the TikTok Shop Business Central integration handle sales tax?

TikTok Shop is a marketplace facilitator in 46 US states and Washington D.C. SyncTools maps TikTok Shop Marketplace Facilitator Tax to a dedicated tax liability G/L account in Business Central — separate from revenue — so your income is accurately stated and your Business Central tax accounts remain audit-ready.

Does SyncTools support summarized and individual order sync for TikTok Shop to Business Central?

Yes. SyncTools supports both individual order sync (one Business Central invoice per TikTok Shop order) and summarized sync (one journal entry per payout period), so you can choose the posting mode that matches your Business Central transaction volume requirements.

Can I test with a Business Central sandbox before going live?

Yes. You can connect SyncTools to a Dynamics 365 Business Central sandbox to validate G/L mapping, VAT posting group assignments, and sync behavior before enabling the integration against your live company.

How to Connect TikTok Shop to Dynamics 365 Business Central in 5 Steps

Connecting TikTok Shop to Dynamics 365 Business Central 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 Dynamics 365 Business Central account In SyncTools, navigate to Accounting System and select Dynamics 365 Business Central. Authorise SyncTools via the Microsoft OAuth flow. SyncTools reads your chart of accounts, dimensions, and posting groups.

Step 3 — Map TikTok Shop transaction types to Dynamics 365 accounts Assign each TikTok Shop transaction component — gross sales, platform commissions, refunds, taxes, and settlement payouts — to the correct Dynamics 365 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 Dynamics 365 Business Central automatically. Check the SyncTools sync log and verify that the posted entries appear correctly in Dynamics 365 Business Central with the right account mapping.

TikTok Shop Dynamics 365 Business Central Integration

Ready to automate your accounting sync?