IRS Standard Mileage Log Excel - Free Template

1. Open the Mileage Log tab and enter each trip on its own row. Start with the date, driver, vehicle, and trip type so the log stays organized from the first drive.
2. Fill in the from and to cities and states, then write a business purpose that explains why the trip was business-related. A vague note like "meeting" is weak; write "pickup of pipe supplies for Job 184" or similar.
3. Enter the odometer start and end readings. The worksheet uses those readings to calculate trip miles, so you do not have to total every drive by hand.
4. Check whether the trip was a round trip and review the IRS rate per mile. If you are tracking reimbursement, this is the line that turns miles into dollars.
5. Use the Summary tab to review total miles and mileage value. For a contractor driving 1,200 business miles in a month, even a small rate change can move the reimbursement by hundreds of dollars.
6. Keep the Instructions tab with your tax file and update the log the same day you drive. Same-day entry is better than trying to rebuild 47 trips from memory at month-end.

The Mileage Log tab is for the people who actually drive for business: a sole proprietor filing Schedule C, a bookkeeper at an LLC, an office manager at a plumbing company, or a household member who uses one car for work and errands. If you drive to a customer site Monday morning, pick up materials Tuesday, and make a sales call Friday, this is the sheet that keeps those miles separate from personal driving.

Image 1 shows the trip-entry sheet with a single row per drive, which is exactly how you want to work during the week. A general contractor with 4 employees might log 18 site visits in 5 business days, while a field service tech can rack up 900 business miles in a month without realizing it until the log is missing.

When The Log Matters Most

You feel the need for this spreadsheet at the end of each month, during payroll review, and again at tax time when you build the return. If you are reimbursing yourself or an employee, the log also gives you a clean support file for the payment, so you are not guessing later whether a 62-mile trip was one-way or round-trip.

What Makes The Structure Useful

The workbook is built around the exact fields you need to document: date, driver, vehicle, route, business purpose, odometer start, odometer end, trip miles, and IRS rate per mile. That is enough detail for a practical log, and it keeps you from wasting time on columns that do not change the deduction or reimbursement total.

The IRS expects mileage records that are written down as you drive, not recreated months later from memory. Keep the log with your tax file for at least 3 years after the return is filed, and longer if a claim stays open or the records support a depreciation issue on the vehicle.

The worksheet’s trip fields line up with the standard mileage method used by many self-employed taxpayers on Form 1040 with Schedule C. If you use the standard mileage rate, you multiply business miles by the rate; for example, 1,500 miles at a hypothetical $0.67 per mile equals $1,005.00 of mileage value.

Standard Mileage Versus Actual Expenses

For most service businesses with one primary vehicle, the standard mileage method is simpler than tracking every gallon of fuel, repair, and insurance payment. Once you start carrying higher repair costs, heavy depreciation, or multiple vehicles with different usage patterns, the actual-expense method can become the better ledger choice because it shows the full profit & loss effect.

Why The Odometer Fields Matter

The start and end odometer readings are not decoration. They give you the backbone of the record, and they let you spot impossible entries, like a 14-mile trip that somehow turns into 41 miles when you review the week.

The biggest mistake is writing down totals at the end of the month instead of logging each trip on the day you drove. That usually means missing small runs that add up fast: 3 supply trips at 18 miles each, 2 site visits at 27 miles each, and a client meeting 41 miles away already equals 149 miles before you count the return legs.

Another common problem is weak business purpose notes. If your log only says "meeting" or "delivery," you leave yourself open to a denied deduction, and a few hundred missed miles can cost real money; at 1,200 business miles, the standard mileage value can easily be over $800.00 depending on the rate used for the year.

Round Trips And Odometer Gaps

People also forget to mark round trips, then double count the return drive later. That does not just inflate the deduction; it makes the record look careless, which is exactly the kind of file you do not want during an audit review or lender package cleanup.

What Bad Logs Cost In Practice

A contractor who loses 4 months of mileage records may give up $2,000.00 or more in deductions on a busy year. That is the price of bad habits: lost tax savings, extra cleanup time, and a file you cannot trust when you are trying to close the books quickly.

Use the log on a fixed day, and attach it to a routine you already do, such as Friday payroll review or the estimated-tax check-in before 1040-ES deadlines. If you wait until quarter-end, you will spend the whole afternoon chasing addresses and odometer numbers instead of entering trips.

Simple Ways To Keep It Current

• Enter trips the same day you drive, before receipts and addresses get buried in your inbox.
• Copy the prior month’s tab habits into the next month so the format stays consistent.
• Use a quick weekly review to catch missing odometer readings before they become permanent gaps.
• Once the workbook gets over 200 to 300 rows for the year, review whether QuickBooks or fleet software would save more time than manual entry.

Image 2 shows the summary sheet, which is the place to check totals instead of scrolling through every trip. When your business has 2 drivers and 1 vehicle, a spreadsheet is fine; when you are managing 8 vehicles or a delivery route with hundreds of stops, you have outgrown the log and need a more complete system.