S
Salsabeel Fragrances · Quarterly Reports
TikTok Shop UK
Mar – May 2026 consolidated reporting
·
Prepared for Uzair (Finance Director)
·
Static data
Mar – May 2026
📥 Downloadable Reports
Excel exports of dashboard data, forecast, and stock position. Click any to download.
VAT Treatment
All GMV, Net Sales and Settlement figures shown on this dashboard are VAT-inclusive. TikTok Shop UK applies the marketplace facilitator rules — TikTok collects VAT from the customer and remits it directly to HMRC on Salsabeel\'s behalf. Seller-facing figures (GMV, Net Sales, Settlement) are therefore gross of VAT.
For ex-VAT analysis (Salsabeel\'s Xero P&L basis): divide by 1.2. Example for Q1 (Mar-May): TikTok-side total settlement £912,434 incl. VAT = £760,362 ex-VAT (VAT implied ~£152,072 @ 20%).
For ex-VAT analysis (Salsabeel\'s Xero P&L basis): divide by 1.2. Example for Q1 (Mar-May): TikTok-side total settlement £912,434 incl. VAT = £760,362 ex-VAT (VAT implied ~£152,072 @ 20%).
Q1 Settlement
£0
TikTok statement basis
Q1 COGS
£0
FIFO from Huzzy Stock 2
Q1 Ad Spend
£0
TikTok Ads attributed
Q1 Net Profit
£0
— %
Report 1 — Dashboard Comparison Mar / Apr / May 2026
All values in GBP. Settlement = TikTok statement total (accrual). Costs shown as positive deductions. Net Profit = Settlement − COGS − Ad Spend.
| Metric | March 2026 | April 2026 | May 2026 | 3-Month Total |
|---|
⚠ Settlement vs Bank Reconciliation
Line
March
April
May
Total
Data-driven insights & suggestions
Root cause: TikTok flipped Salsabeel from daily to weekly Tuesday-batched payouts on 7 April 2026. All eight Apr-May Tuesday batches reconcile to the penny against 5-7 days of underlying statements.
March (bank > statement by £20,069): pre-cadence change, all 30 daily payouts settled within March + late-Feb carryover (~£8.9K on 02 Mar) + Mar 31 paid one day early.
April (statement > bank by £30,961): four weekly batches only covered Apr 2-27 sales; Apr 28-30 (£19,618) plus Apr 1 (£11,367 paid Mar 31) fell outside the calendar window.
May (statement > bank by £12,822): May 26-31 (£32,440) deferred to early June, partly offset by Apr 28-May 4 portion of the May 5 batch (~£19,618).
Recommendation: post a TikTok Shop Receivable each month-end equal to the Difference line — Uzair's existing LMB76 "Split Month Rollovers" clearing account is designed for this. Use the Statement line for P&L and KPIs; use the Bank line for cash flow only. Q1 -£23,713 timing gap closes to near zero by 8 June once May 26-31 stmts clear.
Report 2 — Per-SKU Breakdown — SKUs
Per-SKU per-month metrics. GMV = Net Sales (after seller discounts). All Fees = TT commission + shipping + Smart Promo + other (excludes affiliate). Net Profit = Settlement − COGS − Ad Spend.
| Month | SKU Code | Product | Units | GMV (Net Sales) | All Fees | Affiliate | Ad Spend | COGS | Settlement | Net Profit |
|---|
Bank Reconciliation Deep-Dive TikTok Payout Cadence
Same data as Report 1's reconciliation card, but with the full insight expanded. Useful as a one-pager you can send to Uzair or the auditor.
Line
March
April
May
Total
June 2026 Forecast Optimised for max profit
Method: 3-month trailing average per SKU + per-SKU ad spend optimisation by ROI. Two stock scenarios: A = sell from current stock only, B = April-style replenishment.
Baseline (no optimisation)
£0
— %
Scenario A — No Replenishment
£0
— units lost
Scenario B — Replenish
£0
— % margin
SKU classification
—
winners / modest / organic
Summary — Forecast vs Baseline
Metric
3-mo Trailing Avg
Scen A (No Replen.)
Scen B (Replen.)
Note
⚡ Top 10 Winners — fund these (ROI > 100%)
Highest historical ROI per pound of ad spend. Keep ad spend at current levels.
| SKU | Product | ROI | Avg Monthly Profit | Avg Monthly Ad Spend | Profit-per-£-ad |
|---|
⚠ Stock-Out Risks (Scenario A — no replenishment)
SKUs that would run out mid-June without inbound shipments. Replenishment quantities suggested below.
| SKU | Product | Forecast Need | Stock at 31 May | Shortfall |
|---|
📦 Recommended June Replenishment Order (Scenario B)
Units to ship in to fulfil forecast + 10% safety stock. Cost at 3-month trailing average landed cost per SKU.
| SKU | Product | Need + 10% | Landed Cost/Unit | Order Value |
|---|
📋 Full Per-SKU Forecast
Sortable. Click any column header to sort. Green = winner, yellow = modest, red = loser.
| SKU | Product | Class | ROI | Avg Units | Stock 31 May | Scen A Units | Scen A Profit | Scen B Units | Replenish | Scen B Profit | Recommended Ads |
|---|
Key Insight — Why Scenario B Out-earns the Baseline
Scenario B Net Profit (£99K) beats the 3-mo baseline (£88K) despite slightly LOWER total settlement, by reallocating ad budget away from "modest" SKUs (where each marginal £ of ads returns less than £1 of profit) toward the same volume at lower cost.
Total optimised ad spend = £67K vs May £74K (down 9%) — modest ROI SKUs trimmed to their lowest historical monthly level; winners untouched.
Nyla is your single biggest risk. Nyla EDP / Vanielle / Suede are at zero stock as of 31 May. Without replenishment, ~£45K of June revenue evaporates. Confirm with Uzair when the next sea container lands.
32 SKUs are winners with avg ROI well over 100% — collectively only £9.8K/month in ad spend but disproportionately driving profit. Push more budget here if Nyla stays stocked out and you have ad capacity.