Short answer
Our UK Side Hustle Tax Records Kit 2026/27 (£12.99) is a one-off Excel (.xlsx) and Google Sheets workbook for UK online sellers and side hustlers. It keeps sales of your own unwanted personal possessions separate from taxable trading income, compares the £1,000 trading allowance with your actual expenses (including platform and postage fees), and tracks calendar-year sales against HMRC's 30-sale / €2,000 (~£1,700) platform reporting threshold. Record-keeping only; does not submit directly to HMRC.
Last checked against GOV.UK: 23 October 2026. Sources are linked in each section. HMRC updates its guidance, so always check the source before you act.
Personal possessions vs taxable trading – three rules online sellers mix up
Before you buy any spreadsheet, here is what HMRC's official guidance for online sellers actually says:
- Selling your own unwanted personal possessions is not taxable trading: clearing out your wardrobe on Vinted, Depop or eBay for less than you paid is not a trade and does not count towards the £1,000 trading allowance (GOV.UK). Personal possessions only touch Capital Gains Tax if a single item or set sells for more than £6,000 and you make a profit over what you paid (GOV.UK).
- Buying or making items to sell for profit is taxable trading – with a £1,000 gross trading allowance: if you buy vintage clothes, car-boot stock or wholesale goods to resell at a profit, or make crafts to sell on Etsy, that is trading. If your total gross trading income (what buyers pay you before platform fees, postage or stock costs) across all trades is £1,000 or less in a tax year (6 April to 5 April), it is covered by the tax-free £1,000 trading allowance and you usually do not need to register (exceptions explained here). Over £1,000 gross trading income, you must tell HMRC by 5 October after the tax year and choose between deducting the £1,000 trading allowance instead of expenses, or deducting your actual allowable business expenses.
- Platform reporting (30 sales or €2,000 / ~£1,700) is a calendar-year report, not a tax bill: since 1 January 2024, digital platforms report a seller's goods sales to HMRC for a calendar year (1 January to 31 December) unless the seller made fewer than 30 sales of goods AND received less than €2,000 (around £1,700) on that platform. Platforms count every sale on their site (including personal wardrobe clear-outs), so a platform report does not automatically mean you owe tax – keeping a clear log separating personal items from trading stock lets you show what was what if HMRC asks.
Want to check your own numbers right now? Try our free side hustle & online seller tax checker.
See the finished result (fictional sample data)
Below are three actual screenshots from our UK Side Hustle Tax Records Kit 2026/27 (£12.99) populated with fictional sample transactions only (an imaginary seller making Etsy candles, reselling eBay car-boot finds, and clearing out a personal wardrobe on Vinted). Select any image to open the full-resolution PNG in a new tab on mobile.
What this spreadsheet does – and what it does not do
Record-keeping only; does not submit directly to HMRC. We do not promise tax savings, guaranteed time saved, or legal verdicts on whether an activity is a trade.
What this kit DOES
- Logs up to 500 individual sales (with platform, sale type, buyer price + postage charged, platform fees and net payout) and 500 business expenses.
- Separates personal clear-out sales from taxable trading sales automatically so personal wardrobe sales never inflate your gross trading income.
- Shows both Method A (actual expenses + platform fees) and Method B (£1,000 trading allowance) side by side for the 6 April 2026 – 5 April 2027 tax year.
- Tracks calendar-year (1 Jan – 31 Dec) sales count and net value per platform against the 30-sale and €2,000 (~£1,700) DAC7 reporting thresholds.
What this kit DOES NOT do
- Record-keeping only; does not submit directly to HMRC. Spreadsheets cannot file tax returns or connect to HMRC's API.
- Does not decide legally whether your activity is a trade (it organises your figures and notes; HMRC's Badges of Trade depend on all the facts).
- Does not work out Capital Gains Tax on personal items sold for over £6,000, or total Income Tax / National Insurance across your day job.
- Does not import CSV exports automatically from Vinted, eBay or Etsy APIs (you enter or paste your sales into the Sales Log).
< £0.00), so if a refund makes an entire category negative for the year to date, export for that box is blocked (CHECK (<0)) until reviewed. Compatibility with our spreadsheet has not yet been verified. See our MTD filing software explainer.
What's inside the UK Side Hustle Tax Records Kit (£12.99)
The workbook contains 10 unlocked worksheets in Excel (.xlsx) and Google Sheets format:
| Worksheet tab | What it records or calculates |
|---|---|
| 1. Start Here | Plain-English setup guide, colour key (pale yellow = your inputs; white/grey = automatic formulas) and GOV.UK source links. |
| 2. Settings | Set your tax year (2026/27), calendar year for platform reporting (2026), and editable £ equivalent for the €2,000 platform threshold (default £1,700). |
| 3. Sales Log | 500-row log for every sale across Etsy, Vinted, eBay, Depop, Amazon or Other – tagging each row as Goods I made, Goods bought to resell, Service, Other business income or Personal possession. |
| 4. Expense Log | 500-row log for stock/materials, packaging, postage, equipment and other business costs mapped to SA103 categories. |
| 5. Personal vs Trading | Side-by-side summary of trading sales vs personal possessions kept separate, £6,000+ chattel alert, and a structured HMRC Badges of Trade (BIM20205) self-check grid. |
| 6. Allowance vs Expenses | Side-by-side comparison of Method A (actual expenses + platform fees) vs Method B (£1,000 trading allowance) on your gross trading income. |
| 7. Platform Tracker | Calendar-year breakdown by platform showing goods sales count vs 30 and net value vs £1,700 (~€2,000), with automatic Green / Red reporting status. |
| 8. Monthly Summary | Month-by-month trading income, platform fees, allowable expenses and net profit from April 2026 to March 2027. |
| 9. Annual Summary | Full-year Self Assessment summary (SA103S / SA103F box references) ready to refer to if you need to complete a tax return. |
| 10. Key Dates & Lists | Key UK Self Assessment and platform reporting dates (5 October registration, 31 January filing/payment) and dropdown reference lists. |
Running a full-time online shop or entering Making Tax Digital?
If your online selling is an established self-employed business and you need cumulative Making Tax Digital quarterly updates (Updates 1–4), a 55p/25p business mileage log and a flat-rate working-from-home tracker, see our UK Sole Trader MTD Record-Keeping Kit 2026/27 (£19.99) below.
Questions
What file format do I get, and how is it delivered?
You receive an instant digital download immediately after checkout containing the unlocked .xlsx spreadsheet workbook (no macros or VBA) and a PDF Quick-Start Guide with a one-click link to copy the workbook into a free Google Sheets account.
Which spreadsheet programs and devices are supported?
The workbook works in Microsoft Excel (2016, 2019, 2021 and Microsoft 365 on Windows and Mac), free Google Sheets in any modern browser, and LibreOffice Calc.
Are all Vinted, eBay or Depop sales taxable?
No. Selling your own unwanted personal belongings – such as clearing out old clothes from your wardrobe or selling used household items for less than you paid – is not trading and does not count towards the £1,000 trading allowance (GOV.UK). Capital Gains Tax only applies to a personal possession (a 'chattel') if a single item or set sells for more than £6,000 and you made a gain. By contrast, buying items to resell for a profit or making items to sell for a profit is taxable trading.
Does this spreadsheet submit my figures to HMRC?
No. This kit is for record-keeping only; it does not submit directly to HMRC. If you need to file a Self Assessment return, you copy the annual summary totals into your return. If your total qualifying gross income from trading and property is high enough to bring you into Making Tax Digital for Income Tax (£50,000+ from April 2026 or £30,000+ from April 2027), you will need an MTD quarterly workbook (such as our UK Sole Trader MTD Kit, £19.99) plus bridging software that sends updates to HMRC (our workbook itself does not submit to HMRC).
Will I have to pay separate software fees to file with HMRC?
If you are outside Making Tax Digital and only file an annual Self Assessment return, HMRC's own online Self Assessment service on GOV.UK is free. If your qualifying income brings you into Making Tax Digital for Income Tax, third-party bridging or filing software is required and some vendors charge fees or limit free tiers at year-end. See our MTD filing software explainer.
What is your refund and cancellation policy for digital downloads?
Under Regulation 37 of the UK Consumer Contracts (Information, Cancellation and Additional Charges) Regulations 2013, you have a 14-day statutory cancellation period for digital downloads. You only lose that 14-day right to cancel before the 14 days expire if you start downloading or copying the files after giving explicit prior consent to immediate supply and acknowledging that your right to cancel will be lost once the download begins (where those consent and acknowledgment steps are not completed, or before downloading starts, the 14-day cancellation right remains). Separate from cancellation rights, under the Consumer Rights Act 2015 (sections 34–37), digital content must be of satisfactory quality, fit for purpose and as described – if a file is faulty or does not match its description, email [email protected] for a repair, replacement or refund.
How do I get support if I have a question about the workbook?
Email [email protected] if you need help downloading, opening or using the spreadsheet formulas. We cannot provide personal tax, legal or accounting advice.
About TaxYearSheets: what we do and don't do
What we do: UK record-keeping spreadsheets (Excel and Google Sheets) and free browser-based checkers for landlords, sole traders and online sellers. Every date and rate is sourced to GOV.UK or legislation.gov.uk.
What we don't do: we're not HMRC software and we're not connected to HMRC. Our spreadsheets don't submit anything to HMRC; if you're in Making Tax Digital you still need software that works with it. Nothing here is personal tax advice. More about us.
Free UK tax deadline reminders
A short email 1–3 weeks before key UK tax dates: Making Tax Digital quarterly updates, the 31 January Self Assessment deadline and the end of the tax year. Each one says what's due and who it applies to, and links to the GOV.UK source.
- How often: about once a month, never more than 2 a month.
- What else: occasionally a note about our record-keeping spreadsheets. No spam, and we never share or sell your address.
- Leave any time: there's an unsubscribe link in every email.