UK Business Mileage Tracker 2026/27 – Excel Mileage Calculator

Keep track of your business mileage without the faff. 🌿

The UK Business Mileage Tracker is a simple Excel spreadsheet designed for UK sole traders, self-employed individuals and small business owners who want an easy way to record business journeys and calculate mileage using the 2026/27 mileage rates for cars and goods vehicles.

Simply enter your journeys and mileage, and the spreadsheet does the calculations for you — including automatically applying the different rate once your cumulative business mileage passes 10,000 miles.

What’s included:

• Easy-to-use business mileage log
• Automatic mileage calculations
• 55p per mile for the first 10,000 business miles
• 25p per mile thereafter
• Automatically handles journeys that cross the 10,000-mile threshold
• Monthly mileage summary
• Space to record dates, journeys, purposes and miles
• Designed for the UK 2026/27 tax year
• Instant digital download
• Microsoft Excel spreadsheet

Perfect for: sole traders, freelancers, contractors and small business owners who want a straightforward way to keep their mileage records organised.

Please note: This spreadsheet is designed for cars and goods vehicles and is based on the applicable HMRC mileage rates for 2026/27. It is provided as a record-keeping tool only and does not constitute tax, accounting or financial advice. Always check current HMRC guidance for your individual circumstances.