The short answer: You need two numbers for every vehicle: the odometer reading at its last oil change, and its odometer reading today. Subtract, compare against that vehicle's oil change interval, and you have an overdue list. Telematics (Samsara, Geotab, Motive and others) gives you today's mileage automatically; your shop invoices give you the last service. HoneyRuns' AI agent, Riggs, does this comparison continuously for every vehicle and books the overdue ones.
Why the sticker does not work
The windshield sticker tells the driver when the next change is due. It does not tell you. You only find out a truck is overdue if the driver mentions it, and most drivers have other priorities. In fleets that rely on stickers, the overdue list is whatever the office remembers.
The three pieces of data you need
- Current mileage for every vehicle. If you have telematics, it is already there. If not, a weekly odometer photo from each driver works.
- Mileage and date at the last oil change. This is on the shop invoice. If invoices live in email inboxes, pull the last one for each vehicle.
- The interval for each vehicle. Use the manufacturer's schedule for that make, model, and engine, not one number for the whole fleet. A diesel work truck and a gas transit van do not share an interval. Many service fleets run "severe service" intervals because of idling and short trips.
Building the overdue list
A spreadsheet with one row per vehicle is enough to start:
| Vehicle | Last change (mi) | Today (mi) | Interval (mi) | Miles since | Status |
|---|---|---|---|---|---|
| Van 12 | 48,200 | 54,900 | 5,000 | 6,700 | Overdue |
| Truck 3 | 61,000 | 63,100 | 7,500 | 2,100 | OK |
Add a "coming due" status at 80 to 90% of the interval so you can book before the vehicle is overdue, not after.
Also check by date. A vehicle that barely moves can go a year without hitting its mileage interval, and most manufacturers also set a time limit.
Where it breaks down
The spreadsheet is only right on the day someone updates it. Mileage changes daily. Invoices arrive late or never get entered. A vehicle gets serviced by a different shop and nobody records it. After a few months the list drifts, and people stop trusting it.
Keeping it current automatically
Riggs reads mileage from your telematics every day, tracks completed service, and compares each vehicle against its own service intervals. When a vehicle is coming due, Riggs books it with your shop or mobile mechanic, confirms with the driver, and records the service when it is done.
Frequently Asked Questions
Q: How do I track oil changes for a fleet of vans? A: Record the odometer at each oil change, pull current mileage from telematics or driver reports, and compare the difference against each vehicle's interval. Flag anything past 80 to 90% of the interval as coming due.
Q: Should every vehicle in my fleet have the same oil change interval? A: No. Use the manufacturer's schedule for each make, model, and engine, and the severe-service schedule if the vehicle idles a lot or makes short trips.
Q: Can telematics tell me when an oil change is due? A: Telematics gives you accurate current mileage and engine hours. You still need the last service record and the right interval for each vehicle to know what is due.
Q: What if a vehicle does not drive many miles? A: Check time as well as mileage. Most manufacturers set a maximum time between oil changes even if the mileage interval is not reached.
Get Started with HoneyRuns
Connect your telematics and see which vehicles are due or overdue today. Get started.
HoneyRuns gets fleet maintenance done. It watches mileage, intervals, and telematics, books the repair with the shops and vendors you already use, stays on the driver and the shop until the vehicle is back, and logs the completed service in the system you already run. Your team approves repair estimates before work goes ahead. Founded by fleet operators who manage 70 vehicles across three fleets today.