What this guide is for
This guide helps users get more value from the workbook by explaining how to use it as a practical record-keeping tool through the year, not just as a one-off download.
Spreadsheet guide
How to use the UK tax tracker spreadsheet
Use this guide alongside the workbook to keep records more clearly, review figures more confidently, and build a stronger working routine through the year.
Companion guide
Use this guide while the spreadsheet is open
This guide is designed to help users get more from the workbook, not to replace it. The best approach is to keep the spreadsheet open and use this page to understand how to work through it more confidently.
Best for
Users who want a clearer way to work through the spreadsheet
The workbook becomes more valuable when users treat it as a working system with a regular routine, rather than a file that is only opened occasionally.
How to use this guide
Keep the spreadsheet open while reading. The aim is to help users work through the file more clearly and use the wider site when extra explanation is needed.
Core usage steps
Use the workbook regularly rather than occasionally
- Enter income and costs regularly rather than batching everything later.
- Keep descriptions clear enough that entries still make sense months afterwards.
- Use categories consistently so totals and reviews become easier to understand.
- Review figures through the year instead of waiting for one rushed catch-up.
- Use notes where an entry may need context later.
Sole traders
Most sole trader users will focus on business income, business costs, mileage where relevant, and regular review of working figures across the year.
Landlords
Many landlord users will focus on rental income, property costs, supporting notes, and a cleaner structure for reviewing entries and working totals.
Workbook structure explained
The main parts of the spreadsheet and how they help
Transactions
Use this area to keep income and costs in a clearer working record rather than relying on mixed notes, memory, or bank exports alone.
Mileage
If mileage is relevant, keep journeys and totals in one place so they are easier to review later.
Quarterly summaries
These help users step back and review working figures through the year instead of leaving everything to one later stage.
Dashboard totals
The workbook gives users a clearer working view of figures and patterns as entries build up.
Settings support
The supporting settings help the file feel more structured and practical than a blank spreadsheet shell.
Working routine
The spreadsheet works best when users build a simple routine around it rather than only opening it occasionally.
Practical tips
Small habits make the spreadsheet much more useful
Keep entries current
A short regular update is usually more useful than leaving many weeks of entries to rebuild later.
Use plain descriptions
Clear labels and short notes make later review far easier than vague entries that need decoding.
Review before problems build
Checking the workbook regularly helps users spot missing items, odd figures, or inconsistent records earlier.
Next steps
Use the workbook with the rest of the site, not in isolation
Download the spreadsheet
Use the spreadsheet page if you want the workbook itself and a clearer overview of what it provides.
Resources hub
Compare the workbook with other practical downloads, support pages, and checklist resources.
Start Here
Use Start Here if you still need the wider route through guides, landlord help, tools, and software support.