UK Side Hustle & Self-Employed Tax Tracker

Know what you've earned, what you can claim and roughly how much to put aside for tax. The Side Hustle & Self-Employed Tracker from Tidy Sums Co is made for the UK tax year (6 April - 5 April) and is ideal for sole traders, freelancers, Etsy and eBay sellers and anyone with a side hustle alongside a job.

What's inside

- Income log with automatic 'in this tax year?' check

- Expenses log using HMRC's self-employment expense categories, with a business-use % for mixed costs

- Mileage log at the HMRC simplified rate - 45p a mile for the first 10,000 business miles, 25p after - calculated for you

- Profit summary and a £1,000 trading allowance vs actual expenses comparison that tells you which gives the lower profit

- Estimated income tax and Class 4 National Insurance on your profit, taking your job/pension income into account (2026/27 rates for England, Wales & NI: Personal Allowance £12,570, 20% / 40% / 45% bands, Class 4 NI 6% and 2%) - plus a suggested amount to set aside each month and a payments on account check

- Key Dates tab with countdowns: 5 October registration, 31 January return and payment, 31 July payment on account

- Dashboard with month-by-month and category charts

- Rates are editable on the Settings tab, so you can update them each April

Important: the tax figures are an estimate to help you plan - not tax advice. Please check rates on gov.uk each year. Scotland has different income tax bands, so Scottish taxpayers should treat the income tax figure as a rough guide only (Class 4 NI is UK-wide). This spreadsheet is not Making Tax Digital software.

How it works

- Instant digital download - nothing is posted.

- Opens in Microsoft Excel (2010 or later / Microsoft 365) or Google Sheets (upload to Google Drive and open with Google Sheets, or File > Import). No macros or add-ins.

- Every file starts with a 'Start Here' tab with step-by-step instructions.

- You get two versions: an EXAMPLE file filled with made-up data so you can see how it works, and a BLANK file ready for your own figures.

Please note

- This is a digital file, so no physical item will be sent.

- For personal use only - please don't share or resell.

- Colours on screen may vary slightly between devices.

- Questions? Send Tidy Sums Co a message and we'll happily help.

AI-use disclosure: These templates were designed and built by Tidy Sums Co with the help of AI tools, then checked and tested by us. Listing images are real screenshots of the spreadsheets (example data), not AI-generated pictures.