Mileage Log Template Explained: Fields, Example and How to Use One

A mileage log template is the single document that turns the miles you drive for work into a defensible tax deduction or a clean reimbursement claim. Without one, you are relying on memory and rough guesses - and that is exactly what tax authorities reject. This guide explains what a mileage log template is, the precise fields it must contain, how to fill it out with a worked example, and the mistakes that quietly cost freelancers and small businesses money every year.

Whether you are a self-employed contractor driving to client sites, a consultant visiting offices, or a small business reimbursing employees for their own cars, the principle is the same. The tax office will only honor what you can prove. A structured, consistent log is the proof.

What Is a Mileage Log Template?

A mileage log template is a pre-formatted sheet - on paper, in a spreadsheet, or inside an app - designed to record every business journey you make in a vehicle. Each row represents one trip and captures the date, the route, the odometer readings, the total distance, and the business reason for traveling.

The purpose is substantiation. When you claim mileage as a tax deduction or ask for reimbursement, you are asserting that you drove a specific number of business miles. The log is the evidence behind that number. Both the United States IRS and the United Kingdom's HMRC expect records that are accurate and made at or near the time of travel - what accountants call a "contemporaneous" record.

A mileage log is not the same as an expense receipt. A fuel receipt proves you bought petrol; it does not prove that petrol was used for a business journey. The log connects the vehicle use to a business purpose, which is the part that actually unlocks the deduction.

Why the format matters

A casual note in your phone - "drove to see Acme today" - is technically a record, but it omits the figures that make a claim verifiable. A proper template forces you to capture the same fields every single time, which is what gives the document its evidentiary weight. Consistency is the quiet superpower of a good log.

When Do You Need a Mileage Log?

You need a mileage log any time business vehicle use feeds into a financial claim. The most common scenarios are:

• Claiming the standard mileage rate. If you deduct business driving using a per-mile rate rather than actual vehicle costs, the log is mandatory. The rate is published annually by the IRS in the US and as the Approved Mileage Allowance Payments by HMRC in the UK.
• Reimbursing employees. Under an accountable plan, businesses reimburse staff for business miles driven in personal vehicles. The log substantiates each reimbursement so it stays tax-free to the employee and deductible for the business.
• Splitting business and personal use. If you use one vehicle for both, the log establishes your business-use percentage, which also matters if you ever switch to the actual-cost method.
• Supporting an audit or review. If your return is questioned, the log is the first document an inspector asks for. A complete log usually ends the conversation quickly.

The Essential Fields a Mileage Log Template Must Contain

Every reliable mileage log template shares a common backbone. At minimum, each trip entry should record:

• Date of the journey - the specific day the travel took place.
• Starting location and destination - enough detail to identify the route (client name or address).
• Business purpose - why you made the trip (e.g. "client site visit", "supplier collection").
• Starting odometer reading - the vehicle's mileage at the start.
• Ending odometer reading - the mileage at the end.
• Total miles for the trip - the difference between the two readings.
• Business vs personal classification - a flag distinguishing deductible miles.

Supporting columns make the log more useful: a running monthly or annual total, the rate applied, the calculated reimbursement or deduction amount, and a notes field for parking, tolls, or detours.

A summary block at the top or bottom should record the vehicle, the driver, the period covered, and the opening and closing odometer for the whole period. That period-level total lets you calculate business-use percentage at a glance.

A Section-by-Section Breakdown

Here is how to think about each part of the template, and what "good" looks like in each field.

Header / vehicle details

This identifies whose log it is and which car. Include the driver's name, the vehicle make, model and registration, and the reporting period (often a tax year or month). For a business reimbursing several people, one log per driver per vehicle keeps things clean.

Date column

Use a consistent date format and log entries in chronological order. A log with random gaps or out-of-sequence dates looks reconstructed and invites scrutiny. One row per trip is the cleanest approach, though some drivers consolidate multiple stops on a single route into one entry with notes.

Destination and purpose

The purpose field is where most weak logs fall down. "Business" is not a purpose. "Meeting with Acme Ltd re. website project" is. The destination plus purpose should together tell an inspector exactly why those miles were business miles. Vague entries are the single biggest reason claims get reduced.

Odometer readings

