Fleet Management Spreadsheet: Mileage, Fuel, Maintenance, Renewals and Cost per Mile
How to run a small business fleet from one spreadsheet: vehicle and driver records, fuel and mileage log, maintenance by mileage, registration and insurance renewals, incidents and cost per mile for each vehicle, with a service van example.
A fleet management spreadsheet keeps every company vehicle in one workbook: who drives it, mileage and fuel, maintenance done and due, registration, inspection and insurance renewals, and incidents, so you know the cost per mile of each vehicle and never miss a date. For a business with two to twenty vehicles, a well-built spreadsheet is enough before paying for fleet software. This guide covers the tabs, the formulas and an example with four service vans.
Workbook tabs
| Tab | One row per | Columns |
|---|---|---|
| Vehicles | Vehicle | Unit number, plate, make, model, year, VIN, fuel type, assigned driver, purchase or lease date |
| Drivers | Person | Name, vehicle, license expiration, training |
| Fuel | Fill-up | Date, unit, odometer, gallons, cost, fuel card |
| Maintenance | Service | Date, unit, odometer, type, shop, cost, next service due |
| Renewals | Obligation | Registration, inspection, insurance, lease, due date |
| Incidents | Event | Date, unit, driver, type (breakdown, accident, ticket), cost, status |
| Summary | Vehicle | Miles for the period, MPG, total cost, cost per mile |
Use drop-down lists for unit, driver and type. Consistent names across tabs are what make the totals work.
Mileage and fuel economy
- Current odometer for a unit:
=MAXIFS(Fuel[Odometer],Fuel[Unit],A2) - Miles for the period: the highest minus the lowest reading between the start and end dates.
- Miles per gallon:
=PeriodMiles/SUMIFS(Fuel[Gallons],Fuel[Unit],A2,Fuel[Date],">="&Start,Fuel[Date],"<="&End)
Comparing MPG across identical vehicles on similar routes surfaces mechanical problems, driving habits or fuel card misuse.
Maintenance and renewals
- Next service by mileage:
=[@ServiceOdometer]+[@IntervalMiles], using the manufacturer’s schedule. - Status:
=IF(CurrentOdometer>=[@NextService],"Overdue",IF([@NextService]-CurrentOdometer<=1000,"Due soon","OK")) - Days until each renewal:
=[@DueDate]-TODAY(), orange under 30 days and red when past.
Track driver license expiration dates too. Registration, inspection and commercial vehicle rules depend on your state and on vehicle type and weight, and some vehicles fall under federal motor carrier requirements; check what applies to your fleet. Equipment other than vehicles follows the same logic in the preventive maintenance schedule template.
Cost per mile for each vehicle
Cost for the period: fuel + maintenance + incidents + a share of insurance, registration and lease or depreciation. Cost per mile: =TotalCost/PeriodMiles.
Example: four service vans, one year
| Van | Miles | Fuel | Maintenance | Cost per mile |
|---|---|---|---|---|
| Van 1 | 24,000 | $5,600 | $1,900 | $0.31 |
| Van 2 | 21,000 | $4,900 | $4,300 | $0.44 |
| Van 3 | 23,000 | $5,367 | $1,650 | $0.31 |
| Van 4 | 9,000 | $2,100 | $1,200 | $0.37 |
Fuel is estimated at 15 MPG and $3.50 a gallon; insurance and lease are excluded. Van 2 spends more than twice as much on maintenance as the others, and the log shows why: transmission work and brakes in the same year. Van 4 covers less than half the miles of the rest, so the business may have one van too many or unbalanced routes. Both questions only come up because the data is in one place.
Incidents and tickets
Log every breakdown, accident and ticket with the driver and status. Tickets come with deadlines to respond or pay, so record the date received. Keep fleet costs in your business expense records as well.
When to move to fleet software
With many vehicles, drivers entering data at the same time, or a need for GPS tracking, fleet software with telematics saves time. Clean spreadsheet data makes that move easier. For a single vehicle, the vehicle maintenance log template is simpler; for who drives when, the employee schedule template. More guides are in Fleet & Vehicle Maintenance.
Frequently asked questions
What should a fleet spreadsheet track at minimum?
Unit, driver, mileage, fuel, maintenance, renewals (registration, inspection, insurance, licenses) and incidents.
How often should mileage be recorded?
At every fill-up, or at least weekly, so maintenance alerts stay reliable.
How do I check fuel card use?
Each month, compare the card statement with the fuel log and each vehicle’s MPG; gaps point to errors or misuse.
Does it work in Google Sheets?
Yes, and drivers can log fill-ups from their phones through a Google Form.