AMC renewal tracker and reminder drafts
AMC expired yesterday. The renewal reminder is scheduled for next week.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Get the renewal list
Use customer, contract ref, expiry date, renewal status and approved renewal terms if available. No personal contact details.
Confirm reminder window
Use your team's rule and actual expiry from contract. Do not promise a new term or rate.
Privacy Remove phone numbers, email IDs and payment details where not needed. Use only approved business names and facts.
I'm attaching AMC renewal rows as on [As on date]. Flag open contracts expiring within [Expiry within days] calendar days inclusive and already expired. Sign off: [Sign off]. A. Per contract calculate days to expiry; classify expired, due soon, later, renewed or expiry missing. Renewed rows excluded from reminder list. B. Count statuses and list expiry date, customer and any supplied approved renewal terms. Missing terms require confirmation. C. Draft one short (up to 6 lines) reminder per expired/due-soon open contract, asking to discuss renewal; no invented rate, extension or deadline. Use only supplied facts. Never invent customer names, testimonials, urgency, prices, discounts, delivery dates or credit terms. A person reviews before sending or deciding. Line limits count body lines only, not subject, greeting or sign-off. Keep every required fact; if they do not fit, say so instead of dropping one.
Which model? Use your tool's strongest model with thinking turned on.
In your AI tool: attach the files with the + button, paste, send.
Keep your actual records in your own workbook; ask AI for the local method using headings and rules only.
Excel A:E contract, customer, expiry, status, approved terms. As on [As on date], window [Expiry within days] days. Give formulas for days to expiry and expired/due soon/later/renewed/missing, FILTER review rows and counts; flag absent terms, no auto-renewal. Tell me exactly where to paste formulas or set up the local steps. Use fictional examples only; do not ask for actual customer, employee or vendor records.
Run the method locally; verify every exception against source records and obtain approval before acting.
- A1Expired 10 Nov. Open; ask about renewal, don't say automatically extended.
- A220 Nov. Due soon; terms not approved.
- A5Expiry missing. Check contract before contacting.
Then send this: Check dates and boundary, count each status once, and verify reminders only for open expired/due-soon rows.
It contacts renewed customer
Reply: "Exclude Renewed status."
It assumes same rate
Reply: "Ask to discuss renewal; no rate given."
It guesses expiry
Reply: "Flag missing date."
Sir ne bola urgent. Ab bolo: ho gaya.
Did it work?
Doing this every week? Save it once.
Save the prompt in your AI tool, so next time you only drop the files in. Pick your tool at the top to see how.
What is that?
A Project is a folder in ChatGPT that keeps your instructions and files for every chat inside it. It's on the free plan too. Checked 14 Nov 2026.
What is that?
A Project in Claude is a workspace with its own instructions and files that every chat inside it uses. Checked 14 Nov 2026.
What is that?
A Gem is a custom Gemini that loads your instructions before every chat. Free on every plan; you create it on a computer. Checked 14 Nov 2026.
What is that?
Signed in with a work account, Microsoft's Copilot Chat applies enterprise data protection: your prompts aren't used to train its models. Checked 14 Nov 2026.
If your whole team does this, we'll set it up for all of them in one session.