Equipment Maintenance Log

Keep an asset register with service intervals and a maintenance history, so next-due dates, overdue equipment and costs are always visible.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Log Sheets

Tables

Equipment, Maintenance Records

Fields

27

Views

grid, kanban, calendar, form, dashboard

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Equipment

14 fields · 5 sample rows

  • Asset register (Grid)
  • Condition (Kanban)
EquipmentTextAsset TagTextCategorySingle selectLocationTextManufacturerTextSerial #TextService Interval (days)NumberConditionSingle selectMaintenanceLink to another tableServicesCountLast ServiceRollupNext Service DueFormulaService StatusFormulaLifetime CostRollup
Rooftop AC unit #1HV-001HVACRoof, Block ADaikinDK-8823190GoodQuarterly filter clean & gas check131 Aug 202629 Nov 2026Due soon₹3,700
CNC milling machinePR-014ProductionShop floorHaasHS-5501230FairSpindle lubrication, Replace coolant pump27 Nov 20267 Dec 2026OK₹19,300
Diesel generator 125 kVAPW-002PowerUtility yardCumminsCM-12077180GoodLoad test and oil change120 Sep 202619 Mar 2027OK₹9,200
Server room UPSIT-007ITServer roomAPCAPC-9921365Needs repairBattery health check114 Nov 202614 Nov 2027OK₹0
Fire extinguishers (set)SF-010SafetyAll floors365Good0No history₹0
Field details
Equipment · Text
Asset Tag · Text
Category · Single select
HVAC, Production, Kitchen, IT, Power, Safety
Location · Text
Manufacturer · Text
Serial # · Text
Service Interval (days) · Number
Condition · Single select
Good, Fair, Needs repair, Out of service
Maintenance · Link to another table
Links to Maintenance Records
Services · Count
Last Service · Rollup
latest of Date via Maintenance
Next Service Due · Formula
IF(AND({Last Service}, {Service Interval (days)}), DATEADD({Last Service}, {Service Interval (days)}, 'days'), BLANK())
Service Status · Formula
IF(NOT({Next Service Due}), 'No history', IF(IS_BEFORE({Next Service Due}, TODAY()), 'Overdue', IF(DATETIME_DIFF({Next Service Due}, TODAY(), 'days') <= 14, 'Due soon', 'OK')))
Lifetime Cost · Rollup
sum of Total Cost via Maintenance

Maintenance Records

13 fields · 5 sample rows

  • History (Grid)
  • Calendar (Calendar)
  • Log maintenance (Form)
  • Costs (Dashboard)
Work DoneTextEquipmentLink to another tableDateDateTypeSingle selectPerformed ByTextVendorTextParts CostCurrencyLabour CostCurrencyTotal CostFormulaDowntime (h)NumberResultSingle selectPhotosAttachmentNotesLong text
Quarterly filter clean & gas checkRooftop AC unit #131 Aug 2026PreventiveCoolTech ServicesCoolTech₹1,200₹2,500₹3,7002.0Pass
Spindle lubricationCNC milling machine15 Oct 2026PreventiveRaju (in-house)₹800₹0₹8001.0Pass
Replace coolant pumpCNC milling machine7 Nov 2026RepairHaas service engineerHaas India₹14,500₹4,000₹18,5006.0Fixed
Load test and oil changeDiesel generator 125 kVA20 Sep 2026PreventivePowerCarePowerCare₹6,200₹3,000₹9,2003.0Pass
Battery health checkServer room UPS14 Nov 2026InspectionIT team₹0₹0₹0Needs follow-up2 of 8 batteries below 70% — order replacements.
Field details
Work Done · Text
Equipment · Link to another table
Links to Equipment
Date · Date
Type · Single select
Preventive, Repair, Inspection, Calibration, Replacement
Performed By · Text
Vendor · Text
Parts Cost · Currency
INR
Labour Cost · Currency
INR
Total Cost · Formula
{Parts Cost} + {Labour Cost}
Downtime (h) · Number
Result · Single select
Pass, Fixed, Needs follow-up, Failed
Photos · Attachment
Notes · Long text

Form view “Log maintenance work” asks for: Work Done, Equipment, Date, Type, Performed By, Vendor, Parts Cost, Labour Cost, Downtime (h), Result, Photos, Notes.

Equipment Maintenance Log: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates