"Shopify says we did one number last month, TikTok Seller Centre says another, and our bank account says a third. My partner thinks the bookkeeper is wrong, the bookkeeper thinks the platforms are wrong, and I just want to know which number is real."
All three are real, and that is the problem. They are three different measurements wearing the same name: orders, settlement and cash. Shopify records what customers ordered. The TikTok settlement decides what the platform will pay, after its commission, refunds, shipping and adjustments. The bank counts what actually arrived. A sports brand that tries to make them equal will lose a weekend every month to a spreadsheet war. A sports brand that builds one bridge between them gets a documented settlement reconciliation, a clean set of books, and something better than either: the ability to read the health of each channel from the same page. Here is the method, worked through on an illustrative month.
Everything below is an illustrative example with synthetic planning numbers, not any client's books. Steal the method, then swap in your own data.
Here's the Short Version
- Stop trying to match the three numbers. Reconcile them: document the bridge from orders to settlement to cash, and check each step against a tolerance
- The differences come from a known set of places: settlement timing, refunds, shipping, fees, adjustments, reserves and VAT. Reconcile each category rather than chasing one perfect number
- If TikTok orders run through your Shopify store, they appear in both systems. Count them once, in one place, or you will double your revenue
- Never book the bank receipt as revenue. Recognise revenue when control of the goods passes to the customer under your accounting policy, net of VAT, discounts and expected returns; the fee invoices and their recoverable VAT live in the costs
- Read the channels side by side on four numbers: cash conversion, fee drag, refund rate and contribution after fees. Sports kit shows its character in the refund line faster than anywhere else
- The month-end routine is short enough to run every month and strong enough to survive an accountant's questions: bridge the settlement, post the fees, post the refunds, agree the balance, and check the platform's HMRC seller statement against your numbers as an aggregate cross-check when it lands
- Do not chase pennies. Set and document a tolerance that reflects materiality, transaction volume and the purpose of the control, track every difference, clear known timing items, and investigate anything unusual or above tolerance
Why The Three Numbers Are All Correct
The orders number. Shopify records orders placed across its connected sales channels. It reports discounts, returns, taxes and shipping as separate figures, so choose one defined measure, such as net sales or total sales, and stick to it. If your TikTok Shop is connected to your store through the sales channel, TikTok orders appear here too, which is useful for one basket view and dangerous for reporting: the same order then exists in two systems.
The settlement number. TikTok Seller Centre measures what the platform will pay you, on the platform's clock. Orders settle in delivery-based periods, and affected sellers can have funds held in a 30-day reserve under TikTok's seller-fault cancellation rules rather than for growth on its own. Before payout, TikTok nets refunds, shipping charges and fees against the VAT-inclusive sales, then applies positive or negative adjustments. For a UK established seller, it does not normally deduct the sales VAT; that is your job, through the return. The settlement number is a cash-planning view, not an accounting one.
The bank number. The bank measures money that has finished the journey. By the time it lands, it has already been netted down by every deduction above, and it says nothing about which month's trading it represents.
Three correct numbers, three different questions answered: what did customers buy, what is the platform going to pay, what has arrived. The books need a fourth view: what did the brand earn. That is the bridge's job.
The Bridge, Worked On An Illustrative Month
Here is one month, one channel, walked from the cash that landed to the revenue that belongs in the accounts. The example assumes £60,000 of standard rated revenue after refunds, the standard 9% commission rate, no customer shipping or platform-funded discounts in the commission base, and no other platform fees. Everything is an illustrative number for a sports brand doing about half its volume on TikTok Shop.
| Bridge: TikTok, one month | Amount | What it represents |
|---|---|---|
| Cash settled into the bank in the month | £74,420 | What the platform actually paid in the month |
| Add back: platform commission deducted before payout, including VAT | +£6,480 | Gross-to-net: the fee is a cost, and its VAT comes back through the return |
| Add back: earlier-period refunds and adjustments deducted this month | +£2,000 | Deducted when they land, which is not when they happened |
| Add: the settlement balance the platform still owes at month end | +£8,000 | Sales made but still held, through settlement timing or reserve |
| Less: the balance the platform was holding at the start of the month | -£18,900 | Earlier months' sales paid out in this one |
| Less: output VAT on the month's sales | -£12,000 | Never your money; it passes through the return |
| Revenue for the month, net of VAT and refunds | £60,000 | The number that goes in the management accounts |
The arithmetic, so you can rebuild it: £74,420 plus £6,480 plus £2,000 plus £8,000 minus £18,900 minus £12,000 equals £60,000.
Read the column down and the differences fall into their known categories: settlement timing, refunds, shipping, fees, adjustments, reserves and VAT. When the month's numbers do not agree, you no longer hunt a mystery: you check the categories in order, and timing is often the first to clear, because a delivery settled on the second of the month belongs to last month's revenue.
Two discipline rules keep the bridge honest. First, post refunds when they land in the settlement, and accrue a refund provision in the accounts for what experience says is coming, so both the timing view and the accruals view stay clean. Second, keep the platform's VAT story straight. TikTok's platform commission rate is inclusive of VAT, and a UK established, VAT registered brand can normally reclaim the VAT element as input tax, subject to the usual rules and a valid VAT invoice. Do not confuse that recovered input VAT with the output VAT collected on sales, which TikTok does not deduct for you. We broke the full fee mechanics down in why TikTok Shop brands fail at reconciliation, and the payout side specifically in reconciling payouts at £1M+.
Then Read The Two Channels Side By Side
Once the bridge works, the reporting becomes the easy part, and the point of it appears: the same four numbers, read for each channel at once.
| Number | What it tells you | Sports brand specifics |
|---|---|---|
| Cash conversion ratio: cash received from settlements divided by the sales value attached to those settlements, with days to payout measured separately | How much of each channel's revenue actually reaches the bank, and on what clock | Late December sales may arrive as cash in January. The timing depends on delivery, your settlement period and bank processing. Plan stock bills around actual settlement dates |
| Fee drag: platform fees and commissions divided by the matching net sales base | What the channel charges you for existing, before a pound of ad spend | Commission base includes customer shipping and platform discounts, less refunds; read it monthly because it moves |
| Refund rate: refunded product value excluding VAT divided by gross product sales excluding VAT, measured consistently by channel and category | Where the returns leak touches contribution | Footwear and compression kit can carry high return rates; compare them with your own category data |
| Contribution after variable channel costs, per channel | Include product cost, fulfilment, platform and creator fees, returns and directly attributable advertising, and use it alongside cash timing, stock capacity and customer quality | Same product, different economics: judge channels on contribution, never on revenue share |
Put those four on one page, monthly, and the arguments change shape. "TikTok is bigger" becomes "TikTok is bigger, costs about nine points of commission to run, refunds less on accessories and more on footwear, and converts contribution at this rate". Use the platform's HMRC seller statement as an aggregate cross-check when it becomes available: it carries your seller identity, quarterly figures and fees withheld. It is a cash-basis report and does not replace the monthly settlement bridge, and Shopify stores are not in scope of the regime at all, so the store side of the bridge stays your own work.
The Month-End Routine, Kept Short
- Pull the settlement report for the month, and bridge it to revenue through the categories above. Save the working, month by month, in one place
- Post the fee invoices, including recoverable VAT, as their own cost lines. Platform commission and creator commission are different lines with different owners
- Post refunds as they land, and update the refund provision from your trailing rate by channel
- Agree the settlement control account: opening balance, plus settlement activity, minus cash received, equals closing balance. If it does not agree to within your tolerance, work the known categories before touching anything else
- Compare the month's picture against the platform's own figures and against the store's, and write one sentence on anything that moved more than a normal month
One trap deserves its own warning because it poisons everything downstream: double counting. If your TikTok orders arrive in Shopify through the sales channel, and you also import settlement data, the same revenue can enter twice. Decide where TikTok revenue lives in your books, once, and bridge everything else to it. The related trap is trusting a payout dashboard as a P&L: payouts are cash, and cash says nothing about contribution. Our post on the multi-marketplace finance stack shows how the layers stack when Amazon joins the party as well.
Three Red Flags The Side-By-Side View Exposes
The reason to read both channels on the same page is that each one hides the other's problems. Three patterns show up fast once the four numbers sit side by side, and each has a different medicine.
Cash conversion drifting down while revenue climbs. If the settled percentage of sales falls two or three points over a quarter, split the movement between timing, reserves, refunds, fees, shipping and adjustments before deciding it is only a cash-timing issue. Late December sales may arrive as cash in January, and TikTok's reserve is tied to seller-fault cancellation performance rather than growth on its own. The fix is planning, not panic: forecast cash on settled revenue, not sold revenue, and keep a rolling four week view of what is due in. The trap is treating a big orders week as a big cash week and funding a purchase order on it.
Fee drag creeping upwards. Platform fees and commissions as a percentage of net sales should be stable across normal months. When the percentage climbs, something changed underneath: a category mix shift into higher-rate lines, a campaign that leaned on platform discounts, a new fee line appearing in settlements, or an affiliate layer quietly stacking on top of the platform commission. Sports brands hit this hardest in Q4, when discount campaigns and creator activity peak at the same time. Read the fee lines monthly, not at year end, because by then the quarter is closed and the explanation is gone.
Refund rates diverging between channels. The same shoe, the same size chart, two channels, and returns run at 29% on one and 18% on the other. That gap is information. It usually means the audience differs (impulse buyers return more than repeat customers), the presentation differs (a video that oversells fit versus a product page that understates it), or the sizing guidance is being ignored on one of the paths. Chase the gap rather than the average, because the average moves too slowly to act on.
What Your Accountant Needs From You Each Month
One habit makes the whole system durable: a monthly folder, the same contents every month, handed over before anyone starts posting entries. It contains the settlement reports for each platform, the fee invoices or statements, the store's payout and refund reports, the platform tax reports if you are in the reporting regime, and a line or two on anything unusual, a launch, a warehouse move, a campaign that spiked returns. Five items, ten minutes to assemble, and it turns the bridge from a monthly archaeology project into a checklist. The brands that keep their books clean are not the ones with better software. They are the ones whose folder arrives without being asked for, every month, with the oddities already flagged.
FAQ
Why doesn't my TikTok payout match my orders?
Because they measure different things on different clocks. The payout is net of commission, fees, refunds, shipping and adjustments, and it settles on delivery-based periods, sometimes with a reserve held back. The orders number includes VAT and ignores all of that. Bridge the two through the known categories, settlement timing, refunds, shipping, fees, adjustments, reserves and VAT, and reconcile to a documented tolerance rather than trying to make the numbers equal.
Should I record TikTok orders through Shopify or separately?
Pick one primary place and bridge everything else to it. If TikTok orders flow into Shopify through the sales channel, the cleanest pattern for most sports brands is to hold order-level revenue in the store view and post the settlement, fees and refunds from the platform view into it, with the bridge documented. Whichever you choose, count each order once, or the same revenue will land in your books twice.
How often should we run the reconciliation?
Monthly at minimum, and the routine above is designed to be short enough that monthly actually happens. Some brands run the cash side weekly during Q4 because the settlement timing moves fast in peak. The key discipline is consistency: the same bridge, the same categories, the same documented tolerance, every month, with the working saved so the next person can follow it.
The Bottom Line
Shopify, TikTok and your bank are not disagreeing about your revenue. They are answering three different questions. Build the bridge once: orders, settlement, cash, adjusted for settlement timing, refunds, shipping, fees, adjustments, reserves and VAT, and reconcile to a documented tolerance, clearing known timing items instead of chasing pennies. Then spend the time you saved reading the two channels side by side on cash conversion, fee drag, refunds and contribution, because that is where the next decision lives. The numbers stop arguing and start advising.
If you want your TikTok-to-Shopify bridge built and your channel reporting set up so both tell the same story, that is our daily work for UK sports brands between £1m and £20m. We are specialist social commerce accountants, we read settlement reports all day, and we will tell you plainly what your channels are actually earning. Book a call and bring your last three months of settlements and store reports.