Free Excel template
Free fleet maintenance tracker template
For small fleets, owner-operators and any business with a few trucks or vans that need servicing on time. List each service with its interval and the odometer when it was last done, type each unit's current odometer once, and the template shows the miles left, flags Overdue and Due soon, and tracks date-based items like inspections and registrations by days left. A unit table counts what each vehicle needs and what its last services cost.
Preview and try it
This is the template's sheet, calculated by the same engine as the Cellwise app. Change any number to see the formulas react before you download.
| Row | A | B | C | D | E | F | G | H | I |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Fleet maintenance tracker | ||||||||
| 2 | As of date | Nov 11, 2026 | |||||||
| 3 | Due soon within (miles) | 1,500 | |||||||
| 4 | Due soon within (days) | 30 | |||||||
| 5 | |||||||||
| 6 | Unit | Service | Every (mi) | Last done (mi) | Last cost | Current mi | Next due (mi) | Miles left | Status |
| 7 | Truck 101 | Oil and filter | 15,000 | 412,300 | $385.00 | 425,800 | 427,300 | 1,500 | Due soon |
| 8 | Truck 101 | Tire rotation and inspection | 25,000 | 398,000 | $120.00 | 425,800 | 423,000 | -2,800 | Overdue |
| 9 | Truck 101 | Brake inspection | 30,000 | 401,500 | $240.00 | 425,800 | 431,500 | 5,700 | OK |
| 10 | Truck 102 | Oil and filter | 15,000 | 291,200 | $370.00 | 302,950 | 306,200 | 3,250 | OK |
| 11 | Truck 102 | Air filter | 30,000 | 275,000 | $95.00 | 302,950 | 305,000 | 2,050 | OK |
| 12 | Truck 102 | Coolant service | 60,000 | 244,000 | $310.00 | 302,950 | 304,000 | 1,050 | Due soon |
| 13 | Van 7 | Oil and filter | 7,500 | 84,200 | $89.00 | 90,800 | 91,700 | 900 | Due soon |
| 14 | Van 7 | Tire rotation | 7,500 | 86,000 | $40.00 | 90,800 | 93,500 | 2,700 | OK |
| 15 | Van 7 | Brake pads | 40,000 | 50,000 | $420.00 | 90,800 | 90,000 | -800 | Overdue |
| 16 | Van 8 | Oil and filter | 7,500 | 52,100 | $89.00 | 58,950 | 59,600 | 650 | Due soon |
| 17 | |||||||||
| 18 | Date-based items | ||||||||
| 19 | Unit | Item | Last done | Every (months) | Last cost | Next due | Days left | Status | |
| 20 | Truck 101 | Annual inspection | Nov 20, 2025 | 12 | $150.00 | Nov 20, 2026 | 9 | Due soon | |
| 21 | Truck 102 | Annual inspection | Feb 14, 2026 | 12 | $150.00 | Feb 14, 2027 | 95 | OK | |
| 22 | Van 7 | Registration renewal | Oct 31, 2025 | 12 | $85.00 | Oct 31, 2026 | -11 | Overdue | |
| 23 | Van 8 | Registration renewal | Jun 30, 2026 | 12 | $85.00 | Jun 30, 2027 | 231 | OK | |
| 24 | |||||||||
| 25 | Unit | Current odometer | Due or overdue | Last services cost | |||||
| 26 | Truck 101 | 425,800 | 3 | $895.00 | |||||
| 27 | Truck 102 | 302,950 | 1 | $925.00 | |||||
| 28 | Van 7 | 90,800 | 3 | $634.00 | |||||
| 29 | Van 8 | 58,950 | 1 | $174.00 | |||||
| 30 | |||||||||
| 31 | Overdue | 3 | |||||||
| 32 | Due soon | 5 | |||||||
| 33 | Most urgent by miles | Truck 101, Tire rotation and inspection |
How the formulas work
Current odometer, typed once per unit
Each vehicle's odometer lives in one place, the unit table at the bottom. VLOOKUP finds the unit name in A26:A29 and returns its reading, so when Truck 101 reads 425,800 you update one cell and every Truck 101 service recalculates. FALSE means exact match; a unit name typed differently (an extra space, "Truck101") shows #N/A, which is your cue to fix the name.
Miles left until the next service
Next due is the odometer at the last service plus the interval (G7 is =D7+C7); subtract the current odometer to get the miles left. Truck 101's oil change was done at 412,300 every 15,000 miles, so it is due at 427,300 and has 1,500 miles to go. A negative number means the service is past due by that many miles.
Overdue and Due soon flags
The nested IF checks the urgent case first: no miles left is Overdue, fewer than the warning distance in B3 (1,500 miles) is Due soon, and anything else is OK. Change B3 to give yourself more or less warning. Add conditional formatting (Home > Conditional Formatting > Highlight Cells Rules > Text that Contains) to color the flags.
Days left for date-based items
Some items run on the calendar, not the odometer. EDATE in F20 adds the interval in months to the last-done date, and DAYS counts the days from the as-of date in B2 to that due date. Van 7's registration was due on Oct 31, 2026, so it shows -11 days and Overdue. Replace B2 with =TODAY() in your copy to keep the counts current every time you open the file.
What each unit needs
COUNTIFS counts the unit's rows whose status is anything but OK ("<>OK" means not equal to OK), once in the mileage list and once in the date list. Truck 101 has 3 items due or overdue, so it is the one to book into the shop first. B31 and B32 total the Overdue and Due soon flags for the whole fleet: 3 and 5.
Make it yours
- Use the service intervals from each vehicle's maintenance manual or your shop. They differ by engine, duty cycle and fluid, so they are inputs here, not rules.
- Update the odometers in B26:B29 once a week, or from your ELD or fuel card report, and the whole sheet updates.
- When a service is done, type the new odometer reading in Last done and the cost in Last cost. For a full history, keep a second sheet with one dated row per service.
- Add a row for each new service or unit, then widen the ranges in the VLOOKUP, COUNTIFS and SUMIF formulas to include them.
FAQ
How do I track vehicle maintenance by mileage in Excel?
For each service, record the interval in miles and the odometer when it was last done. Next due is =last_done+interval, and miles left is =next_due-current_odometer. Flag it with =IF(miles_left<=0,"Overdue",IF(miles_left<=1500,"Due soon","OK")).
How do I make Excel warn me before a service is due?
Keep a warning distance (or number of days) in a cell and compare the miles or days left with it in an IF formula, then color the result with conditional formatting. This template flags anything within 1,500 miles or 30 days as Due soon.
Can I use this for one truck or for a car?
Yes. Keep a single unit in the unit table and list its services. It works the same for a car, a van, a tractor or a trailer with a hub odometer; for equipment that runs on hours, type engine hours instead of miles.
Functions used
VLOOKUPVertical lookupIFPicks a result from a testEDATESame day, months laterDAYSDays between datesCOUNTIFSCounts with several conditionsSUMIFAdds cells that matchCOUNTIFCounts cells that matchINDEXValue at a positionMATCHPosition of a valueMINSmallest number
Related guides
- How to track expiration dates in Excel
- How to write a nested IF in Excel
- How to add months to a date in Excel
- How to make a mileage log in Excel
More free templates
- Employee expense report template for ExcelFor employees who need to claim back business costs, and for the managers and bookkeepers who check those claims.Free .xlsx
- Purchase order template for Excel (PO form with sample)A simple purchase order form for small businesses, office managers and buyers who send POs to suppliers and want to track what actually arrives.Free .xlsx
- Accounts receivable aging report templateFor owners, bookkeepers and credit controllers who invoice customers on terms and need to see who owes what and for how long.Free .xlsx
- Weekly employee shift schedule templateFor managers of shops, cafes, restaurants and small teams who build the rota in a spreadsheet.Free .xlsx
Updated