Cellwise Start free

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.

cellwise-fleet-maintenance-tracker.xlsxExcel workbook · 5.2 KB · works in Excel, Google Sheets, Numbers and LibreOffice · no signup
Download free template

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.

RowABCDEFGHI
1Fleet maintenance tracker
2As of dateNov 11, 2026
3Due soon within (miles)1,500
4Due soon within (days)30
5
6UnitServiceEvery (mi)Last done (mi)Last costCurrent miNext due (mi)Miles leftStatus
7Truck 101Oil and filter15,000412,300$385.00425,800427,3001,500Due soon
8Truck 101Tire rotation and inspection25,000398,000$120.00425,800423,000-2,800Overdue
9Truck 101Brake inspection30,000401,500$240.00425,800431,5005,700OK
10Truck 102Oil and filter15,000291,200$370.00302,950306,2003,250OK
11Truck 102Air filter30,000275,000$95.00302,950305,0002,050OK
12Truck 102Coolant service60,000244,000$310.00302,950304,0001,050Due soon
13Van 7Oil and filter7,50084,200$89.0090,80091,700900Due soon
14Van 7Tire rotation7,50086,000$40.0090,80093,5002,700OK
15Van 7Brake pads40,00050,000$420.0090,80090,000-800Overdue
16Van 8Oil and filter7,50052,100$89.0058,95059,600650Due soon
17
18Date-based items
19UnitItemLast doneEvery (months)Last costNext dueDays leftStatus
20Truck 101Annual inspectionNov 20, 202512$150.00Nov 20, 20269Due soon
21Truck 102Annual inspectionFeb 14, 202612$150.00Feb 14, 202795OK
22Van 7Registration renewalOct 31, 202512$85.00Oct 31, 2026-11Overdue
23Van 8Registration renewalJun 30, 202612$85.00Jun 30, 2027231OK
24
25UnitCurrent odometerDue or overdueLast services cost
26Truck 101425,8003$895.00
27Truck 102302,9501$925.00
28Van 790,8003$634.00
29Van 858,9501$174.00
30
31Overdue3
32Due soon5
33Most urgent by milesTruck 101, Tire rotation and inspection

How the formulas work

Current odometer, typed once per unit

F7=VLOOKUP(A7,$A$26:$B$29,2,FALSE)

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

H7=G7-F7

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

I7=IF(H7<=0,"Overdue",IF(H7<=$B$3,"Due soon","OK"))

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

G20=DAYS(F20,$B$2)

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

C26=COUNTIFS($A$7:$A$16,A26,$I$7:$I$16,"<>OK")+COUNTIFS($A$20:$A$23,A26,$H$20:$H$23,"<>OK")

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

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

Related guides

More free templates

Updated