Maintenance Records & Work Orders · Excel template

Free Vehicle Maintenance Log

A running per-vehicle maintenance log that records every service, repair, part, and cost, laid out to carry the four record elements 49 CFR 396.3(b) requires, and the service history that protects resale value and warranty claims. Use it alongside our fleet calculators to size the costs this template tracks, or browse fleet management software when you are ready to automate the workflow. See all downloads in the template library, and check the fleet glossary for any unfamiliar terms.

Built and reviewed by the FleetOpsClub research team. Preview it free below.

  • Columns for date, odometer, service type, parts, labor, vendor, and cost
  • The four record elements 49 CFR 396.3(b) requires of a motor carrier: vehicle identification (company number, make, serial number, year, tire size), the nature and due date of each inspection and maintenance operation, a record of inspections/repairs/maintenance with date and nature, and, for buses, the pushout-window and emergency-door test record
  • Retention built into the layout: maintenance records must be kept where the vehicle is housed or maintained for 1 year, and for 6 months after the vehicle leaves the carrier's control (49 CFR 396.3(c))
  • A retention column that also covers the three shorter clocks: 3 months for a DVIR and its repair certification (49 CFR 396.11(a)(4)), 12 months for a roadside inspection report (49 CFR 396.9(d)(3)(ii)), 14 months for an annual periodic inspection report (49 CFR 396.21(b)(1))
  • Editable CSV. Yours to keep
  • Print or save as PDF
  • No spam · unsubscribe anytime

How to use it

  1. 1

    Open a tab or sheet per vehicle and head it with the identification 49 CFR 396.3(b)(1) asks for (company/unit number, make, serial number (VIN), year, and tire size) plus the name of whoever furnishes the vehicle if you do not own it.

  2. 2

    Log every service the moment it's completed: date, odometer, and what was done. 49 CFR 396.3(b)(3) asks only for the date and the nature of the work, so a one-line entry made on the day is compliant; a detailed entry made from memory a month later is not, because it is no longer a record.

  3. 3

    Record parts, labor hours, vendor, and total cost so the log doubles as a spend record.

  4. 4

    Fill the retention column from the record class, not from habit: a maintenance record runs 1 year on site plus 6 months after the vehicle leaves your control, a DVIR 3 months, a roadside inspection report 12 months, an annual inspection report 14 months.

  5. 5

    Post the due date of the next inspection or service in the same row: 49 CFR 396.3(b)(2) requires a means to indicate the nature and due date of upcoming operations, and a log that only records the past does not satisfy it.

  6. 6

    Reference the log before scheduling work to avoid duplicate service.

  7. 7

    Keep the log where the vehicle is housed or maintained, which is where 49 CFR 396.3(c) says the records must be retained, not only in a head-office folder.

What's inside

  • Columns for date, odometer, service type, parts, labor, vendor, and cost
  • The four record elements 49 CFR 396.3(b) requires of a motor carrier: vehicle identification (company number, make, serial number, year, tire size), the nature and due date of each inspection and maintenance operation, a record of inspections/repairs/maintenance with date and nature, and, for buses, the pushout-window and emergency-door test record
  • Retention built into the layout: maintenance records must be kept where the vehicle is housed or maintained for 1 year, and for 6 months after the vehicle leaves the carrier's control (49 CFR 396.3(c))
  • A retention column that also covers the three shorter clocks: 3 months for a DVIR and its repair certification (49 CFR 396.11(a)(4)), 12 months for a roadside inspection report (49 CFR 396.9(d)(3)(ii)), 14 months for an annual periodic inspection report (49 CFR 396.21(b)(1))
  • A chronological service ledger for each vehicle
  • Cost tracking you can total per vehicle and per period
  • Example entries showing how to log routine service, an unplanned repair, a DVIR defect repair, and an annual inspection
  • Editable spreadsheet you can extend per unit

Preview the template

Here's a real sample of the layout — the actual columns and structure you'll work in. The complete template, plus the editable spreadsheet, unlocks the moment you enter your email.

Preview

Vehicle Maintenance Log

Head each sheet with the vehicle identification 49 CFR 396.3(b)(1) requires: company/unit number, make, serial number (VIN), year, tire size. Retention, from the CFR text (checked 2026-09-30): maintenance records 1 year where the vehicle is housed or maintained, plus 6 months after it leaves your control (396.3(c)); DVIR and its repair certification 3 months (396.11(a)(4)); roadside inspection report 12 months, with corrections certified to the issuing agency within 15 days (396.9(d)(3)); annual periodic inspection report 14 months (396.21(b)(1)).

DateOdometer (mi)Record TypeService / RepairPartsLabor (hrs)VendorCost (USD)Next DueRetain Until
2026-01-1262,300PM serviceOil & filter change5W-30, oil filter0.6In-house78.0070,300 mi2027-01-12 (1 yr · 396.3(c))
2026-02-0464,910RepairFront brake padsPads, hardware kit1.4Midtown Auto265.00—2027-02-04 (1 yr · 396.3(c))

Frequently asked questions

Quick answers to the questions buyers usually ask once the category, software, or rollout details start getting more specific.

A

The schedule says what's due; the log records what was actually done. Together they give you a defensible service history: essential for warranty claims, resale value, and demonstrating diligence after an incident.

A

At minimum: date, odometer, the work performed, parts used, and cost. Vendor and labor hours make the log useful for budgeting and cost-per-mile analysis too.

A

Under 49 CFR 396.3(c), the records must be retained where the vehicle is either housed or maintained for 1 year, and for 6 months after the vehicle leaves the motor carrier's control. Three related records run on different clocks: a driver vehicle inspection report and its certification of repairs is 3 months (49 CFR 396.11(a)(4)), a roadside inspection report is 12 months (49 CFR 396.9(d)(3)(ii)), and an annual periodic inspection report is 14 months (49 CFR 396.21(b)(1)). Those four periods are why the template carries a retention column rather than one blanket rule.

A

49 CFR 396.3(b) lists four elements, and requires the records for each motor vehicle a carrier controls for 30 consecutive days. They are: an identification of the vehicle including company number if so marked, make, serial number, year and tire size, plus the name of the person furnishing it if the carrier does not own it; a means to indicate the nature and due date of the various inspection and maintenance operations to be performed; a record of inspections, repairs and maintenance indicating their date and nature; and a record of tests conducted on pushout windows, emergency doors and emergency door marking lights on buses. Note the second one: a log that records only completed work misses half the requirement, because the due date of upcoming work has to be visible too.

A

A complete, consistent service history is one of the strongest signals a vehicle was cared for. Buyers and auction houses pay more for documented maintenance.

A

49 CFR 396.3(c) is specific: the records are retained where the vehicle is either housed or maintained. A central spreadsheet satisfies that only if the terminal the vehicle runs out of can produce it on demand. The same wording appears again for annual inspection reports in 49 CFR 396.21(b)(1). The original or a copy must be retained where the vehicle is housed or maintained, for 14 months.

A

Yes, one interval that has no equivalent on a truck. 49 CFR 396.3(a)(2) requires that pushout windows, emergency doors and emergency door marking lights in buses be inspected at least every 90 days, and 49 CFR 396.3(b)(4) requires the record of those tests to live in the same maintenance records. Add a row class for it so the 90-day clock is visible next to the mileage-based services rather than tracked separately.

A

For a handful of vehicles, a well-kept spreadsheet like this one is genuinely enough: it's the discipline of logging every event, not the tool, that produces a usable service history. It tends to strain once several people need to edit it at once, once you want automatic mileage-based due-date reminders, or once the fleet grows past what one person can review weekly; that's the point most fleets move to dedicated software.