- One row per job: date, asset ID, meter reading, work type, findings, parts, who did it, downtime and next due.
- Truck fleets keep maintenance records under 49 CFR 396.3, plus driver inspection reports and annual inspection reports.
- OSHA requires daily forklift examinations and signed records for some monthly crane inspections.
- Move from a spreadsheet to a CMMS when you can no longer see each asset's history at a glance.
What is a maintenance log?
A maintenance log is a dated record of every inspection, service and repair done on one machine, vehicle or building system. Each entry says what was checked or fixed, who did it, what parts went in and when the next job is due. People also call it a maintenance log sheet, a maintenance register, a service log or an equipment history. A paper sheet on a clipboard, a spreadsheet and the work order history in maintenance software all do the same job. They differ in how easily you can search them later.
A good log records three kinds of work, as the Department of Energy's operations and maintenance guidance defines them (PNNL, O&M Best Practices). Reactive maintenance, "also called corrective maintenance", is the "run it until it breaks" approach. Preventive maintenance is "actions performed on a time- or machine-run, time-based schedule that detect, preclude, or mitigate degradation of a component or system". Predictive maintenance "schedules maintenance tasks based on the quantified condition of the equipment", such as a vibration or oil reading, instead of the calendar. Tag every row with its type so you can see later how much of your work was planned.
For some equipment the log is a legal duty: motor carriers under FMCSA rules, employers with forklifts and overhead cranes under OSHA, and process plants under OSHA's process safety rule. Aircraft have their own FAA rules; see aircraft maintenance logbook entries.
What should a maintenance log template include?
Use one row per job and the same columns for every asset. OSHA's process safety rule is a good model for the core fields. It requires each inspection and test of process equipment to be documented with "the date of the inspection or test, the name of the person who performed the inspection or test, the serial number or other identifier of the equipment on which the inspection or test was performed, a description of the inspection or test performed, and the results of the inspection or test" (29 CFR 1910.119). Add the fields that make the log useful for planning:
| Column | What to enter | Why it matters |
|---|---|---|
| Date | The day the work was done, and the time for breakdowns | Shows intervals and response times |
| Asset ID | A number that never changes: unit number, serial number or tag | Keeps every job on one asset together |
| Meter reading | Hours, miles or cycles at the time of the job | Many service intervals run on use, not the calendar |
| Work type | Preventive, corrective, inspection or predictive | Shows how much work was planned |
| Problem or task | The symptom reported, or the scheduled task | Links the job to its cause |
| Work done and findings | What was checked, measured, adjusted or replaced | The core of the record |
| Parts used | Part numbers and quantities | Spares planning and warranty claims |
| Done by | Name or ID of the technician, or the outside shop | Accountability and sign-off |
| Downtime | Hours the asset was out of service | Shows what failures cost in lost time |
| Next due | Date or meter reading of the next service | Turns the log into a schedule |
| Status | Open, waiting for parts, or closed | Nothing gets lost between shifts |
Used as an equipment maintenance log template for one machine, the table can live on a single sheet. For a shop or a fleet, keep one table for all assets with the Asset ID column, and a second table that lists each asset once: make, model, serial number, year, location and in-service date.
How do you keep an equipment maintenance log?
Start from the manufacturer's manual. It sets the service tasks and intervals for each machine, and OSHA's process safety rule expects the same: inspection frequency "shall be consistent with applicable manufacturers' recommendations and good engineering practices, and more frequently if determined to be necessary by prior operating experience" (29 CFR 1910.119). Write each task into the log as a preventive line with its interval, then record each time it is done.
Some equipment has inspection rules of its own. Forklifts and other powered industrial trucks "shall be examined before being placed in service", and "Such examination shall be made at least daily". A truck that needs repair "shall be taken out of service until it has been restored to safe operating condition" (29 CFR 1910.178). Many sites keep a daily pre-shift checklist for each truck and carry any defect into the maintenance log.
Overhead and gantry cranes need written proof for some checks. OSHA requires hooks to get a "monthly inspection with a certification record which includes the date of inspection, the signature of the person who performed the inspection and the serial number, or other identifier, of the hook inspected", and sets "Periodic inspection - 1 to 12-month intervals" for the whole crane (29 CFR 1910.179). A routine that keeps any equipment log useful:
- Tag every machine with an asset ID and use it in every entry.
- Log breakdowns the same day, with the symptom in the operator's words and the cause the technician found.
- Record measurements, not just "OK": pressures, temperatures, vibration readings and wear.
- Close each entry with what was done and whether the machine went back into service.
- Review the log each month for repeat failures on the same asset.
What must a truck or fleet maintenance log contain?
Interstate motor carriers in the United States follow 49 CFR Part 396, the Federal Motor Carrier Safety Administration's maintenance rules. Under section 396.3, carriers "must maintain, or cause to be maintained, records for each motor vehicle they control for 30 consecutive days". The records must include "An identification of the vehicle including company number, if so marked, make, serial number, and year", "A means to indicate the nature and due date of the various inspection and maintenance operations to be performed" and "A record of inspection, repairs, and maintenance indicating their date and nature" (49 CFR Part 396). A truck maintenance log with a vehicle list, a schedule of due items and a dated service history covers all three.
Two more records sit beside the log. Drivers write a driver vehicle inspection report (DVIR) "at the completion of each day's work on each vehicle operated", though "Drivers are not required to prepare a report if no defect or deficiency is discovered by or reported to the driver." The carrier must then certify on the report "that the defect or deficiency has been repaired or that repair is unnecessary before the vehicle is operated again". Each vehicle also needs a periodic inspection: it must have passed one "at least once during the preceding 12 months", with documentation on the vehicle (49 CFR Part 396).
| Fleet record | Rule | How long to keep it |
|---|---|---|
| Inspection, repair and maintenance record | 49 CFR 396.3 | 1 year where the vehicle is housed or maintained, and 6 months after it leaves your control |
| Driver vehicle inspection report and repair certification | 49 CFR 396.11 | Three months from the date of the report |
| Periodic (annual) inspection report | 49 CFR 396.17 and 396.21 | Fourteen months from the date of the report |
The DVIR "may be created and maintained in electronic format", so an app or telematics system can replace paper (49 CFR Part 396). The periods above are minimums. This page is general information, not legal advice: read the full rule and your state's rules for your vehicles.
A vehicle maintenance log template for a car or light van needs fewer columns: date, odometer, service done, shop, parts and the next due mileage. Keep the receipts with it. They prove the service history when you sell the vehicle.
What is a preventive maintenance log?
A preventive maintenance (PM) log lists planned tasks with their intervals and records each time they are done. Where the general log looks back, the PM log looks ahead: its main column is the next due date or meter reading. Build it from the manufacturer's schedule and the rules above, then adjust intervals with your own failure history. Group the tasks by what triggers them:
- Calendar tasks, monthly, quarterly or yearly: inspections, filter changes, safety checks.
- Meter tasks, every so many hours, miles or cycles: oil changes, belt and bearing service.
- Condition tasks, triggered when a reading crosses a limit: vibration, temperature, oil analysis. These are predictive maintenance in the sense above.
- Regulatory tasks with fixed dates, such as the annual commercial vehicle inspection or the monthly crane hook check.
Track the PM completion rate: tasks done on time divided by tasks due. If an asset keeps breaking down despite on-time PM, the interval or the task itself is wrong.
How do you set up a maintenance log template in Excel?
A spreadsheet works well for a few dozen assets. Set it up so it stays clean as it grows:
- Put the log in an Excel table. "Every table column has filtering enabled in the header row so that you can filter or sort your table data quickly", which is how you pull up one asset's history (Microsoft, Excel tables).
- Use drop-down lists for Asset ID, Work type and Status. "Drop-downs allow people to pick an item from a list that you create" (Microsoft, drop-down lists), so one asset is never typed three different ways.
- Add a calculated column for Next due. "By entering a formula in one cell in a table column, you can create a calculated column in which that formula is instantly applied to all other cells in that table column" (Microsoft, Excel tables). For a 90-day task, Next due is the Date cell plus 90.
- Keep the asset list on a second sheet, and never reuse an asset ID.
- Save a dated copy each month, or store the file where version history is on.
When the log outgrows a spreadsheet, the next step is a computerized maintenance management system (CMMS). The Department of Energy's guide defines a CMMS as "a type of management software that performs functions in support of management and tracking of O&M activities" and suggests asking: "Are you able to access historical information on the last time a system was serviced, by whom, and for what condition?" A CMMS adds "Historical tracking of all work orders generated which become sortable by equipment, date, person responding, etc." (DOE FEMP O&M guide, chapter 4). It "does not make decisions"; it only holds what people enter, so the habits above still decide its quality.
Plants that run a manufacturing execution system often record downtime reasons there as well. Keep the asset IDs the same in both systems.
Maintenance log example: a small fleet and shop (illustration)
An illustrative maintenance log for a fictional company with two trucks, a trailer, a forklift and an air compressor. Asset IDs, readings and work are invented for this page.
| Date | Asset | Meter | Type | Problem or task | Work done | By | Downtime | Next due |
|---|---|---|---|---|---|---|---|---|
| Mar 3 | TRK-07 tractor | 412,880 mi | Preventive | Service A due | Oil and filters changed, brakes adjusted, tires checked | Tech 2 | 3 h | 427,880 mi |
| Mar 5 | TRK-07 tractor | 413,410 mi | Corrective | DVIR: left marker lamp out | Bulb and socket replaced; DVIR certified as repaired | Tech 2 | 0.5 h | None |
| Mar 6 | FL-02 forklift | 6,214 h | Inspection | Daily pre-shift check | Hydraulic leak at tilt cylinder; truck tagged out of service | Operator 14 | Until repaired | Repair before use |
| Mar 6 | FL-02 forklift | 6,214 h | Corrective | Tilt cylinder leak | Seal kit installed; leak test passed; returned to service | Tech 1 | 5 h | PM at 6,464 h |
| Mar 10 | CMP-01 air compressor | 18,902 h | Predictive | Vibration reading above limit | Motor bearing replaced; vibration back within limit | Outside shop | 6 h | Next monthly reading |
| Mar 12 | TRL-11 trailer | None | Inspection | Annual periodic inspection | Passed; report on file and decal applied | Qualified inspector | 2 h | March next year |
Read across the forklift rows. The daily check found the leak, the truck stayed out of service until it was fixed, and the repair entry closed the loop. That chain, from symptom to fix to return to service, is what a useful log shows. If you track costs, give parts and labor their own columns.
How long should you keep maintenance records?
Keep the legal minimum, then keep the history for the life of the asset. The fleet minimums are in the table above. Under OSHA's process safety rule, "Incident investigation reports shall be retained for five years" (29 CFR 1910.119), and mechanical integrity records stay with the equipment they describe.
Beyond the rules, a full history pays off three ways. It shows the next owner of a machine or truck how it was cared for, it supports warranty claims, and it shows which assets fail most so you can plan replacements.
When you change systems, export the whole history first, with asset IDs, dates, meter readings and notes, and keep it in an open format such as CSV beside the new system.
Common mistakes with maintenance logs
Most weak logs fail on consistency, not on the template.
- Entries that say "serviced" or "OK" with no readings, findings or parts.
- Asset IDs typed differently from one entry to the next, or reused after a machine is scrapped.
- Logging preventive work but not breakdowns, so the history hides the failures.
- No meter reading, so nobody can tell whether a service was on time.
- Defects found on a daily check that never reach the log, or never get closed.
- One technician's private notebook instead of a shared log.
- Throwing away old logs when a retention period ends while the equipment is still in use.
Are years of maintenance logs also a data asset?
They can be, for companies that own and run the equipment. AI data buyers have asked Origin for the maintenance history that equipment owners keep: work orders with failure codes, technician notes, root-cause analyses and what happened after each repair, over years of linked history on the same assets. A log kept the way this page describes, with stable asset IDs, written findings and the result of each repair, holds exactly that. See licensing industrial maintenance records for the rights questions, and field service records if your company services other people's equipment.
What must come out first: critical infrastructure details such as network diagrams, protection settings and the exact locations of critical assets, copied OEM manual pages and service bulletins, an outside contractor's confidential methods or prices, and technician names, badge numbers and injury details. The de-identification guide covers replacing names with codes, and the data inventory template helps you list what you hold.
Origin is an independent data partner. Your company decides what is shared and signs any license itself, and a buyer may pay Origin when a deal closes.
Does your company hold records like these? See what your data is worth.
Common questions
What is the difference between a maintenance log and a maintenance schedule?
A maintenance schedule looks ahead: it lists the tasks each asset needs and when they are due, by date or by hours, miles or cycles. A maintenance log looks back: it records what was actually done, when, by whom and what was found. Most teams combine the two in one template, with a next-due column that turns each finished job into the next scheduled one.
How long do you have to keep truck maintenance records?
Under FMCSA rules, a motor carrier keeps inspection, repair and maintenance records for each vehicle for 1 year where the vehicle is housed or maintained, and for 6 months after the vehicle leaves its control. Driver vehicle inspection reports and repair certifications are kept for three months, and periodic inspection reports for fourteen months. These are minimums; many fleets keep the full history for the life of the vehicle.
What should a vehicle maintenance log include?
At minimum: the vehicle's identity (unit number, make, serial number and year), the date and odometer reading of each service, what was inspected, repaired or replaced, who did the work, and when the next service is due. For commercial trucks, FMCSA rules require the vehicle identification, a way to show the nature and due date of upcoming maintenance, and a dated record of the work.
Is a driver vehicle inspection report the same as a maintenance log?
No. A driver vehicle inspection report (DVIR) is the driver's end-of-day report of defects on one vehicle, and the carrier certifies on it that each defect was repaired or that repair is unnecessary. The maintenance log is the carrier's running record of all inspection, repair and maintenance on the vehicle. Defects from each DVIR should flow into the maintenance log as corrective entries.
Can I keep a maintenance log in Excel instead of maintenance software?
Yes, for a small number of assets. Use an Excel table so you can filter one asset's history, drop-down lists for asset IDs and work types, and a calculated column for the next due date. Move to a computerized maintenance management system when you cannot easily see when each asset was last serviced, by whom and why, or when several people need to log work at once.
What is the difference between preventive and corrective maintenance?
Preventive maintenance is planned work done on a calendar or run-time schedule to stop wear before it causes a failure, such as oil changes, lubrication and filter changes. Corrective, or reactive, maintenance is repair after something breaks or a defect is found. A good maintenance log tags each entry with its type, so you can see how much work was planned and which assets keep breaking.
How often should forklifts be inspected under OSHA rules?
OSHA requires powered industrial trucks to be examined before they are placed in service, at least daily, and after each shift where they run around the clock. A truck found to need repair, or unsafe in any way, is taken out of service until it is restored to safe operating condition. Many sites record the daily check on a pre-shift checklist and copy any defect into the maintenance log.
Who should sign a maintenance log entry?
The person who did the work, and for safety-critical work the person who checked it. OSHA's process safety rule asks for the name of the person who performed each inspection or test, and its crane rule asks for the inspector's signature on certain monthly certification records. For other equipment, a name or technician ID on every entry plus a supervisor's review is common practice.
Sources and further reading
- eCFR: 49 CFR Part 396, Inspection, Repair, and Maintenance (FMCSA)
- OSHA: 29 CFR 1910.178, Powered industrial trucks
- OSHA: 29 CFR 1910.179, Overhead and gantry cranes
- OSHA: 29 CFR 1910.119, Process safety management of highly hazardous chemicals
- PNNL, O&M Best Practices: Maintenance Approaches (DOE Federal Energy Management Program)
- DOE FEMP: O&M Best Practices Guide, Release 3.0, Chapter 4, Computerized Maintenance Management System
- Microsoft Support: Overview of Excel tables
- Microsoft Support: Create a drop-down list (Excel)
