Home/Templates/Business Mileage Log
    Expenses
    XLSX

    Business Mileage Log

    An IRS-compliant mileage log with automatic deduction calculation at the 2025 standard rate of $0.70/mile. Log each trip contemporaneously, reconstructed logs are the #1 reason mileage deductions get disallowed on audit.

    Why this matters

    The IRS requires 'contemporaneous' mileage records, meaning you log each trip at the time it happens, not at year-end from memory. Reconstructed logs are consistently disallowed on audit.

    For 2025 the standard mileage rate is $0.70 per business mile. That covers gas, maintenance, depreciation, and insurance combined.

    The alternative is the 'actual expense' method, which requires tracking every gas, repair, and insurance receipt plus depreciation. For most drivers the standard rate is simpler and often larger.

    How to use it

    1. Fill in driver name, vehicle description, and year at the top.
    2. Each trip: enter date, start location, end location, and business purpose.
    3. Record start and end odometer readings, the sheet calculates miles automatically.
    4. The deduction column applies the current IRS standard rate ($0.70/mi) automatically.
    5. Log every trip on the day it happens, apps like MileIQ can auto-log if manual entry is impractical.
    6. At year-end, total miles and deduction feed directly onto Schedule C, Line 9 (or Form 2106 for employees where still applicable).

    Frequently asked questions

    Want us to set this up for you?

    Our team will implement this template into your bookkeeping workflow, connect it to your accounting software, and train your team.

    Related templates

    Expense Report Template
    Employee Expense Form
    Single-event expense form with categories, approval, and reimbursement.
    More resources: , Calculators, Deduction library, Financial reporting, Business growth.

    We use cookies to enhance your experience. View our Privacy Policy