Home » Vendor Contract Tracker 2026 — Renewal, Notice & Spend Control Excel
Vendor Contract Tracker 2026 — Insigra Reports Excel system cover
Vendor Contract Tracker 2026 — Insigra Reports Excel system cover

Vendor Contract Tracker 2026 — Renewal, Notice & Spend Control Excel

$49.00 USD
14
Operational Sheets
25
Tracked Columns
4,146
Live Formulas
0
Subscriptions Required

Vendor spend leaks at the renewal date — the auto-renew nobody flagged, the notice window that closed last week, the contract that rolled over at last year's rate.

The Vendor Contract Tracker is a focused Excel system for the one discipline that protects procurement margin: knowing exactly which contract is up, when the notice deadline actually falls, and what each one costs — across every vendor, on one screen. Setup takes about ten minutes. Five minutes a week keeps you ahead of every renewal. One-time purchase, no subscriptions, no software to roll out.

Designed For

Who Uses This System

Built for the person accountable for renewals, notice periods, and vendor spend — where missing a window is a direct cost, not an administrative slip.

COOs & Operations LeadsProcurement & Vendor ManagersFinance & FP&AFounders — SMB to Mid-marketOffice & Admin ManagersConsultants
The Problem

Why Renewals Quietly Cost You Money

The expensive contract is not the one you negotiate. It is the one that renews while you are looking elsewhere. Four blind spots do most of the damage:

—Notice deadlines are invisible — you learn a window closed only after the contract has already rolled over
—Auto-renew contracts hide in plain sight — locked in for another term before anyone reviews the rate
—Spend concentration is never mapped — no one knows which categories or vendors carry the bulk of annual cost
—Finished contracts inflate live totals — old commitments distort what you are actually spending now
Complete System

What You Receive

Two Excel files and a PDF guide — a worked example carrying 318 sample contracts so you can see every alert and view in action, plus a blank template to run your own. One-time purchase.

1Filled Example Workbook (.xlsx)318-contract worked example
→Contract Tracker — one row per contract, 25 columns; eight calculate themselves
→Dashboard — six headline KPIs and a value-by-category chart, live
→Action Center — every contract ranked by urgency, with the next move
→Renewals & Alerts — bucket counts and value plus a 12-month renewal calendar
→Auto-Renew Exposure — your watch-list of contracts that renew themselves
→Risk Matrix — criticality against urgency across the portfolio
→Spend Summary — annual value by category with concentration share
→Savings & ROI — negotiation outcomes, baseline against achieved
→Vendor Scorecard — a performance read for each vendor
→Settings — single source of truth: as-of date, alert window, seven pick-lists
2Blank Template Workbook (.xlsx)

Identical sheet structure to the example, ready for your contracts. Fill only the shaded input cells — every formula, countdown, alert, dashboard tile and chart updates on its own. Room for 400 rows; copy a formula row down for more.

3PDF User Guide

Ten-minute setup from Settings through to the Dashboard, a field-by-field reference for all 25 columns, a guide to reading the alert flags, and a simple weekly operating rhythm.

Qualification

Is This Right For You?

This System Is For
✓Teams managing 10 or more active vendor or SaaS contracts
✓Anyone responsible for catching renewal and notice windows before they close
✓COOs, procurement and finance leads who want a five-minute weekly view
✓Founders who need renewal and spend control without procurement software
✓Consultants standing up a contract-governance layer for a client
Not Suitable For
×Businesses with only a handful of simple, non-renewing contracts
×Teams who want a plain contact list rather than a renewal and spend system
×Users who need Google Sheets — this is built for Microsoft Excel
×Anyone expecting automated email reminders — this is a self-managed weekly workbook
Outcomes

What This Enables

Never Miss a Notice Window
Notice Deadline is End Date minus your notice days, with a live countdown. You act against the real deadline, not just the expiry date.
Auto-Renew Under Control
Every self-renewing contract is flagged and listed on its own exposure view, so you decide before another term locks in.
Spend Concentration, Visible
Category rollups show where the money sits before you negotiate — the leverage and consolidation cases become obvious.
Clean Live Numbers
Mark contracts Renewed, Replaced or Cancelled and they drop out of live totals while staying on record — current figures never inflate.
One-Glance Urgency
The Alert column and Action Center turn every end date into a plain instruction — Action Now, Upcoming, OK, Expired — ranked for you.
Measured Savings
Log every negotiation outcome — baseline against achieved — for an auditable record of what the discipline returns.
Common Questions

Frequently Asked

What version of Excel is required?+
Excel 2016 or later on Windows or Mac. The system uses standard formulas only — no macros, no VBA, no Power Query, no add-ins.
Does this work in Google Sheets?+
It is built and tested for Microsoft Excel. Some formulas and dashboard outputs may not carry over reliably on import to Google Sheets.
How many contracts can I track?+
There is room for 400 rows out of the box. To go further, select the last formula row, copy it, and paste down as many rows as you need — every calculation extends automatically.
How does it know what counts as "due soon"?+
A single Reporting As-of Date and an alert window on the Settings sheet drive every countdown and flag. Change the as-of date for a fresh read of the whole portfolio at any time.
Can a consultant use this for client work?+
The standard license covers single-business use. For use across multiple clients or organisations, contact hello@insigrareports.com to discuss a professional license.