How to Track Fleet Service Intervals (Without a Spreadsheet)

Spreadsheets Aren't Built for This

Every fleet manager starts with a spreadsheet. It makes sense at first. You've got five vehicles, you know roughly when each one needs a service, and a simple table does the job.

Then the fleet grows to 15. Then 30. Someone forgets to update the sheet. The odometer reading is from two months ago. Now you're looking at stale data, trying to figure out which machines are overdue.

Why Spreadsheets Specifically Fail

• Manual entry errors - transposed digits, wrong vehicle row, hours entered in the km column. One typo can make a service look current when it's 200 hours overdue.
• Forgotten updates - readings only get entered when someone remembers. The spreadsheet is only as good as the last time it was touched.
• No alerts - spreadsheets don't push notifications. They don't message you when a machine crosses a service threshold.
• No visual dashboard - a wall of numbers doesn't communicate urgency. You have to mentally compare readings for every vehicle, every time you look.
• No accountability trail - no record of who updated what, when, or whether the data is correct.

Spreadsheets work for things that change slowly and don't have consequences when out of date. Fleet service intervals are the opposite.

Service Interval Types

Different vehicles track service intervals differently. Getting this wrong throws off your entire schedule.

Engine Hours - Heavy Machinery

For excavators, loaders, dozers, graders, generators, and most heavy plant, engine hours are the primary metric.

These machines might only travel short distances but run their engines 10-12 hours a day under heavy load. Kilometres are meaningless for a machine that sits in one spot and digs.

Engine hours are the true measure of how hard the engine and hydraulic system have been working. Manufacturer service schedules are built around them.

Mileage - Road Vehicles

Utes, trucks, vans, and other road-registered vehicles typically track services by kilometres. Common intervals are every 10,000 km or 15,000 km depending on the vehicle.

Vehicles operating in dusty, heavy-load, or short-trip conditions often have shorter recommended intervals.

Time-Based - Low-Usage Equipment

Some vehicles and plant don't accumulate hours or kilometres quickly enough to trigger interval-based services.

A generator that only runs during power outages or a trailer sitting in the yard for months still needs servicing. Rubber deteriorates, fluids degrade, and corrosion doesn't care about odometer readings.

Time-based intervals (typically 6 or 12 months, whichever comes first alongside hours or km) catch these machines so they don't get forgotten.

Common Service Intervals

Understanding what's involved at each interval helps you plan resources, parts, and workshop time.

Hours-Based (Heavy Machinery)

• 250 hours - engine oil and filter change, basic inspection of belts, hoses, and fluid levels. Grease all points. Check air filter.
• 500 hours - everything in the 250-hour service, plus hydraulic oil filter, fuel filter, cabin air filter. Detailed inspection of undercarriage, tracks, and hydraulic lines. Battery condition check.
• 1,000 hours - major service. Coolant flush, hydraulic oil sample, valve clearance check, full electrical inspection, brake inspection. Often requires a qualified mechanic. This is where you catch developing problems.
• 2,000 hours - full overhaul. Engine inspection, turbo check, injector testing, complete undercarriage assessment, swing bearing inspection, full hydraulic system evaluation. A workshop job that can take days.

Kilometres-Based (Road Vehicles)

• 10,000 km - standard interval for many light commercial vehicles in Australian conditions. Oil and filter change, tyre rotation, brake inspection, fluid top-up, general inspection.
• 15,000 km - some manufacturers specify this interval, but for trade vehicles in dusty or heavy-load conditions, 10,000 km is more realistic.

Intervals overlap. When a machine hits 1,000 hours, you're doing the 1,000-hour, 500-hour, and 250-hour service all at once. Your tracking system needs to handle that and show which interval is coming up next.

What to Track Per Service

Recording that "a service was done" isn't enough. For each service event, capture:

• Hours or km at service - the exact reading. This is the baseline for calculating the next service.
• Service type - which interval was completed (250hr, 500hr, 1000hr, etc.). Not just "service done."
• Parts used - oil type and quantity, filter part numbers, coolant type, replacement parts. Matters for warranty compliance.
• Oil samples - for heavy machinery, one of the most valuable diagnostic tools available.
• Mechanic - who performed the service. Internal workshop, external contractor, or operator.
• Costs - parts, labour, consumables, additional repairs. Without cost tracking, you can't calculate cost-per-hour or make keep-vs-replace decisions.
• Notes and photos - anything the mechanic observed outside the standard service. Wear patterns, emerging issues, components approaching end of life.

