Workflow7 min read
Renewal tracking spreadsheet vs software: a free template and when to switch
By the RenewalRemind team
A renewal tracking spreadsheet works for a handful of items if it has the right columns: item, type, client, provider, expiry date, days left, cost, auto-renew, account owner and notes. It stops working once nobody opens it — spreadsheets don't send reminders, can't see that a site is down and drift out of date. Switch to a renewal tracker when you have more than about 20 items, more than one person, or clients depending on you.
Key takeaways
- Columns that matter: item, type, client, provider, expiry, days left, cost, auto-renew, account owner, notes.
- Days left: =C2-TODAY() — then conditional formatting for 30 and 7 days.
- A spreadsheet only works if someone opens it; reminders are what actually prevent expiry.
- Switch at ~20 items, a second person, or the first renewal you nearly missed.
Almost everyone starts tracking renewals in a spreadsheet. It's free, flexible and already open on your computer. For a handful of items, it's the right choice. Below is a template with the columns that actually matter, the formulas to make it useful, and the honest signs you've outgrown it.
The renewal tracker template
Create these columns in Google Sheets or Excel (one row per renewable item):
| Column | Example | Why it matters |
|---|---|---|
| A. Item | example.com | What renews |
| B. Type | Domain / SSL / Hosting / Email / Licence / AMC | Different types renew differently |
| C. Client | Sharma Traders | Who to bill and who to tell |
| D. Provider | Hostinger | Where to renew |
| E. Expiry date | 2027-03-14 | The date everything else depends on |
| F. Days left | =E2-TODAY() | What you actually look at |
| G. Cost | ₹1,299 / year | Budget and invoicing |
| H. Auto-renew | Yes — client's card | Whether you must act, and whose card can fail |
| I. Account owner | Client / us | Who can log in and renew |
| J. Notes | Renew for 3 years next time | Anything the next person needs |
Formulas that make it work
Days left (copy down column F):
=IF(E2="", "", E2-TODAY())A status column that reads like a traffic light:
=IF(F2="", "", IF(F2<0, "Overdue", IF(F2<=7, "Critical", IF(F2<=30, "Warning", "Safe"))))Then add conditional formatting on the status column — red for Overdue, orange for Critical, amber for Warning — and sort by days left so the most urgent rows are always at the top.
Where spreadsheets fall short
- They don't remind anyone. A spreadsheet only works when someone opens it. The week you're busy is the week something expires.
- They drift out of date. Renew a domain and forget to update the row, and next year's date is wrong.
- They can't see the real world. A spreadsheet doesn't know that an auto-renewal failed, a certificate wasn't installed or a site is down.
- Sharing is all or nothing. Everyone with the link sees every client and can edit every row.
- Scripts become a project. You can make Google Sheets email you with Apps Script and a time trigger — but then you maintain a script, and it still can't check a site.
Signs it's time to switch
- You track more than about 20 items, or more than a few clients.
- More than one person needs to see or update the list.
- You've had a near miss — or a real one.
- Clients pay you to look after their sites, so a missed renewal is your problem.
- You also want to know when a site is down or its certificate is about to expire.
What renewal tracking software should do
| Spreadsheet | Renewal tracker | |
|---|---|---|
| Cost | Free | Free plans exist; paid as you grow |
| Reminders | Only if you script them | Email and in-app, on a schedule |
| Domain expiry dates | Look up by hand | Looked up automatically (WHOIS) |
| Site and SSL monitoring | No | Often built in |
| Team access | Whole sheet or nothing | Per-person permissions |
| Import your existing sheet | — | CSV import |
If you're choosing a tool, check that it covers all your renewal types — not just domains — and that it reminds several people well before the date (see how to set up reminders for client renewals).
Frequently asked questions
How do I calculate days until expiry in Excel or Google Sheets?
If the expiry date is in cell E2, use =E2-TODAY() and format the cell as a number. Negative values mean the item has already expired.
Can Google Sheets send renewal reminders?
Not on its own. You can write an Apps Script with a time trigger to email upcoming expiries, but it needs maintaining and won't tell you if a site is down or a certificate is broken.
What should a renewal tracker include?
Every renewable item (domains, SSL, hosting, email, licences, AMC contracts), its expiry date, provider, cost, whether it auto-renews, who owns the account and who should be reminded.