What is a fleet asset register?
A fleet asset register is the master list of every vehicle and unit you operate: what it is, where it is, who uses it, who owns it and when its documents expire. It is the one place everyone checks before they plan maintenance, renew insurance, assign a driver or replace a vehicle, so it has to be complete and current.
This fleet asset register template in Excel keeps that list in one sheet, calculates the next document renewal for every vehicle, summarizes the fleet by type, site and ownership, and adds a custody log for fuel cards, tools and devices.
What should you record for each vehicle?
| Group | Fields |
|---|---|
| Identity | Vehicle ID, plate, VIN or chassis number, type, make, model, year |
| Use | Site, department, assigned driver, status (active, off road, disposed) |
| Ownership | Owned, leased or rented; acquisition date and price; lease end |
| Documents | Registration expiry, insurance expiry, next periodic inspection |
| Meter | Current odometer |
Pick one vehicle ID format, such as TRK-07, and use it in every other file. That is what lets the fuel log, maintenance schedule and budget link back to this register.
How to use the fleet asset register
- Set up the lists of vehicle types, sites and drivers on the Settings sheet.
- Add one row per vehicle with its identity, use, ownership and document dates.
- Filter the Documents column every week for Expired and Due soon, and start renewals.
- Update the odometer monthly, or whenever you record a service.
- Mark a vehicle Disposed when it leaves the fleet. Keep the row for the record.
How does the register track renewals?
In the example, TRK-07's insurance ends in 22 days, so it is due soon; TRK-11's registration expired 9 days ago. Disposed vehicles are left out of renewals.
Fleet summary by type, site and ownership
The summary counts the fleet's vehicles, split into active and off road, and shows average age and documents expired or due soon. Tables by type, site and ownership show where the fleet is and how it is held, which helps when you plan replacements or compare depots.
Custody log for fuel cards, tools and equipment
Fuel cards, tools, tablets, keys and safety equipment go missing when nobody records who has them. The custody log records each item, who it was issued to and when it is due back. Days out are calculated, and items past their return date are marked Overdue.
Limits of a spreadsheet asset register
The register is only as good as the last update. Odometer readings, drivers and status change every day, and a spreadsheet does not know until someone types it in. The template does not send renewal reminders or read vehicle data.