Fuel · Free Excel template

Generator and Compressor Daily Log Sheet

A daily log for every generator and compressor on site. Record the hour meter, the load, the kWh meter and the tank readings; the workbook works out run hours, load share and fuel used, compares the fuel with what the data sheet says the set should use, and flags light load, fuel gaps and service due.

Free: enter your name, email and job title and we email you the file. Works in Excel 2019 or later, Microsoft 365, Google Sheets and LibreOffice Calc, with no macros.
  • 1,000 log rows, 30 units
  • Fuel used against the data sheet
  • Light load and service flags
safee-generator-log-sheet-en.xlsx
DateUnitRun hLoadFuel used (L)Expected (L)DifferenceFlags
10-01GN-0120.055%1,1151,112+0.2%
10-01GN-0218.019%520515+1.1%Light load
10-01AC-018.070%168
10-04GN-0120.055%1,3601,112+22.3%Fuel above expected
10-05GN-0218.018%500Light load; Tank reading missing
Example rows. The two generators use the fuel figures of the Cummins C500 D5 data sheet; the 5% allowed difference is an example on Settings.
What's in the file

A register of units, a daily log and a monthly summary

You enter each unit once with its data sheet figures. The operator or site electrician fills one row per unit each day, and the workbook does the checking.

  1. 01

    Units

    Number, type, model, serial, site, prime rating and power factor, fuel use at 25, 50, 75 and 100% load from the data sheet, tank size, service interval and the hour meter at the last service.

  2. 02

    Service status

    The latest hour meter from the log, hours since the last service, the next service and a status: OK, Service due soon or Service overdue.

  3. 03

    Daily log

    Hour meter, average kW or a typed load % for compressors, kWh meter, tank level at start and end and fuel added, with the operator or shift.

  4. 04

    Calculated per row

    Run hours, energy, load share, fuel used, actual and expected liters per hour, expected fuel, difference %, liters per kWh and fuel cost.

  5. 05

    Six flags

    Meter went back, over 24 run hours, fuel above or below expected, light load under 30% and a missing tank reading.

  6. 06

    Monthly summary

    Per unit for the month: days, hours, energy, average load, fuel used and expected, difference, L/h, L per kWh, cost, light-load days and flags; all units by month, with a chart.

What is a generator log sheet?

A generator log sheet is the daily record of a set's running: hour meter readings, load, energy produced, fuel added and tank levels, with the operator's name. On construction sites, camps and batching plants it is often the only record of how many hours a set ran and how much diesel went into it.

This log goes one step further. It compares the fuel each set used with the fuel its data sheet says it should use at the load it carried, so a gap stands out the same day instead of at month end.

How to use the generator log

  1. Register each unit with its prime rating, power factor and the fuel use at 25, 50, 75 and 100% load from its data sheet.
  2. Read the meters at the start and end of each day or shift: hour meter, kWh meter if fitted, and the tank level in liters.
  3. Record every refuel in Fuel added, with the liters from the bowser meter or the issue log.
  4. Record the load in kW from the panel meter when there is no kWh meter. For a compressor, type a load % if you know it.
  5. Review the flags each day and write the reason in Notes.
  6. Review the monthly summary and the service status with the site manager.

How does the log calculate fuel and load?

Run hours = hour meter end − hour meter start Fuel used = tank start + fuel added − tank end Load share = kWh ÷ run hours ÷ rated kW (or average kW ÷ rated kW) Rated kW = prime kVA × power factor Expected L/h = straight line between the data sheet points around the load share Difference % = fuel used ÷ (expected L/h × run hours) − 1 Light load = load share below 30% (Caterpillar)

Caterpillar's white paper says standby and prime diesel sets are designed to run between 50 and 85% of nameplate, and that light loading below 30% for extended periods harms the engine; both bands are on Settings. The allowed fuel difference and the service warning are your choice.

Sources: Brian Jabeck, The Impact of Generator Set Underloading, Caterpillar, October 2013 (Source: Caterpillar); Cummins, C500 D5 data sheet, EMERD-5935-EN, August 2017 (Source: Cummins data sheet). Last reviewed 21 October 2026.

Worked example: two 455 kVA sets and a compressor

