Sale!

UK Sole Trader Expense Tracker (Excel)

Original price was: £5.39.Current price is: £4.31.

A ready-made UK expense tracker spreadsheet for sole traders – log income and expenses by HMRC category all year, ready for Self Assessment. Editable in Excel or Google Sheets, instant download.

  • Instant download after checkout
  • One-off payment — no subscription
  • Card, Apple Pay & Google Pay — secure checkout
  • HMRC-ready — built for UK freelancers

Description

This UK sole trader expense tracker is a ready-made Excel spreadsheet that keeps your income and outgoings organised all year, so Self Assessment season is a copy-paste job instead of a scramble through old receipts.

Expenses are already grouped into the categories HMRC actually asks for on the Self Assessment return – so at year end you can see exactly what to enter, where.

Works in Excel, Google Sheets or Numbers on Windows, Mac, iPhone or Android. Instant download, no subscription, yours to reuse every tax year.

How the tracker works

Log each cost once, with the date, what it was and which category it falls under. Keep your categories in line with the expense boxes on the Self Assessment form and January becomes a copy-and-paste job.

Most sole traders now use the cash basis by default. That means you record a cost on the day the money leaves your account, not when the bill arrives.

Keep the receipts too

The spreadsheet is your summary. HMRC can still ask for the proof behind it, so keep receipts or a clear photo of each one for at least five years after the 31 January filing deadline.

What about Making Tax Digital?

From April 2026, sole traders with qualifying income over £50,000 have to keep digital records and send quarterly updates. That threshold drops to £30,000 in April 2027. A spreadsheet is still allowed, but you will need bridging software to send the figures to HMRC. Below the threshold, this tracker is all you need.

Not sure what you can claim? See our list of allowable expenses for UK freelancers.

A worked example

Your phone contract is £30 a month and about 60% of its use is for work. Log £18 a month under phone costs, which is £216 for the year. Do the same for broadband, software and travel, and at year end each category total goes straight into the matching box on your return.

Questions before you buy

What about the £1,000 trading allowance?

You can deduct the allowance or your real expenses, not both. Tracking real costs is how you find out which is bigger. The allowance is due to rise to £3,000 from April 2027.

What can’t I claim?

Everyday clothes, ordinary commuting and personal costs. If something is partly personal, claim the business share only.