PROMPT BRO
Purchase desk

Vendor scorecard from actual receipts

Vendor rating says excellent. The rejection register says please check.

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

By handRarely done
With AI30 min
Each time · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Get vendor performance rows

Use vendor, deliveries, on-time deliveries, received qty and rejected qty from GRN. Same period.

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)
vendor-rating.xlsx

Period: [Period] Review rule: [Review rule] I'm attaching vendor-rating.xlsx. A. Calculate on-time % and rejection % per vendor; flag missing or invalid counts. B. List vendors needing review with reasons; sum deliveries and quantities for valid rows only. C. Suggested questions, not automatic vendor removal. 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)
4valid vendors
2review flags
1held
  • V260% on time. 3 of 5; review.
  • V310% rejected. 10 of 100; review.
  • V4Invalid count. 6 on time of 5 deliveries.
Before you trust it

Then send this: Recheck rates and boundaries, exclude invalid counts and sum valid totals.

If it goes wrong
Invents score weights

Reply: "Use supplied rates only."

Divides by zero

Reply: "Hold invalid denominator."

Removes vendor

Reply: "Review flag only."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?