Knowledge

Business mileage claim spreadsheet for the self-employed

Posted on Mar 12th, 2018 | Expenses

Business mileage claim spreadsheet for the self-employed, image of cars on the motorway

Business mileage is an important – but often overlooked – expense for freelancers and contractors.

Claiming business mileage helps reduce your company profits, and therefore the amount of tax you pay at the end of the year. In short, claiming business miles is good news for you and your company.

The government allows you to claim a rate per mile, depending on your mode of transport. Those that cycle will find mileage expenses especially beneficial – you can claim 20p per mile without incurring the fuel and insurance costs of your car-driving counterparts.

All business mileage must be recorded on a standard form (although no proof of the journey is required, unlike other allowable expenses), and reported every year on your P11D. Here are the rates (per mile) allowed by the government:

Mode of transport

First 10,000 miles

Over 10,000 miles

Car/van £0.45 £0.25
Motorcycles £0.24 £0.24
Bikes £0.20 £0.20

Business mileage spreadsheet

The best way to record your business mileage on a day-to-day basis is with a mileage expenses spreadsheet which, as luck would have it, you’ll find right here!

Get the 2018/19 business mileage expenses spreadsheet

Need to claim mileage from previous years? Get the 2017/18, 2016/17 and 2015/16 spreadsheets.

Note there’s no prescribed, HMRC-approved mileage claim form template. You just need to give the information to the taxman in a consistent, well-presented way. For this reason, a standard expenses spreadsheet that logs all business mileage is always a good idea.

business-expenses-banner

Join Crunch Chorus:
The free community for the self-employed

You'll get access to a range of benefits, such as invoice software, jargon-free business guides, great networking opportunities, discounts, plus much more

Written by Jon Norris

Useful tools and resources

Business guides

From understanding expenses to starting a limited company, we've a range of jargon-free business guides for you to download and keep.

Invoicing software and templates

Create, send and store sole trader invoices in a snap with our free invoice software. You can also download a selection of invoice templates for all business types.

Take-home pay calculator

Use our Take-Home Pay Calculator to work out your true earnings and see if you could save money with a different company set up.