Gather every agreement into one folder, have an AI assistant extract the end date, renewal type, notice period and price-change clause from each into a spreadsheet register, then calculate the notice deadline with a formula (end date minus notice) and set two reminders before each deadline, owned by a named person. AI reads; the spreadsheet counts.
The date that catches businesses out is almost never the renewal date. It's the last day you can give notice. A software contract that renews on 1 March with 90 days' notice has to be cancelled by 1 December, three months before anyone thinks about it. Most missed renewals come from tracking the wrong date, so the whole set-up below is built around the notice deadline.
Four terms to pull from every agreement
Before you run any AI over your contracts, agree what you're extracting. These four terms decide whether you can act in time.
- Current term end date. When the present period finishes. Often not written as a date: "12 months from the Effective Date" means you calculate it from the start.
- Renewal mechanism. Auto-renewal (sometimes called evergreen: it rolls over unless someone stops it), renewal by agreement, rolling monthly, or fixed term with no renewal.
- Notice period and method. How long before the end you must tell them, and how: "written notice", "by email to the account manager", "by recorded post to the registered office". An email to the wrong address can be invalid.
- Price-change clause. Whether the price can rise at renewal and by how much, such as "the greater of 5% or the increase in the consumer price index". This is what turns a forgotten renewal into an expensive one.
Two more are worth capturing when they appear: a minimum commitment (you must pay for 12 months even if you cancel) and any right to terminate for convenience mid-term.
Step 1: Find the agreements you don't know you have (half a day)
The signed PDFs in your contracts folder are the easy part. The renewals that bite are the ones nobody filed. Work through these sources:
- Your e-signature account. Export every completed envelope from the last three years.
- Email search. Search for "order form", "renewal", "subscription agreement", "terms of service", "auto-renew" and "notice" across the shared and owner mailboxes.
- Card and bank statements. Every recurring payment is a contract, even if the "contract" is a click-through terms page. List each recurring payee from the last 13 months; annual charges only appear once.
- Supplier portals. Software dashboards usually show the plan, the billing cycle and the renewal date under billing or subscription settings. Screenshot or save the page as a PDF, because the online terms can change.
- Physical files. Leases, equipment finance, insurance schedules. Scan them with the OneDrive or Google Drive mobile app.
Name files consistently as you go, for example Supplier - Agreement type - Start date.pdf, so the register can link to them.
Step 2: Extract the terms with a prompt that quotes its evidence
Use an AI assistant on a business plan (ChatGPT Business, Claude Team, Gemini in Workspace or Microsoft 365 Copilot) so your contracts aren't used for training. Upload contracts in small batches, three to five at a time, and ask for a table with the exact clause quoted next to each answer. The quote is what makes checking fast.
You are extracting renewal terms from the attached agreements for a contract register.
For EACH agreement return one row with these columns:
Supplier | Agreement type | Start date | Initial term | Current term end date |
Renewal type (auto / by agreement / rolling / none) | Renewal term length |
Notice period as written | Notice period in days (calendar or business?) |
Notice method and address | Price-change clause (summary) |
Minimum commitment | Termination for convenience (Y/N) | Clause references
Rules:
- Quote the exact wording you relied on for end date, renewal and notice, with the
clause number or page.
- If a term isn't stated, write NOT STATED. Do not infer or assume market norms.
- If the end date must be calculated from the start date, show the start date and
the term, and write CALCULATE. Do not do the arithmetic.
- If two documents conflict (e.g. an order form and master terms), flag CONFLICT
and quote both.An illustrative row that came back for a project-management software order form:
Supplier: [Software vendor] | Type: Subscription order form | Start: 14 Feb 2025 |
Initial term: 12 months | End date: CALCULATE (start 14 Feb 2025 + 12 months) |
Renewal: auto | Renewal term: 12 months | Notice as written: "at least sixty (60)
days prior to the end of the then-current Subscription Term" | Days: 60 calendar |
Method: "written notice to the Customer Success contact or via the admin console" |
Price change: "renewal pricing may increase by up to 7%" | Minimum: full term |
Termination for convenience: N | Clauses: Order Form s.3; Master Terms 9.2What you'd check and fix in that row: the order form says 60 days, but open Master Terms clause 9.2 yourself, because master terms sometimes set a longer period that the order form doesn't override. And "via the admin console" means cancelling may simply be a setting, which is worth noting in the register so the person acting knows where to click.
Mistakes the extraction step makes
- "One month" turned into 30 days. A month's notice from 31 March isn't the same as 30 days. Record it as a month and let the formula handle it.
- The anniversary trap. "Prior to each anniversary of the Effective Date" was read as the end of the calendar year. The quote column exposes this immediately.
- Superseded documents. A 2023 agreement and a 2025 amendment both extracted as live. Keep only the latest term, and note the amendment in the clause reference.
- Scanned pages with no text layer. Some tools skip image-only pages silently. If a 14-page lease returns only terms from page 1, rescan with OCR switched on.
For long agreements where you need more than dates, the tutorial on AI contract review for small firms covers what these tools catch and miss.
Step 3: Build the register so the formulas do the counting
Paste the rows into Excel or Google Sheets as a table. Add these calculated columns, which work the same way in both:
| Column | Formula (example) | What it handles |
|---|---|---|
| End date (when CALCULATE) | =EDATE(StartDate, TermMonths) - 1 | "12 months from" start dates, including month-ends |
| Notice deadline (days) | =EndDate - NoticeDays | Calendar-day notice periods |
| Notice deadline (months) | =EDATE(EndDate, -NoticeMonths) | "One calendar month's notice" |
| Notice deadline (business days) | =WORKDAY(EndDate, -NoticeDays, Holidays) | Notice counted in working days, skipping a holiday list |
| Days left to act | =NoticeDeadline - TODAY() | Drives the colour and the reminders |
| Status | =IF(DaysLeft<0,"MISSED",IF(DaysLeft<=14,"ACT NOW",IF(DaysLeft<=60,"DECIDE","OK"))) | One word the owner can filter on |
Then add the human columns the AI can't fill: Owner (a person, not "ops"), Decision (renew / renegotiate / cancel / undecided), Annual cost and Link to file. Colour the Status column with conditional formatting so "DECIDE" and "ACT NOW" rows stand out when the sheet opens.
When a contract auto-renews, update the end date to the new term's end rather than adding a row. The history stays in the file; the register shows what's live.
Step 4: Reminders that land with the person who decides
Two reminders per contract is the sweet spot: one at 60 days before the notice deadline (time to review usage and get alternative quotes) and one at 14 days (time to send notice properly). One reminder gets snoozed; five get ignored.
Pick the lightest mechanism that works for your volume:
- Under about 30 agreements: create two calendar events per row by hand in Outlook or Google Calendar, invite the owner, and put the clause quote and file link in the event notes. An hour's work, and it needs no automation to maintain.
- 30 to 150 agreements: a scheduled workflow in Zapier, Make or Power Automate runs each morning, reads the register, and emails each owner the rows whose Days left to act equals 60 or 14. A few tasks a day; on Zapier this needs a paid plan because the free tier only allows two-step workflows.
- Over 150, or several signers: consider a dedicated contract tool (see below).
Here's reminder wording that gets acted on, because it contains the decision, not just the date:
Subject: DECIDE by 3 Nov - Design software renewal ($4,320/yr, +7% cap)
The design software subscription auto-renews on 2 Jan for 12 months.
Last day to give notice: 3 Nov (60 days' notice, written, via admin console).
Current seats: 12 | Seats active in last 30 days: 8
Options: renew as is / drop to 8 seats / cancel
Clause: Order Form s.3 "at least sixty (60) days prior..." File: [link]
Please record your decision in the register by 20 Oct.If you'd rather not build a workflow at all, the tutorial on ChatGPT scheduled tasks for business reminders shows a lighter option for a handful of dates, though it won't read your register for you.
A 12-person marketing agency's 46 agreements, start to finish
Take a marketing agency of 12 people with numbers that are illustrative but typical. Nobody had owned contracts; renewals were discovered on the bank statement.
Gathering (3.5 hours): the operations manager found 46 live agreements: 27 software subscriptions (only 9 with a signed order form, the rest click-through terms), 8 client retainers, 5 freelancer and partner agreements, an office lease, two insurance policies, a phone and broadband contract, a printer lease and a domain and hosting account.
Extraction (2 hours): ten batches through Claude on the agency's Team plan, about 4 minutes per batch to run and 8 to check against the quoted clauses. Doing the same by hand had been estimated at 15-20 minutes per agreement, so 12-15 hours.
Register and reminders (1.5 hours): formulas as above, owners assigned, calendar events for the 19 agreements with notice periods over 30 days.
What the first pass turned up:
- A printer lease that auto-renewed for 36 months unless cancelled with 90 days' written notice by post. The deadline was seven weeks away. Nobody knew.
- Three annual software plans billed monthly. Cancelling "any time" only stopped renewal; the remaining months of the annual commitment were still owed. Two were barely used.
- One software contract whose notice deadline had passed eight days earlier. It renewed; the lesson went into the register as a note for next year.
- Four agreements where the AI returned NOT STATED for notice. Three genuinely had none (rolling monthly); one had it in a separate terms page the order form referred to, which had to be saved and extracted separately.
Illustrative outcome in year one: two unused tools cancelled on time ($1,900 a year), seats cut on a third ($1,150), and the printer lease renegotiated rather than rolled over. The register takes the operations manager about 20 minutes a month to maintain: adding new agreements and updating renewed end dates.
Your own client retainers renew too
For an agency, the renewals that matter most are the ones clients can end. The same register works in the other direction: for each client retainer, record the term end, the client's notice period and your price-review clause, and set the 60-day reminder as a trigger to prepare a renewal conversation, not a cancellation.
AI earns its place again here. Sixty days out, the account lead can ask an assistant to turn the last quarter's reports into a one-page renewal note:
Using the attached monthly reports for [client] (July-September), draft a one-page
renewal note for the client's marketing director. Include: the three results that
matter most to their stated goals, one thing that underperformed and what we'll change,
and a proposal for the next 12 months at the current fee plus the 4% annual review in
clause 6. Plain, direct tone. Don't invent any figure not in the reports.A web design studio would do the same with hosting and care-plan agreements, where the renewal note lists uptime, updates applied and the tickets resolved. The point is the reminder arrives with enough lead time to have the conversation before the client's own notice deadline.
When a dedicated contract tool beats the spreadsheet
A spreadsheet register handles most small businesses comfortably. Consider a dedicated contract-management tool once you have more than about 150 live agreements, several people signing contracts, or a need for approval workflows and audit history.
If you already sign with Docusign, check its Agreement Manager (previously called Navigator), which Docusign says uses AI to extract key terms, commitments and deadlines and to manage renewals and obligations. Docusign includes it only in selected Intelligent Agreement Management plans, so compare the plan price against the few hours a month the spreadsheet actually costs you. The same test applies to any contract tool: run your 20 most awkward agreements through its trial and compare its extracted notice deadlines with your checked register.
Giving notice so it actually counts
Tracking the deadline is wasted if the notice itself is invalid. Three details decide it, and the register should already hold all three: the method (email, post, portal), the address or contact, and whether the contract counts notice from when it's sent or when it's received. "Received no later than 60 days before" means a letter posted on day 61 can arrive too late. Weekends matter too: if the deadline falls on a Saturday, send it on the Thursday rather than finding out whether Friday counts.
An AI assistant can draft the notice from the register row in seconds. Give it the row and the clause, and ask for something short and unambiguous. An illustrative result for a video-hosting subscription:
Subject: Notice of non-renewal - Account 48213 - Subscription ending 31 January
Dear Customer Success team,
In accordance with section 9.2 of the Master Subscription Terms, we give notice
that we do not wish to renew our subscription (account 48213, Business plan,
10 seats), which ends on 31 January. Please confirm in writing that the
subscription will not renew and that no further charges will be taken after
that date.
Kind regards,
[Name], Operations Manager, [Company]What to check before sending: the account number and plan name against the latest invoice, the section number against the contract rather than the register, and that the sender is someone the contract recognises (some agreements require notice from an authorised signatory). Then keep the proof: the sent email with its timestamp, the postal receipt, or a screenshot of the portal's cancellation confirmation. Save it next to the contract and mark the register's Decision column "Notice given" with the date.
If the supplier replies offering a discount to stay, you've lost nothing by giving notice on time. You now negotiate from a position where the default is that the contract ends, which is a much stronger place than asking for a better price a week after it silently renewed.
Checking the register is right before you rely on it
A register that's wrong is worse than none, because people stop checking the contracts themselves. Build in these checks:
- Clause-quote review on every row. The person entering the row reads the quoted clause and confirms the notice period matches. This is the step that catches most errors.
- Random re-read. Each quarter, pick five rows at random and read the original agreement end to end. If more than one has an error, re-check the whole batch it came from.
- Red-flag filter. Filter for auto-renew = yes and notice = NOT STATED. Every one of those needs a human answer.
- Bank statement reconciliation. Once a quarter, compare recurring payees on the statement with the register. Any payee not in the register is an agreement you've missed.
- Test one reminder. Set a dummy row with a deadline tomorrow and confirm the reminder reaches the owner, not a shared inbox nobody reads.
A final caution on notice itself: when you do cancel, send notice exactly as the contract specifies, keep proof of delivery, and ask the supplier to confirm in writing. For contracts with large sums or unclear wording, get a solicitor to read the clause before you rely on your own interpretation. The tutorial on auto-renewals, price rises and notice periods in AI software contracts covers the negotiating side once your register tells you what's coming, and whether chat-with-PDF tools are safe for contracts is worth reading before you upload anything confidential.
Renewal tracking questions from small teams
Should the AI calculate the notice deadline for me?
Let it quote the clause and the notice period, but calculate the deadline with a spreadsheet formula. Language models make date arithmetic slips, especially with month-ends and business days, and a formula is checkable by anyone. Keep the AI on reading and the spreadsheet on counting, and you get the benefit of both without trusting either blindly.
What if a contract has no end date at all?
Rolling agreements with no fixed term usually say how much notice either side must give to end them. Record the notice period and set a yearly review date instead of a deadline, so someone still asks whether you need the service. Mark the row clearly as rolling so it doesn't look like missing data.
Is it safe to upload contracts to an AI assistant?
Contracts contain commercial terms and sometimes personal data, so use a business plan that doesn't train on your content, or strip out names and prices you don't need extracted. Check the tool's retention terms first. For highly sensitive agreements, extract by hand or use a tool your legal adviser has approved.
Further reads
- How to Read AI Software Pricing: Seats, Credits, and Usage Fees — Understand seat, credit and usage terms before a software renewal.
- AI Clauses for Agency Contracts: Disclosure, Ownership, Approvals — What to put in your own client contracts about AI use.
- How to Summarise Long Documents With AI Without Missing Details — Get reliable summaries of long agreements without missed details.
- AI Document Processing: Turn PDFs and Scans Into Usable Data — The wider picture of turning PDFs into usable data.
- Can AI Sort and File Incoming Documents for Your Business? — Catch new contracts as they arrive instead of hunting later.
- Automate Client Onboarding With AI: Forms, Contracts, and Emails — Make every new client contract land in the register automatically.
- How to Automate Insurance Renewals With AI and Keep More Clients — Automate the renewal calendar, pre-fill last year's answers, score which clients might leave, and spend broker time on the calls that keep them.
- How to Write Terms of Business With AI and What Needs a Lawyer — Map your trading terms clause by clause, draft the operational ones with AI, and brief a lawyer on the risky ones so the review stays short.
- How to Get Your Records Ready to Sell Your Business, With AI — Get your accounts, contracts, stock and staff records buyer-ready over 12 to 24 months, using AI to index, summarise and spot the gaps.
- Compliance Calendar: Track Licences, Insurance and Certificates — Track every licence, policy and certificate in one register, let AI pull the dates from new documents, and send reminders early enough to act on.
- How to Compare Supplier Quotes Side by Side With AI — Use AI to pull three messy quotes into one like-for-like table, spot what each leaves out, and recheck the totals in a spreadsheet before you choose.
- AI Supplier Management: Track Prices, Lead Times, and Risk — A supplier register AI can keep up to date: price histories from invoices, measured lead times, delivery performance and a simple risk score, reviewed monthly.
- Can AI Review a Contract? What Small Business Owners Should Know — What an AI first read of a contract catches and misses, when to pay a lawyer, a clause-by-clause prompt and a tour operator's hotel contract read end to end.
- AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.
Sources: Docusign Agreement Manager product page, checked September 2026.