Business Mileage Log: Commute vs Business Split Worksheet
A freelancer who drives the same car to a coworking desk, a client site, and the grocery store cannot treat every mile alike. Commute miles, business miles, and personal miles often sit on one odometer. A mileage log does a narrow job: it records each trip with enough detail to reconstruct later, tags the category you assigned at the time, and proves that categorized miles for a period still add up to the odometer change. The log is not a completed Schedule C line and not a finding that any mile is deductible.
This guide is US federal recordkeeping education as of the source-check date, 2026-10-26. It is a bookkeeping illustration, not tax advice, not a determination of deductible vehicle expense, and not advice about a state return. Every trip and every mile below is synthetic. IRS Topic no. 510, Business use of car, states that if you use a car for both business and personal purposes, you may deduct only the cost of its business use, and that the law requires you to substantiate expenses by adequate records or sufficient evidence. Publication 463, Travel, Gift, and Car Expenses, is the IRS publication that explains deductible travel and car expenses and the records needed to prove them. Read the disclaimer before treating any page here as a filing instruction. Neighboring trails include the one-card personal and business split and the bank reconciliation trail.
Why commute and business need different tags
Topic 510 draws a bright line for mixed-use cars: only the business portion of cost is in play for a deduction discussion, whether you later use the standard mileage rate method or the actual expense method. A log that collapses every outbound drive into one "work" bucket makes that split impossible to rebuild. Commute between home and a regular workplace is the classic example of miles that feel work-related in the moment and still need a non-business tag in many federal analyses. This worksheet does not litigate your facts. It forces a category on every trip so a reviewer can see what you claimed as business when the period closed.
Use at least three categories on the sheet: business, commute, and personal. Add a fourth, such as medical or charity, only if you already keep those miles for a separate purpose and you will not mix them into the business total. The business total is the only column this sheet feeds into a later standard-mileage arithmetic illustration. Commute and personal stay visible so the odometer residual still closes.
Fields: one row per trip, one period residual
A usable log needs a stable trip ID, date, start odometer, end odometer, miles (end minus start), category, origin, destination, business purpose (required when category is business), client or project ID when applicable, and an evidence link (calendar invite, invoice, parking receipt, or map export). Miles must equal end minus start on every row. Do not type miles from memory when odometer values exist.
Write the category rule once in the header. The rule in the example is: tag business only for trips whose primary purpose that day is client delivery, client meeting, supplies purchased solely for a named client job, or travel between temporary work locations already noted in the purpose field; tag commute for home to the regular coworking desk and the return; tag personal for everything else. Your rule may differ. The sheet's job is to apply one written rule consistently, not to invent a new rule per trip after the fact.
For each vehicle and each period (week or month), record the opening odometer on the first trip and the closing odometer on the last trip. The residual check is: sum of all trip miles in the period equals closing odometer minus opening odometer. If the residual needs a plug, stop. Find a missing trip or a mistyped odometer instead of forcing the business subtotal to a round number.
Worked example: one synthetic freelancer week
The figures in this section are synthetic. They are not a real taxpayer, not a recommended commute, and not a finding about any filing position.
Assume sole proprietor Blair drives one car during the week of 2026-10-20 through 2026-10-24. Opening odometer Monday morning is 42,100. Closing odometer Friday evening is 42,268. Trips:
TRIP-26-101 on 2026-10-20, 42,100 to 42,112, 12 miles, commute, home to coworking desk, purpose "regular workplace commute." TRIP-26-102 same day, 42,112 to 42,118, 6 miles, business, coworking to Client North office, purpose "on-site scope review INV-N-88," evidence EVID-CAL-N88. TRIP-26-103, 42,118 to 42,124, 6 miles, business, Client North back toward coworking then parking, purpose "return from INV-N-88." TRIP-26-104, 42,124 to 42,136, 12 miles, commute, coworking to home.
TRIP-26-105 on 2026-10-21, 42,136 to 42,148, 12 miles, commute, home to coworking. TRIP-26-106, 42,148 to 42,163, 15 miles, business, coworking to office-supply store then Client East, purpose "job-specific materials for INV-E-12," evidence EVID-RCPT-E12. TRIP-26-107, 42,163 to 42,178, 15 miles, business, return path toward coworking. TRIP-26-108, 42,178 to 42,190, 12 miles, commute, coworking to home.
TRIP-26-109 on 2026-10-22, 42,190 to 42,205, 15 miles, personal, home to grocery and back, purpose "personal errands." TRIP-26-110 on 2026-10-23, 42,205 to 42,217, 12 miles, commute; TRIP-26-111, 42,217 to 42,229, 12 miles, commute home. TRIP-26-112 on 2026-10-24, 42,229 to 42,241, 12 miles, commute; TRIP-26-113, 42,241 to 42,256, 15 miles, business, coworking to temporary project site South, purpose "install support for PROJ-S-03"; TRIP-26-114, 42,256 to 42,268, 12 miles, mix of return toward home with a personal stop already tagged by splitting: Blair records 42,256 to 42,262 (6 miles) as business return toward the usual route and 42,262 to 42,268 (6 miles) as personal after a non-business stop, with evidence note EVID-NOTE-SPLIT-1024. For the table below, TRIP-26-114a is 6 business miles and TRIP-26-114b is 6 personal miles.
The business column is 63 miles for the week. The commute column is 84. Personal is 21. Nothing is deleted because it was inconvenient. If Blair later multiplies business miles by a published standard mileage rate for an arithmetic illustration, that product is still not a prepared return. The IRS standard mileage rates page lists self-employed and business rates by period (for 2026, 72.5 cents per mile for January 1 through June 30, and 76 cents per mile for July 1 through December 31, as posted on that page when retrieved). An illustration at the second-half 2026 business rate would be 63 × 0.76 = 47.88 dollars. That figure is reproducible arithmetic on the tagged miles; it is not advice to claim 47.88 dollars.
Common log failures
Reconstructing a month from memory. Topic 510 points to adequate records. A reconstructed round number with no trip IDs fails the residual check as soon as odometer photos disagree. Enter trips the day they happen, or export them from a tracker the same day.
Tagging the home-to-desk drive as business because email was checked in the car. Follow the written header rule. If the rule says that drive is commute, keep it commute. Changing the rule mid-year without a dated note makes both halves of the year hard to defend as one method.
Netting personal errands inside a business loop without a split. When a business return includes a personal stop, split the odometer at the stop, as in TRIP-26-114a and TRIP-26-114b. One row with a blended purpose hides the personal miles inside the business total.
Using the standard mileage rate on commute miles. The rates page publishes business, charity, medical, and moving rates for defined purposes. This sheet keeps charity and medical off the business total unless you intentionally maintain separate columns tied to those purposes. Do not multiply the commute column by the business rate in the illustration cell.
Skipping parking and tolls. Topic 510 notes that parking fees and tolls attributable to business use are separately deductible whether you use the standard mileage rate or actual expenses. Keep them on a neighboring expense log with trip IDs; do not bury them as invented extra miles.
A one-page logging procedure
- Name the vehicle, the period, and the opening odometer.
- Write the category rule in the header before the first trip.
- Add a row for every trip with start and end odometer, category, destination, and purpose.
- Split mixed trips at the odometer reading where the purpose changes.
- Sum business, commute, and personal miles separately.
- Confirm the three sums equal closing minus opening odometer.
- Store evidence links with the log. Topic no. 305 explains that well-organized records help if a return is examined and describes general periods of limitations; this sheet does not set your retention period.
- Only then discuss with a tax professional how business miles and any parking or tolls flow onto a return.
Keep the log with the same year's bank reconciliation and card split worksheets when those miles support client travel already invoiced. The log is part of the record pack. It is not the return.
What this sheet does not decide
The worksheet does not decide whether a workplace is regular or temporary, whether a home office changes a commute fact pattern, whether you must use standard mileage or actual expenses, whether a vehicle is listed property, how depreciation interacts with a rate method, or how any amount flows to Schedule C or Form 2106. It does not apply state conformity to federal mileage rules. It sets no retention period of its own. Take the completed log, residual check, and evidence pack to a CPA or enrolled agent before filing. None of those pages is tax advice.
Sources and method
- IRS Topic no. 510, Business use of car — retrieved 2026-10-26
- IRS: About Publication 463, Travel, Gift, and Car Expenses — retrieved 2026-10-26
- IRS: Standard mileage rates — retrieved 2026-10-26
- IRS Topic no. 305, Recordkeeping — retrieved 2026-10-26
AI-assisted writing with automated source, calculation and editorial checks. No hands-on testing or professional certification is claimed. Check the stated assumptions before applying this guide.