Oil Sampling for Heavy Machinery

Oil sampling ties directly into service tracking. At each major service interval (typically 500 hours and above), an oil sample is taken and sent to a lab.

What the Lab Tests For

• Wear metals - iron, copper, lead, aluminium, chromium. Elevated levels indicate which components are wearing. High iron means cylinder or ring wear. High copper means bearing wear.
• Contaminants - coolant in the oil (head gasket), fuel dilution (injector problem), dirt ingress (air filter or seal failure)
• Oil condition - whether the oil is still doing its job or has degraded

Tracking Trends Over Time

A single elevated reading might not mean much. But a rising trend over three or four samples tells you exactly what's happening inside the engine.

Store oil sample results against the vehicle's service history so the full picture is right there when reviewing a machine's health.

Parts Preparation and Lead Times

Knowing a service is due in 50 hours is only useful if you've ordered the parts.

A 500-hour service kit for a 20-tonne excavator isn't sitting on the shelf at the local parts store. Specialist filters, specific oil grades, and OEM parts often have lead times of days or weeks.

If you don't have enough advance warning, the machine sits idle while you wait for parts from interstate or overseas.

Good tracking gives you a "prep zone" - a warning when a machine is 50-100 hours out from its next service. That's your signal to check stock, order parts, and book workshop time. When the machine hits the interval, everything is ready and downtime is minimised.

The Cost of Missing a Service

Skipping or delaying a service has real financial consequences that compound quickly:

• Voided warranty - most manufacturers require proof of servicing at specified intervals. Miss one, and the warranty on a $300,000 excavator disappears. That $500 service you skipped just cost you $300,000 in coverage.
• Accelerated wear - contaminated oil damages bearings, rings, and seals. A $200 oil change becomes a $15,000 engine rebuild.
• Unplanned downtime - a breakdown costs the repair, plus the crew standing around, plus the hire machine, plus the project delay. Planned maintenance at $1,000 is always cheaper than a $15,000 emergency repair.
• Safety risk - brake fade, hydraulic leaks, steering play, tyre failure. A machine that hasn't been serviced is a machine you can't trust. Under WHS legislation, you have a duty to ensure it's safe.
• Reduced resale value - a complete service history adds thousands to resale value. Machines with full records consistently sell for 10-20% more than equivalent machines without.

Automated Alerts and Work Orders

This is where proper tracking separates from spreadsheets entirely.

A good service tracking system:

• Sends alerts automatically when a machine crosses a threshold - say, 50 hours until next service. Proactively, with enough lead time to order parts.
• Generates work orders pre-populated with service type, required parts, and vehicle details. The workshop gets a complete brief without transcription.
• Escalates overdue services so machines past their interval are flagged prominently. You can't miss them, and there's an accountability trail.

What Good Tracking Looks Like

Evaluate any system against these characteristics:

• Visual gauges - not a list of numbers. A gauge or progress bar showing green (plenty of time), yellow (approaching service), and red (due or overdue) for every vehicle at a glance.
• Automated countdowns - remaining hours or kilometres calculated automatically from last service reading and current readings from daily prestarts.
• Prep zone warnings - advance alerts at a configurable threshold before service is due. Time to order parts, book the workshop, and schedule the machine out.
• Complete history per vehicle - service records, prestart history, fuel usage, defect logs, oil samples, and costs all linked in one place.
• Always current - readings from daily prestarts feed directly into the countdown. Data is never more than 24 hours old. No manual updates required.

Stop Relying on Memory

The fleet managers who stay on top of services aren't the ones with the best spreadsheets. They're the ones with systems that do the tracking for them.

Updated readings from daily inputs. Automated countdowns. Alerts when thresholds are crossed. Clear flagging of what needs attention before it becomes a breakdown.

Burgy tracks service countdowns automatically using visual gauges that show exactly how many hours or kilometres remain until each service interval. Prep zone warnings help you order parts ahead of time, and a complete service history is stored against every vehicle in your fleet.