PROMPT BRO
Purchase desk

Physical stock differences with values

Counting day: the shelf has ninety-nine. The software has one hundred.

Not yet tested No recorded AI run has verified this prompt yet. Try it on the practice files first, then use the checks in step 3 before you rely on it.

By hand1–2 days
With AI2 hrs
Each time · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Prepare count sheet

Use SKU, book qty, counted qty and approved unit value. Recount discrepancies.

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)
stock-count.xlsx

Count date: [Count date] Value basis: [Value basis] I'm attaching stock-count.xlsx. A. Calculate qty and value difference; hold missing count/value. B. List shortage/excess and complete-row net variance; reconcile book and physical values. Show each row value as qty × unit value = value, show every column total as an explicit sum of the row values, and check that physical total − book total equals the sum of row variances before reporting. C. Recount priorities and questions, no adjustment. For a held row (for example a unit mismatch or missing count), do not state a converted, implied or indicative quantity or value, even as a hypothesis; say what is needed to resolve it. 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)
2shortages
1excess
−₹400net variance
  • P1−₹500. 5 short × ₹100.
  • P2+₹200. 2 extra × ₹100.
  • P5Count missing. Exclude until counted.
Before you trust it

Then send this: Recalculate differences and reconcile known values.

If it goes wrong
Blank zero

Reply: "Unknown, not zero."

Nets away shortage

Reply: "Separate shortage/excess."

Posts adjustment

Reply: "Review only."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?