Try the sheet here, on the example
The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.
Example from the sheet
| As of | 46342 | |||||
|---|---|---|---|---|---|---|
| Vehicles | 8 | Services overdue | 2 | |||
| Distance driven | 12,350 | Services due soon | 1 | |||
| Fuel bought | 723.9 | Registration or insurance expired | 1 | |||
| Fuel cost | 2,991.47 | Registration or insurance expiring soon | 2 | |||
| Service cost | 9,177.50 | Highest cost per mile (unit) | V06 | |||
| Total cost | 12,168.97 | Lowest cost per mile (unit) | V05 | |||
| Fleet cost per mile | 0.99 | |||||
| Fleet fuel economy | 17.06 | |||||
| Month | Fuel cost | Service cost | Month start | Service type | Jobs | Cost |
| Jun 2026 | 0.00 | 340.00 | 46174 | Scheduled service | 7 | 1,697.50 |
| Jul 2026 | 0.00 | 635.00 | 46204 | Tyres | 3 | 4,160.00 |
| Aug 2026 | 0.00 | 0.00 | 46235 | Brakes | 2 | 950.00 |
| Sep 2026 | 0.00 | 3,469.50 | 46266 | Repair | 3 | 2,275.00 |
| Oct 2026 | 1,883.06 | 3,583.00 | 46296 | Inspection | 1 | 95.00 |
| Nov 2026 | 1,108.41 | 815.00 | 46327 | Other | 0 | 0.00 |
Example from the “Dashboard” tab, with the numbers and formulas that are in the file.
What is inside
- Dashboard: Fleet totals (distance, fuel bought, fuel cost, service cost, total cost, cost per mile and fuel economy), counts of overdue and due-soon services and of expired or expiring papers, the vehicles with the highest and lowest cost per mile, and three charts: cost by vehicle, fuel and service cost by month, and service cost by type.
- Due List: The vehicles that need attention, overdue and expired first, with plate, driver, service status, distance to the next service, next service date, papers status and days to expiry. Shows up to 40 vehicles.
- Vehicles: One row per vehicle with your details (plate, type, make and model, driver, start odometer, registration and insurance dates, service interval). It calculates current odometer, distance driven, fuel and service cost, cost per mile, fuel economy, last scheduled service, next service due and the status. Room for 100 vehicles.
- Fuel: The fill-up log: date, unit ID, odometer, quantity, price per unit and station. It adds the cost and the plate, and flags a unit ID that is not on the Vehicles sheet. Room for 1,000 entries.
- Service: The maintenance log: date, unit ID, odometer, type, cost and vendor. A job of type Scheduled service resets the vehicle's service clock. Room for 500 entries.
- Lists: Your vehicle types and service types for the dropdowns.
- Settings: Today's date, the alert window, the distance margin before a service is due, currency symbol, units and company name.
The file opens on a start tab (“Start here”) that explains how to use it.
What makes it different
A log that only records what happened cannot tell you what is due next. This workbook turns the log into a schedule: each vehicle has a service interval in distance and days, and the status moves from OK to Due soon to Overdue on its own. Fuel, service, registration and insurance are in one file, and the cost per mile counts both fuel and service, not fuel alone. The sample is a small fleet of eight vehicles with entries in October and November 2026.
How do I keep a fleet maintenance log in Excel?
Give each vehicle a unit ID on the Vehicles sheet, with its odometer reading on the day you start tracking. Then add a row to the Service sheet for every job: the date, the unit ID, the odometer, the type and the cost. Use the type Scheduled service for the regular oil and inspection visit, because that is the entry that restarts the service clock.
Set how often each vehicle needs service, in distance and in days. The sheet adds those to the last scheduled service to give the next service odometer and date. In the sample, two vehicles are overdue for service, one is due soon, and the Due List puts them at the top.
How do I calculate fleet cost per mile and fuel economy?
Cost per mile is the total of fuel and service cost divided by the distance the vehicle has driven since you started tracking. Fuel economy is the distance driven divided by the fuel bought. Both are on the Vehicles sheet for each unit and on the Dashboard for the whole fleet. In the sample the fleet has driven 12,350 miles at a cost of 0.99 per mile and 17.06 miles per gallon.
Use the same units and the same currency throughout. For a fair fuel economy figure, fill the tank each time and start tracking on a full tank, because the sheet divides all the fuel bought by all the distance driven. Compare vehicles of the same type: in the sample the box truck costs 2.54 per mile and the pickup 0.37.
How do I track registration and insurance renewals for a fleet?
Type the registration and insurance expiry dates on the Vehicles sheet. The sheet takes the earlier of the two, compares it with the As of date and marks the vehicle Expired, or Expiring soon when it falls inside the alert window. Those vehicles join the Due List. Check your local rules for what must be renewed and when; the sheet only tracks the dates you enter. For general business spending, see the business expenses budget.
How to use it
- On the Settings sheet type today's date (the As of date), the alert window in days, the distance margin for a service coming due, and your units (miles and gallons, or kilometres and litres).
- On the Vehicles sheet add one row per vehicle: unit ID, plate, type, make and model, driver, the odometer when you start tracking, registration and insurance expiry dates, and how often it needs a scheduled service (distance and days).
- On the Fuel sheet log every fill-up: date, unit ID, odometer, quantity and price per unit.
- On the Service sheet log every job: date, unit ID, odometer, type and cost. Choose the type Scheduled service for the regular service: it resets that vehicle's service clock.
- The Vehicles sheet calculates current odometer, distance driven, fuel and service cost, cost per mile, fuel economy, the next service due and its status.
- Open Due List for the vehicles that are overdue or due soon for service, or whose registration or insurance is expired or expiring, and Dashboard for fleet totals and charts.
Before you start:
- Capacity: 100 vehicles, 1,000 fuel entries and 500 service entries. The Due List shows the first 40 vehicles that need attention.
- Current odometer = the highest odometer in the Fuel log for the vehicle (or its start reading if it has no fuel entries yet). Distance driven = current odometer - start odometer.
- Cost per mile = (fuel cost + service cost) / distance driven. Fuel economy = distance driven / fuel bought; it is closest to true when you fill the tank every time and start tracking on a full tank.
- Next service due is the last Scheduled service odometer + the distance interval, and its date + the day interval. If a vehicle has no Scheduled service logged yet, the start odometer is used for the distance.
- Service status: Overdue (past the due odometer or date), Due soon (within the distance margin or the alert window), OK. Registration and insurance use the earlier of the two dates.
- The labels miles and gallons come from Settings and are only labels: use one unit system and one currency in one workbook.
Still running this on Excel?
This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.
| In this sheet | In Custom Software from Softwiro |
|---|---|
| One file that one person edits at a time, and copies reach you on WhatsApp. | A program with a login for each user and permissions you define, and everyone sees the same data. |
| You type everything and check the numbers by hand. | We design the screens around your work steps, so each person records only what concerns them. |
| Columns and formulas are fixed as the sheet was designed. | We build what you need: reports, alerts and screens your way. |
| Backups and security are your own responsibility. | The program runs on a secured server with regular backups. |
Frequently asked questions
Is this fleet maintenance log really free?
Yes. Download it, use it for your fleet and change anything you like. There is nothing to sign up for to open the file.
Does it work in kilometres and litres?
Yes. Change the distance unit and fuel unit on Settings. They are labels, so the figures stay as you typed them. Use one unit system in one workbook.
How many vehicles can it hold?
100 vehicles, 1,000 fuel entries and 500 service entries. The Due List shows the first 40 vehicles that need attention. Spreadsheets get harder to keep accurate as the fleet and the number of people entering data grow.
How does it know a service is due?
From the last entry of type Scheduled service for that vehicle, plus the distance and the days you set. It is Due soon when the vehicle is within the distance margin or the alert window, and Overdue when either has passed.
Does it work in Google Sheets and LibreOffice?
Yes. It uses only ordinary formulas such as SUMIFS, COUNTIFS, INDEX, MATCH and IF, so it works in Excel 2016 and later, LibreOffice and Google Sheets.
Is the template free?
Yes, with no sign-up and no email address. Use it, edit it and share it as you like.
Does it work in Google Sheets and on mobile?
The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.
What is the difference between the white and the gray cells?
You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.
Can I use the sheet from an AI assistant?
Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html
All the templates in this group: Free Excel templates for cars: showroom, rental, workshop and maintenance
More free templates for: Transport and cars
More free templates
- Car Rental Booking Tracker for Excel
- Auto Parts Inventory and Sales Spreadsheet for Excel
- Ad Performance Tracker for Excel (ROAS, CPA)
- A/B Test Log Template for Excel (Experiment Tracker)
- Ecommerce Profit Margin Calculator for Excel
- Installment Payment Tracker for Excel
- Social Media Content Calendar Template for Excel
- Class Schedule Maker for Excel
- GPA Calculator for Excel (Weighted and Unweighted, by Term)
- Lesson Plan Template for Excel with Curriculum Tracker