Vendor & Contract Renewal Tracker: Excel & Google Sheets Template

Vendor Contract Renewal Tracker for Excel and Google Sheets

A spreadsheet for tracking vendor contracts and subscriptions by their notice deadline, the last day you can cancel or renegotiate before a contract renews on its own.

What's included

• A contract register with 200 rows that works out annual cost, next renewal, notice deadline, days left and a status (Act now, Upcoming, Notice passed, Active or Expired). Auto-renewing contracts roll forward to the next term.
• A Notice Letter tab that drafts a non-renewal, renegotiation or termination letter for the contract you pick
• A Savings Won column for what each renegotiation or cancellation saved per year
• A vendor list with 100 rows, W-9 status and insurance certificate (COI) expiry dates
• A quarterly vendor scorecard with five weighted criteria
• A 12-month renewal calendar
• A dashboard with totals, a watch list, the next notice deadlines and 4 charts
• A Phone View tab with the next 10 deadlines
• An Instructions tab and a 2-page Quick Start Guide (PDF)

Files

• Vendor Contract Renewal Tracker.xlsx, with fictional sample vendors and contracts
• Vendor Contract Renewal Tracker (blank).xlsx, the same workbook with no data
• Quick Start Guide.pdf

You get them in one zip file, Vendor Contract Renewal Tracker.zip.

Good to know

Works in Excel 2016 or later and Microsoft 365 on Windows or Mac, and in Google Sheets on a computer, phone or tablet. There are no macros or add-ins. To use it in Google Sheets, upload the .xlsx to Google Drive, open it with Google Sheets, then choose File > Save as Google Sheets.

The notice letter is a starting point, not legal advice. Check the notice clause in your contract for how notice has to be sent.

This is a digital download, so nothing is shipped. You can download the files from your Etsy Purchases page (or the Payhip link) right after you buy. Sample names and figures are fictional.

License (single company): for use inside one company only. You may edit it and use it with your team. You may not resell, share or redistribute the files, or use one purchase for more than one company.

Questions? Email Bengopoyan1@gmail.com. More templates: etsy.com/shop/KeelAndCharter and payhip.com/KeelandCharter

Designed and reviewed by Keel & Charter. AI tools helped build the spreadsheets, draft the text and lay out the preview images. Preview images show the actual files with sample data.