Both example generators use the Cummins C500 D5 data sheet: 455 kVA prime, 364 kW, and 32.9, 51.6, 71.9 and 94.3 L/h at 25, 50, 75 and 100% load.

  • GN-01, 4 October: 4,000 kWh in 20 hours is 200 kW, a 55% load. The data sheet gives 55.6 L/h, so 1,112 L were expected. The tank went from 790 L, plus 1,400 L added, to 830 L: 1,360 L used, 22.3% above expected, over the 5% allowance.
  • GN-02 carries about 70 kW, a 19% load, every day, so each row shows Light load. In October it uses 0.412 L per kWh against 0.287 L per kWh for GN-01, 44% more fuel for each kWh.
  • GN-02, 5 October: 480 L were added but the end-of-day tank reading is missing, so fuel used is blank and the row is flagged.
  • AC-01 has no fuel curve yet, so its liters and hours are logged (21.5 L/h on average) without a difference.
  • Service: GN-01 is 240 hours past its last service on an example 250-hour interval, so it shows Service due soon; GN-02 is at 275.5 hours and shows Service overdue.

Common mistakes with generator logs

  • Writing fuel added but no tank levels. Without both readings you cannot tell fuel used from fuel stored.
  • Reading the meter only at refuels. Daily readings show which day the gap happened.
  • Using the standby column of the data sheet for a set that runs as the main supply. Use the column for the rating it runs at.
  • Ignoring light load. A large set on a small load wastes fuel and, below 30% for long periods, harms the engine.
  • One log for several sets. Each set needs its own rows, or the comparison with its data sheet is lost.

What the template does not do

The log works with the readings you enter; it does not read the generator or the tank. Data sheet figures are for a set in good condition, and below 25% load the expected fuel is extended beyond the data sheet. A difference is a question to answer, not proof of theft or a fault. Service intervals come from the manufacturer's manual. To estimate fuel and size a set before you hire it, use the Generator Fuel Consumption & Load Calculator; to track issues from a site tank or bowser, use the Site Diesel Tank and Bowser Issue Log.

Related Safee solution

Record fills, drops and running time without manual readings

With a tracking unit and a fuel level sensor on the generator's tank, Safee's Fuel fill/theft report lists each fill and each drop by the alarm conditions you set, and the Fuel Tracking Dashboard sums fills, drops and actual consumption by day. Equipment Activity Status shows when the set is running from a signal wired to the unit.

  • Fuel fill and drop alarms with a minimum amount and a time window you set.
  • Fuel Tracking Dashboard by day, with actual consumption from the fuel sensor.
  • Equipment Activity report with active and non-active time.
  • Total Engine Hours in the Message History report where the unit reads the CANbus.
FAQ

Questions about generator log sheets

Want fills, drops and run hours for every site generator without daily readings? Talk to Safee.

What should a generator log sheet include?

Date, unit, operator, hour meter at start and end, load or kWh, tank level at start and end, fuel added, and notes on faults or stops. This log adds the expected fuel from the data sheet and flags differences.

How do I calculate a generator's fuel use from tank readings?

Fuel used = tank level at the start + fuel added − tank level at the end. Divide by the run hours for liters per hour, or by the kWh for liters per kWh.

Where do the expected fuel figures come from?

From the set's data sheet, which lists fuel use at 25, 50, 75 and 100% load. The log draws a straight line between the two points around your load share.

What load is too low for a diesel generator?

Caterpillar's white paper says running below 30% of rated output for extended periods harms the engine, and that standby and prime sets are designed for 50 to 85% load.

Can I use it for air compressors and lighting towers?

Yes. Log hours and tank readings for any diesel unit. When its data sheet lists fuel at load points, enter them on Units and type a load % to get the expected fuel.

Which Excel version do I need?

Excel 2019 or Microsoft 365, Google Sheets or LibreOffice Calc. The latest hour meter on Units uses MAXIFS, which older Excel versions do not have.

Next step

See every fill and drop at your site generators

Tell us how many generators and tanks you run, and we will show you how Safee's fuel reports record fills, drops and running time for each set.

Related tools and templates

Control site fuel and power

Get the report

Enter your details and we will email you the file.

Use your real name so the file arrives addressed to you. Don't worry, we won't flood you with emails or calls.

Scroll to Top