Fleet Trackers to Digitise Business Mileage Logs

Don’t neglect your mileage log book until tax season. Learn how a fleet tracking software can ease the burden of mileage tracking.
construction site, digitise mileage tracker, miles driven

For many companies, business mileage logs are one of the best ways to seek tax relief. This makes mileage logs an important tool for fleet managers because of their ability to document employee’s business driving. In the event of an audit, an accurate and defensible mileage record is a powerful resource for a company with a fleet.

Unfortunately, many businesses still rely on outdated paper mileage sheets which lead to inaccurate mileage logs. To improve the accuracy and utility of your business mileage records, it is important to adopt digital mileage sheets through innovative fleet management software solutions.

In this article, we discuss the importance of digitised business mileage logs and provide a customisable template to help improve how you track company-related trips.

Read more: Survey Find Lack of Technology is Stunting the Service Industry

Mileage log template

Before we go on to explain the ins and outs of a mileage log, please go ahead and download our free mileage log template below. This will make your life far easier.

Get a Free Mileage Log Template


Once you have downloaded our free mileage log template, follow the instructions below on how to use the mileage log template and how to automise the mileage log template with fleet tracking.

How to use Your Mileage Log Template

On your mileage log template you will find a space to record the date, purpose and miles of each journey. Always fill these parts in your mileage log template.

A mileage log template

The pre-existing formula in the mileage log template will automatically update the “total” miles traveled. At the end of every month, you can then calculate the total number of business miles traveled and claim money back from your company.

Find out how to calculate reimbursements in this section.

Using Mileage Log Template with Fleet Tracking

High-performing fleet tracking, like Vimcar’s Fleet Geo, tend to offer Data Export features. This allows users to track their fleet’s vehicles (company cars and/or pool cars) and then download that data straight into a spreadsheet.

That way, filling in your mileage log template is a nearly-instant process and can be done at the end of the month, instead of on a day to day basis.

What Is a Mileage Tracker/Mileage Log and Why Is it Important?

A mileage tracker is a tool for calculating the number of miles travelled while a mileage log is a record of accumulated miles on trips over a specific period. The HMRC requires companies to track their business miles every year for a minimum of six years. This information is essential for claiming tax returns and the HRMC will need accurate records to verify your business trips.

Writing down a mileage log

Most companies used to track business travel with a pen and paper. However, this approach is inefficient. Because of human error and other factors, employees can forget to record all their business travels. It can also be difficult to complete mileage logs accurately. Sometimes, an employee will forget to include vital information such as dates, start and end destinations, and other important details. A paper mileage tracker can also be lost or destroyed by the elements.

Read more: The Unforeseen Benefits Of Truck GPS Tracking

Mileage on a car dashboard

An improvement over the old paper mileage logs is the digital spreadsheet. However, drivers still need to record their business miles on the spreadsheet manually. While spreadsheets are safe from the elements, they are not protected from human forgetfulness and sudden system failure, especially when you don’t back up your records.

So how do you create accurate business mileage records that will stand up to HMRC scrutiny? 

Automated mileage tracking tools are the most effective solutions for recording business miles. A good example is the integrated fleet management software with vehicle tracking capabilities from Vimcar.

With Vimcar’s vehicle tracking software, you get precise, digitised records of company car trips, route information, and other vital information for effective fleet management. Vimcar allows you to export mileage records and other important travel data for all company vehicles in different file formats.

Accurate and defensible mileage records guarantee you will get the tax relief your business deserves whenever the HMRC checks your books.

Why Is it Important to Digitise a Mileage Tracker?

Digitised mileage tracking is the best way to log business trips accurately while also complying with HMRC regulations. Here are benefits of adopting a digitised mileage tracker:

1. Improved Accuracy

Considering the fast-paced nature of business environments, it is easy to see why about 90 percent of drivers submit inaccurate mileage claims. Digitised mileage tracking eliminates exaggerated and inaccurate journey records. You don’t have to round up miles or inflate them because someone forgot to take accurate records.

Saving time with a digital mileage log

2. Easy and Time Saving

Digitised mileage tracking eliminates the need for drivers to put pen to paper for mileage tracking. It also reduces the time fleet managers spend reviewing mileage claims. Vimcar’s plug-and-play vehicle tracking tool provides an easy-to-use vehicle route tracking functionality that takes precise records of business miles with no manual input. This helps save time and effort, allowing employees to focus on satisfying customers and moving the company closer to its goals and objectives.

