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.

Updated 12 min read

Download .xlsxExcel spreadsheet · 47 KB · Free, no sign-up

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.

Equipment maintenance schedule template Excel, Schedule tab columns and formulas (row 5 shown)
ColumnHeaderContentsFormula
AAsset IDA permanent number painted on the machine, matching the Readings tabTyped
BMachineWhat the machine isTyped
CEngine and serialEngine model and serial number from the engine, not the machine frameTyped
DTaskOne maintenance item and action, as worded in the manualTyped
EInterval, hoursFrom the manual; blank for calendar-only tasksTyped
FInterval, monthsFrom the manual; blank for hours-only tasksTyped
GShop interval, hoursA shorter interval set by the shop; blank to use column ETyped
HInterval sourceManual page and footnote, or the shop rule behind column GTyped
ILast service dateDate the task was last doneTyped
JHours at last serviceHour meter at that serviceTyped
KCurrent hoursLatest meter reading for the asset=MAXIFS(Readings!$C:$C,Readings!$B:$B,$A5)
LReading dateDate of that reading=MAXIFS(Readings!$A:$A,Readings!$B:$B,$A5)
MHours per weekRate 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,"")
NHours due atLast service hours plus the interval in force=IF(AND(E5="",G5=""),"",J5+IF(G5<>"",G5,E5))
OHours leftNegative once the meter passes the due point=IF(N5="","",N5-K5)
PCalendar dueLast service date plus the month interval=IF(F5="","",EDATE(I5,F5))
QProjected hours dateThe date the meter reaches column N at the current rate=IF(OR(N5="",N(M5)<=0),"",L5+MAX(O5,0)/M5*7)
RNext dueThe earlier of the calendar date and the projected date=IF(AND(P5="",Q5=""),"",MIN(P5,Q5))
SDays to dueNegative once overdue=IF(R5="","",INT(R5)-TODAY())
TStatusDue 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")))
UDone and work orderDate done, hours, initials and the work order numberTyped

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.

Readings tab columns (row 2 shown)
ColumnHeaderContents
ADateDate the meter was read
BAsset IDMatches column A of the Schedule tab
CHoursMeter reading to one decimal
DRead byInitials

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.

Honda GX390 maintenance schedule, as printed in manual 37Z5F602, page 7
ItemActionIntervalNote
Engine oilCheck levelEach use
Engine oilChangeFirst month or 20 hours, then every 6 months or 100 hours
Reduction case oil, applicable typesCheck level; changeEach use; first month or 20 hours, then every 6 months or 100 hours
Air filterCheckEach use
Air filterCleanEvery 3 months or 50 hoursEvery 6 months or 100 hours for the dual-element internal vent carburetor type; more often in dusty areas
Air filterReplaceEvery year or 300 hoursPaper element type only; cyclone type every 2 years or 600 hours
Sediment cupCleanEvery 6 months or 100 hours
Spark plugCheck and adjustEvery 6 months or 100 hours
Spark plugReplaceEvery year or 300 hours
Spark arrester, applicable typesCleanEvery 6 months or 100 hours
Idle speedCheck and adjustEvery year or 300 hoursServicing dealer
Valve clearanceCheck and adjustEvery year or 300 hoursServicing dealer
Combustion chamberCleanAfter every 500 hoursServicing dealer
Fuel tank and filterCleanEvery year or 300 hoursServicing dealer
Fuel tubeCheckEvery 2 years, replace if necessaryServicing 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.

Filled Readings tab, rows used by the formulas (sample readings)
DateAsset IDHoursRead by
Oct 13, 2026PW-1222.0JM
Oct 15, 2026PC-1356.6JM
Oct 15, 2026CS-1265.5JM
Oct 20, 2026SG-10.0RT
Nov 10, 2026PW-1238.0JM
Nov 12, 2026PC-1412.6RT
Nov 12, 2026CS-1301.5RT
Nov 12, 2026SG-111.5RT
Filled Schedule tab, selected columns, as of November 13, 2026 (sample machines and history; Honda intervals)
AssetTaskIntervalLast service, hoursNow, hrs/wkHours dueCalendar dueProjectedNext dueDaysStatus
PC-1Oil change100 h, 6 moSep 21, 2026, 330.0412.6, 14.0430.0Mar 21, 2027Nov 20, 2026Nov 20, 20267Due in 14 days
PC-1Air filter clean25 h shop, 3 moNov 2, 2026, 395.0412.6, 14.0420.0Feb 2, 2027Nov 15, 2026Nov 15, 20262Due in 14 days
PC-1Valve clearance, dealer300 h, 12 moApr 6, 2026, 120.0412.6, 14.0420.0Apr 6, 2027Nov 15, 2026Nov 15, 20262Due in 14 days
PW-1Oil change100 h, 6 moMay 4, 2026, 150.0238.0, 4.0250.0Nov 4, 2026Dec 1, 2026Nov 4, 2026-9Due now
PW-1Sediment cup clean100 h, 6 moMay 4, 2026, 150.0238.0, 4.0250.0Nov 4, 2026Dec 1, 2026Nov 4, 2026-9Due now
CS-1Spark plug replace300 h, 12 moDec 8, 2025, 0.0301.5, 9.0300.0Dec 8, 2026Nov 12, 2026Nov 12, 2026-1Due now
CS-1Air filter clean25 h shop, 3 moOct 26, 2026, 290.0301.5, 9.0315.0Jan 26, 2027Nov 22, 2026Nov 22, 20269Due in 14 days
CS-1Oil change100 h, 6 moOct 26, 2026, 290.0301.5, 9.0390.0Apr 26, 2027Jan 19, 2027Jan 19, 202767OK
SG-1Break-in oil change20 h, 1 moOct 20, 2026, 0.011.5, 3.520.0Nov 20, 2026Nov 29, 2026Nov 20, 20267Due 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

  1. Read the engine model and serial number from each engine and record them in column C; a machine frame can outlive its engine.
  2. 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.
  3. Move the "each use" items to the operator's daily checklist.
  4. Enter any shop interval in column G, with its source in column H.
  5. 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.
  6. Read every hour meter, enter the readings on the Readings tab, and repeat each week for at least four weeks before trusting column Q.
  7. 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.
  8. 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