# Generator maintenance Excel sheet (free)

> Free generator maintenance sheet: run-hours log, diesel litres and cost per hour, service due by hours with alerts, breakdowns and monthly cost. No sign-up.

Source: https://softwiro.com/blog/generators-maintenance-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Generator maintenance sheet in Excel (free): run hours, fuel and service

Know each generator's litres and cost per hour, which service is due and what breakdowns cost, from simple logs you type.

20 November 2026 5 min read

## In short

- Register each generator, log every run with hours, litres and cost, and the sheet gives litres and cost per running hour.
- Service is measured in hours since the last service of each type, with status OK, soon or overdue and a ranked alert list.
- Breakdowns with cost and downtime join fuel and service in a total cost per hour and a monthly report.
- The sheet is free, works in Excel, Google Sheets and LibreOffice, and the online version keeps your data in your browser.

You own one generator or several, in a building, shop, factory or farm, and you want to know how much diesel each one burns per hour, when the oil and filters are due before something fails, and what the generators really cost you each month. The free [generator maintenance sheet](https://softwiro.com/ar/templates/generators-maintenance) answers this from three logs you type: runtime, service and breakdowns.

## The problem it solves

A generator runs only when the power fails, so nobody remembers its service until it breaks. Diesel is bought in batches on loose paper, so the cost of a running hour stays unknown and a generator that burns more than its twin goes unnoticed. With sites in several places the paper multiplies. Periodic service is usually measured in running hours, not dates, and the sheet works those hours out from the runtime log itself.

## How it works, step by step

1. In الإعدادات (Settings) type today's date, the analysis period (from and to), the "soon" percentage, the idle days and the report year.
2. In المولدات (Generators) register each one: code, make, kVA, location, fuel type, tank size, service interval in hours and the hour-meter reading before the first log row.
3. In أنواع الصيانة (Service types) edit the list of jobs and each interval in hours.
4. In سجل التشغيل (Runtime log) type each run: date, generator, start and stop meter (or the hours directly), litres added and their cost.
5. In جدول الصيانة (Service schedule) list which service types each generator follows, and record every service done in سجل الصيانة (Service log).
6. The sheet calculates hours since the last service, the hours left and the status: "overdue" when the interval is reached, "soon" at the percentage you set, otherwise "OK".
7. Open التنبيهات (Alerts), الملخص (Summary) and شهري (Monthly) for priorities and costs with charts.

## What each sheet does

- المولدات: the register plus running hours, litres, litres per hour and its cost, total cost per hour, the current meter, how many hours the tank lasts, maintenance status and an idle flag.
- سجل التشغيل: one row per run with the price per litre worked out,.
- التنبيهات: overdue, then soon, then never-serviced items, ordered by priority.
- Service sheets and الأعطال: the type list, the schedule, the service log and the breakdowns.
- شهري and الملخص: fuel, service and repair cost by month and by generator, with four charts.

## Walk-through on the sample numbers

The generators and figures below are sample data in the file, not a real business. The example has 5 generators and 26 runs, today is 20 November 2026 and the analysis period runs from 1 October to 30 November:

- Fuel: 235 running hours and 2,620 litres costing 53,458 in total, an average of 11.15 litres per hour and 20.40 per litre.
- Thirstiest generator: the Cummins 250 with 92 hours and 1,435 litres, or 15.60 litres per hour. The Perkins 100 ran 44 hours on 443 litres, 10.07 per hour. The Honda 5.5 ran 14 hours on 22 litres, 1.57 per hour, and its 15-litre tank lasts about 9.5 hours.
- Service: the Perkins 100 oil was last changed at meter 990 and the meter now reads 1,224, so 234 of 250 hours have passed (94%): "soon", 16 hours left. Its fuel filter has run 524 hours against 500, so it is "overdue" by 24 hours.
- Alert order: most overdue is the Deutz 60 fuel filter (615 hours against 500), then the Perkins filter, then the Cummins oil (262 against 250). The Cummins air filter is "soon" (462 of 500) and its battery check has "no record". In total 9 items are OK, 2 soon, 3 overdue and 1 has no record.
- Idle: the rental Perkins 40 last ran on 5 November, 15 days ago against a limit of 14, so it shows "not run".
- Cost: 5 breakdowns cost 7,080 with 52 hours of downtime (the biggest was the Perkins 100 vibration at 3,200 and 24 hours), and service in the period cost 2,610. Total cost is 63,148, or 268.71 per hour.
- Monthly: October had 145 hours and a total cost of 37,152 (256.22 per hour); November had 90 hours and 25,996 (288.84 per hour).

## Features and why they matter

- Service by hours, not dates: you see the generator that is nearly due even if it hardly ran.
- Litres and cost per hour for each generator: spot the thirsty one and compare sites.
- Total cost: fuel, service and repairs together, so breakdowns are not forgotten.
- Works in Excel 2016 and later, Google Sheets and LibreOffice, free. It holds 20 generators, 1,500 runs, 500 services and 300 breakdowns.

## Common mistakes

- A stop meter below the start: the row turns red and its hours are not counted.
- Leaving the hours before the first log row empty: the meter starts from zero, so service looks earlier or later than it is.

## Putting it to use

Open the sheet and replace the examples with your generators, type each meter from its current reading, then record the last service of each type. If you track cars instead, see the [fleet fuel and maintenance sheet](https://softwiro.com/templates/fleet-fuel-maintenance), and for parts the [spare parts inventory sheet](https://softwiro.com/templates/spare-parts-inventory).

## Who it suits and when it is not enough

It suits an owner of a building, factory, farm or rental generators who types the runs personally. When you have many technicians across sites who should each log from their phone and you want alerts sent automatically, Softwiro can [build a system around the way you work](https://softwiro.com/contact).

## Your next step

Download the sheet, enter one generator with its last meter reading and last service, log this week's run and read its maintenance status in the "المولدات" sheet.

## FAQ

**How do I work out diesel use per hour?** Divide litres added by running hours, which is what the "litres / hour" column does.

**Does the status change when I log a service?** Yes, the latest service meter comes from the log and the status goes back to "OK".

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: generator maintenance (1/3)](https://softwiro.com/uploads/cheatsheets/generators-maintenance/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/generators-maintenance/en-1.jpg)[![Cheat sheet: generator maintenance (2/3)](https://softwiro.com/uploads/cheatsheets/generators-maintenance/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/generators-maintenance/en-2.jpg)[![Cheat sheet: generator maintenance (3/3)](https://softwiro.com/uploads/cheatsheets/generators-maintenance/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/generators-maintenance/en-3.jpg)

0 downloads · 3 pages

## 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 edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

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

## Questions this raises

### How do I work out diesel use per hour?

Type each run's hours and litres added in the runtime log; the sheet divides litres by hours over the analysis period and shows litres per hour for each generator. It is an estimate that depends on load.

### How does the sheet know a service is overdue?

It counts the hours since the last service of the same type and compares them with its interval in hours: overdue when reached, soon at the percentage set in Settings, otherwise OK.

### Should I type the generator's hour meter or the hours directly?

Either. Type start and stop meter and the hours are calculated, or type the hours in the no-meter column. Enter the meter reading before the first row in the Generators sheet.

### Are the example service intervals right for my generator?

No, they are illustrative. Use your generator maker's manual and edit them in the service types sheet or in the generator's own interval.

## Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project

[All writing](https://softwiro.com/blog.html)