3. HMRC Compliant

Tax return

According to one estimate, 93 percent of SMEs won’t pass a HGV laws on mileage inspection because of inaccurate and incomplete records. A digitised mileage tracking system will record and store every trip, providing accurate records that are HMRC compliant.

4. Safer Records

Most digitised mileage tracking solutions store information in the cloud. This means you won’t lose your mileage records in the event of a computer crash, cyberattack, or natural disaster. Automatic mileage trackers provide an added layer of redundancy that significantly reduces the chances of losing mileage records.

5. Higher Tax Benefits

tax records, fleet management tax benefits

If you have a company fleet, a digitised mileage tracker makes it easier to calculate the VAT amount claims on your fuel spend. It also simplifies claiming tax benefits on business mileage. And the system allows fleet managers to distinguish between business travel and personal trips.

Want advice on how to better manage your fleet? Our fleet experts can give you a free consultation!

How To Calculate Your Business Mileage Deduction Using A Mileage Log

Managing your business mileage log is an excellent way to seek tax relief when tax season arrives. The HMRC requires all businesses to keep a mileage for every employee, every year. With the right mileage tracking tool integrated with your fleet management software, you can keep accurate logs for tax reasons.

Calculating mileage logs

The HMRC sets mileage rates employees can use to claim expenses per business mile travelled. These claims are vital for any employees using personal cars for work-related travel. Let’s see the mileage rates for 2020 and how you can use them to calculate your business mileage deduction.

The Mileage Rate For 2020

  • Cars and Vans: 45 pence over the first 10,000 miles and 25 pence above 10,000 miles
  • Motorcycles: 24 pence per mile
  • Bicycles: 20 pence per mile
  • Passengers: 5p per passenger carried in a car or van for a work trip

Calculate Mileage Deductions on Your Tax Returns

Multiply the miles travelled by the mileage rate for the current tax year. For example, if you travel 10,000 miles away from work on your personal vehicle, with a mileage rate of 45, you can claim:

  • 10,000 × 45p = £4500

If you pay taxes 20%, you claim is worth:

  • £4,500 @ 20% = £900

If you pay taxes at 40%, your mileage log tax rebate is worth:

  • £4,500 @ 40% = £1,800

Can You Claim a Mileage Tax Refund If You Have an Employer?

Talking to an employer about mileage logs

If you’re taxed for mileage allowance, you can claim back all approved mileage rates. If you have an untaxed mileage log allowance, you can claim the difference between approved mileage rates and what you’re paid. If your employer has paid you the full approved mileage rates, you’re ineligible for tax claims.

Let’s say you are an employee and receive less than the allowed mileage payment allowance. You can claim the remaining unused allowance.

For example, say you travel 5,000 miles for the tax year, and your employer reimburses you 30p per mile of business travel.

  • 5000 × 30p = £1500

The allowed HMRC mileage rate for the first 10,000 miles is 45p per mile. So your remaining reimbursement is:

  • 5000 × 15p = £750

You can apply for tax relief on this balance and save on tax on your highest tax rate. Let’s assume 40%.

  • £750 @40% = £300

What If My Mileage Log Has More Than 10,000 Miles?

If you cover more than 10,000 business miles during a tax year, apply a 45p rate to the first 10,00 miles and 25p to the other miles.

Let’s say you cover 15,000 business miles. Your claim will be:

  • (45p×10,000) + (25p × 5,000)= £5,750.

However, since this amount is above £2,500, you need to complete a self-assessment tax return to get the claim.

Can I Claim If I Carry a Passenger on a Business Trip

The current rate for a passenger in your car for a work-related trip is 5p. However, you cannot claim this passenger allowance if your employer does not pay it, or if their passenger allowance is less than 5p per mile.

A driver and a passenger

With the Vimcar vehicle tracking software, you can keep accurate mileage log and use them to calculate the tax relief your business deserves.

Final Words on Mileage Logs

Adopting fleet management practices is essential for getting maximum returns on investment from company vehicles. Using digitised logbooks and mileage trackers can help provide accurate records of your business trips, offering tremendous cost-reducing and tax benefits. Vimcar’s Fleet Geo fleet management software provides a wide range of tools, including real-time vehicle tracking and digitised mileage records to simplify administrative and legal obligations.

Visit our website to learn how Vimcar cuts costs and optimizes your fleet management workload.


Vimcar Brochure


Fleet Geo
Leave a Reply

Your email address will not be published. Required fields are marked *

You May Also Like