# Fleet Maintenance and Fuel Log Excel Template

> A free Excel fleet log: record fuel and service per vehicle, see cost per mile and fuel economy, the next service due, and expiring registration and insurance.

Source: https://softwiro.com/templates/fleet-maintenance-log
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Fleet Fuel and Maintenance Log Template for Excel

A free Excel workbook for a small fleet of vans, trucks, pickups or cars. You log each fill-up and each service job against a unit ID, and the sheet works out how far each vehicle has driven, what it has cost in fuel and service, the cost per mile, the fuel economy, and when the next scheduled service is due. A Due List collects the vehicles that need attention, including expired or expiring registration and insurance. It opens in Excel, LibreOffice and Google Sheets, and you can switch the labels from miles and gallons to kilometres and litres.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-fleet-maintenance-log.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-fleet-maintenance-log-blank.xlsx)

Excel file (.xlsx) · 159 KB · 9 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## 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](https://softwiro.com/templates/small-business-budget-tracker).

## How to use it

1. 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).
2. 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).
3. On the Fuel sheet log every fill-up: date, unit ID, odometer, quantity and price per unit.
4. 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.
5. The Vehicles sheet calculates current odometer, distance driven, fuel and service cost, cost per mile, fuel economy, the next service due and its status.
6. 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.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-fleet-maintenance-log.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-fleet-maintenance-log-blank.xlsx)

Excel file (.xlsx) · 159 KB · 9 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## 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. |

[See Custom Software from Softwiro](https://softwiro.com/contact) · [Ask for a demo](https://softwiro.com/contact)

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person updates | Every driver and mechanic logs their own entries with a login |
| You type each fill-up | Fuel and mileage arrive from the driver's phone or a fuel card |
| A due list you check yourself | Reminders sent when a service or renewal is close |
| Fixed columns and intervals | Rules for your vehicles, routes and depots |
| Charts inside the workbook | A live dashboard for the owner |

### Extra features in the app

- Drivers log their own fuel and mileage from a phone, with a photo of the receipt
- Service reminders sent to the fleet manager and the driver before they are due
- A work order for each job, with the vendor, parts and approval
- Documents such as registration and insurance stored with each vehicle
- Alerts when a fill-up looks unusual for that vehicle
- Reports by vehicle, driver, depot or month without building formulas

[Ask for your custom system](https://softwiro.com/contact)

## 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](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](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](https://softwiro.com/templates/for-cars)

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

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
