PROMPT BRO
Sales desk

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

By hand2 hrs
With AI15 min
Per month · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Get the renewal list

Use customer, contract ref, expiry date, renewal status and approved renewal terms if available. No personal contact details.

First time? Try it on fake data first:

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.

Fill the orange boxes
You send (the "prompt": the message you paste into your AI tool)
amc-renewals.xlsx

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.

What you'll get back (example, from the practice files)
1expired
2due soon
1date missing
  • 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.
Before you trust it

Then send this: Check dates and boundary, count each status once, and verify reminders only for open expired/due-soon rows.

If it goes wrong
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?