Every equipment dealer tracks warranties somewhere — a spreadsheet, an ERP custom field, a binder, someone's memory. The question isn't whether you track them; it's whether the tracking fires when a warranty is about to expire, with enough lead time to sell the renewal. This is the practical guide: what to record per machine, where spreadsheets break, and what dedicated warranty tracking software changes.
What to track per asset (the minimum viable record)
| Field | Why it matters |
|---|---|
| Serial number | The identity everything else hangs on — service history, claims, coverage disputes |
| Customer + site | Warranties belong to machines, but conversations happen with people |
| Install date | Anchors the warranty clock and, later, the end-of-life estimate |
| Warranty start / end | The OEM coverage window — the date that drives everything |
| Extended warranty end | If you sold one, it supersedes the OEM date; effective coverage = the later of the two |
| Model → OEM defaults | Standard warranty months per model, so new units get correct dates automatically |
| Service history | Was that repair under coverage? Without history per serial, you can't prove it either way |
Two subtleties cost dealers real money. First, extended warranties overwrite nothing — they layer. If your system has one "warranty end" column, every extension you sell silently corrupts the record of what the OEM owes you. Track both dates. Second, the model's published warranty period is data, not trivia — pre-loading OEM defaults per model means a newly registered unit gets the right dates with zero typing. Servatio ships these defaults for 168+ models across Melag, Dürr Dental, NSK, Planmeca and others.
Where the spreadsheet breaks
A warranty spreadsheet works at 30 machines. It degrades quietly as you grow:
- No alerts. A date in a cell doesn't ring. Someone has to remember to filter by date — weekly, forever, including August.
- No ownership. The sheet says the warranty expires; it doesn't say who is supposed to call the customer, or whether they did.
- Stale on day one. Every install, extension and contract signed has to be re-typed. Each miss is a permanently wrong row.
- No value attached. 40 expiring warranties is a list; "€38,000 of renewal value expiring in 60 days" is a Monday-morning priority.
The industry pattern we see repeatedly: dealers crossing ~100 installed machines lose 20-30% of renewal opportunities to silent expiration. The data was in the sheet the whole time. (The full conversion playbook is in our warranty leakage guide.)
Servatio's AI importer maps your warranty spreadsheet automatically — and from then on, every expiration fires an alert at 90/60/30 days with the at-risk value attached.
Start free trialWhat warranty tracking software changes
Dates become a pipeline
Instead of a column you filter, coverage becomes visual stages — active → expiring 90d → 60d → 30d → expired — that a manager scans like a sales board. Movement between stages is automatic; the work is the conversation, not the bookkeeping.
Expirations become alerts with owners
An alert engine watches every machine and pushes upcoming expirations into an inbox — snoozable, dismissable, resolvable, with an audit trail. Nothing depends on someone remembering to look.
Alerts carry money
Each expiring warranty carries its renewal value, so the queue self-prioritizes: the €4,000 CBCT contract conversation happens before the €150 curing-light one.
The machine answers questions in the field
A QR code on the unit opens its identity and live coverage status — so a technician on site (or the customer) can answer "is this under warranty?" without calling the office.
Tracking feeds the next sale
Tracking is step one. The same record powers warranty management (renewal offers, AI-drafted in the customer's language), service contracts, and asset lifecycle planning — one system of record, several revenue motions.
Frequently asked questions
What should warranty tracking software record per asset?
Serial, customer and site, install date, warranty start/end, extended warranty end, the model's OEM defaults, and service history per serial. Effective coverage is the later of OEM and extended dates.
Can I track warranties in a spreadsheet?
Up to ~100 assets, with discipline, yes. Past that it fails silently: no alerts, no ownership, stale dates, and renewal opportunities expiring unnoticed.
Tracking vs. management — what's the difference?
Tracking is the system of record (dates, coverage, alerts). Management adds the commercial layer (pipelines, offers, contracts, billing). Dealers need both — ideally in one tool, so the record drives the revenue motion directly.
How fast can I be live?
If your data is in Excel: import it, let the AI map the columns, review the flagged rows. Most dealers see their full warranty pipeline populated the same afternoon.