Measurement
Part of Profit analytics for UK marketplace sellers beats revenue tracking
Profit analytics for UK marketplace sellers beats revenue tracking
Profit analytics for UK marketplace sellers: how VAT, referral fees and FBA costs sit between revenue and cash, and what a seller dashboard must hold.
What to take away
- Revenue tracking answers how much arrived. Profit analytics answers what the seller kept after fees, tax and refunds.
- On UK marketplaces the largest deductions are referral or final value fees, fulfilment charges and VAT.
- A profit dashboard should reconcile orders, fees and refunds to a settled payout before it shows margin.
- Margin per SKU, not account margin, is the figure that changes buying and pricing decisions.
- VAT registration and Making Tax Digital shape which software a seller can realistically use.
Why revenue totals flatter a UK seller account
Marketplace dashboards lead with sales totals because that number is easy to collect. A seller can watch it climb for a quarter while the bank balance falls.
Fee lines, refunds and tax arrive later, and often in separate reports. Revenue without them measures activity rather than trading.
VAT registration is where the gap widens. Once taxable turnover passes the threshold, a seller charges output VAT on sales and must keep digital records behind the return. GOV.UK sets out when registration is required.
The practical fix is to reconcile before reporting. Profit analytics for UK marketplace sellers starts from the payout, not from the sales total. A marketplace dashboard that reconciles before showing money puts exception queues ahead of headline figures.
The fee layers between revenue and payout
UK marketplace economics rarely come down to a single deduction. Five layers do most of the damage.
- Referral fee or final value fee, charged as a percentage of item price plus postage.
- Fulfilment fee, charged per unit on FBA and per parcel on many third-party logistics routes.
- Storage charges, billed monthly and higher for slow-moving stock.
- Advertising and promotion spend, which never appears on the order record.
- Refunds, return postage and any fee the marketplace does not credit back.
VAT sits outside that list, because it depends on registration status rather than on the order itself. A registered seller accounts for output VAT on the sale and can usually reclaim input VAT on fees and postage.
An eBay margin calculator that stops at final value fees will overstate margin once promoted listings and returns are added. A marketplace seller profit and loss template that holds only revenue and cost of goods has the same flaw.
A worked example on one Amazon UK order
The amounts below are illustrative and do not come from any Amazon profit dashboard or rate card.
| Line | Amount |
|---|---|
| Sale price including postage | £30.00 |
| Referral fee at 15% | -£4.50 |
| FBA fulfilment fee | -£4.20 |
| Output VAT at 20%, seller registered | -£5.00 |
| Advertising share for the order | -£2.10 |
| Cost of goods | -£8.00 |
| Net contribution | £6.20 |
The seller books £30.00 of revenue and keeps £6.20 of contribution. A revenue report displays the first figure and hides the rest.
Move the advertising share by £1.00 and the contribution moves with it. That sensitivity is what a buying decision needs.
Which route suits which seller
| Route | Best for | Main gap |
|---|---|---|
| Seller spreadsheet | A few SKUs on one marketplace | Fee lines missed at scale |
| Marketplace calculator | Quick checks before listing | Ignores VAT and refunds |
| Amazon profit dashboard | FBA sellers with settled payouts | Weak on eBay and own site |
| Accounting software | VAT returns and year-end | Slow per-SKU margin detail |
The choice matters less than the discipline of matching every fee to an order or settlement period. A tool that cannot show its matching rules will not be trusted for long.
What a profit dashboard has to hold
A workable sequence runs from the order line to banked cash.
- Import order lines with a stable identifier and the marketplace order date.
- Match each fee line to its order or settlement period.
- Separate refunds from chargebacks, and flag fees that were not credited back.
- Convert any foreign currency at a recorded rate and date.
- Reconcile the total to the payout before displaying margin.
Making Tax Digital for VAT requires digital records and a compatible solution for returns. GOV.UK explains the record-keeping duties in its guidance on charging, reclaiming and recording VAT.
HMRC also publishes the list of software that is compatible with Making Tax Digital for VAT, which is the sensible first filter before a seller trials anything.
Sellers who want the bookkeeping question answered directly can start with which accounting software for UK marketplace sellers handles MTD.
Common questions
Does profit analytics replace bookkeeping?
No. Bookkeeping keeps the VAT return and statutory accounts correct, while profit analytics explains which products make money. Most sellers need both, and the overlap is the fee detail.
How often should the margin report be rebuilt?
Match the cycle to the payout schedule, which on Amazon is typically every two weeks. Rebuilding monthly leaves too much room for unmatched fee lines.
What if fees arrive only at settlement?
Match at settlement period level and allocate to orders using a documented rule. Write the rule down, because an unexplained allocation will not survive an audit or a change of software.
Can a spreadsheet hold all this?
Yes, for a small catalogue on one marketplace. Once several marketplaces, currencies and VAT rates are in play, a spreadsheet becomes a maintenance job rather than a reporting tool.