TikTok Shop pays UK sellers via bank transfer every few days, but each payout is a net figure: gross sales minus platform fees, affiliate commission, refunds, and VAT. Recording only the bank deposit in QuickBooks gives HMRC incomplete revenue figures and leaves your cost-of-sales accounts understated. Proper TikTok Shop QuickBooks accounting means breaking every settlement into its components so your Profit & Loss matches the transactions customers actually paid for, not the smaller cash amount TikTok remitted.
HMRC expects you to declare gross sales as turnover and show fees as expenses. If you are VAT-registered, you must account for output tax on the full sale price, even though TikTok withheld its share before paying you. This guide walks through the settlement-file workflow, the journal entries QuickBooks needs, and the compliance checkpoints UK ecommerce accountants use to keep TikTok Shop books audit-ready.
Why the bank deposit does not equal your sales
TikTok Shop operates a marketplace-facilitator model under UK VAT law. The platform collects payment from the customer, deducts its fees and any affiliate commission, holds back VAT (if you are registered), processes refunds, and transfers the net proceeds to your UK bank account. A typical £1,000 gross-sales settlement might arrive as a £670 deposit once you subtract:
- Platform commission (often 5-8% depending on category)
- Payment-processing fee (around 2.9% + 25p per transaction)
- Affiliate commission (variable, can exceed 10% on creator-driven sales)
- VAT remitted separately to HMRC by TikTok (if you are under the £90,000 VAT threshold, TikTok may still collect VAT under marketplace-facilitator rules but will not withhold it from your payout)
- Customer refunds and returns processed since the last settlement
If you post only the £670 deposit to a QuickBooks sales account, your turnover is artificially low, your fees are invisible, and your VAT return (if registered) will understate output tax. HMRC's Making Tax Digital for Income Tax Self Assessment (MTD ITSA), mandatory from April 2026 for sole traders and partnerships earning above £50,000, requires digital links between transaction records and your filed return. Recording TikTok Shop payouts as lump sums breaks that link and puts you offside when HMRC audits your revenue.
Download the TikTok Shop settlement file
TikTok Shop Seller Centre provides a detailed settlement report for every payout cycle (usually twice per week). Log in to seller.tiktok.com, navigate to Finance > Settlement, and download the CSV or Excel file that corresponds to each bank deposit. The file lists:
- Order ID and transaction date
- Gross product revenue (the price the customer paid)
- Platform fee (TikTok's commission)
- Payment-processing fee
- Affiliate commission (if applicable)
- Refund adjustments
- VAT collected (separated into your liability and any marketplace-facilitator VAT TikTok remits directly)
- Net settlement amount (the figure that hits your bank)
Save each settlement file with a consistent naming convention—YYYYMMDD_TikTok_Settlement.csv—so you can match it to the corresponding bank transaction in QuickBooks. Reconciling every payout back to its source file is the foundation of TikTok Shop accounting that satisfies both your accountant and HMRC.
QuickBooks chart-of-accounts setup for TikTok Shop
Before you post your first settlement journal, create dedicated accounts in QuickBooks Online (or Desktop) to capture each line item. We recommend:
- Income > TikTok Shop Sales (gross product revenue, excluding VAT)
- Income > TikTok Shop Shipping Revenue (if you charge separately for delivery)
- Cost of Sales > TikTok Shop Platform Fees
- Cost of Sales > TikTok Shop Payment Processing Fees
- Cost of Sales > TikTok Shop Affiliate Commission
- Other Current Liabilities > VAT Output Tax – TikTok Shop (if you are VAT-registered and TikTok is not remitting VAT on your behalf)
- Other Current Assets > TikTok Shop Clearing Account (a temporary holding account to net everything down to the bank deposit)
Using a clearing account lets you post the gross transaction components as a journal entry, then post the net payout to the clearing account and mark the clearing balance as reconciled against the bank feed. This two-step workflow keeps your P&L accurate while your bank reconciliation stays clean.
VAT treatment when TikTok is the deemed supplier
Under UK marketplace-facilitator rules (introduced in the March 2021 VAT amendments), TikTok becomes the deemed supplier for VAT purposes when it facilitates a sale to a UK consumer. If you are VAT-registered and TikTok processes the payment, TikTok collects the VAT, remits it to HMRC, and issues you a payment net of VAT. You do not show that VAT on your own return. However, if TikTok does not act as deemed supplier (rare, but possible if you fulfill outside the platform's payment flow), you must account for output tax yourself. Check your settlement file headers and your seller-centre VAT settings to confirm which regime applies, then configure your QuickBooks VAT codes accordingly. Most UK sellers will find that TikTok handles VAT collection and their QuickBooks sales entries are net (VAT-exclusive) figures.
Posting the settlement journal in QuickBooks
Each payout requires a journal entry that debits the clearing account for the net settlement and credits all the gross components. Here is a worked example for a £1,000 gross-sales settlement (VAT-registered seller, TikTok acting as deemed supplier, so no VAT liability on our books):
- Debit TikTok Shop Clearing Account: £670.00
- Debit TikTok Shop Platform Fees: £60.00
- Debit TikTok Shop Payment Processing Fees: £30.00
- Debit TikTok Shop Affiliate Commission: £40.00
- Debit TikTok Shop Refunds (if you track returns separately): £200.00
- Credit TikTok Shop Sales: £1,000.00
The journal balances because £670 + £60 + £30 + £40 + £200 = £1,000. Post this journal on the settlement date (the date TikTok processed the payout, visible in the settlement file). Then, when the £670 deposit appears on your bank feed, categorise it to the TikTok Shop Clearing Account. QuickBooks will show a zero balance in the clearing account, the bank reconciliation will tick, and your Profit & Loss will report £1,000 of TikTok Shop Sales and £130 of fees (£60 + £30 + £40) in the correct expense categories.
Handling refunds and returns
TikTok Shop processes refunds by reducing the next settlement. If a customer returned a £50 item this cycle, the settlement file will show -£50 in the refunds column, and your net payout will be £50 lighter. Record the refund as a debit to a contra-revenue account (TikTok Shop Refunds) or a negative credit to TikTok Shop Sales, and ensure the debit side of your journal still reconciles to the bank deposit. Some accountants prefer a dedicated returns account under Cost of Sales so the P&L separates true product revenue from post-sale adjustments; both methods comply with UK GAAP as long as the disclosure is consistent.
Reconciling TikTok Shop in QuickBooks every settlement cycle
Download the settlement file as soon as the payout email arrives, typically within 24 hours of the bank deposit. Open the CSV, sum the net-settlement column to confirm it matches the bank transfer, then prepare the journal entry using the gross-sales, fees, and refund columns. Post the journal in QuickBooks with a memo line referencing the settlement ID (found in the TikTok Seller Centre or the file name), then match the bank transaction to the clearing account. This cycle-by-cycle rhythm prevents a backlog of unreconciled payouts and ensures your QuickBooks file stays audit-ready for year-end or an HMRC compliance check.
If you sell on multiple platforms—Amazon, Shopify, eBay—adopt the same settlement-level workflow for each. Consistency across channels is what lets a specialist ecommerce accountant review your books efficiently and gives you confidence that every fee, refund, and gross sale is captured in the right period and the right account.
MTD ITSA and digital-record requirements
From April 2026, sole traders and partnerships with qualifying income above £50,000 must keep digital records and file quarterly updates under Making Tax Digital for Income Tax Self Assessment. QuickBooks Online and QuickBooks Desktop (with the MTD bridging module) are HMRC-recognised software, but you must ensure your transaction records—including TikTok Shop settlements—are posted in a way that creates a digital audit trail from the settlement file to the filed return. Recording only net payouts breaks that trail; posting settlement journals with line-item detail preserves it. If HMRC queries your turnover, you can hand over the QuickBooks journal report and the matching TikTok settlement CSVs as corroborating evidence.
Common TikTok Shop QuickBooks mistakes (and how to avoid them)
We see four recurring errors when UK sellers first connect TikTok Shop to QuickBooks:
- Posting the bank deposit as sales. The deposit is net; sales are gross. Always use a clearing account and a journal entry to split out fees and refunds.
- Double-counting VAT. If TikTok is the deemed supplier, do not add a VAT liability in QuickBooks. The settlement file will show VAT collected, but TikTok remits it; your books should record only the net (VAT-exclusive) sale.
- Ignoring affiliate commission. Creator-led sales can carry 10-20% commission. If you forget to debit this cost, your gross margin looks artificially high and you will overpay yourself or your investors.
- Mixing settlement dates. TikTok's settlement date (the date it processed the payout) may differ from the bank-clearing date by a day or two. Use the settlement date for the journal so the transaction sits in the correct VAT or income-tax period.
A TikTok Shop accountant will spot these in the first month-end close, but fixing them retrospectively means re-opening prior VAT periods or amending filed returns. Get the workflow right from settlement one and you will save both time and compliance risk.
Using QuickBooks apps and automation tools
As of early 2025, TikTok Shop does not offer a native QuickBooks integration in its app marketplace. Third-party tools such as A2X, Link My Books, and Synder have begun rolling out TikTok Shop connectors that fetch settlement files via API, generate the journal entries automatically, and post them to QuickBooks on a daily or per-settlement schedule. These apps typically cost £20-50 per month and eliminate manual CSV downloads, but they require you to map TikTok's fee categories to your QuickBooks chart of accounts correctly during setup. If you sell across Amazon, Shopify, and TikTok Shop, a multi-channel reconciliation app can centralise the workflow and reduce month-end close time from days to hours.
Before adopting an app, verify that it handles UK VAT correctly (especially the deemed-supplier scenario) and that it posts settlement-level journals rather than order-level entries. Order-level posting can flood QuickBooks with thousands of line items and make bank reconciliation unwieldy; settlement-level posting keeps the transaction count manageable and mirrors the cash cycle.
Spreadsheet alternative for smaller sellers
If your TikTok Shop revenue is under £3,000 per month, you may prefer a manual spreadsheet workflow. Create a Google Sheet or Excel template with columns for settlement date, gross sales, platform fee, payment fee, affiliate commission, refunds, and net payout. Each month, paste in the settlement-file rows, sum each column, and transfer the totals to a single QuickBooks journal entry. This batch approach is slower than an app but costs nothing and gives you full visibility into the numbers. Once your monthly TikTok revenue exceeds £5,000, the time saved by automation usually justifies the subscription cost.
Year-end and tax-return considerations
When your accountant prepares your Self Assessment return or your Limited Company CT600, they will reconcile QuickBooks turnover to your bank statements. TikTok Shop settlements create a timing difference: sales recognised in one period may not reach the bank until the next. If you run QuickBooks on an accrual basis (revenue recognised when the order ships, not when TikTok pays you), you will also need to track unbilled/unsettled sales as a receivable at period end. Most ecommerce sellers use cash-basis accounting under the HMRC cash-basis scheme (available to sole traders and partnerships with turnover below £150,000), which means revenue is recognised when the settlement hits the bank. Either way, your QuickBooks journals must tie back to the settlement files, and the settlement files must tie back to the bank deposits.
If HMRC opens a compliance check, they will ask for sales evidence. Hand them your QuickBooks P&L, the underlying journals, and the TikTok settlement CSVs. That three-layer audit trail—P&L to journal to source file—is what closes the enquiry quickly and demonstrates you have taken reasonable care under the ecommerce bookkeeping compliance standards UK tax law requires.
Final word
TikTok Shop QuickBooks accounting is settlement-driven: every payout must be broken into gross sales, platform fees, payment fees, affiliate commission, and refunds, then posted as a journal entry that reconciles to the bank deposit. Recording only the net transfer understates your turnover, hides your true cost base, and leaves you exposed when HMRC queries your numbers or MTD ITSA goes live in April 2026. Follow the settlement-file workflow, use a clearing account, and reconcile every cycle. If your TikTok revenue is growing or you run multiple sales channels, talk to a specialist—book a discovery call with an SCA accountant and we will build you a QuickBooks reconciliation process that scales with your sales and keeps your records audit-ready from day one.
