Template
Equipment Maintenance Schedule Template Excel:Hour-Meter and Calendar Columns, Whichever-First Due Formulas, Honda GX390 Intervals and a Filled Boise Hardscape Schedule
Equipment maintenance schedule template excel layout: hour and month intervals, whichever-first due formulas and Honda GX390 rows filled for a Boise crew.
An equipment maintenance schedule template excel layout gives each service task on each machine two intervals, operating hours and calendar months, and its formulas return the next due date under the manufacturer's rule of whichever comes first. The filled schedule below covers four Honda GX390-powered machines at a hardscape contractor in Boise, Idaho.
FieldRanger, field service software that runs inside HubSpot, publishes this layout with its other free field service templates. The page offers the column and formula tables as a free .xlsx download with no sign-up: the Schedule columns on a Template sheet, a Readings tab and a Sample sheet. Intervals come from Honda's GX390 owner's manual, and formulas from Microsoft's function reference.
Maintenance schedule and equipment register
A register and a schedule describe the same machines in different units. The equipment tracking spreadsheet keeps one row per item: where it is, who holds it, what it cost. A maintenance schedule keeps one row per task per machine: an oil change, an air filter, a valve adjustment, each with its own interval and its own last service.
The difference sets the formulas. A register's next service date can be one EDATE on one calendar interval. A small-engine schedule needs two limits per task: the hour meter can reach its limit months before the calendar does, or the reverse.
Equipment maintenance schedule template Excel columns and formulas
The Schedule tab holds one row per task, headers in row 4 and the first task in row 5. Formulas are shown for row 5 and copy down. Columns K, L and M read the Readings tab described in the next section.
| Column | Header | Contents | Formula |
|---|---|---|---|
| A | Asset ID | A permanent number painted on the machine, matching the Readings tab | Typed |
| B | Machine | What the machine is | Typed |
| C | Engine and serial | Engine model and serial number from the engine, not the machine frame | Typed |
| D | Task | One maintenance item and action, as worded in the manual | Typed |
| E | Interval, hours | From the manual; blank for calendar-only tasks | Typed |
| F | Interval, months | From the manual; blank for hours-only tasks | Typed |
| G | Shop interval, hours | A shorter interval set by the shop; blank to use column E | Typed |
| H | Interval source | Manual page and footnote, or the shop rule behind column G | Typed |
| I | Last service date | Date the task was last done | Typed |
| J | Hours at last service | Hour meter at that service | Typed |
| K | Current hours | Latest meter reading for the asset | =MAXIFS(Readings!$C:$C,Readings!$B:$B,$A5) |
| L | Reading date | Date of that reading | =MAXIFS(Readings!$A:$A,Readings!$B:$B,$A5) |
| M | Hours per week | Rate over the last 28 days of readings | =IFERROR((K5-MINIFS(Readings!$C:$C,Readings!$B:$B,$A5,Readings!$A:$A,">="&L5-28))/(L5-MINIFS(Readings!$A:$A,Readings!$B:$B,$A5,Readings!$A:$A,">="&L5-28))*7,"") |
| N | Hours due at | Last service hours plus the interval in force | =IF(AND(E5="",G5=""),"",J5+IF(G5<>"",G5,E5)) |
| O | Hours left | Negative once the meter passes the due point | =IF(N5="","",N5-K5) |
| P | Calendar due | Last service date plus the month interval | =IF(F5="","",EDATE(I5,F5)) |
| Q | Projected hours date | The date the meter reaches column N at the current rate | =IF(OR(N5="",N(M5)<=0),"",L5+MAX(O5,0)/M5*7) |
| R | Next due | The earlier of the calendar date and the projected date | =IF(AND(P5="",Q5=""),"",MIN(P5,Q5)) |
| S | Days to due | Negative once overdue | =IF(R5="","",INT(R5)-TODAY()) |
| T | Status | Due now, due within 14 days, or OK | =IF(R5="","",IF(OR(AND(N5<>"",K5>=N5),AND(P5<>"",TODAY()>=P5)),"Due now",IF(S5<=14,"Due in 14 days","OK"))) |
| U | Done and work order | Date done, hours, initials and the work order number | Typed |
Column R carries the manual's rule. Honda heads its table "Perform at every indicated month or operating hour interval, whichever comes first", so the earlier of P and Q wins. MIN skips the empty text a single-limit row returns in P or Q, so one formula serves every row.
Column T tests the limits directly, not the projection. A meter past column N is due now; so is a calendar date already passed, however little the machine has run. Columns P, Q and R are formatted as dates, or they display serial numbers.
MAXIFS returns "the maximum value among cells specified by a given set of conditions or criteria", and MINIFS the minimum (Microsoft Support, MAXIFS function and MINIFS function, checked November 13, 2026). Microsoft lists both for Excel 2019 and later and Microsoft 365. In Excel 2016, columns K and L are typed instead.
Readings tab and the weekly hour rate
The Readings tab logs the hour meter, one row per reading. A reading is taken when a machine returns to the yard, at each service, and weekly for machines that sit.
| Column | Header | Contents |
|---|---|---|
| A | Date | Date the meter was read |
| B | Asset ID | Matches column A of the Schedule tab |
| C | Hours | Meter reading to one decimal |
| D | Read by | Initials |
Column M divides the hours run in the last 28 days by the days between the oldest and newest reading in that window, times 7. With one reading in the window it returns blank, and column Q stays blank rather than inventing a date. Four weeks smooths the swings: a saw can run 30 hours on one slab week and none the next.
Honda's footnote 3 asks for this tab: "For commercial use, log hours of operation to determine proper maintenance intervals." A machine without an hour meter gets one fitted, or its hours are estimated from job records and column H says so.
Honda GX390 intervals from the owner's manual
The intervals below are transcribed from page 7 of Honda's owner's manual for the GX240, GX270, GX340 and GX390, publication 37Z5F602 (Honda Power Equipment, GX240 to GX390 owner's manual, read November 13, 2026). The page warns: "Failure to follow this maintenance schedule could result in non-warrantable failures." Column U therefore records hours and initials as well as a date.
| Item | Action | Interval | Note |
|---|---|---|---|
| Engine oil | Check level | Each use | |
| Engine oil | Change | First month or 20 hours, then every 6 months or 100 hours | |
| Reduction case oil, applicable types | Check level; change | Each use; first month or 20 hours, then every 6 months or 100 hours | |
| Air filter | Check | Each use | |
| Air filter | Clean | Every 3 months or 50 hours | Every 6 months or 100 hours for the dual-element internal vent carburetor type; more often in dusty areas |
| Air filter | Replace | Every year or 300 hours | Paper element type only; cyclone type every 2 years or 600 hours |
| Sediment cup | Clean | Every 6 months or 100 hours | |
| Spark plug | Check and adjust | Every 6 months or 100 hours | |
| Spark plug | Replace | Every year or 300 hours | |
| Spark arrester, applicable types | Clean | Every 6 months or 100 hours | |
| Idle speed | Check and adjust | Every year or 300 hours | Servicing dealer |
| Valve clearance | Check and adjust | Every year or 300 hours | Servicing dealer |
| Combustion chamber | Clean | After every 500 hours | Servicing dealer |
| Fuel tank and filter | Clean | Every year or 300 hours | Servicing dealer |
| Fuel tube | Check | Every 2 years, replace if necessary | Servicing dealer |
"Each use" rows belong on the operator's daily checklist: no formula knows whether a machine ran today. The dealer rows stay. Footnote 2 assigns them to the servicing dealer unless the owner has the tools and the skill, so the shop books them ahead. Page 18 gives the GX390's oil capacity as 1.1 liters (1.2 US quarts), and page 8 recommends SAE 10W-30 meeting API SJ or later. A Parts and fluids column can carry both.
Dusty-site override in the shop interval column
The manual sets numbers for normal conditions only. Footnote 1 says: "Service more frequently when used in dusty areas." Page 7 refers operation "in unusually wet or dusty conditions" to the servicing dealer.
Column G holds the shop's figure, and column H its source. The sample shop runs its compactor and saw on base gravel and cut concrete, and cleans their air filters at 25 hours, half the manual's 50, on its dealer's advice. The other two machines keep 50. Column F still holds 3 months, and column R still takes the earlier date.
Filled maintenance schedule: hardscape contractor in Boise, Idaho
The shop builds patios, retaining walls and walkways with four GX390-powered machines: PC-1, a reversible plate compactor; PW-1, a 4,000 psi pressure washer with electric start; CS-1, a 14-inch walk-behind concrete saw; and SG-1, a stump grinder bought in October. TODAY() returns November 13, 2026. The business, machines, readings and history are samples; the intervals are Honda's, apart from the two 25-hour shop intervals.
| Date | Asset ID | Hours | Read by |
|---|---|---|---|
| Oct 13, 2026 | PW-1 | 222.0 | JM |
| Oct 15, 2026 | PC-1 | 356.6 | JM |
| Oct 15, 2026 | CS-1 | 265.5 | JM |
| Oct 20, 2026 | SG-1 | 0.0 | RT |
| Nov 10, 2026 | PW-1 | 238.0 | JM |
| Nov 12, 2026 | PC-1 | 412.6 | RT |
| Nov 12, 2026 | CS-1 | 301.5 | RT |
| Nov 12, 2026 | SG-1 | 11.5 | RT |
| Asset | Task | Interval | Last service, hours | Now, hrs/wk | Hours due | Calendar due | Projected | Next due | Days | Status |
|---|---|---|---|---|---|---|---|---|---|---|
| PC-1 | Oil change | 100 h, 6 mo | Sep 21, 2026, 330.0 | 412.6, 14.0 | 430.0 | Mar 21, 2027 | Nov 20, 2026 | Nov 20, 2026 | 7 | Due in 14 days |
| PC-1 | Air filter clean | 25 h shop, 3 mo | Nov 2, 2026, 395.0 | 412.6, 14.0 | 420.0 | Feb 2, 2027 | Nov 15, 2026 | Nov 15, 2026 | 2 | Due in 14 days |
| PC-1 | Valve clearance, dealer | 300 h, 12 mo | Apr 6, 2026, 120.0 | 412.6, 14.0 | 420.0 | Apr 6, 2027 | Nov 15, 2026 | Nov 15, 2026 | 2 | Due in 14 days |
| PW-1 | Oil change | 100 h, 6 mo | May 4, 2026, 150.0 | 238.0, 4.0 | 250.0 | Nov 4, 2026 | Dec 1, 2026 | Nov 4, 2026 | -9 | Due now |
| PW-1 | Sediment cup clean | 100 h, 6 mo | May 4, 2026, 150.0 | 238.0, 4.0 | 250.0 | Nov 4, 2026 | Dec 1, 2026 | Nov 4, 2026 | -9 | Due now |
| CS-1 | Spark plug replace | 300 h, 12 mo | Dec 8, 2025, 0.0 | 301.5, 9.0 | 300.0 | Dec 8, 2026 | Nov 12, 2026 | Nov 12, 2026 | -1 | Due now |
| CS-1 | Air filter clean | 25 h shop, 3 mo | Oct 26, 2026, 290.0 | 301.5, 9.0 | 315.0 | Jan 26, 2027 | Nov 22, 2026 | Nov 22, 2026 | 9 | Due in 14 days |
| CS-1 | Oil change | 100 h, 6 mo | Oct 26, 2026, 290.0 | 301.5, 9.0 | 390.0 | Apr 26, 2027 | Jan 19, 2027 | Jan 19, 2027 | 67 | OK |
| SG-1 | Break-in oil change | 20 h, 1 mo | Oct 20, 2026, 0.0 | 11.5, 3.5 | 20.0 | Nov 20, 2026 | Nov 29, 2026 | Nov 20, 2026 | 7 | Due in 14 days |
Three rows are due now. PW-1 has run 88 hours since May, short of its 100-hour oil interval, but six months have passed: the calendar triggered its oil and its sediment cup. CS-1 is the reverse. Its spark plug is 26 days from its calendar date and 1.5 hours past its hour limit.
Two PC-1 rows share one dealer trip. The compactor reaches 420 hours around November 15, the due point for its air filter and its valve clearance, so both go to the dealer that week. SG-1 reaches its first month on November 20 with 8.5 hours still to run; the break-in oil change follows the calendar.
Projected dates assume the last four weeks' rate continues. CS-1's January 19 oil change holds only if the saw cuts nine hours a week all winter. Stored from December, with weekly readings still logged, its rate falls to zero, column Q goes blank, and the April 26 calendar date governs.
Winter storage rows on a November schedule
Storage preparation is a calendar task with no hour limit. The manual gives two methods: stabilizer in a full tank of fresh fuel, then "run the engine outdoors for 10 minutes"; or drain the tank and carburetor. Fuel problems "may occur within a few months", and damage "resulting from neglected storage preparation" is outside the Distributor's Limited Warranty.
The sample shop adds three winter rows per machine. "Storage preparation" falls due December 1, 2026, with no hours. "Battery recharge" applies to PW-1 alone, monthly, because the manual says to recharge "once a month while the engine is in storage". "Removal from storage" falls due on the March start date and points to the before-operation checks. Sheet plastic is ruled out as a cover: "A nonporous cover will trap moisture around the engine".
Schedule set-up from data plate to first due date
- Read the engine model and serial number from each engine and record them in column C; a machine frame can outlive its engine.
- Copy every interval row from the engine manual's maintenance schedule into columns D to F, with the page number in column H, and the machine manufacturer's own items (belts, blades, hydraulic oil) as further rows from the machine's manual.
- Move the "each use" items to the operator's daily checklist.
- Enter any shop interval in column G, with its source in column H.
- Enter the last service date and hours for each row from receipts and work orders; for a new machine, enter the in-service date and 0.0.
- Read every hour meter, enter the readings on the Readings tab, and repeat each week for at least four weeks before trusting column Q.
- Sort or filter on column T each Monday, and turn every "Due now" and "Due in 14 days" row into a work order with its number in column U.
- After each service, overwrite columns I and J with the new date and hours, then confirm that column N moved up by one interval and column T returned to OK.
The maintenance work order template is the record each due row turns into: asset, meter reading, tasks, parts and the sign-off that returns the machine to service. Schedules for buildings rather than engines, where every interval is a calendar interval, follow the HOA maintenance schedule template.
Maintenance software and the hour meter
A spreadsheet flags a due task; it does not put the machine, the parts and a mechanic in one place on one day. The dispatch software page covers that step: a due row becomes a booked job.
In FieldRanger, maintenance is scheduled and tracked for each piece of equipment. Equipment is checked in and out by scanning its QR code on a phone and assigned to jobs and technicians. An availability calendar prevents double-booking a machine that is due at the dealer, and the usage history records who used which equipment, and when. Recurring job templates cover repeat service work, and any report downloads as CSV or Excel. The equipment record itself is described on the equipment tracking software page.
A shop that services by engine hours keeps the hour readings in columns J to Q of the workbook and uses FieldRanger for jobs, check-outs and history. Each day is its own job in FieldRanger; multi-day jobs are not built.
Frequently asked questions
How to create an equipment maintenance schedule in Excel?
List one row per task per machine with an hour interval and a month interval from the manufacturer's manual, the last service date and hours, and the current meter reading. Compute the hours due as last service hours plus the interval, the calendar due date with EDATE, and the next due date as the earlier of the calendar date and the date the meter is projected to reach the hour limit.
Is there a free equipment maintenance schedule template for Excel to download?
Yes. The page offers a free .xlsx download with no sign-up: a Template sheet with every Schedule column and formula, headers in row 4 and the first task in row 5, a Readings tab, and a Sample sheet with the Boise schedule.
How does a spreadsheet handle "whichever comes first" for hours and months?
It computes both limits separately, a calendar date with EDATE and a projected date from the weekly hour rate, and takes the earlier with MIN. The status column then tests the two limits directly, so a machine past either one shows as due now.
What is the oil change interval for a Honda GX390?
Honda's owner's manual sets the first oil change at the first month or 20 hours, then every 6 months or 100 hours, whichever comes first. The engine takes 1.1 liters, with SAE 10W-30 recommended for general use.
What is the difference between an equipment maintenance schedule and an equipment register?
A register has one row per machine and records where it is, who holds it, its cost and its condition. A maintenance schedule has one row per task per machine and records each task's intervals, last service and next due date.
PW-1 and the six-month limit
The pressure washer ran 88 hours in six months and still came due on November 4, the row a schedule built on hours alone would have missed. Its oil change, the sediment cup on the same engine and the spark plug on CS-1 are the week's work, ahead of PC-1's dealer visit on November 15 and the storage rows on December 1. Each of those rows closes on a maintenance work order from the free field service templates. FieldRanger's plans are listed on pricing; a 14-day Start free trial, no card, covers PW-1's oil change and PC-1's dealer week as booked jobs.
FieldRanger runs field service inside HubSpot
Estimates, scheduling and dispatch, a technician app and invoicing on the HubSpot records sales already keeps. Every plan starts with a free trial.
Book a demo