# Contract Renewal and Notice Deadline Tracker Worksheet > Source: https://netray.co/tools/contract-renewal-and-notice-deadline-tracker-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable register of contracts with end dates, notice periods, auto-renew flags and the cost of annual uplifts. ## Category compliance-legal ## Industry Discrete Manufacturing ## Audience - Contracts manager - Buyer - Controller - Owner ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Contract **Key:** contract **Type:** text #### Counterparty **Key:** party **Type:** text #### Type **Key:** type **Type:** select **Options:** - Supply agreement - Service contract - Software license - Lease - Maintenance - Customer agreement - NDA - Other #### End date **Key:** end_date **Type:** date #### Notice days **Key:** notice_days **Type:** number #### Auto renews **Key:** auto **Type:** select **Options:** - Yes - No #### Annual value **Key:** annual **Type:** number **Format:** currency #### Uplift on renewal (%) **Key:** uplift **Type:** number #### Uplift cost per year **Key:** uplift_cost **Type:** number **Expr:** annual * uplift / 100 **Format:** currency #### Owner **Key:** owner **Type:** text #### Next action **Key:** action **Type:** select **Options:** - Review - Renegotiate - Renew - Terminate - Rebid - None **Rows:** **Contract:** CNC maintenance contract **Party:** Techserv Machine Care **Type:** Maintenance **End date:** 2027-03-31 **Notice days:** 90 **Auto:** Yes **Annual:** 42000 **Uplift:** 5 **Owner:** Maintenance **Action:** Renegotiate **Contract:** ERP annual support **Party:** ERP vendor **Type:** Software license **End date:** 2027-01-31 **Notice days:** 60 **Auto:** Yes **Annual:** 96000 **Uplift:** 7 **Owner:** IT **Action:** Review **Contract:** Aluminium bar supply **Party:** Metalline Supply **Type:** Supply agreement **End date:** 2027-06-30 **Notice days:** 120 **Auto:** No **Annual:** 310000 **Uplift:** 3 **Owner:** Purchasing **Action:** Rebid **Contract:** Forklift lease **Party:** LiftCo Leasing **Type:** Lease **End date:** 2026-12-31 **Notice days:** 30 **Auto:** Yes **Annual:** 18000 **Uplift:** 4 **Owner:** Operations **Action:** Terminate **Contract:** Mutual NDA, aerospace customer **Party:** Orbit Dynamics **Type:** NDA **End date:** 2028-02-01 **Notice days:** 0 **Auto:** No **Annual:** 0 **Uplift:** 0 **Owner:** Sales **Action:** None **Totals:** #### Total annual contract value **Key:** annual **Agg:** sum **Format:** currency #### Total uplift cost per year **Key:** uplift_cost **Agg:** sum **Format:** currency #### Contracts tracked **Key:** contract **Agg:** count **Format:** integer **Summary:** #### Average uplift on value **Key:** avg_uplift **Expr:** sum_uplift_cost / sum_annual * 100 **Format:** percent **Description:** Weighted average uplift across all contracts with a value. **Notes:** Compute the notice deadline as the end date minus the notice days, and add it to your calendar with a reminder 30 days earlier. Dates in the table are examples. Auto-renew clauses are the most expensive to miss. ## Content **Intro:** Contracts that renew automatically cost real money when nobody notices the notice deadline. A simple register with end dates, notice periods and uplift percentages catches them in time. This worksheet is that register, exportable to Excel. **Sections:** #### How to use the worksheet **Body:** List every contract with a term: supply agreements, service and maintenance, software support, leases, customer agreements and NDAs. Enter the end date and the notice period in days from the contract. Mark auto renew. Enter the annual value and the uplift percentage you expect on renewal, and the cost of that uplift is computed. Sort by end date and review monthly. Each row needs an owner and a next action. **Bullets:** - Notice deadline equals end date minus notice days - Flag auto-renew contracts first - Record the owner who negotiates, not the signatory - Review the list monthly with finance #### Why the uplift column matters **Body:** Most renewals include a price increase, either a fixed percentage or an index. Multiplying annual value by the uplift shows the cost of doing nothing. Across a portfolio this often justifies a rebid or renegotiation project, especially for maintenance and software support where vendors depend on inertia. Compare the total with your target savings. #### Worked example **Body:** In the sample, the aluminium supply contract carries the biggest value at USD 310,000, with a 3 percent uplift costing USD 9,300 per year and a 120 day notice period. Its end date of 30 June means notice must be given by early March. The ERP support contract, with 60 days notice before 31 January, has to be addressed by early December, otherwise it auto renews at plus 7 percent. #### Common mistakes **Body:** Common errors are missing contracts held by individual departments, tracking the signature date rather than the end date, ignoring notice periods, and forgetting evergreen contracts that renew after the first term. Link the register to your vendor master, so each supplier record in the ERP shows its contract end date and notice deadline. **Cta:** Netray can help pull spend by supplier from your ERP next to contract terms, so renewal decisions use real numbers. This is optional. **Faq:** #### How far ahead should I review a contract? **Answer:** Start at least the notice period plus 60 to 90 days before the end date. That leaves time to benchmark prices, rebid if needed, and negotiate. For large contracts, start even earlier. #### What is an evergreen clause? **Answer:** An evergreen clause renews a contract automatically for another term unless someone gives notice. Missing the notice window can lock you in for a year or longer, so these deserve the first alert. #### Should NDAs be in the register? **Answer:** Yes, they have end dates and survival periods too. They rarely carry cost, but confidentiality obligations can last years after the relationship ends, and you need to know what is still in force. #### Can I export this to Excel? **Answer:** Yes. Export to Excel or CSV and keep it on a shared drive, or import it into your contract system. Computed uplift cost exports as values. ## Search terms contract renewal tracker excel, contract expiry tracker template, contract notice period tracker, auto renewal contract register, supplier contract register template, contract management spreadsheet free --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json