UK Sole Trader Bookkeeping & Self Assessment Tracker

Simple bookkeeping for UK sole traders, freelancers and side hustlers. Log income, expenses and mileage as you go, and at the end of the tax year you'll have totals by HMRC-style expense category, a comparison with the £1,000 trading allowance, a rough tax and NI estimate and your key Self Assessment dates.

WHAT'S INCLUDED

• Income log with automatic tax year (6 April–5 April) and month

• Expenses log: 11 allowable categories based on HMRC's self-employment pages, business-use % for mixed costs, receipt check

• Mileage log using HMRC simplified rates (45p/25p cars & vans, motorcycles, bicycles)

• Use of home: hours per month converted to HMRC's flat rates

• Tax Year Summary: turnover, expenses by category, expenses vs £1,000 trading allowance, rough income tax & Class 4 NI estimate (England, Wales & NI rates, editable), set-aside per month and key dates

• Overview dashboard incl. missing receipts and days to the 31 January deadline

• Start Here guide

GOOD TO KNOW

• Assumes the cash basis (the default for most sole traders) and one trade. Rates are editable each April.

• It's a record-keeping aid, not tax advice and not Making Tax Digital software. If MTD for Income Tax applies to you (from April 2026 for qualifying income over £50,000, April 2027 over £30,000), you'd need MTD-compatible or bridging software.

HOW TO USE

• Excel: download and open the .xlsx (Excel 2016 or later / Microsoft 365).

• Google Sheets: upload the .xlsx to Google Drive, open it, then File › Save as Google Sheets (free Google account needed).

• A 'Start Here' tab walks you through every step. Example rows show how it works. Just overwrite or clear them.

PLEASE NOTE

• This is a digital download. No physical item will be sent. Your file downloads instantly after purchase.

• UK edition: £ GBP, DD/MM/YYYY dates and UK terminology.

• For personal use or use within your own organisation. Please don't resell or share the file.

• As it's a digital file, returns can't be accepted. But if anything doesn't work as described, send us a message and we'll put it right.

• This is a planning tool, not legal, tax or financial advice.

HOW THIS WAS MADE

This template was designed and built with the help of AI tools, working from our own original brief and design direction, and was tested before listing. Preview images are mockups generated from the actual file.