PROMPT BRO
Purchase desk

Purchase spend and price change report

Purchase MIS says cost increased. The next question is always 'why?'

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

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

Export purchase working

Use vendor, SKU, qty, current unit rate and approved previous comparable rate. Same period and units.

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)
purchase-mis.xlsx

Period: [Period] Flag increase above %: [Flag increase above %] I'm attaching purchase-mis.xlsx. A. Calculate line spend qty × rate, group by vendor and SKU. Show known spend total. B. Compare current vs previous rates; flag increase above threshold and missing prior rate. C. Facts and questions for buyer; no guessed cause or purchase decision. 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)
₹55,000spend
2price flags
1prior missing
  • V1/P120% increase. ₹120 vs ₹100.
  • V2/P225% increase. ₹250 vs ₹200.
  • V3/P3Prior missing. Cannot compare.
Before you trust it

Then send this: Recalculate spend totals and rate percentage flags.

If it goes wrong
Invents cause

Reply: "Flag and ask vendor."

Sums rates

Reply: "Use qty × rate for spend."

Missing prior zero

Reply: "Unknown comparison."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?