Excel · SheetsTrip log with odometer-based miles, a vehicle expense register and a year summary for both deduction methods.
What's included:
- Trips: miles from odometer readings or a manual figure
- Purpose and client columns with drop-downs
- Vehicle expense register with categories
- Year summary: standard-mileage figure and actual costs × business use
- Rate and odometer settings you control
- Excel, Google Sheets and LibreOffice
Preview: what's inside
Settings Settings
| Setting | Value |
|---|---|
| Rate per business mile | 0.70 |
| Odometer on 1 January | 42318 |
| Odometer on 31 December (fill at year end) |
Summary Year summary
- Business trips logged
- Business miles
- Business parking & tolls
- Standard-mileage figure (miles × rate + parking/tolls)
- Total miles driven (needs year-end odometer)
- Business-use percentage
- Actual vehicle costs (all categories)
- Actual costs × business use
Sheet Trips — One row per business trip. Miles = end − start odometer, or the manual figure.
| Date | Start odometer | End odometer | Miles (manual) | Business miles | From | To | Purpose | Client / job | Parking & tolls | Value at rate |
|---|---|---|---|---|---|---|---|---|---|---|
| 2026-01-06 | 42318 | 42359 | auto | Home office | Client: Hale Dental | Client visit | Hale Dental | 4.50 | auto | |
| 2026-01-07 | 42371 | 42396 | auto | Home office | Wholesale supplier | Supplies run | auto | |||
| 2026-01-09 | 63 | auto | Home office | Site: 18 Birch Rd | Job site | Birch Rd remodel | 2.00 | auto |
Sheet Expenses — Every vehicle cost with a receipt.
| Date | Category | Vendor | Amount | Receipt kept? | Note |
|---|---|---|---|---|---|
| 2026-01-08 | Fuel | Corner fuel | 48.20 | Yes | |
| 2026-01-15 | Repairs & maintenance | Main St Garage | 129.00 | Yes | Oil change + wipers |
Preview generated from the actual file: sample rows are example data you replace with your own; formulas fill the calculated columns.
Good to know
- Instant digital download. Nothing physical is shipped.
- Licensed for personal and single-business use.
- 30-day fix-or-refund if a file doesn't work as described (terms).
- Support: eclipsekingdom.support@gmail.com