Free Vehicle Inspection Checklist for Excel

A daily checklist the driver fills in before the first trip, plus the log and register behind it: a vehicle with a reported defect stays OUT OF SERVICE until the repair is entered, and services and annual inspections show OVERDUE or DUE SOON. Works in Microsoft Excel and Google Sheets.

Preview of the vehicle register with unit number, type, location and status: in service, overdue, due soon and out of service

What a vehicle inspection checklist covers

A daily vehicle inspection is the driver's check before the first trip: a walk-around with the engine off, a look under the hood, then the cab and controls with the engine running. For commercial vehicles the law requires it: the driver checks the vehicle is safe before driving, reported defects are repaired before it runs again, and each vehicle gets an annual inspection. Company cars and vans outside those rules follow the same routine because it is how flat tires and failed brakes get caught in the yard rather than on the road.

The Daily Checklist prints one sheet per vehicle per week, a column per day:

  • Walk-around (engine off): tire inflation and tread, wheels and lug nuts, all lights, windshield and mirrors, wipers and washer fluid, body and load area, leaks under the vehicle.
  • Engine bay: engine oil, coolant and brake fluid levels.
  • Cab and controls (engine on): service and parking brakes, steering play, horn, seat belts, dashboard warning lights, the fire extinguisher, warning triangles and first-aid kit, and the documents on board.

A sheet records that someone looked; it cannot keep a van with a worn tire in the yard tomorrow. So the workbook keeps the record behind it:

Inspection Log. One row per defect report, service, annual inspection or repair, with PASS or FAIL. A FAIL stays an OPEN DEFECT until the repair date is entered.

Vehicle Register. One row per vehicle, with type, location, make and model and plate. It reads the log, shows OUT OF SERVICE while a defect is open, and runs two clocks: the service interval per type from the Vehicle Types tab (six months for cars and pickups, four for cargo vans, three for box trucks and tractors, all editable) and the 12-month annual inspection, which also counts as a service. Status reads OVERDUE when either clock runs out, DUE SOON two weeks before a service or a month before the annual, and IN SERVICE otherwise.

For trailers, use the trailer inspection checklist; the maintenance log template keeps the full service history of each vehicle.

Who uses a vehicle inspection checklist

Drivers do the daily check. The fleet manager and the shop need the rest.

Delivery and courier fleets

Cargo vans that run every day and change drivers between shifts.

Field service companies

Service trucks and pickups that technicians take home and drive to jobs.

Construction contractors

Pickups and box trucks moving crews and equipment between sites.

Company car pools

Pool cars and SUVs booked by different employees each week.

Municipal and utility fleets

Mixed fleets of cars, trucks and service bodies with their own inspection schedules.

Fleet maintenance shops

Defect reports to repair, services and annual inspections across the fleet.

Before you fill it in

The van with the bad tire went out again this morning.

Try UNIO24 to automate vehicle inspections.

Try UNIO24 Free

A spreadsheet goes out of date within days, and keeping it current takes someone's time every day. UNIO24 automates that work: each inspection, defect and repair updates the vehicle's record as it happens.

Your vehicle register, six months in
The same check in UNIO24
A submitted daily vehicle pre-trip inspection in UNIO24 for a cargo van: odometer reading, walk-around items marked pass, and the tires item marked failed with the comment "Left front tire worn to the wear bar"
UNIO24Mobile during a daily vehicle inspection: the tires question marked Fail with the comment "Left front tire worn to the wear bar"
Feature comparison
CapabilityFree TemplateUNIO24 FreeRecommended for growing fleets
Inspections
Daily vehicle checklistThe template prints a weekly sheet per vehicle. UNIO24 runs a ready-made pre-trip template on the driver's phone.PartialYes
Photos of the damageThe cracked mirror or the worn tire, attached to the inspection.NoYes
Defects and due dates
Keep a vehicle with a defect off the roadThe register shows OUT OF SERVICE from the log. UNIO24 records the defect and can turn it into a repair work order.PartialYes
Service and annual inspection datesBoth track them. UNIO24 also schedules the next inspection.PartialYes
Data & reliability
Many drivers and depots at onceA shared file gets overwritten. UNIO24 handles simultaneous users.PartialYes
Full history per vehicleEvery inspection, defect, repair and service kept on the vehiclePartialYes
Full support0/ 66/ 6

Frequently Asked Questions

About vehicle inspections and the template

Is the vehicle inspection checklist free?

Yes. No cost, no subscription, no card. Enter your name and email and the Excel file downloads straight away.

Is a daily vehicle inspection required by law?

For commercial vehicles, yes: the law requires the driver to check the vehicle is safe before driving, and reported defects to be repaired before the vehicle runs again. For company cars and light vans it is usually a company policy rather than a legal duty. Check the rules that apply to your vehicles.

How often should fleet vehicles be serviced?

Follow the manufacturer's interval by miles or months, whichever comes first, and shorten it for hard use. The template defaults to six months for cars and pickups, four for cargo vans and three for box trucks, tractors and service trucks. Change it on the Vehicle Types tab.

What should a daily vehicle inspection include?

Tires and wheels, all lights, windshield, mirrors and wipers, fluid levels and leaks, brakes, steering, horn, seat belts, dashboard warning lights, the safety kit and the documents on board. The checklist in this file groups them into a walk-around with the engine off, the engine bay, and the cab with the engine running.

What is a DVIR?

A driver vehicle inspection report lists the defects a driver found on the vehicle. For commercial vehicles, reported defects must be repaired before the vehicle is operated again. In this file, a report with defects is logged as a FAIL and keeps the vehicle OUT OF SERVICE until the repair date is entered.

Does it work for trailers?

Trailers have their own checks: coupling, landing gear, air lines and glad hands. Use the trailer inspection checklist for them.

up arrow