Your Cart
Loading

UK Sole Trader Bookkeeping Spreadsheet | Self Assessment Tracker | Excel

On Sale
£6.95
£6.95
Added to cart

Stop the January scramble: log income, expenses and mileage as you go, and your Self Assessment totals are worked out for you.


WHAT YOU GET

• One spreadsheet for the whole tax year (6 April to 5 April), in £

• Income, expenses, mileage and use-of-home logs that add themselves up

• A Tax Year Summary with expenses by category, the £1,000 trading allowance comparison and a rough tax & NI estimate

• An Overview dashboard with missing receipts and days to the 31 January deadline

• Works in Excel and Google Sheets


WHO IT'S FOR

• UK sole traders and freelancers filing Self Assessment

• Side hustlers checking whether the £1,000 trading allowance covers them

• Anyone who wants simple records without accounting software


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.


PAIRS WELL WITH

• Christmas Budget Planner (£2.99): plan the festive spending in the same simple spreadsheet style: https://payhip.com/b/e9Mhq


Free guide to go with it: https://venueready-hub.pages.dev/guides/self-assessment-31-january-checklist/


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.


You will get a XLSX (107KB) file