Free · 30-Day Edition

The mileage log
truckers actually use.

A free, IRS-ready Excel log for owner-operators and company drivers. Bilingual headers (EN/ES). Automatic miles, MPG, and cost-per-mile. Built by a real bookkeeper — not by someone who's never sat in a truck.

Excel + Google Sheets EN / ES headers 30-day record
Owner-operator semi-truck on the road at sunset
Why it matters

The IRS doesn't care
that you "kind of remember."

Most drivers track miles in their head, on a napkin, or in three different apps that don't talk to each other. When tax time hits, the deductions get rounded down — or worse, denied — because the records aren't there.

01

Memory isn't documentation

The IRS requires a contemporaneous record: date, miles, business purpose, origin, and destination. Reconstructing it in April from memory is a red flag in an audit.

02

Apps lock your data

Subscription apps charge $15–30 a month and hold your historical data hostage when you cancel. A spreadsheet you own forever doesn't.

03

Generic templates miss the point

Most free mileage logs are built for sales reps, not truckers. No fuel tracking, no MPG, no concept of loaded vs empty miles, no IFTA structure when you're ready for it.

What's inside

Everything you need.
Nothing you don't.

Six tabs. Forty trips per log. Numbers that calculate themselves. Designed for the way truckers actually work — between loads, late at night, in a cab.

01

Trip log with auto-totals

Enter odometer start and end. Total miles calculate themselves. Mark each trip Loaded, Empty, or Personal — the dropdowns are bilingual.

02

Fuel log with cost math

Gallons × price = total cost, automatically. Track every fill-up by state — useful now, essential when you upgrade for IFTA.

03

Monthly summary dashboard

Total miles, loaded percentage, average MPG, cost per mile. The numbers your accountant asks for, and the ones you actually need to run the business.

04

Bilingual headers (EN/ES)

Date / Fecha. Odometer Start / Odómetro Inicio. Same file, both languages. Technical terms (IFTA, BOL, DOT, MPG) stay in English — that's how the industry uses them.

05

Validated inputs

Drop-downs for status and state. Formulas that ignore invalid odometer entries. No #DIV/0! errors when cells are empty. Audited and tested.

06

Yours forever

It's a .xlsx file. No login, no cloud lock-in, no subscription. Save it, copy it, modify it, send it to your CPA. You own the data.

Built for the seat

For the driver who
actually does the miles.

Not for spreadsheet experts. Not for accountants. Built for the person who's been awake since 4 AM, has 600 miles left to Bakersfield, and needs a system that takes 30 seconds at the next stop — not a 20-minute data-entry session at the end of the week.

A look inside

This is what the
trip log looks like.

A taste of the actual file. The blue cells are formulas. The white ones are inputs. Auto-totals at the bottom of every column.

Trip Log · Registro de Viajes

Date / Fecha Origin / Origen Destination / Destino Odo Start Odo End Miles Status / Estado
10/01/2026 Cape Coral, FL Atlanta, GA 100,000 100,650 650 Loaded / Cargado
10/02/2026 Atlanta, GA Cape Coral, FL 100,650 101,100 450 Empty / Vacío
10/05/2026 Cape Coral, FL Miami, FL 101,100 101,270 170 Loaded / Cargado
TOTAL 1,270

↑ Miles in gold are calculated automatically. The full file has 40 entry rows plus monthly summary, fuel tracking, and setup tabs.

Free vs Full

What you get free.
What's in the full version.

The free version is a real working file — not a teaser. The full version is for drivers ready to track IFTA, multiple trucks, and run real profit-per-mile analysis.

Feature
Free · 30-day
Trip log with auto-totals
✓ 40 entries
✓ Unlimited
Fuel log with cost math
✓ 40 entries
✓ Unlimited
Monthly summary dashboard
✓ + Annual
Bilingual EN/ES headers
Multi-truck / multi-driver
State-by-state mileage breakdown
✓ All 48 + Canada
IFTA quarterly summary
✓ Auto-calculated
Maintenance log + PM alerts
Income & expense tracker
Profit-per-mile dashboard
PDF export for CPA / audit
See the full version →
Built by

Made by someone who
actually does the books.

No marketing team. No SaaS pitch. Just a real bookkeeper in Cape Coral, Florida, who got tired of clients showing up to tax season with shoeboxes.

DC

Dayana Capote

Bookkeeper · Civera Business Services · Cape Coral, FL

I've spent years cleaning up records for self-employed clients — including truckers who lost thousands in deductions because their mileage records didn't hold up. This template is what I wish every client had used from day one. It's not fancy. It just works, and it survives an audit.

Common questions

The honest FAQ.

Is this really free?
Yes. The 30-day version is free. Drop your email, get the file. No card, no trial, no automatic upgrade. The full version (12 months, IFTA, multi-truck, dashboard) is a separate one-time purchase if you decide you want it later.
Does it work in Excel and Google Sheets?
Yes. The file is .xlsx — opens in Microsoft Excel (Windows, Mac), Google Sheets, Apple Numbers, and LibreOffice. All formulas work in all of them.
I'm a company driver, not an owner-operator. Is this useful for me?
Yes. Even if your employer logs your business miles, your personal record matters for: deducting unreimbursed business miles where applicable, keeping a backup independent of your ELD, and tracking your own performance — personal MPG, fuel cost, time on the road.
Why bilingual headers?
US trucking is bilingual on the road. Headers like "Date / Fecha" and "Odometer Start / Odómetro Inicio" let any driver — or any family member helping with bookkeeping — use the same file. Technical terms (IFTA, BOL, DOT, MPG) stay in English because that's how the industry uses them.
Is this IRS-compliant for mileage deductions?
Yes. The IRS requires a contemporaneous record of date, miles, business purpose, and origin/destination for each trip. The log captures all four. Keep your fuel and toll receipts alongside it. (As always, this is a tracking tool, not tax advice — consult a CPA for your specific situation.)
What about IFTA?
The free version captures fuel by state and miles per trip — the raw data IFTA needs. The full version adds the automatic quarterly summary that calculates tax due/credit per jurisdiction. If you only need raw tracking right now, free is enough; when you're ready to file, upgrade.
Will I get spammed?
No. You'll get the file, a short follow-up with how to get the most out of it, and occasional notes when we publish something useful for truckers. Unsubscribe link in every email. Your email is never sold.

Get the file. Start today.

Thirty days of clean mileage tracking. Yours forever. Free.

Instant download · No card · Unsubscribe anytime