One-time setup
On the other device: ☰ → Set up my phone → Copy setup link, send it here, paste it above, and tap Import. Otherwise, fill in the fields below.
Must be an https://script.google.com/…/exec URL from your own Sheet.
—
Auto-generated and stored only on this device. It authenticates this app to your Sheet.
Your name, vehicle, URL, secret, and any unsynced trips are stored only in this browser (localStorage). Nothing is sent to any server except your own Google Sheet.
Odometer
Classification & purpose
Sync status
Each saved trip posts directly to your personal Google Sheet. Offline entries are queued on this device and retried automatically.
Not tax advice — keep your own records and consult your tax advisor.
Menu
Mileage Tracker · local-first PWA
Vehicles & businesses
Add more than one to get a vehicle picker when logging. Each trip is tagged with its vehicle, so one Sheet covers all your cars.
Add more than one to get a business picker when logging — handy for a side business or consulting work.
Annual odometer
Record your odometer at the start of the year (≈ Jan 1) and end of the year (≈ Dec 31) — just twice a year. End minus start is your total miles for the year. The IRS asks for your total miles even under the standard mileage rate (Schedule C, Part IV, lines 44a–c), and total miles is what sets your business-use % if you use the actual-expense method. Your per-trip odometers already cover individual trips. Saved to a separate Odometer tab.
An actual odometer reading is best; a reasonable estimate from service/repair records is acceptable if needed.
Not tax advice. This tool helps you keep contemporaneous records; it doesn’t determine what’s deductible or which method to use. Confirm the standard-mileage vs. actual-expense choice and your recordkeeping with your own tax advisor.
IRS guidance (2026)
The 2026 business standard mileage rate is 72.5¢ per mile. Useful IRS references (open in a new tab):
2026 standard mileage rate — news release Standard mileage rates (all years) Topic 510 — Business use of car Pub. 463 — Travel, Gift & Car Expenses Schedule C instructions (Part IV — vehicle)Not tax advice. Links are provided for convenience; confirm anything tax-related with your own advisor.
Connection settings
Advanced — you set this up once. You normally don’t need to change it again.
—Set up your Google Sheet
Do this once, on a computer (the Apps Script editor needs a desktop browser).
- Go to sheets.new and name the sheet (e.g. “Mileage Log”).
- Extensions ▸ Apps Script. Rename the project to Mileage Tracker.
- Delete the sample code, tap Copy script below, paste it in, and Save.
- Deploy ▸ New deployment → gear ⚙ → Web app. Set Description: “Mileage Tracker”, Execute as: Me, Who has access: Anyone → Deploy → approve (normal consent, no warning).
- Copy the Web app URL (the long one ending in /exec — not the “Deployment ID”) and paste it into the Webhook URL box on the Setup screen.
No editing needed — your shared key is already inserted.