# Generator Maintenance Log Excel Template

> A free Excel generator log: a register of your units, a run and fuel log, fuel per run hour, cost per run hour, service due by hours and date, and downtime.

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

---

Free Excel template

# Generator Maintenance Log Template for Excel

A free Excel workbook for anyone who owns a standby or prime-power generator: a facility manager, a farm, a small business or a rental fleet. List your units once, then log each run (exercise, load test, outage or prime power) with the hour-meter readings and the fuel you added, and each service or repair with its cost and downtime. The sheet works out hours run, fuel per run hour, cost per run hour, the next service by hours and by calendar date, and marks every unit OK, Due soon or Overdue. It opens in Excel, LibreOffice and Google Sheets, and the fuel unit and currency are yours to choose.

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

Excel file (.xlsx) · 163 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 |  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- | --- | --- |
| Generators | 6 |  |  | Services overdue |  |  | 2 |
| Hours run | 515.5 |  |  | Services due soon |  |  | 1 |
| Fuel added | 1,378.5 |  |  | Units not run lately |  |  | 1 |
| Fuel cost | 5,675.76 |  |  | Downtime from service (hours) |  |  | 28.5 |
| Maintenance cost | 3,655.00 |  |  | Load tests logged |  |  | 2 |
| Total cost | 9,330.76 |  |  | Exercise runs logged |  |  | 5 |
| Total cost per run hour | 18.10 |  |  | Highest cost per run hour (unit) |  |  | G02 |
| Fuel per run hour | 2.67 |  |  | Lowest cost per run hour (unit) |  |  | G04 |
| Month | Fuel cost | Maintenance cost | Month start | Hours run | Service task | Jobs | Cost |
| Jun 2026 | 0.00 | 0.00 | 46174 | 0.0 | Scheduled service | 5 | 1,800.00 |
| Jul 2026 | 0.00 | 0.00 | 46204 | 0.0 | Load bank test | 0 | 0.00 |
| Aug 2026 | 0.00 | 780.00 | 46235 | 0.0 | Battery | 1 | 185.00 |
| Sep 2026 | 0.00 | 345.00 | 46266 | 0.0 | Repair | 3 | 1,550.00 |
| Oct 2026 | 4,343.60 | 1,390.00 | 46296 | 394.5 | Inspection | 1 | 120.00 |
| Nov 2026 | 1,332.16 | 120.00 | 46327 | 121.0 | Other | 0 | 0.00 |

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.

## What is inside

- Dashboard: Totals for hours run, fuel added, fuel cost, maintenance cost and total cost per run hour, counts of overdue and due-soon services, units not run lately, downtime, load tests and exercise runs, plus four charts: fuel and maintenance cost by month, hours run by month, cost by generator and maintenance cost by task.
- Due List: The units that need attention, overdue first, then due soon and units that have not run lately, with make and model, location, hours to the next service, the next service date and days since the last run. Shows up to 40 units.
- Generators: The register: unit ID, make and model, rating, fuel type, tank size, location, service interval in hours and in months, and the hour-meter reading when you start. It calculates current hours, hours run, fuel per run hour, cost per run hour, last run, next service and status, and how long the tank lasts at the unit's average burn. Room for 40 units.
- Run Log: One row per run: date, unit, run type, hour meter start and end, fuel added and price. It adds hours run and fuel cost, and flags a unit ID that is not in the register or an end reading below the start. Room for 1,000 runs.
- Service: The service history: date, unit, task, hour meter reading, cost, downtime in hours and vendor. A job of type Scheduled service restarts that unit's service clock. Room for 500 entries.
- Lists: Your fuel types, service tasks and run types for the dropdowns.
- Settings: Today's date, the alert window in days, the margin in hours before a service is due soon, how many days without a run is too long, the currency symbol, the fuel unit and your company name.

The file opens on a start tab (“Start here”) that explains how to use it.

## What makes it different

A paper logbook records what happened but does not tell you what is due. This workbook keeps the run hours, the fuel and the service history in one place and turns them into a schedule: each unit has a service interval in hours and in months, and its status moves from OK to Due soon to Overdue by itself. It also shows what a run hour costs, fuel and repairs together. The sample is a mixed set of six units with runs in October and November 2026.

## How do I keep a generator maintenance log in Excel?

Start with a register. Give each generator a unit ID on the Generators sheet, with its make and model, rating, fuel type, tank size, location and the hour-meter reading on the day you begin. Then add a row to the Run Log every time it runs, with the meter reading before and after, and a row to the Service sheet for every job. Use the task Scheduled service for the regular service, because that is the entry that restarts the clock.

Type the service interval for each unit in hours and in months. Take them from your manufacturer's manual, since they differ by engine and by whether the unit is standby or prime power; the sheet does not assume any. In the sample, two units are overdue for service and one is due soon, and the Due List puts them at the top.

## How do I track generator run hours, exercise runs and load tests?

Log each run on the Run Log with a run type: Exercise, Load test, Outage, Prime power or Other. The hours run are the end reading minus the start reading, added up per unit, and the Dashboard counts the load tests and exercise runs you have logged. In the sample that is 2 load tests and 5 exercise runs, and 515.5 hours run in total.

Set how many days without a run is too long on the Settings sheet. A unit with no run inside that window, or none logged at all, shows on the Due List as not run lately. How often you exercise or load test a unit depends on your manufacturer, your insurer and any local rules, so check those and type what applies.

