The lines a UK marketplace seller profit report needs

What to take away

For UK marketplace sellers, choosing marketplace seller tools starts with the report: does it distinguish sales activity from the margin left after deductions?

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. A VAT-registered seller needs output VAT separated from sales revenue and recoverable input VAT tracked against purchases. That distinction belongs in the profit report, alongside the fee and refund lines.

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 or final value fees charged by the marketplace.
Fulfilment charges, including Amazon FBA charges where applicable.
Advertising charges, including eBay promoted listings.
Returns handling and refund-related charges, with any fee credits recorded separately.
Subscription or store charges allocated to the settlement period.

Fee layers to payout

Sale price plus postage
Referral or final value fee
Fulfilment fee per unit
Monthly storage charges
Advertising and promotion spend
Refunds and return postage

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.

Revenue and contribution are different measures

The amounts below are illustrative and do not come from any Amazon profit dashboard or rate card. What the report needs is one line per money movement, in this order:

Revenue net of any VAT charged on the sale.
Output VAT on the period's sales, held apart from revenue.
Input VAT recoverable on fees, postage and other purchases.
Cost of goods, entered per SKU rather than as one total.
Referral or final value fees.
Fulfilment charges, including Amazon FBA charges where applicable.
Advertising, including eBay promoted listings.
Returns handling and refund adjustments, with fee credits on their own line.
Subscription or store charges allocated to the settlement period.
Payout total for the period, and the contribution left after every deduction above.

Each line carries a date and a source document, so it can be traced back to the settlement report it came from.

Line	Amount

One order: revenue to contribution

Sale price including postage£30.00
Referral fee at 15%£4.50
FBA fulfilment fee£4.20
Output VAT at 20%£5.00
Advertising share£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

Best for

Seller spreadsheet: A few SKUs on one marketplace
Marketplace calculator: Quick checks before listing
Amazon profit dashboard: FBA sellers with settled payouts
Accounting software: VAT returns and year-end

Main gap

Seller spreadsheet: Fee lines missed at scale
Marketplace calculator: Ignores VAT and refunds
Amazon profit dashboard: Weak on eBay and own site
Accounting software: Slow per-SKU margin detail

sellerboard is an example of an Amazon profit-analytics tool; Xero is accounting software. The table describes reporting approaches rather than a product shortlist: check each product's marketplace coverage, fee matching and per-SKU cost handling against the report you need.

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.

Settlement reconciliation establishes the cash collected, not the whole profit. Include per-SKU cost of goods and costs paid outside the marketplace, such as separately billed advertising or postage, and keep VAT liabilities out of the margin calculation.

Making Tax Digital for VAT requires digital records and a compatible solution for returns. All VAT registered businesses need to keep VAT records digitally and file their VAT returns using MTD-compatible software.

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. Its service is called Find software that's compatible with Making Tax Digital for VAT.

VAT filing compatibility is not a substitute for the fee matching and product-cost detail a profit report needs.

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.