How I turn a messy mileage dump into a clean trip log sheet
Mileage reimbursement and tax logs die in the same place: a pile of odometer screenshots, calendar crumbs, and "I drove to the client Tuesday" texts with no usable total.
Here is the workflow I use when someone dumps a month of trips and wants a clean mileage log back in about a day.
What "good enough" looks like
- One sheet a bookkeeper or client can skim without guessing
- Date, purpose, start/end (or round-trip), miles, and who/where
- Business vs personal labeled — no mixed mystery rows
- A month total that matches the source crumbs you were given
- No fake GPS polish — only what the dump supports
Intake checklist
- The raw dump (photos, texts, calendar exports, odometer notes, Maps history exports)
- Whether this is for reimbursement, taxes, or a client invoice add-on
- The rate or rule set (IRS standard mileage, client policy, employer policy) — or "leave blank, just log miles"
- Home / office base address if round-trips should start there
- Anything that must stay out (personal trips, medical, other clients)
The pass order that saves time
- Inventory sources — list every file and the date range it covers.
- Build a trip skeleton — one row per distinct trip day or destination cluster.
- Normalize miles — prefer stated odometer deltas; estimate only when the dump clearly supports a route and label it estimated.
- Purpose in plain English — "client site visit — Acme kickoff", not "misc".
- Flag gaps — missing end odometer, personal side trips, same-day double counts.
- Totals + spot-check — month miles, trip count, and three rows you can defend from the sources.
Sheet columns that work
| Column | What goes here |
|---|---|
| Date | Trip date |
| Purpose | Business reason in one short line |
| From / To | Start and end locations |
| Miles | Distance for that trip |
| Round-trip? | Yes / No |
| Source | Photo, calendar, text, Maps export |
| Notes | Gaps, estimates, personal carve-outs |
Common traps
- Logging the same commute twice because calendar and Maps both show it
- Mixing personal errands into business rows without a flag
- Inventing exact miles when the dump only has "about 40 minutes"
- Forgetting the return leg on site visits
- Leaving purpose blank so the sheet fails a reimbursement review
Soft handoff
When the log is done, send:
- The mileage sheet (totals visible)
- A short list of trips that still need miles or purpose
- Pointers back to the source photos/notes you used
That is the whole job. No fancy GPS stack required.
I do this as a 24-hour DFY service for freelancers and small businesses ($12 for mileage/trip dump → mileage log sheet). Shop: https://brittanybonds.gumroad.com/l/mileagesheet — code ADMIN12 for \$2 off. Full catalog: https://brittanybonds.gumroad.com/ and https://brittany-bonds.github.io/
Top comments (0)