Mileage Log Spreadsheet, Excel and Google Sheets, Business Mileage Tracker Tax Deduction

Most mileage logs undercount, and they all undercount the same way: you write
down the drive out and forget the drive back.

So this one asks for the one-way distance and a tick box. Drove there and
back? Tick it. The sheet doubles the miles for you, every time, without you
having to remember.

Your business miles and your deduction add themselves up as you type — on the
front page, and broken out month by month. No reconstructing a year of driving
from calendar entries the week before a deadline.

WHAT YOU TYPE
- Your rate per mile, once.
- One row per drive: date, why, from, to, one-way miles, round trip yes or no,
and a category.

That is the whole system. Everything else fills itself in.

WHAT IS INSIDE
- Trips — 500 rows, with dropdowns for round trip and category
(Business, Personal, Medical, Charity). Only Business counts toward the
deduction, so you can keep one honest log of everything.
- Monthly Summary — business miles, deduction, all miles and trip count for
every month, plus a year total.
- Read Me First — your rate, your tax year, and the two numbers you actually
want: business miles and what they are worth.

WHY THERE IS NO IRS RATE PRINTED IN IT
Because it would be wrong by January. The standard rate changes most years and
has been revised mid-year before — a number baked into a file sold today goes
stale in every copy already downloaded. So the rate is a cell you set, with a
pointer to irs.gov. A wrong rate in a tax tool is worse than no rate at all.

WORKS IN BOTH
Excel and Google Sheets. Drag it into Google Drive and every formula, dropdown
and colour carries over. A PDF quickstart is included.

WHY THE GREY CELLS ARE LOCKED
Every calculated cell is protected, because the fastest way to break a log is to
overwrite a formula and not notice for eleven months. Type in the yellow cells.
No password is set — you can unlock any sheet if you want to.

This is a record-keeping tool, not tax advice. Which trips qualify, and whether
the standard rate or actual expenses suits you better, is a question for your
accountant.

INSTANT DOWNLOAD
Delivered the moment you buy. Nothing ships.

Questions get a real answer from a person, at hello [!at] gablepath.com.

AI DISCLOSURE
The spreadsheet's structure, formulas and wording were designed and built with
the help of AI tools, then tested and checked by a person before listing. The
cover and preview images are generated graphics, not photographs.