Mileage Log

What it does

• Setup tab: year, business name (optional), distance unit (km or mi), your rate per km or mile, a start address (optional), up to 5 vehicles and up to 8 trip purposes (Client visit, Supplies, Delivery, Site visit, Bank/Post office and Other to start), all yours to rename. The lists become the drop-downs
• Trip Log tab: one row per trip with date, vehicle, from, to, purpose, business Y/N, odometer start and end, a typed distance if you don't use the odometer, round trip Y/N (doubles a typed one-way distance) and notes. Distance used and the deductible amount are worked out for you
• Built-in checks: an odometer end reading below the start turns red, and a Check column tells you about any row to fix (no distance, a missing date, a date outside the year)
• Monthly Summary tab: business distance, personal distance, total, business %, deductible amount and number of trips for all 12 months, with year totals, plus the same figures by vehicle and by purpose
• Dashboard: business, personal and total distance, business %, your rate, total deductible amount, trips logged, business trips, average business trip, top purpose and a chart of business distance by month
• Room for 1,000 trips. The tabs are protected without a password, so formulas don't get typed over by accident (you can unprotect them any time)

What you get

• XLSXMileage-Log.xlsx (blank, ready for your own trips)
• XLSXMileage-Log-with-Sample-Data.xlsx (a filled-in example: a made-up small business with 40 trips from January to June in 2 vehicles, some of them personal)
• PDFQuick-start guide (PDF)

Good for

Self-employed people, freelancers, contractors, real estate agents, delivery drivers and small business owners who drive for work and want a clean mileage record for the year, in kilometres or miles.