PROMPT BRO
Purchase desk

Rate contract expiry and invoice checks

Annual rate contract expired. The bill still remembers the old rate.

Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files

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

Prepare contract comparison rows

Use contract ref, expiry from approved contract, item, contract rate and billed rate. Same unit and tax basis.

First time? Try it on fake data first:

Privacy Remove bank account numbers, PAN, personal phone numbers and emails. Use vendor business names or codes, item codes and approved commercial details.

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

As on: [As on] Review within days: [Review within days] I'm attaching rate-contracts.xlsx. A. Classify expiry: expired, within window, later, missing. B. Compare billed and approved rates; flag missing or difference. Count expiry and rate exceptions separately. C. Questions for buyer and consultant; no automatic renewal or price change. Use only supplied facts, quotes and approved terms. Flag missing GST, freight, payment days or delivery instead of assuming. Check stock against physical count or software before ordering. A person checks before sending, ordering, paying or posting.

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
2rate flags
  • C1Expired 10 Nov. Verify contract status.
  • C2₹20 higher. ₹520 billed vs ₹500.
  • C5Rate missing. Cannot compare.
Before you trust it

Then send this: Recheck date boundary and each rate difference; no assumed extension.

If it goes wrong
Assumes renewal

Reply: "No renewal unless confirmed."

Uses new market rate

Reply: "Contract rate only."

Missing expiry

Check signed contract locally.

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?