In this guide 6 sections
Give every installed compressor its own serial record. Log run hours at each visit, set intervals per part such as oil, filters, separator and belts, and project the next due date from daily running. Raise the reminder before the visit needs booking.
Start with one record per installed machine
List every compressor you have sold or serviced. Use the serial number as the key, not the customer name, because one customer may run six machines across three sites and every unit needs its own service history.
Add the model, the commissioning date, the site address and the contract type, since a comprehensive contract and a parts-only contract need different reminders. Capture the opening meter reading too.
This sheet is slow to build. It is also the step nobody can skip.
- Serial number, model and air end number
- Commissioning date and first meter reading
- Site, contact person and contract type
- Operating pressure and duty, if the customer shares it
Set service intervals per part, not per machine
A compressor does not wear as one unit. The oil filter, air filter, separator element, oil and drive belt each wear on a separate interval, usually taken from the maker’s manual. The air end overhaul lies far beyond.
Write the intervals as a table by model, where each row is a part and each column is a trigger: run hours, calendar months or whichever comes first. A machine in a dusty foundry hits its air filter limit sooner than one in a clean lab, which is why hours and months both matter.
Keep the table apart from the machine records. When a manual changes an interval, you edit one row, and every machine linked to that model picks up the new limit on its next reading.
- Oil and oil filter
- Air intake filter and separator element
- Drive belt or coupling
- Air end inspection and overhaul
Turn run hours into a due date
Run hours alone do not say when to book a visit, so take the last two meter readings and divide the difference by the days between visits. That gives hours per day for the site.
A plant on three shifts may add twenty hours a day, while a workshop on one shift adds eight, so the same remaining hours mean very different dates. Dividing the hours remaining by that rate gives the projected due date, and the date moves each time a new reading comes in.
Ask for a monthly meter photo. That takes a minute on their side, yet between visits it is the only real data you will have on how hard the machine is working.
Remind early enough to plan the visit
Reminders on the due date are late. The technician needs a free day, the parts need picking and the customer must arrange a shutdown of the line before anyone arrives with a toolbox. So set the reminder at the lead time of your slowest part, which is often an imported separator element or an air end overhaul kit.
Send two alerts. The service coordinator gets the part list and the customer gets a proposed date window, so neither waits for the other to start the conversation.
Overdue machines deserve their own list. Sort that list by contract value and by how many hours past the limit each machine has run, so the riskiest units get the first free technician.
- Reminder date set by parts lead time
- Part kit list generated per machine
- Customer notice with a proposed visit window
- Overdue list sorted by contract and hours past limit
Close each visit with the record that feeds the next one
The service report should capture the meter reading, the parts replaced with batch numbers, the oil sample finding and any fault noted. Fill it on a phone at the site. Memory two days later is no substitute.
Closing the report resets only the changed parts. Untouched parts keep running toward their own limits, and a spreadsheet usually fails here because someone forgets to reset one row of the table or resets the wrong one.
Pick five installed machines this week, build their records end to end, and check the projected due dates against what your technicians already know about each site.
Compressor service schedule worksheet
A single printed sheet in three parts. The top part holds serial number, model, site, contract type and commissioning reading, and the middle part lists each wearing part with its hour and month limit. The bottom part logs each visit, with columns for meter reading, hours per day, projected next due date, parts used and the technician’s name.
Open a blank worksheet to printQuestions owners ask
What if a customer will not share meter readings?
Estimate the rate from your own visits and shorten the gap between them, then flag those machines so everyone reads the projection as a guess. Offer a monthly photo request by message.
Should the interval follow hours or months?
Use both and act on whichever arrives first. Oil ages even on a machine that rarely runs, and filters in a dusty site clog long before the calendar says they should, so one trigger alone misleads.
How do we handle machines moved to another site?
Keep the serial record, change the site. The history stays attached to the machine, which is what a later buyer, a lender or an auditor will want to see before relying on its service record.
Can a spreadsheet do this?
Yes, for a few dozen machines. It struggles once several technicians update readings and part resets at the same time, because one overwritten row silently hides an overdue overhaul.