eBay Vinted Seller Spreadsheet UK 2026/27 | HMRC Reseller Tax Tracker (Excel + Google Sheets)
A spreadsheet for UK online sellers and resellers. You log each sale once, from any platform, and it works out your profit after fees, postage and what you paid for the item, then adds everything up for HMRC.
Since 1 January 2024, selling platforms have to collect your details. Each January they report sellers to HMRC if, on that platform, they made 30 or more sales of goods in the calendar year or received €2,000 (about £1,700) or more. Being reported doesn't mean you owe tax. Clearing out your own wardrobe is unlikely to be taxable. Buying or making things to sell for profit is likely to be trading, and in 2026/27 trading income over £1,000 means registering for Self Assessment. This workbook shows you which side of each line you're on.
WHAT IT DOES
• Sales log for every platform: item price, postage the buyer paid, refunds, platform fees and the postage label you bought
• Stock tab: enter a haul once and the cost of each item flows to the sale, so every sale shows its real profit
• "Will HMRC hear about me?" checker: your sales count and takings on each platform against the 30 sales / £1,700 reporting limits, with how many you have left
• Personal items kept separate: they count toward the platform's test but stay out of your trading income
• £1,000 trading allowance vs your actual costs: it works out both and uses whichever leaves less profit to tax, with a preview of the £3,000 allowance coming in April 2027
• Making Tax Digital quarterly totals in HMRC's fields, per quarter and year to date, for when you pass £50,000, £30,000 or £20,000
• Tax estimate that includes your salary or pension, Class 4 National Insurance, payments on account and a figure to put aside each month
• Dashboard with profit and margin by platform, a monthly chart and data checks for missing stock refs or platforms
WHAT YOU GET
• Blank workbook (.xlsx), room for 2,000 sales, 500 stock lines and 500 expenses
• Sample workbook: a made-up vintage reseller on eBay, Vinted, Etsy, Depop and TikTok Shop, filled in for a full year
• Quick Start Guide (PDF, 2 pages)
• Works in Microsoft Excel 2016 or later (Windows and Mac), Google Sheets, Apple Numbers and LibreOffice. No macros, no add-ins, no subscription.
PLEASE NOTE
• This is a digital download. Nothing will be posted.
• It keeps records and produces figures. It doesn't send anything to HMRC or connect to your selling accounts.
• Rules and rates are for the 2026/27 tax year, checked on GOV.UK in November 2026. The £1,700 figure is GOV.UK's approximation of €2,000 and moves with the exchange rate.
• For UK sole traders selling goods. It doesn't cover VAT returns, limited companies, partnerships, Capital Gains Tax calculations or services sold through apps.
• This is a record-keeping and estimating tool, not tax advice. If you're unsure whether your selling counts as trading, check HMRC's guidance or ask an accountant.
FAQ
Q: I only sell my old clothes on Vinted. Do I need this?
A: Probably not for tax, as selling your own things is unlikely to be taxable. If you're near 30 sales, the checker shows whether Vinted will report you, so a letter from HMRC won't come as a surprise.
Q: Vinted's report and my figures don't match. Why?
A: Platforms report by calendar year (January to December). Your tax return runs 6 April to 5 April. The workbook does both.
Q: Should I use the £1,000 allowance or my expenses?
A: Whichever gives the lower profit. Resellers with stock costs usually do better with actual expenses. The workbook picks for you.