Mileage Log Spreadsheet for Self-Employed Drivers — IRS Schedule C Deduction & Pub 463 Trip Log

Logs each trip with the four things IRS Publication 463 asks a taxpayer to keep — date, miles, place, and business purpose — then shows what those miles are worth: a Schedule C mile cuts self-employment tax, charged at 15.3% (IRC §1401) on 92.35% of net earnings (IRC §1402(a)(12)), on top of your income-tax bracket, while a deduction disallowed for lack of records can carry the 20% accuracy-related penalty of IRC §6662.

Your numbers

Business miles driven this year (client visits, job sites, deliveries — excluding commuting)Personal miles driven this year (same vehicle, non-business)Commuting miles this year (home to your regular place of work — not deductible under IRS rules, entered so total mileage reconciles)IRS standard mileage rate for YOUR tax year, in dollars per mile — copy it from the IRS Notice covering that year (the value shown is a placeholder; replace it)Business parking fees and tolls paid this year (deductible in addition to the standard mileage rate)Your net Schedule C profit for the year, before the mileage deductionYour marginal federal income-tax bracket, in percent%Actual vehicle costs paid this year (fuel, insurance, repairs, tyres, depreciation) — for the method comparison on the last sheet

Your result

Total miles on the vehicle this year	-
Deductible business miles (commuting and personal removed)	-
Business use of the vehicle, percent	-
Standard mileage deduction	-
Deduction including business parking and tolls	-
Self-employment tax saved (15.3% on 92.35% of the reduction in net earnings)	-
Federal income tax saved at your bracket	-
Total tax saved by this mileage log	-

Everything updates as you type. Nothing is uploaded. This runs in your browser.

Get the full calculatorFull version: all tabs, your own file, works offline.