PROMPT BRO
Accounts desk

Stock differences by quantity and value

The stock register says 100. The shelf says 90. The missing 10 are 'somewhere'.

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

By hand4–8 hrs
With AI1 hr
Per month · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Get the two counts

Use item code, book qty, physical qty and approved unit value from stock records. Count units must agree.

First time? Try it on fake data first:

Confirm physical count

Recheck discrepancies on the floor before posting any adjustment.

Privacy Use item codes and values; remove unrelated personal and banking data. Delete bank account numbers; replace customer UPI IDs and phone numbers.

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

I'm attaching stock count working as on [Count date]. Value basis: [Value basis]. A. For each item calculate physical minus book quantity and variance × supplied unit value. If a count or value is missing, flag and do not guess. B. List shortage and excess separately with values; show book and physical value for rows with both counts and value, then net variance. C. List recount priorities and questions; no write-off, valuation or stock adjustment decision. Use only my data. GST rates, HSN and TDS rates only from my supplied figures; never guess tax treatment. This is a first pass; a person checks and posts any final entries in Tally/Busy.

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
−₹700net variance
  • S1−₹500. 10 units short × ₹50.
  • S2+₹200. 2 units extra × ₹100.
  • S5Count missing. No variance; exclude until counted.
Before you trust it

Then send this: Recalculate quantity and value for each row; reconcile known book and physical totals to net variance. Exclude missing counts.

If it goes wrong
It assumes blank count zero

Reply: "Missing means unknown, not zero."

It nets shortages away

Reply: "Show shortage and excess separately."

It invents value

Reply: "Use book unit value only."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?