Free Mileage Log Templates

Every mile you drive for business, charity, or medical reasons has a dollar value attached to it at tax time. Lose track of those miles, and you lose the deduction or reimbursement that comes with them. A mileage log is the record the IRS expects you to keep, and the more accurate it is, the stronger your position during an audit or expense review. We have gathered the most useful mileage log templates in Excel and Google Sheets, covering daily trip tracking, monthly reporting, annual overviews with toll logging, fuel-efficiency analysis, and reimbursement-ready formats with built-in formulas.

Gas Mileage Log Template

This template is for anyone who wants to understand not just how far they are driving but how much each mile is costing them in fuel. It is particularly useful for fleet managers comparing fuel efficiency across vehicles, delivery drivers monitoring rising gas expenses, or individuals who want to identify when their vehicle’s fuel economy starts declining.

You log each trip with the date, miles driven, gallons purchased, and the total fill-up cost. The template then calculates three values per trip: cost per gallon, miles per gallon, and cost per mile. These per-trip calculations use conditional formulas that stay blank until you enter the required data, so empty rows do not produce errors.

The most useful section is the log dashboard at the top of the sheet. It automatically computes six running averages across all your entries: average miles per trip, average gallons per trip, average cost per trip, average cost per gallon, average miles per gallon, and average cost per mile. As you add more entries over weeks and months, these averages become a fuel-efficiency report. If your average miles per gallon drops noticeably over time, that could point to a maintenance issue worth investigating, like underinflated tires, a dirty air filter, or a change in driving habits. The template comes in two sheets — one with sample entries and a blank version ready for your own data.

Business Vehicle Mileage Log Template

If you drive a company car or use your personal vehicle for work-related travel and need to submit mileage reports for reimbursement, this template is built for that exact workflow. You log each trip by entering the date, the purpose of travel, and your odometer reading before and after the trip. The template calculates the distance for every trip automatically, so there is no manual subtraction involved.

Where this template becomes especially useful is in the reimbursement calculation at the top. You enter your employer’s per-mile rate (or the current IRS standard rate) once, and the template multiplies that rate by your cumulative mileage to show your total reimbursement amount. That number updates in real time as you add rows, which means you always know where you stand before submitting the report.

At the bottom, a signature and date section is included for organizations that require a signed mileage report before processing payment. If your company’s expense approval process involves a printed or PDF copy with a signature, this template is ready for that step. It is a good fit for employees in sales, field service, consulting, or any role that involves regular travel between job sites or client locations.

12-Month Mileage Log Template

Annual mileage tracking can get messy fast, especially when you are logging trips across 12 months and trying to pull everything together for tax filing or a year-end expense report. This template handles that by spreading the year across 12 separate monthly sheets (January through December) and feeding all the data into an annual overview sheet automatically through cross-sheet formulas.

Each monthly sheet has two tracking areas side by side. On the left, you record your travel: date, purpose, departure point, destination, and odometer start and end readings. On the right, a separate section is dedicated to toll tracking, where you enter the turnpike name, entry and exit points, and the toll amount. The summary panel on each monthly sheet computes three values: total miles multiplied by the reimbursement rate (your mileage expense for the month), total tolls paid, and the combined total of both.

The annual overview pulls all four columns — total miles, mileage expense, total tolls, and total expense — from every monthly sheet, so you never have to copy numbers between tabs. Yearly totals at the top sum everything across all 12 months. You enter the reimbursement rate and the calendar year on the overview sheet once, and each monthly tab picks up that information and generates the correct month name using a formula.

This template is the strongest choice for frequent drivers who pay tolls regularly, such as sales representatives covering multi-state territories or consultants traveling between metro areas with turnpikes. Instead of reconstructing a full year of records during tax season, you log trips throughout the year and have a complete, organized annual record ready whenever you need it.

Monthly Mileage Log Template

For employees who submit mileage reports on a monthly cycle, this template is built around that exact reporting rhythm. You fill it in throughout the month and have a complete log with trip distances and reimbursement totals by the last day, ready for supervisor review.

You start by entering your employee name, ID, department, supervisor name, reporting month, vehicle ID, and reimbursement rate in the header section. Each row in the log records a single trip with the date, purpose, starting point, destination, odometer start and end readings, auto-calculated total miles, and a comments column. The comments area is useful for noting client names, project codes, or anything else your accounting department might request alongside the mileage data.

Two summary fields at the top of the sheet show total miles and total reimbursement, both updating as you add entries. The total reimbursement is calculated by multiplying cumulative miles by the rate you entered, so there is no formula to build or adjust.

This template is a strong choice for roles with predictable monthly travel patterns — field technicians with regular service routes, account managers visiting clients on a rotation, or healthcare workers traveling between facilities. It keeps your monthly reporting obligation contained to a single, complete sheet rather than scattered notes or receipts.

Daily Mileage Log Template

