Motor Vehicle Log Book Spreadsheet Template

A log book for tax purposes has the following key features:

• A log book record of car trips doesn’t need to be kept for the whole year. The minimum requirement is a continuous 12-week period which commences in or before the tax year.
• Unless there is a change of circumstances a log book claim established in this way is valid for 5 years, at which time the minimum 12-week log book record must be repeated.
• It is permissible to keep a vehicle log book in electronic form, such as a spreadsheet or other program. It can be quite convenient to keep the log book as a spreadsheet on your computer, and update it regularly with your journey records.

We’ve prepared a simple spreadsheet which serves this purpose. It does the basic arithmetic needed to work out a business expense percentage.