Record the actual dashboard reading at the start and end of each trip, not a rounded estimate. The start reading of a new trip should normally match the end reading of your previous business trip plus any personal miles in between. Readings that do not reconcile across the period are a red flag.

Total miles

This is simply end minus start. Many spreadsheet templates calculate it automatically. If you are claiming a per-mile rate, this column multiplied by the rate gives your deduction or reimbursement for the trip.

Classification and notes

Flag each trip as business or personal. Commuting between home and a regular workplace is generally personal and not claimable in either the US or UK - a nuance that trips up many first-time claimants. Use the notes column for tolls, parking, or any context that explains an unusual entry.

A Realistic Mileage Log Example

Meet Priya, a freelance UX designer trading as a sole proprietor. She uses her own car for client visits and keeps a spreadsheet mileage log. Here is a slice of one week.

For the week, Priya drove 209 miles in total, of which 195 were business. Her readings reconcile cleanly: each trip's start matches the prior end, including the 14 personal miles on 06 Jun. At her jurisdiction's per-mile rate, she multiplies 195 by the rate to get the week's deductible amount, then carries the running total forward. Because every business row has a named client and a specific purpose, her log would survive a review without a follow-up question.

Notice what makes this work: no gaps in the odometer chain, a real purpose on every business line, and personal trips logged rather than hidden. The discipline is small; the protection is large.

Mileage Log vs Related Business Documents

A mileage log overlaps with several other records, so it helps to be clear on where each one stops and starts.

The key distinction: a mileage log measures distance and purpose, not money spent. If you reimburse staff for both mileage and other costs, you will often pair the mileage log with an expense report rather than replacing one with the other. For a fuller picture of related records, our expense report template and timesheet template guides cover the neighbouring documents.

Pros and Cons of Using a Mileage Log Template

A standardized template beats ad-hoc note-taking, but it is worth knowing the trade-offs.

Pros

• Audit protection. A consistent, contemporaneous log is the strongest defense if your mileage claim is questioned.
• Maximized deductions. Capturing every eligible trip means you stop leaving money on the table from forgotten journeys.
• Clean reimbursements. Employees get paid accurately and businesses keep payments tax-free under an accountable plan.
• Effortless reconciliation. Odometer chains and running totals make year-end accounting far faster.
• Reusable structure. Once built, the same template serves every month and every vehicle.

Cons

• Requires discipline. A template only works if you actually fill it in at the time - gaps undermine the whole record.
• Manual entry on paper or spreadsheets. Hand-keying readings is tedious and error-prone compared with automatic capture.
• Risk of reconstruction. Logs rebuilt long after the fact are weaker and may be challenged.
• Format confusion. Mixing business and personal miles without clear flags can muddy your business-use percentage.

Common Mistakes to Avoid

These are the errors that turn a perfectly good claim into a reduced or rejected one.

• Vague purposes. Writing "business" or "meeting" without naming the client or reason. Inspectors read this as padding.
• Estimating instead of reading the odometer. Round numbers like "50 miles" repeated across many entries look invented. Use actual readings.
• Logging commutes as business. Travel between home and a regular place of work is usually personal in both the US and UK. Claiming it is a frequent and avoidable error.
• Gaps in the odometer chain. When trip start readings do not follow on from prior end readings, the log stops reconciling and loses credibility.
• Reconstructing from memory at year-end. A log written months later is far less persuasive than one kept as you drove.
• Mixing methods. Claiming the per-mile rate and also deducting fuel and repairs for the same vehicle double-counts costs and is not allowed.
• Forgetting personal trips. Leaving personal journeys out of the log breaks the odometer continuity even though they are not claimable.
• No driver or vehicle identification. A log that does not say whose car it is becomes hard to tie to a specific claim.

Best Practices for an Audit-Proof Mileage Log

Follow these steps to keep a log that holds up under any review.

1. Record trips contemporaneously. Enter each journey on the day it happens, or within a few days at most. Timeliness is what makes a record credible.
2. Capture the full odometer chain. Log personal trips too, so the readings reconcile across the entire period and your business-use percentage is provable.
3. Write specific purposes. Name the client, the site, or the task for every business trip. Specificity is the difference between an accepted and a reduced claim.
4. Pick one method and stick to it. Decide between the standard mileage rate and actual costs for each vehicle, and apply it consistently for the year.
5. Reconcile monthly. At month-end, check that the readings flow and the totals add up. Fixing a gap in June is easy; finding it next April is not.
6. Keep the supporting evidence. Hold on to fuel receipts, parking tickets, and calendar entries that corroborate the log. They reinforce, not replace, the record.
7. Retain records for the required period. Both the IRS and HMRC expect you to keep mileage records for several years after the relevant filing. Store them securely and back them up.
8. Separate logs per vehicle. If you run two cars for business, keep a distinct log for each so readings never get confused.

