Vehicle register
Give every vehicle a stable Unit ID and keep the identity, status, current mileage, maintenance source, assignment, and document location together.
SMALL FLEET MAINTENANCE & OPERATIONS
The Small Fleet Maintenance Operating Manual
A Practical System for Preventive Maintenance, Service Scheduling, Repair Costs, Vehicle Records and Keeping 3-50 Vehicles Organized
By Warren Holtby · Published by Mercer Lane Press
A practical administrative system for small fleets that connects vehicle records, source-backed maintenance rules, due and overdue scheduling, defect and repair actions, service history, repair costs, downtime, review routines, and a 30-day implementation plan.
WHO IT IS FOR
For small fleets that have outgrown memory and scattered records
Owners, managers, administrators, and maintenance coordinators responsible for roughly 3-50 vehicles who need a dependable way to keep maintenance information, mileage, defects, repair approvals, invoices, costs, and follow-up from becoming scattered across memory, messages, calendars, and disconnected files.
- Maintenance dates, mileage readings, invoices, defects, bookings, and vehicle details living in separate places with no single view of what needs attention next
- Scheduled work appearing current even when mileage is stale, a source is missing, or a date-based trigger has been overlooked
- Driver observations, repair recommendations, quotes, approvals, and completed work failing to become owned actions with closure evidence
- Repair spend being tracked without enough context to separate planned work, unplanned events, downtime, repeat problems, and useful replacement-review evidence
- A spreadsheet becoming difficult to trust because formulas, input fields, statuses, source references, and data-quality checks have not been designed as one system
THE CONTROL SYSTEM
Six connected records instead of several partial systems
The operating model links the asset, the maintenance requirement, the due trigger, the next action, completion evidence, and the review of exceptions.
Maintenance rules
Record what each vehicle requires, where the requirement came from, the trigger type, the last supported baseline, and the next due point.
Live service schedule
Separate requirement, status, and action so DATA ISSUE, OVERDUE, DUE SOON, BOOKED, and CURRENT remain visible for the right reasons.
Defects and repair actions
Turn observations into controlled records with an owner, next action, target date, approval path, and documented disposition.
Service and cost history
Close completed work with date, mileage, vendor, cost, evidence, linked actions, recommendations, and the correct next-due reset.
Exception review
Use weekly, monthly, and quarterly views to focus attention on overdue work, stale data, open actions, downtime, repeat events, cost changes, and replacement-review candidates.
DECISION-USEFUL RECORDS
See more than the repair invoice total
- Defect intake, next actions, repair authorization, and closure
- Service history, document evidence, repair costs, and downtime
- Monthly and quarterly exception reviews
- Repair-versus-replace evidence packs
- Spreadsheet architecture, formula testing, and software-review triggers
The book keeps planned and unplanned work, downtime, repeat events, source confidence, and repair-versus-replace evidence distinct so a single number does not become a false verdict.
IMPLEMENTATION
Build forward control first, then improve the history
Spreadsheet architecture
Build separate tables for vehicles, mileage, rules, defects/actions, service history, downtime, settings, audit checks, and dashboard exceptions.
Formula and data QA
Test exact due points, missing mileage, dual triggers, stale data, late service, corrections, row additions, negative values, and other edge cases before trusting the status output.
30-day rollout
Define ownership, reconcile active vehicles, verify maintenance sources, launch the due board and mileage routine, add repair control and cost history, then stress-test and freeze Version 1.
What this book does not do
The system organizes maintenance administration. It does not invent vehicle-specific service intervals, diagnose faults, or replace manufacturer information, qualified mechanical advice, warranty requirements, recall instructions, or the legal and regulatory rules that apply to a particular operation.
Use authoritative sources. Vehicle-specific requirements vary. Use current manufacturer information and the appropriate official or qualified source for maintenance, safety, regulatory, warranty, and technical decisions.
FREE SUPPORTING GUIDES
Build the part of the fleet-maintenance system you need next
FLEET MAINTENANCE
How to Build a Small Fleet Maintenance System Without Managing from Memory
Build a closed maintenance-control loop so each vehicle requirement becomes visible, owned, completed, recorded, and reviewed.
Read the guideFLEET MAINTENANCE
Fleet Maintenance Schedule Spreadsheet: What to Track for Each Vehicle
Build the spreadsheet as connected tables, then make missing data, dual triggers, due-soon windows, and formula logic visible and testable.
Read the guideFLEET MAINTENANCE
Fleet Defect and Repair Workflow: From Driver Report to Closed Action
Capture observations, assign the next action, control authorization, retain evidence, and close the loop only after the record is ready for the future.
Read the guideFLEET MAINTENANCE
Fleet Repair Costs and Downtime: When a Vehicle Deserves a Replacement Review
Use consistent cost definitions and downtime evidence to identify vehicles that need review without relying on a universal repair-cost threshold.
Read the guideFLEET MAINTENANCE
A 30-Day Small Fleet Maintenance Setup Plan
Prioritize forward visibility first: define ownership, reconcile vehicles, verify rules, launch the exception schedule, then add closure, cost, dashboard, and QA.
Read the guidePut the operating method into practice
Calculate one verified maintenance rule by date or mileage with the free browser tool. For recurring records across several vehicles, explore the Small Fleet Maintenance System, a separate Excel workbook and forms product. The book teaches the method; the digital product supplies working files. The book is sold separately.
SEARCH BY THE PROBLEM
Small fleet maintenance schedules that turn service history into a working system
Small-fleet operators commonly search for fleet maintenance schedules, preventive-maintenance checklists, mileage tracking and maintenance spreadsheets. The book focuses on controlling due work, defects, repair history and vehicle availability rather than relying on memory.
Questions this guide is designed to help with
- How do I build a preventive maintenance schedule for a small fleet?
- What should a fleet maintenance checklist track?
- How can I track vehicle service by mileage and time?