A pipeline, not a colour-coded spreadsheet.
Filter by overdue, due soon, and coming up. Each row is a real certificate with a property, a service type, and a date — the same record the field team will reopen when they go back. Assign the renewal instead of hoping someone noticed the tab in Excel.