Annual Maintenance Contract (AMC) Tracker Format in Excel: Free Template & Operations Checklist

Why Facility AMCs Fail Without Tracking

In commercial buildings, factories, schools, and corporate offices, physical operations depend on Annual Maintenance Contracts (AMCs). You have contracts for diesel generator sets, passenger elevators, VRV/chiller air conditioning systems, CCTV networks, UPS battery banks, and fire suppression systems.

When an AMC lapses quietly, nothing seems wrong—until a chiller compressor seizes in July or an elevator controller card burns out during business hours. When you call the vendor, you discover:

• The contract expired 18 days prior without notice.
• Repairs that would have been covered under the warranty or comprehensive contract now require emergency purchase orders at three times the standard cost.
• The technician dispatch takes 72 hours instead of the 4-hour SLA stipulated in your agreement.

A structured AMC tracking sheet prevents these emergency operational breakdowns by establishing clear visibility into vendor service dates and renewal deadlines.

The Standard AMC Excel Column Format

Here is the exact column layout operational facility teams use to manage complex equipment portfolios:

Comprehensive vs. Non-Comprehensive AMC Terms

When tracking your maintenance contracts, always include a dedicated column specifying the contract scope:

• Comprehensive AMC (CAMC): The vendor covers scheduled routine servicing, labor costs, replacement of worn consumable components, and major mechanical failures. This is mandatory for mission-critical hardware like elevators, main switchgear, and server room precision AC units.
• Non-Comprehensive AMC (Labor Only): The vendor provides periodic scheduled inspections and diagnostic labor, but every spare part, gasket, capacitor, or fluid replacement is billed separately. If you have this contract type, you must budget a secondary maintenance contingency fund.

Quarterly PPM Scheduling Inside the Tracker

A common mistake in maintenance tracking is only logging the annual expiration date while ignoring the quarterly Planned Preventive Maintenance (PPM) visits. Vendors often bill full quarterly charges even when their technicians skip scheduled maintenance runs.

Add four sub-columns for Q1 Service, Q2 Service, Q3 Service, and Q4 Service with signed job-sheet numbers. Do not approve vendor invoices until your facility engineer confirms the preventive service report is attached.

Contract Notice Deadlines & Vendor Negotiation

Most commercial AMC agreements include an automatic rollover clause stipulating that unless either party gives 30 or 60 days written notice prior to the expiration date, the contract automatically extends for another 12 months with a standard 5% to 8% price increase.

By tracking the Notice Deadline rather than the final expiration date, your procurement team gains a 60-day window to evaluate market competitor rates, negotiate discounts, or tender a fresh RFP.

Upgrading from Spreadsheets to WhatsApp Alert Ladders

While an Excel sheet is a solid starting point, spreadsheet files frequently get locked, corrupted, or ignored during busy facility renovations.

Switching your asset register to RenewOS gives your facilities team proactive escalation alerts sent straight to WhatsApp and email at 90, 60, 30, and 7 days. Your technicians can capture equipment nameplates directly using on-device camera OCR without typing serial numbers manually.