Once the log is complete and reconciled, it feeds directly into your tax return or reimbursement run. For the reimbursement side, it should flow into an expense workflow rather than living in isolation - which is where pairing it with structured business documents pays off.

How a Mileage Log Fits Into Your Business Workflow

A mileage log is rarely the final document - it is an input. The miles you record become a number on an expense report, a line on a tax return, or a reimbursement paid to an employee. Treating the log as part of a connected workflow, rather than a standalone sheet, is what stops business travel from becoming a year-end scramble.

For a freelancer like Priya, the flow is simple: log trips as they happen, total business miles monthly, then transfer the figure into her bookkeeping and, ultimately, her self-assessment. For an agency reimbursing several drivers, the log becomes part of an approval chain - the driver submits it, a manager reviews it, finance pays it under an accountable plan, and the totals roll up into the company's deductible motoring costs.

This is where keeping your business documents in one connected system matters. When your invoices, expenses, and supporting records live together, reconciling mileage against client work and reimbursements is straightforward. Modern platforms such as Aviy let you generate professional business documents and keep your billing organized in one place, so a mileage figure does not get stranded in a spreadsheet nobody opens again. If you want to understand how the surrounding records connect, the business documentation checklist maps the full set of documents a business needs.

The broader principle applies to any business record: capture it consistently, store it where it is easy to find, and connect it to the workflow it serves. A mileage log that lives in isolation gets forgotten. One that feeds your reimbursements and tax filings earns its keep.

Paper, spreadsheet, or app - which format wins?

The right format depends on how much you drive and how disciplined you are. A paper logbook in the glovebox is simple and works without batteries, but it relies entirely on you remembering to fill it in, and the figures still have to be typed up later. A spreadsheet template is the sweet spot for most freelancers: it calculates totals automatically, is easy to back up, and exports cleanly into your bookkeeping.

For drivers covering high mileage across many clients, a GPS-based app that detects trips automatically removes the biggest weakness of manual logs - the forgotten journey. The trade-off is that you must still review and classify each trip as business or personal, since an app cannot read your intent. Whatever you choose, the test is the same: does it capture every required field, and can you produce a clean export if asked?

Choosing between the mileage rate and actual costs

Most jurisdictions let you claim vehicle use in one of two ways, and your log supports both. The standard mileage (or approved allowance) method multiplies your business miles by a fixed per-mile rate - simple, and the log is all you need. The actual-cost method instead deducts a business-use percentage of your real running costs: fuel, insurance, servicing, and depreciation. That method needs the log to establish the business-use percentage and a folder of receipts on top.

For most freelancers and consultants, the per-mile rate is simpler and often comparable in value, which is why the mileage log is the workhorse record. Whichever method you pick, the log is doing the heavy lifting of proving how much of your driving was for the business.

A note on tax rules

Mileage rates, what counts as business travel, and record-retention periods all vary by country and change over time. Treat this guide as educational rather than as tax or legal advice, and confirm the current rules and rates with the IRS, HMRC, or your equivalent tax authority - or ask a qualified accountant - before you file. The structure of a good log is universal; the specific numbers are not.

Summary

A mileage log template is a deceptively simple document that does heavy lifting: it converts the miles you drive for work into evidence a tax authority will accept. The fields are few - date, route, purpose, start and end odometer, total miles, and a business-or-personal flag - but filling them in consistently and contemporaneously is what makes the difference between a claim that sails through and one that gets cut.

Keep the odometer chain unbroken, write specific purposes, log personal trips too, pick one method, and reconcile every month. Pair the log with your wider expense and billing records so the numbers flow into your reimbursements and tax return without a year-end panic. Do that, and your mileage log template becomes one of the easiest, highest-return habits in your business.

Frequently asked questions

What information must a mileage log include?

At a minimum, each entry needs the date, the destination and a specific business purpose, the starting and ending odometer readings, the total miles for the trip, and a flag showing whether it was business or personal. A header recording the driver, vehicle, and reporting period rounds it out. These fields together let a tax authority verify that the miles you claim were genuinely business travel.

Does the IRS require a mileage log?

Yes. To claim the standard mileage rate or substantiate vehicle expenses, the IRS expects records that show the date, mileage, destination, and business purpose of each trip, kept at or near the time of travel. Estimates or reconstructed logs are far weaker. Confirm the current rules on irs.gov, as guidance and the per-mile rate are updated periodically.

Can I claim mileage without a log?

It is risky. Without a contemporaneous record, you have little to substantiate the miles you claim, and a tax authority can reduce or deny the deduction during a review. Some allow estimates supported by other evidence in limited cases, but a proper log is always the safer, stronger position. Keeping one as you go is far easier than reconstructing it later.

How often should I update my mileage log?

Ideally on the day each trip happens, or at least weekly. The longer you wait, the more trips you forget and the less credible the record looks if questioned. A weekly reminder works well for most freelancers. Reconciling the totals monthly catches any gaps in the odometer chain while they are still easy to fix.

What is the difference between a mileage log and an expense report?

A mileage log records distance and the business purpose of vehicle journeys; an expense report records money spent on business costs like meals, supplies, or travel tickets. They serve different purposes and often work together - the mileage figure can become a line on an expense report. One measures miles, the other measures spending.

Can I use an app instead of a paper mileage log?

Yes. Many drivers use GPS-based apps that log trips automatically, which reduces manual entry and missed journeys. As long as the app captures the required fields - date, route, purpose, distance, and classification - and you can export the records, it satisfies the same requirements as a paper or spreadsheet log. Always keep a backup of the data.

How long should I keep my mileage records?

Retention periods vary by jurisdiction, but tax authorities typically expect you to keep records for several years after the relevant filing in case of a review. The IRS and HMRC both publish specific retention guidance. Store your logs securely, back them up digitally, and confirm the exact period that applies to your situation with your tax authority or accountant.

Are commutes counted as business mileage?

Generally no. Travel between your home and a regular place of work is usually treated as personal commuting in both the US and UK, and is not claimable. Travel to a temporary site, a client, or between work locations during the day typically does qualify. Because the rules have nuances, check the current guidance for your jurisdiction.

Can I switch between the mileage rate and actual costs?

There are rules about this, and they differ by country. In general you choose one method per vehicle and apply it consistently, and switching can be restricted depending on how you started. You cannot claim the per-mile rate and also deduct fuel and repairs for the same vehicle. Confirm the current switching rules with your tax authority or accountant.

Do I need separate logs for two business vehicles?

Yes. Keep a distinct log for each vehicle so the odometer readings never get mixed up and you can calculate the business-use percentage for each car independently. A single combined log makes reconciliation impossible and undermines the credibility of both records. Label each log clearly with the vehicle make, model, and registration.

Conclusion

A mileage log template is one of the highest-return administrative habits a freelancer or small business can adopt. For a few minutes a week, you turn ordinary business driving into a deduction or reimbursement that a tax authority will accept without argument. The fields are straightforward and the discipline is small, but the protection it buys during a review is significant.

Treat your mileage log template as a living input to your wider finances rather than a forgotten spreadsheet. Record trips as they happen, keep the odometer chain unbroken, write specific purposes, and reconcile monthly. Pair it with your expenses, invoices, and tax records so the numbers flow where they need to go. Do that consistently and you will never again find yourself reconstructing a year of journeys from memory the night before a filing deadline.

Related guides

• Expense Report Template: A Practical Guide
• Timesheet Template: A Practical Guide for Businesses
• Business Documentation Checklist: Every Document Your Business Needs
• Vehicle Expense Claims for Business Owners: A Practical Guide
• Travel Expense Claims Explained: A Practical Guide for Businesses
• Business Expense Tracker Template Explained: Fields, Example and How to Use It

Sources and further reading

• IRS Standard Mileage Rates
• IRS Topic No. 510, Business Use of Car
• HMRC Travel - Mileage and Fuel Rates/Allowances
• GOV.UK Simplified Expenses if You're Self-Employed
• SBA Recordkeeping Guidance