Online Seller Profit and Tax Record 2026/27 (Vinted, eBay, Etsy, Depop)
Online Seller Profit and Tax Record 2026/27 is a spreadsheet for UK people selling on Vinted, eBay, Etsy and Depop.
Log your stock and your sales. It works out the profit on every item after postage and fees, the days each one took to sell, and your trading profit by month and by platform.
It also answers the tax questions resellers ask:
- Will my platform report me to HMRC? It counts sales and sale-price totals per platform per calendar year against the gov.uk limits (30 sales, or 2,000 euros, about £1,700).
- Do I use the £1,000 trading allowance or my real costs? It works out both profits and shows the lower one.
- Do I need Self Assessment? It shows the registration date and whether your income is over the allowance.
- Am I trading, or selling things I own? Items from your own wardrobe are flagged as personal and kept out of trading profit, and the nine badges of trade are there as questions to answer.
- What do I put on my return? A tax year summary lines up turnover, costs and profit with the SA103F captions.
You type each platform's fees from its own fees page. The workbook holds no platform rates. gov.uk limits are on the Settings sheet with their links, checked on 2026-11-06.
You get an example copy (an invented Vinted and eBay reseller) and a blank copy. Works in Excel 2016 or later and in Google Sheets. No macros. Everything except the yellow cells is locked, with no password.
It does not connect to any platform and does not send anything to HMRC. It is not tax advice.