Free template · no email required
Free fleet maintenance spreadsheet template
A ready-to-use spreadsheet for small shops running a handful of trucks. Track every truck, its service history, the registration and insurance dates that get it pulled off the road, and what each one actually costs to run. Works in Excel or Google Sheets.
Free forever · no sign-up, no email wall · yours to edit however you like
What’s inside
Five tabs, already set up with headers and formulas. Below is exactly what you get — the example rows belong to a fictional shop, Ridgeline Heating & Air, so you can see how each tab is meant to be filled in. Delete them and add your own trucks.
Trucks
One row per truck — the master list every other tab points back to. Add a truck once here; reference it by unit number everywhere else.
| Unit | Year | Make | Model | VIN | Plate | Current mileage | Assigned to | Status |
|---|---|---|---|---|---|---|---|---|
| Truck 1 | 2019 | Ford | F-250 | 1FTBF2B69KEC12345 | VAN-4471 | 84,210 | Mike R. | Active |
| Truck 2 | 2021 | Ram | 2500 | 3C6UR5DL7MG512244 | VAN-5590 | 61,340 | Dana P. | Active |
| Truck 3 | 2018 | Chevrolet | Silverado 2500 | 1GC1KVEY3JF118834 | VAN-3320 | 103,880 | Luis T. | Active |
| Truck 4 | 2020 | Ford | Transit 350 | 1FTBW2CM7LKA55471 | VAN-6612 | 72,510 | Sam W. | Active |
| Truck 5 | 2022 | GMC | Sierra 2500 | 1GT49PEY6NF241190 | VAN-7788 | 39,960 | Unassigned | Active |
Service log
Every oil change, brake job, and inspection, with the odometer reading and what comes next — so a skipped service shows up before the truck breaks down.
| Date | Unit | Service | Odometer | Vendor | Cost | Next due (date) | Next due (miles) | Notes |
|---|---|---|---|---|---|---|---|---|
| 2026-01-12 | Truck 1 | Oil & filter | 81,000 | QuickLube Plus | $79.95 | 2026-07-12 | 86,000 | Synthetic blend |
| 2026-02-03 | Truck 3 | Front brake pads | 101,200 | Ridgeline Bay | $340.00 | 131,200 | Rotors still good | |
| 2026-02-20 | Truck 2 | Tire rotation | 58,800 | Discount Tire | $25.00 | 65,800 | ||
| 2026-03-15 | Truck 4 | Oil & filter | 70,100 | QuickLube Plus | $84.50 | 2026-09-15 | 75,100 | Full synthetic |
| 2026-04-02 | Truck 5 | State inspection | 37,200 | Ridgeline Bay | $45.00 | 2027-04-02 | Passed | |
| 2026-05-19 | Truck 1 | Coolant flush | 83,400 | Ridgeline Bay | $120.00 | 113,400 |
Registration & insurance dates
The dates that get a truck pulled off the road: registration/tags, insurance, and state inspection expiry per truck. Sort by the soonest date and you always know what to renew next.
| Unit | Registration expires | Insurance expires | Inspection expires | Insurance carrier | Policy # | Notes |
|---|---|---|---|---|---|---|
| Truck 1 | 2026-08-31 | 2026-11-15 | 2026-09-30 | Cornerstone Mutual | CM-88213 | |
| Truck 2 | 2027-01-31 | 2026-11-15 | 2027-02-28 | Cornerstone Mutual | CM-88213 | |
| Truck 3 | 2026-07-15 | 2026-11-15 | 2026-08-15 | Cornerstone Mutual | CM-88213 | Renew soon |
| Truck 4 | 2026-12-31 | 2026-11-15 | 2027-01-15 | Cornerstone Mutual | CM-88213 | |
| Truck 5 | 2027-03-31 | 2026-11-15 | 2027-04-02 | Cornerstone Mutual | CM-88213 |
Cost log
Every dollar a truck costs — fuel, repairs, insurance, registration, maintenance. Tag each line with a unit and category, and the Summary tab totals what each truck really costs to run.
| Date | Unit | Category | Description | Vendor | Amount |
|---|---|---|---|---|---|
| 2026-01-05 | Truck 1 | Fuel | Fill-up | Shell | $92.40 |
| 2026-01-12 | Truck 1 | Maintenance | Oil & filter | QuickLube Plus | $79.95 |
| 2026-02-03 | Truck 3 | Repair | Front brake pads | Ridgeline Bay | $340.00 |
| 2026-02-14 | Truck 4 | Repair | Transmission service | Ridgeline Bay | $890.00 |
| 2026-03-01 | Truck 4 | Repair | A/C compressor | Ridgeline Bay | $1,120.00 |
| 2026-03-15 | Truck 4 | Maintenance | Oil & filter | QuickLube Plus | $84.50 |
| 2026-03-22 | Truck 2 | Fuel | Fill-up | Costco | $88.10 |
| 2026-04-02 | Truck 5 | Registration | Annual renewal | State DMV | $84.00 |
| 2026-04-18 | Truck 4 | Repair | Alternator | Ridgeline Bay | $410.00 |
| 2026-05-06 | Truck 1 | Insurance | Monthly premium | Cornerstone Mutual | $128.00 |
| 2026-05-19 | Truck 3 | Maintenance | Coolant flush | Ridgeline Bay | $120.00 |
| 2026-06-01 | Truck 4 | Fuel | Fill-up | Shell | $96.70 |
Summary
A light dashboard the other tabs feed automatically: total spend per truck (summed from the Cost log) plus a fleet total. No macros — just SUM formulas you can read.
| Unit | Total spend |
|---|---|
| Truck 1 | $300.35 |
| Truck 2 | $88.10 |
| Truck 3 | $460.00 |
| Truck 4 | $2,601.20 |
| Truck 5 | $84.00 |
| Fleet total | $3,533.65 |
Prefer Google Sheets?
Copy the whole template straight into your own Google Drive — every tab and formula comes across, and the plain SUM/SUMIF formulas keep working. Or grab the Excel file above if you'd rather work in Excel.
Opens a copy in your own Google Drive.
What this fleet maintenance spreadsheet tracks
Most shops start with the truck information in three places at once: some of it in the owner's head, some in a notebook in the office, and the rest in the glovebox. This template pulls it into one file with five tabs, each doing one job, so anyone in the shop can open it and see where every truck stands.
The heart of it is the Service log — a plain truck maintenance log that captures every oil change, brake job, tire rotation, and state inspection as it happens, along with the odometer reading, the vendor, what it cost, and when the same job is due again. Because each row records the next-due date and next-due mileage, the log stops being a rear-view record and starts warning you: sort by the soonest due date and the truck that needs attention next rises to the top. Pair that with the Cost log, where every fuel fill-up, repair, insurance payment, and registration fee gets tagged to a unit and a category, and the Summary tab quietly adds up what each truck actually costs to run — so the one that is nickel-and-diming you on repairs stops hiding inside a fleet average. None of it needs a formula you cannot read; it is ordinary SUM and SUMIF, the kind you can audit at a glance.
It is built for the way a small shop actually works — 5 to 25 trucks, no dedicated fleet manager, no telematics contract. You reference each truck by a unit number ("Truck 1", "Truck 2"), and every other tab points back to that master list. Here is what each tab covers:
- Trucks
- One row per truck — the master list every other tab points back to. Add a truck once here; reference it by unit number everywhere else.
- Service log
- Every oil change, brake job, and inspection, with the odometer reading and what comes next — so a skipped service shows up before the truck breaks down.
- Registration & insurance dates
- The dates that get a truck pulled off the road: registration/tags, insurance, and state inspection expiry per truck. Sort by the soonest date and you always know what to renew next.
- Cost log
- Every dollar a truck costs — fuel, repairs, insurance, registration, maintenance. Tag each line with a unit and category, and the Summary tab totals what each truck really costs to run.
- Summary
- A light dashboard the other tabs feed automatically: total spend per truck (summed from the Cost log) plus a fleet total. No macros — just SUM formulas you can read.
How to use the template
You can be tracking your whole shop in about ten minutes. The example rows are sample data for a fictional shop — delete them and drop in your own.
Download the file and open it
Grab the Excel file above, or import it into Google Sheets. Everything is already set up — five tabs, headers, and formulas. Nothing to install.
List your trucks on the Trucks tab
Add one row per truck: unit number, year, make, model, VIN, plate, current mileage, and who drives it. This is the master list the other tabs refer back to, so do it first.
Fill in the registration and insurance dates
On the Registration & insurance dates tab, enter each truck's registration/tags, insurance, and state inspection expiry. Sort the tab by the soonest date and the next thing to renew is always at the top.
Log service as it happens
Every oil change, brake job, or inspection gets a row on the Service log — the date, the odometer reading, the vendor, the cost, and when it is next due (by date or by mileage). This is your maintenance history and your early warning at once.
Record what each truck costs
Drop every fuel fill-up, repair, insurance payment, and registration fee on the Cost log, tagged with the unit and a category. The Summary tab totals it up so you can see which truck is quietly costing you the most.
Check it on a set day each week
The spreadsheet only works if someone opens it. Pick a day — Friday afternoon, first thing Monday — glance at the soonest renewal dates and anything due for service, and handle it before it becomes a problem.
Where the spreadsheet breaks down
A spreadsheet is a genuinely good place to start, and for a two- or three-truck shop it may be all you ever need. But there are four places it tends to fall apart as the shop grows — worth knowing before one of them costs you a truck.
It never warns you
A cell with a date in it does nothing. It will not email you 30 days before a registration lapses or a policy expires. You only find out when someone opens the file and happens to look at the right row — or when a driver gets pulled over with expired tags. The spreadsheet holds the date; it does not watch it.
Nobody keeps it updated
Every shared spreadsheet drifts. A truck gets serviced and nobody logs it; a policy renews and the date never changes. Within a couple of months the file quietly stops matching reality, and a spreadsheet you cannot trust is worse than none — because you think you are covered when you are not.
It lives on one person's computer
When the office manager is out sick, so is the fleet's memory. Nobody else knows what is due, where the insurance card is, or which truck is overdue for brakes. The knowledge is in the file, and the file is on a laptop nobody can get to.
Month-end turns into QuickBooks archaeology
When you finally want to know what Truck 4 actually cost this year, you are cross-referencing the Cost log against QuickBooks by hand, hunting for fuel receipts and repair invoices that never made it into the sheet. The numbers are technically all there — spread across two systems that do not talk to each other.
When you outgrow the spreadsheet
At some point the spreadsheet stops saving you time and starts costing it. Usually it is a specific moment: a truck gets a ticket for tags you thought were current, or you realize nobody has updated the file in a month, or you spend an afternoon at month-end reconstructing costs from QuickBooks. That is the signal that you have outgrown a static file.
FleetClerk is what the spreadsheet is quietly trying to be. It is the same idea — every truck, its dates, its service, its costs, in one place — except it watches the dates for you and emails you 30, 14, and 7 days before anything lapses, so a renewal never depends on someone remembering to open a file. It connects to QuickBooks Online so cost per truck adds itself up instead of waiting for month-end. And it lives online, so the whole shop can see it, not just whoever has the laptop.
You do not have to switch today. Keep the spreadsheet as long as it is working. But when it stops, moving up is easy — and the free plan covers up to 5 trucks with no credit card.
Let FleetClerk watch the dates for you
Free for up to 5 trucks — no card, no contracts.
Everything the spreadsheet does, plus reminders before registration, insurance, inspection, and service lapse — and cost per truck synced from QuickBooks on paid plans.
Fleet spreadsheet questions, answered
Is the template really free?
Yes — free to download, free to use, and free to change however you like. There is no email wall and no sign-up. Share it with anyone in your shop.
Does it work in Excel and Google Sheets?
Both. The file is a standard .xlsx that opens in Excel, Numbers, or LibreOffice, and there's a one-click "Copy to Google Sheets" button on this page that drops the whole template into your own Drive — the formulas are plain SUM and SUMIF, so nothing breaks on the way in.
What does the spreadsheet track?
Five tabs: your trucks (the master list), a service log with next-due dates and mileages, a registration and insurance date tracker, a cost log by truck and category, and a summary tab that totals cost per truck automatically.
Can I use this as a vehicle registration tracker?
Yes. The Registration & insurance dates tab is a registration tracker on its own — sort it by the soonest expiry and the next truck to renew is always at the top. It just cannot remind you the way software can; you have to open it and look.
Can I use it as a truck maintenance log?
That is exactly what the Service log tab is — a running truck maintenance log with a row for every oil change, brake job, and inspection, each with the date, odometer reading, vendor, cost, and when the next service is due (by date or by mileage). Keep it current and it doubles as both your maintenance history and your early warning that a service is coming up.
What's the difference between this and FleetClerk?
The spreadsheet holds your data; FleetClerk acts on it. A spreadsheet cell will not email you before a registration lapses, will not chase whoever forgot to log a service, and will not add up cost per truck from QuickBooks on its own — you have to remember to open the file and keep it current. FleetClerk does all of that automatically and lives online for the whole shop. It is the same information the template tracks, turned into something that watches your trucks instead of just recording them. The free plan covers up to 5 trucks with no credit card.
Will my example data get mixed in with mine?
No — the sample rows are for a fictional shop so you can see how each tab is meant to be filled in. Delete them and add your own trucks. Nothing is connected to a real account.
Weighing a real tool instead? See how FleetClerk compares to Fleetio.