SaaS renewal forecasting template
A free Excel spreadsheet for tracking vendor contract renewals, notice window deadlines, and auto-renewal risk. Built for procurement managers and finance teams at 50-500 person companies.
No email required. Works in Excel and Google Sheets.
What's in the template
Sheet 1
Contract register
- 118 columns: vendor, type, owner, value, dates
- 2Auto-calculated notice deadline
- 3Days-to-deadline counter (updates daily)
- 4Status: ACTIVE / DUE SOON / URGENT / EXPIRED
- 5Risk level: HIGH / MEDIUM / LOW
- 6UK financial year (Apr-Mar) assignment
- 7Dropdown validation on all key fields
- 8Conditional colour coding throughout
Sheet 2
Renewal calendar
- 112-month rolling view from today
- 2Shows contract value in expiry month
- 3Totals row per month - plan your renewal budget
- 4Auto-linked from contract register
- 5No manual updates needed
Sheet 3
Summary dashboard
- 1Total active contracts
- 2Total annual vendor spend
- 3Contracts with auto-renewal clauses
- 4URGENT and DUE SOON counts
- 5Value at risk (high-risk contracts)
- 6Spend breakdown by category
- 7All figures pull automatically
Who it's for
Procurement managers
Tracking 50+ vendor contracts in a spreadsheet that nobody updates. This one updates itself.
Finance managers
Finance asked for total vendor spend and it took three days. The dashboard gives you an answer in three seconds.
IT managers
SaaS sprawl. 40 tools, half on auto-renewal. The register flags every auto-renewal clause.
Office / operations managers
You own the vendor relationships but have no system. This is the system.
Want this done automatically?
Renewly extracts renewal dates, notice windows, and auto-renewal clauses from your vendor contract PDFs automatically - usually in under a minute per contract. No copy-paste, no manual entry.
Free for up to 5 vendor contracts. Starter from $149/month.