The hour meter runs your equipment costs
Most construction equipment costs are keyed to one number: the hour meter. Service intervals are set in hours. Rental agreements allow a set number of hours per day, week, or month and charge overtime past that. Engine and undercarriage wear, resale value, warranty coverage, and the owning-and-operating rate you bid with all track hours. If nobody is reading the meter every day, you don't know what the equipment is costing you.
This free equipment hour meter and fuel log gives a superintendent, equipment manager, or small fleet owner a daily log that's quick to fill out, and it turns those readings into a weekly summary by unit and a service tracker that tells you which machine needs a PM next.
What's in the workbook
1. Daily Log
One row per unit per day: date, unit ID (dropdown from your fleet list), job, operator, start and end hour-meter readings, fuel gallons, fuel cost from the ticket, DEF, idle hours, and notes. Formulas calculate:
- Hours Used = End − Start. If End is lower than Start, the cell shows CHECK METER: usually a typo, the wrong unit, or a replaced gauge.
- Gal / Hr for that day.
- An amber flag when idle is more than 25% of run time.
- Running totals at the top: total hours, fuel, fuel cost, average price per gallon, DEF, and fleet gallons per hour.
2. Weekly Summary
Enter a week-ending date and SUMIFS rolls up the seven days for every unit: days run, hours, fuel, fuel cost, DEF, gallons per hour, fuel cost per hour, idle hours and idle %, and utilization against the scheduled hours you set (50 hours per week by default), with an in-cell bar. Units under 50% utilization turn amber, which usually means one should be off-rented or moved to another job.
3. Service Tracker
Your fleet list, and the source of the dropdown on the daily log. For each unit: description, make/model, serial or VIN, owned or rented, the service interval, and the meter reading and date at the last service. The tracker calculates:
- Next Service @ Hrs = last service + interval
- Current Meter: the highest end reading logged for the unit
- Hours Remaining to the next service
- Avg Hrs / Day and Est. Work Days to Service, so the shop knows how much lead time it has
- Service Status: OK, DUE SOON (within your warning window, 50 hours by default), or OVERDUE
How to run it on the job
- Set up the fleet first. Enter every unit on the Service Tracker using the number painted on the machine. Pull the PM interval from the operator's manual for that model (engine oil and filters are commonly every 250 or 500 hours, and other components run on longer multiples). Enter the meter reading from the last service sticker or work order.
- Read the meter, don't estimate it. Start of shift and end of shift, or at every fueling. Writing down "8 hours" for an 8-hour day is how you end up with a meter 200 hours ahead of your records.
- Log fuel from the ticket. Whether the fuel truck comes daily or the operator fills from a transfer tank, log gallons and cost per unit. If fuel is bought on account, the fuel vendor's ticket number goes in Notes.
- Log DEF when you top off. Tier 4 Final diesels with SCR aftertreatment use diesel exhaust fluid. Consumption is a small percentage of diesel use and runs roughly proportional to it, so a unit using much more or much less DEF than usual needs a look.
- Note idle and downtime. Waiting on trucks, waiting on layout, breakdowns. These notes back up delay claims and T&M tickets.
- Review the weekly summary every Monday. Look at utilization, idle %, and gallons per hour by unit, then check the Service Tracker for anything DUE SOON and schedule it before it becomes OVERDUE.
Reading the numbers
Gallons per hour
Every machine settles into a normal burn rate for the work it's doing. An excavator trenching all day burns more per hour than the same excavator setting pipe. What you're watching for is change. If the same machine on the same work goes from 3.5 to 4.5 gal/hr, look for a clogged air filter, a fuel leak, a dragging brake, a hydraulic problem, or fuel that isn't going into that machine. Your own weekly history is the baseline to compare against.
Idle percentage
An idling machine still burns fuel and still runs the hour meter toward its next service and its trade-in value. High idle is sometimes unavoidable (cold starts, waiting on trucks), but a skid steer that idles 30% of every day between loads is a coaching conversation. Many newer machines have auto-idle and auto-shutdown settings that operators turn off.
Utilization
Utilization = hours run ÷ scheduled hours. A rented telehandler running 10 hours a week on a 50-hour schedule is costing you the full rental rate for about 20% use. Either off-rent it and bring one in when needed, or share it with another job. Owned equipment with chronically low utilization is a candidate to sell.
Fuel cost per hour
Fuel is usually the biggest variable operating cost, and it moves with the market. The weekly fuel $/hr by unit is a real, job-specific number to check against the fuel component of the equipment rates you bid with. It's fuel only, not a full owning-and-operating rate.
Rented equipment: why the meter matters even more
Most rental agreements price equipment on a single-shift allowance per day, week, or 4-week month and charge overtime for hours beyond it. Check your own agreement for the exact terms. Your daily meter log is the check on the rental invoice. It's also how you avoid running a rented machine past its scheduled service. Call the rental house as the unit approaches its interval. Running past due can put the resulting repair on you under many rental agreements.
Dyed diesel and fuel records
Off-road equipment typically runs on dyed (untaxed) off-road diesel, and dyed fuel can't legally go into on-road vehicles. Keeping fuel logged per unit makes it clear where the off-road fuel went, and that record helps if you ever need to back up fuel tax records. Talk to your accountant about the records your business needs to keep. This template is a record-keeping tool, not tax advice.
Common mistakes
- Logging hours from the time card instead of the meter. Operator hours and machine hours are not the same number.
- Forgetting to update the last service. If the shop does a PM and nobody updates the tracker, the unit shows OVERDUE forever and people start ignoring the flag.
- One sheet per machine. Twenty separate logs never get rolled up. Keep one daily log for the fleet and let the weekly summary sort by unit.
- Not tying hours to the job. Hours by job are the backup for equipment charges on change orders and T&M tickets.
From spreadsheet to daily report
Excel works for a small fleet with one person keeping the log. Once several foremen are writing meter readings on paper and someone re-types them on Friday, you're paying twice for the same data and getting it a week late. Field PM daily reports capture equipment hours from the foreman's phone with the rest of the day's report, tie them to the job, and roll them into the PM dashboard. Tool & equipment tracking keeps custody and maintenance in the same place. Start a free 30-day trial. No credit card required.
Related free templates
- Equipment inspection checklist: the pre-shift walkaround that goes with the meter reading
- Tool checkout log & inventory: custody and calibration for tools and small equipment
- Daily field report: log equipment on site alongside manpower and production
- T&M ticket template: bill equipment hours on extra work
- Productivity calculator: check production against the hours you're paying for
- Browse all free construction templates