When you make multiple trips in a single day, a monthly or generic log does not capture enough detail to satisfy IRS documentation requirements or a thorough employer audit. This template logs every trip with the time of departure, the origin and destination, and a business-versus-personal classification that directly affects how your reimbursement is calculated.

The business/personal distinction is where this template adds the most value. Each row includes a column where you mark the trip as “Business” or “Personal.” The reimbursement amount column uses a conditional formula that checks this designation: if the trip is business, it multiplies the mileage by your per-mile rate and rounds to two decimal places. If the trip is personal, the reimbursement shows as zero. This means you can log all your driving in one place, and the template sorts out what qualifies for reimbursement or deduction on its own.

At the bottom of the sheet, two separate totals appear. One uses a SUMIF formula to add up only business miles, and the other sums all miles including personal trips. Having both numbers visible is important because the IRS expects you to document total vehicle use, not just the business portion. If you claim 15,000 business miles but cannot show what your total mileage was, that gap in documentation weakens your records.

The header includes fields for employee name, ID, department, vehicle plate number, reporting period, reimbursement rate, prepared date, and an “Approved By” line for supervisor sign-off. This template comes in two sheets — a sample version showing how entries should look and a blank version for your own use. It is the best fit for rideshare drivers, delivery drivers, real estate agents, and anyone whose daily schedule involves multiple stops across different locations.

Generic Mileage Log Template

Not every mileage tracking situation fits neatly into a daily, monthly, or annual format. This template is the most adaptable option in the collection, and it works for freelancers, independent contractors, small business owners, or anyone who tracks mileage on their own schedule — by week, by project, or by client engagement.

Like the daily template, it includes a business/personal column and conditional formulas that calculate reimbursement only for trips marked as business. You enter each trip’s date, purpose, from and to locations, and odometer readings. The mileage and reimbursement amount calculate automatically once the data is entered. Rows marked as personal return a blank in the reimbursement column, so your totals always reflect only the deductible or reimbursable portion.

The bottom of the sheet has two totals: a SUMIF-calculated business-only mileage sum and a total reimbursement amount. These formulas mean you can use this template for a one-week project or stretch it across several months, and the totals will always be accurate.

Where this template is most useful is for people whose driving does not follow a fixed pattern. A freelance photographer who drives to three shoots one week and none the next, a consultant who travels heavily during a specific engagement and then works from home, or a small business owner who makes irregular supply runs and client visits — all of these scenarios fit comfortably into this layout. The header covers employee name, ID, department, vehicle info, reimbursement rate, and reporting period, so it is also ready for submission to a client or employer if needed.

IRS Standard Mileage Rate for 2026

The IRS announced that the standard mileage rate for business use of a vehicle in 2026 is 72.5 cents per mile, an increase of 2.5 cents over the 2025 rate. This rate represents what the IRS considers a reasonable per-mile cost to operate a vehicle for business. It factors in depreciation, insurance, repairs, fuel, and maintenance. These rates apply equally to electric, hybrid, gasoline, and diesel vehicles.

The rate for medical and moving purposes (for qualifying military members and certain intelligence community personnel) dropped to 20.5 cents per mile, and the charitable rate remains at 14 cents per mile.

When using any of the templates above, you should update the reimbursement rate field to match the current IRS rate (or your employer’s rate, if different). Each template in this collection stores the rate in a single cell at the top of the sheet, and all reimbursement calculations reference that cell. Changing it once updates every row.

Standard Mileage Rate vs. Actual Expense Method

You have two options when deducting vehicle costs for business use on your taxes: the standard mileage rate and the actual expense method. Understanding the difference can help you pick the one that results in a larger deduction.

Standard mileage rate: You multiply the total business miles driven during the year by the IRS rate (72.5 cents per mile in 2026). This method requires less record-keeping because you only need to track your mileage, the date, and the business purpose of each trip. The templates in this post are designed for this method.

Actual expense method: You track every vehicle-related cost throughout the year, including gas, oil, tires, repairs, insurance, registration fees, lease payments, and depreciation. Then you calculate what percentage of your total driving was for business and apply that percentage to your total expenses. This method can result in a higher deduction if your vehicle costs are above average, but it requires significantly more documentation.

For leased vehicles, the IRS requires you to use the standard mileage rate for the entire lease period, including renewals, if you choose that method in the first year.

For most people who drive a moderate number of business miles, the standard mileage rate is simpler and still produces a meaningful deduction. If you drive a high-mileage vehicle with significant repair and maintenance costs, the actual expense method might be worth the extra record-keeping.

What To Include in a Mileage Log for Tax Purposes

The IRS does not accept vague summaries or round-number estimates as mileage documentation. If your records ever come under review, each entry needs to be specific enough to verify independently. Here is what every trip entry should contain:

