Mileage Log Spreadsheet, Vehicle Trip Tracker for Business & Personal Use, Google Sheets, Excel, Printable PDF

Keep a clean, organized mileage record. Log each trip with odometer readings or miles, and get monthly totals by purpose, an estimated value at your rates, and business-use percentage.

WHAT'S INCLUDED
- Vehicle Mileage Log spreadsheet (.xlsx), blank
- Example file with sample trips
- Printable PDF (US Letter + A4): mileage log (2 pages), annual summary

FEATURES
- Room for 1,000 trips
- Odometer start/end or manual miles
- Purposes: business, medical, charitable, moving, personal, commute
- You enter the rate per mile, so it never goes out of date
- Monthly totals by purpose and estimated value
- Business-use percentage from your year-start/end odometer

HOW TO USE
1. Download the files from your Etsy Purchases page (instant download, nothing is shipped).
2. Excel: open the .xlsx file. Google Sheets: upload the .xlsx to Google Drive, open it, then choose File > Save as Google Sheets.
3. Start on the 'Start Here' tab and fill in the pale-yellow cells. Everything else calculates for you.
4. Print the PDF pages at home or at a print shop (US Letter and A4 included).

GOOD TO KNOW
- Digital download only. No physical item will be shipped.
- Works in Microsoft Excel 2010 or newer (Windows and Mac) and Google Sheets (free). Apple Numbers and LibreOffice not fully tested.
- Formula cells are protected (no password) to prevent accidental edits.
- Colors may look slightly different on screen vs. print.
- For personal use only. Please don't resell or share the files. (c) Porchlight Ledger
- Record-keeping tool only, not tax or legal advice. Check current official guidance or ask a tax professional.

ALSO IN THE SHOP
- Household Tax Prep Organizer (gather tax documents and receipts in one place): https://www.etsy.com/au/listing/4587781246/tax-prep-organizer-2026-tax-year
- Home Maintenance Schedule (seasonal home upkeep and repair log): https://www.etsy.com/au/listing/4587775584/home-maintenance-schedule-spreadsheet

AI disclosure: I used AI tools to help build this template (formula drafting, layout, written instructions and the product preview images). Every formula was reviewed and tested in LibreOffice with sample data, and the files were checked before listing.