## How do I calculate generator fuel use per hour and cost per run hour?

Fuel per run hour is the fuel you added divided by the hours run, and cost per run hour is the fuel cost, or fuel plus maintenance, divided by the hours run. Both are on the Generators sheet for each unit. In the sample the fleet used 1,378.5 gallons over 515.5 hours, which is 2.67 gallons per run hour, and its total cost of 9,330.76 comes to 18.10 per run hour.

The figure is closest to true when you fill the tank to the same level after every run, so the fuel added matches the fuel burned. Compare units of the same size: a small unit that runs for only a few hours can show a high cost per hour because its service cost is spread over very few hours. For general spending outside the generator, 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 margin in hours before a service counts as due soon, how many days without a run is too long, your currency symbol and your fuel unit.
2. On the Generators sheet add one row per unit: unit ID, make and model, rating, fuel type, tank size, location, how often it needs service (hours and months, from your manufacturer's manual) and the hour-meter reading the day you start tracking.
3. On the Run Log sheet add a row for every run: date, unit ID, run type (exercise, load test, outage, prime power), hour-meter start and end, fuel added and the price per unit.
4. On the Service sheet log every job: date, unit ID, task, hour-meter reading, cost and downtime. Choose the task Scheduled service for the regular service: it restarts that unit's service clock.
5. The Generators sheet then shows hours run, fuel per run hour, cost per run hour, the next service due by hours and by date, and a status of OK, Due soon or Overdue.
6. Open Due List for the units that are overdue, due soon or have not run lately, and Dashboard for totals, monthly cost and charts.

**Before you start:**

- Capacity: 40 generators, 1,000 run log entries and 500 service entries. The Due List shows the first 40 units that need attention.
- Hours run = hour-meter end minus start, summed per unit. Current hours = the highest end reading in the Run Log (or the start reading if the unit has no runs yet).
- Fuel per run hour = fuel added / hours run. It is closest to true when you top the tank up to the same level after every run, so the fuel added matches the fuel burned.
- Next service is the last Scheduled service reading + the hours interval, and its date + the months interval. With no Scheduled service logged yet, the start reading is used for the hours. The intervals are yours: type what your manufacturer's manual says.
- Service status: Overdue (past the due hours or the due date), Due soon (within the margin in hours or the alert window in days), OK. Leave an interval blank to ignore it.
- Rating can be kW or kVA, and the fuel unit and currency are labels only: use one fuel unit and one currency in one workbook.

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

Excel file (.xlsx) · 163 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 operator and technician logs their own entries with a login |
| You type each meter reading | Readings arrive from the operator's phone or a monitoring unit |
| A due list you check yourself | Reminders sent when a service or test is close |
| Fixed columns and intervals | Rules for your units, sites and contracts |
| Charts inside the workbook | A live dashboard for the owner |

### Extra features in the app

- Operators log runs and fuel from a phone at the generator, with photos of the hour meter and receipts
- Service reminders sent to the site manager and the technician before a service is due
- A work order for each job with the vendor, parts and approval
- Manuals, warranty and test reports stored with each unit
- An alert when fuel use per hour drifts from a unit's normal
- Reports by unit, site or month without building formulas

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

## Frequently asked questions

### Is this generator maintenance log really free?

Yes. Download it, use it for your units and change anything you like. There is nothing to sign up for to open the file.

### Does it work for standby and for prime-power generators?

Yes. Log exercise runs, load tests and outages for a standby unit, and long prime-power runs for a unit that carries the load every day. Each unit has its own service interval in hours and months, so a heavily used unit and a rarely used one are scheduled differently.

### Where do the service intervals come from?

From you. Type the interval for each unit from your manufacturer's manual into the register. The sheet adds them to the last scheduled service to give the next service hours and date, and does not suggest any itself.

### How many generators can it hold?

40 units, 1,000 run log entries and 500 service entries. The Due List shows the first 40 units that need attention. A spreadsheet gets harder to keep accurate as more people and sites add data.

### Does it work in Google Sheets and LibreOffice?

Yes. It uses ordinary formulas such as SUMIFS, COUNTIFS, INDEX, MATCH and IF, so it works in Excel 2016 and later, LibreOffice and Google Sheets. Change gallons to litres and the dollar sign to your own currency symbol on the Settings sheet.

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

More free templates for: Workshops and maintenance

## More free templates

- Car workshop job orders tracker (Excel)
- Spare parts inventory sheet
- Metal and turning workshop job sheet in Excel: job orders, materials and labor
- Glass and aluminium workshop sheet in Excel: orders by square metre, cutting and waste
- Carpentry workshop sheet: cutting list, boards, cost and delivery
- Equipment Inspection Log Template for Excel
- Coffee Roasting Log and Costing Spreadsheet for Excel
- Hotel Guest Folio Template for Excel (Rooms, Reservations, Billing)
- Auto Parts Inventory and Sales Spreadsheet for Excel
- Clothing Store Inventory Spreadsheet (Size and Color) for Excel
- Multi-Location Inventory Spreadsheet for Excel
- Quran Hifz Tracker Template for Excel (Sabaq, Sabqi, Manzil)
- Rotating Savings Club Tracker for Excel (Susu, Tanda, ROSCA)

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