Mileage Log Template

Each trip is one row. The sheet subtracts the odometer readings to get Miles this trip, sums the business-flagged rows into total business miles, and — only if a rate is present — multiplies by your editable cents-per-mile rate:

miles this trip       = max(odometer finish − odometer start, 0)
total business miles  = Σ miles this trip   (business-flagged rows)
estimated deduction   = total business miles × rate
% business use        = business miles ÷ total miles

A backward odometer pair (finish < start) is guarded to 0 and flagged — totals never go negative. Leave the rate blank for a miles-only sheet: no deduction or $0 appears anywhere. The % business use line shows only when a personal trip is present (with all-business trips it is trivially 100% and suppressed).

The rate is an editable cell pre-filled with the latest published IRS standard business mileage rate ($0.70/mile for tax year 2025). The IRS rate changes annually — set the cell to the figure for your tax year and confirm it at irs.gov. This worksheet uses the IRS standard mileage method (a flat cents-per-mile rate); the "actual expenses" method is a different record. This is tax prep, not a filing, and it is not an IRS-certified record. Nothing is saved; there is no GPS, no automatic trip capture, and no stored trip database.