Here's a bug we found in our own product: once a renewal date passed, the vendor sat at "216 days overdue" forever, and the reminders stopped. Most spreadsheets have the same bug. The contract auto-renewed, nobody updated the cell, and the tracker quietly stopped tracking.
Two kinds of renewals
Auto-renewing contracts roll into a new term unless you cancel. For these, a passed date isn't "overdue", it's "you're locked in for another term", and the next date is what matters. Fixed-term contracts actually end. For these, a passed date means the service may stop.
VendorCat now asks one question per vendor, "Does it auto-renew, and on what term?", and rolls the date forward on its own, with a note in the vendor's history. Only fixed-term contracts turn red as expired.
The three dates that matter
- The renewal date: when the next term starts.
- The cancellation window: often 30 to 90 days before renewal. Miss it and you're paying for another year.
- Your decision date: a week or two before the window closes, so there's time to ask the questions.
Set reminders against the window, not the renewal. VendorCat's 30/14/7-day alerts exist for exactly this.
One more habit
Before any renewal over a few hundred dollars, look at the vendor, not just the invoice. Did they get acquired? Breached? Raise prices on new customers? A two-minute look at the report card is cheaper than a year of regret.