• Date of the trip. Record the exact calendar date for every trip, not just the week or month. The IRS expects a contemporaneous log, meaning the entries should be recorded at or near the time of travel. A log that only says “March” with a lump mileage total will not hold up under scrutiny.
• Destination or route. Write the actual location you drove to, not just a general label like “meeting” or “office.” For example, “ABC Corp headquarters, 450 Market St, Newark, NJ” is far stronger documentation than “client visit.” If the trip involved multiple stops, note each one.
• Business purpose of the trip. Each entry should state why the trip was necessary for business. Acceptable descriptions include client consultation, product delivery, job site inspection, supply pickup, or training session. The IRS wants to see that the trip had a legitimate business reason, and a one- or two-word description per entry is enough as long as it is specific.
• Odometer readings or total distance. Record the odometer at the start and end of each trip, or at minimum the total miles driven. Odometer-based records are the most defensible because they can be cross-checked against your vehicle’s annual mileage. The templates in this collection calculate trip distance automatically from start and end readings, which removes the guesswork.
• Business or personal designation. If you use your vehicle for both business and personal travel, every trip should be marked as one or the other. The IRS only accepts a deduction for the business portion, and a log that does not distinguish between the two creates a documentation gap. Several templates in this collection include a business/personal column with conditional formulas that total only the deductible miles.

Who Should Keep a Mileage Log

• Self-employed individuals and freelancers can deduct business mileage directly on Schedule C of their tax return. This includes rideshare and delivery drivers, real estate agents, consultants, photographers, and anyone who drives to meet clients or deliver goods.
• Employees who receive mileage reimbursement from their employer need a mileage log to submit with their expense reports. Even if your company reimburses at the IRS rate, you typically need to provide documented proof of the miles driven.
• Small business owners who use a personal vehicle for business errands, supply runs, or customer visits should track those trips. The mileage deduction can reduce taxable income, and accurate logs protect you during audits.
• Charitable volunteers who drive for qualified charitable organizations can deduct 14 cents per mile. A mileage log documents these trips if you choose to claim the deduction.
• Medical travelers who drive to and from medical appointments may deduct mileage at 20.5 cents per mile in 2026, though this deduction is only available if you itemize and your medical expenses exceed 7.5% of your adjusted gross income.

How Mileage Reimbursement Works

When an employer reimburses employees for business mileage, the process usually follows this pattern: the employee logs their trips in a mileage report, submits it to a supervisor or accounting department, and receives reimbursement based on a per-mile rate.

If the reimbursement is at or below the IRS standard mileage rate and the employee provides adequate records, the reimbursement is not considered taxable income. This is referred to as an “accountable plan.” Under an accountable plan, the employee must substantiate the business purpose, date, and mileage of each trip, and must return any excess reimbursement.

If an employer reimburses above the IRS rate, the amount exceeding the standard rate is treated as taxable income and must be reported on the employee’s W-2. Similarly, if the employer uses a “non-accountable plan” (flat car allowances with no documentation required), the full amount is taxable.

The business vehicle and monthly templates in this collection include the reimbursement rate and auto-calculated reimbursement totals, which means you can fill in the log and hand it directly to your employer as a substantiated expense report.

Tips and Mistakes To Avoid When Tracking Mileage

The templates above handle the calculations and formatting, but the accuracy of the numbers depends entirely on how consistently you enter your trip data. These practices will help you build records that hold up during reimbursement reviews and IRS audits.

• Log every trip immediately. The most common mistake is waiting until the end of the week or month to fill in mileage records from memory. Odometer readings especially are hard to recall accurately after even a few days. Keep your log in your vehicle — in the glove box if you use a printed version, or pinned to your home screen if you use the Excel version on your phone.
• Use actual odometer readings, not estimates. Writing “about 30 miles” for every trip signals that the log was filled in from guesswork rather than real data. The templates in this collection compute mileage from odometer start and end values, which is the most accurate and defensible method.
• Do not count your daily commute as business mileage. The IRS does not consider your regular drive between home and your primary workplace to be a deductible business trip. However, if you drive from your office to a client site and then home, the office-to-client and client-to-home legs may qualify as business mileage.
• Separate business and personal trips on every entry. If you drive to a client meeting and then stop for groceries on the way home, the grocery stop portion is personal. Templates with a business/personal column (like the daily and generic templates) handle this distinction at the trip level, and the SUMIF formulas total only the deductible miles automatically.
• Do not skip short trips. A five-mile drive to the post office to mail business packages still counts. Over a year, those skipped short trips can add up to a significant amount of missed deductions.
• Update the reimbursement rate every year. The IRS rate changes annually. If you carry over a template from a previous year, check the rate cell and update it before logging new trips. One outdated number will throw off every reimbursement calculation in the sheet.
• Record your odometer on January 1 and December 31. This produces a total annual mileage figure the IRS can compare against your claimed business miles. If you claim 25,000 business miles but your total annual mileage is only 20,000, that gap will raise questions.
• Back up your records regularly. Save a copy of your completed mileage log to cloud storage or email it to yourself at the end of each month. The IRS can audit returns up to three years back (or six years in certain situations), so you may need to produce records from well beyond the current year.