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

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

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.
As of46342
Vehicles8Services overdue2
Distance driven12,350Services due soon1
Fuel bought723.9Registration or insurance expired1
Fuel cost2,991.47Registration or insurance expiring soon2
Service cost9,177.50Highest cost per mile (unit)V06
Total cost12,168.97Lowest cost per mile (unit)V05
Fleet cost per mile0.99
Fleet fuel economy17.06
MonthFuel costService costMonth startService typeJobsCost
Jun 20260.00340.0046174Scheduled service71,697.50
Jul 20260.00635.0046204Tyres34,160.00
Aug 20260.000.0046235Brakes2950.00
Sep 20260.003,469.5046266Repair32,275.00
Oct 20261,883.063,583.0046296Inspection195.00
Nov 20261,108.41815.0046327Other00.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

  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.

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 sheetIn 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 · Ask for a demo

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

All templates · Free tools