You do not reconcile a TikTok Shop payout by coding the bank deposit to sales. You post the gross detail from the settlement statement into a clearing account, take the fees out as costs, and let the payout clear that account back to zero. Get it right and every settlement takes minutes. Get it wrong and you understate turnover, lose the VAT inside TikTok's fees, and spend year end unpicking it.
This is the Xero setup I use, checked against TikTok's UK seller policies and Xero's behaviour in October 2026. Every figure in the worked example is synthetic.
What does a TikTok Shop settlement actually contain?
A statement is one payout batch, not one order. TikTok groups the orders that settled in the period, deducts its fees, and pays the balance to your bank. TikTok's own definition of the settlement amount is net sales minus shipping minus fees plus adjustments.
| Statement field | What it means | Why it matters in Xero |
|---|---|---|
| Statement ID | The batch reference | Put it in the narration so you can find the posting in a year |
| Payout ID | The transfer that paid the batch to your bank | The link between the statement and the bank line |
| Statement date | The date the statement was recorded | Not the same as the sale date. This trips up VAT periods |
| Status | Pending, processing, paid or failed | Only paid has reached your bank |
| Net sales | Sales after refunds and seller discounts | The gross figure your turnover and Box 6 are built from |
| Shipping | Shipping costs and adjustments | A cost if TikTok shipped it, income if the customer paid you for it |
| Fees | Commission and platform charges | Expenses, with reclaimable VAT inside |
| Adjustments | Subsidies, reimbursements, penalties | Usually income or expense, not part of net sales |
| Settlement amount | What lands in the bank | The number you must never code to sales |
The timing is delivery based. TikTok releases funds 1, 3, 8 or 31 days after delivery depending on your settlement tier, and the transfer usually lands within 3 business days of the settlement period ending. I have covered the tiers and the reserve in detail in TikTok Shop payout reconciliation at £1m, so I will not rebuild it here. What matters for Xero is that the order date, the statement date and the payout date are three different dates. Only paid has reached your bank. Pending and processing sit in the clearing account as money in flight.
Why can't you code the payout straight to sales?
Because the payout is net. On the example below a customer paid £3,600.00 for goods and £3,128.04 arrived in the bank. Book the £3,128.04 as turnover and you have done four things wrong at once.
You have understated sales. Turnover is what customers paid, not what the platform forwarded after its cut. Every ratio you use is now measured against the wrong number.
You have hidden the fees. Commission is a real cost of sale. Net it off and the P&L looks better than the business, right up until someone asks why the profit never turns into cash.
You have lost input VAT. The 9% commission is quoted inclusive of VAT. That VAT is recoverable if you hold the fee invoice. Skip the fee and you skip the reclaim.
You have muddled the VAT return. Box 6 wants the net value of your sales, not your bank receipts. The gap is the fees, and it has to be visible somewhere.
One thing to settle before the mechanics. If you are a UK business selling UK stock to UK customers, TikTok is not the deemed supplier. The sale is yours and the output VAT is yours. TikTok's fee is a separate supply to you, which is why the two VAT treatments sit in different places. The deemed supplier rules bite when the seller is overseas, even with stock already in the UK, and when goods are outside the UK at the point of sale in a consignment of £135 or less. That produces a different statement shape, and it needs a different conversation.
How should you set up the Xero accounts?
Six accounts, one a clearing account. The codes are a suggestion, so use what fits your chart.
| Account | Type in Xero | Suggested code | What posts here |
|---|---|---|---|
| TikTok Shop clearing | Bank | 090 | Gross sales in, fees out, payout out. Ends at zero |
| Sales, TikTok Shop | Revenue | 201 | Goods at the price the customer paid, excluding VAT |
| Delivery income | Revenue | 205 | Customer paid delivery, excluding VAT |
| Refunds and returns | Revenue, contra | 206 | Refunds, posted as a negative |
| Platform commission | Expense | 310 | TikTok's percentage fee, excluding VAT |
| Platform service fees | Expense | 311 | Per parcel and other platform charges, excluding VAT |
Create the clearing account as a Bank type, not a current asset. Two Xero behaviours decide that. Xero will not let a manual journal post to a bank account. And bank rules and transfers need a bank account at each end. A current asset clearing account works if you plan to clear it by journal, but you lose the transfer rule that does most of the monthly work.
Leave the clearing account without a bank feed. It is not a real bank account. It is a holding pen, and you want it sitting quietly until a payout arrives.
How do you post a settlement, line by line?
Illustrative example. A UK VAT registered brand, standard rated goods, Shipped by Seller, one payout covering 12 delivered orders. None of these are client numbers. The arithmetic is the point.
| Statement line | Amount including VAT | VAT inside | Net |
|---|---|---|---|
| Goods sold | £3,600.00 | £600.00 | £3,000.00 |
| Customer paid delivery | £84.00 | £14.00 | £70.00 |
| Refunds | (£240.00) | (£40.00) | (£200.00) |
| Net sales | £3,444.00 | £574.00 | £2,870.00 |
| TikTok Shop commission at 9% | (£309.96) | (£51.66) | (£258.30) |
| Shipped by Seller fee, 12 at £0.50 | (£6.00) | (£1.00) | (£5.00) |
| Payout to bank | £3,128.04 |
The maths: 3,600.00 plus 84.00 less 240.00 is 3,444.00. Commission is 9% of 3,444.00, which is 309.96. Take off the 6.00 parcel fee and 3,128.04 lands in the bank.
Step 1: pull the statement and the fee invoice
Seller Centre, Finance, Statements. Export the statement you are posting and keep the order level file beside it, because that file is your evidence for what made up the batch. Then open Finance, Invoices and download the platform service fee invoice for the same month. You need the invoice to support the input VAT.
Step 2: receive the gross sales into the clearing account
Open the clearing account, choose New transaction, then Receive Money. Set the amounts to tax inclusive, because every figure on the statement already contains VAT. Add three lines.
Goods, £3,600.00, coded to Sales TikTok Shop at 20%. Delivery, £84.00, coded to Delivery income at 20%. Refunds, minus £240.00, coded to Refunds and returns at 20%. The transaction total is £3,444.00.
Xero strips the VAT out of each line and posts £574.00 to your VAT account. You never type the VAT figure yourself. That is the whole reason for using tax inclusive amounts rather than working the split on a calculator and hoping.
Step 3: take the fees out of the clearing account
Spend Money from the same account, dated the same day. Commission £309.96 to Platform commission at 20%. Parcel fee £6.00 to Platform service fees at 20%. Total £315.96, and Xero posts £52.66 of input VAT.
If you would rather enter TikTok's monthly invoice as a bill, do that instead, but pay it from the clearing account so the clearing balance still lands at zero. Pay it from the real bank account and you will double count the cash, because the payout already arrived net of that fee.
Step 4: transfer the payout
When £3,128.04 appears in your real bank feed, do not code it to sales. Create a transfer from the clearing account to the bank account for that amount. The transfer option on the reconcile screen does it in one step and marks both sides. The clearing account then reads 3,444.00 in, 315.96 out in fees and 3,128.04 out to the bank. Balance zero.
Step 5: prove the clearing balance
Run the Account Transactions report on the clearing account for the period. The closing balance should equal the money TikTok is still holding: statements pending, statements processing, and any reserve. If it does not, you have missed a statement or posted a fee twice. Find it. Do not plug it with a journal, because next month the plug becomes the error.
Step 6: tie it to the VAT return
| VAT return box | What it covers | This example |
|---|---|---|
| Box 1 | VAT due on sales | £574.00 |
| Box 4 | VAT reclaimed on purchases | £52.66 |
| Box 5 | Net VAT to pay | £521.34 |
| Box 6 | Net sales excluding VAT | £2,870.00 |
| Box 7 | Purchases excluding VAT | £263.30 |
If those five figures do not agree to the statement, the difference is nearly always one of three things. A refund posted twice. A fee coded without VAT. Or a statement dated into the wrong period.
What about the dates, and why your VAT quarter never quite matches?
The VAT tax point on a sale is the earlier of the invoice and the payment. On TikTok the customer pays at checkout, so the tax point is the checkout date, not the statement date and not the payout date. HMRC sets that out in VAT Notice 700, section 14.2.2.
That means a payout received in January can contain December sales. If a statement straddles your quarter end, split it. Sales go into the earlier period, the fees and the payout go into the later one. A five minute adjustment keeps Box 1 honest.
There is one exception. If you use VAT Cash Accounting, the tax point moves to the date you receive payment, which is the payout. You can join if you expect taxable supplies of £1.35m or less in the next year, and you must leave once they pass £1.6m. For a brand on the 31 day tier with a 30 day reserve, that is a real cash flow advantage, and it makes the posting simpler because the statement date becomes the right date.
The mechanics of the VAT itself are in our VAT guide for TikTok Shop sellers.
What about mixed VAT rates in one basket?
The statement gives you one net sales figure. It does not know that the children's clothing in the basket is zero rated and the gift box is standard rated. If you sell a mix, do not apply 20% to the whole statement. Work the VAT from the product level export, where each SKU carries its rate, and post the sales lines so the total VAT agrees to that calculation.
Keep the product level file with the posting, because that is what supports the split.
What about refunds, reserves and money still in transit?
Refunds. Platform commission reverses when an order is returned, in full for a full return and in part for a partial one. Creator commission is less reliable. It reverses only if the refund lands before the creator is paid, so treat recovered creator commission as a bonus rather than a certainty.
Reserves. TikTok can hold settlement funds for 30 calendar days after delivery where a seller does not meet its Seller Fault Cancellation Rate criteria. That money is still your sale, but it is not cash yet. It stays in the clearing account until the payout arrives. The Seller Centre shows it under Finance, then On hold, then Reserve.
Money in transit. At month end the clearing balance should equal the total of pending, processing and reserve in the Seller Centre. That single comparison catches most errors before they reach the accounts.
Negative balances. If fees exceed the order value, usually on a heavily discounted low value order, a statement can go negative. Post it as it is. Forcing it to zero hides a real cost.
How do you stop next month taking a day?
Build one bank rule. On the real bank account, create a rule: when the reference contains TIKTOK, create a transfer from the clearing account. Xero supports transfer money rules, and that one rule removes the manual step every payout.
Copy last month's entries. Receive and spend money transactions can be copied, so you change three amounts and two dates instead of rebuilding every line.
Use cash coding sparingly. Cash coding is Xero's spreadsheet view for reconciling a batch of statement lines. It creates new transactions as it goes, so it suits a run of identical bank charges and not anything already coded. On a clearing account you rarely need it.
Find and match the odd ones. If a payout is split, or a chargeback lands against a settled order, use Find and Match to put one bank line against several items.
Do the three way tie at month end. Statement total, clearing balance, VAT return. When they agree, close the month.
If you want the margin side of the same conversation, the TikTok Shop profit calculator takes the fee stack apart at order level.
Do you need a tool instead?
For one TikTok Shop in one currency, no. The method above takes 30 to 45 minutes a month once the accounts exist, and you understand every line.
The case for an integration such as A2X or Link My Books arrives when you add Amazon and Shopify. Three statement formats, three fee structures and three sets of reserves stop being a monthly job. Even then, check how the tool handles platform funded discounts and refunds after settlement, because those break the tie out.
If you run QuickBooks rather than Xero, the logic is identical and the account names are not. Our guide to TikTok Shop QuickBooks accounting walks the same settlement through that file. And if you are still deciding whether the platform is worth the fee stack at all, start with the TikTok Shop sellers hub.
FAQs
Do I need to post every TikTok order into Xero separately?
No. Post at settlement level and keep the order level export as your audit trail. HMRC wants digital records that support the return, and the export, statement and fee invoice give you that. What you must not do is post only the bank receipt, because the sales and fees never appear at all.
Why does my clearing account not go back to zero?
Almost always because some money is still with TikTok. Compare the clearing balance to the pending, processing and reserve totals in the Seller Centre. If those match, nothing is wrong and the balance is money in transit. If they do not match, look for a statement posted twice, a transfer entered twice, or a fee paid from the real bank account.
Where does the VAT on the 9% commission go?
Inside the fee. The 9% is quoted inclusive of VAT, so on a £309.96 commission the VAT is £51.66 and the net cost is £258.30. Code the gross figure to the commission account at 20% and let Xero split it, then keep TikTok's monthly platform service fee invoice as evidence for the reclaim.
The Close
Reconciliation is not a spreadsheet exercise. It is the proof that the money you earned, the money you banked and the VAT you declared are all the same story.
Set the clearing account up once, post every statement the same way, and month end stops being a rebuild. Leave it to a lump sum coded to sales and you will be explaining the gap to an inspector with a bank statement in your hand.
If your TikTok settlements and your Xero file have drifted apart and you cannot see where, book a call.