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
Get the two counts
Use item code, book qty, physical qty and approved unit value from stock records. Count units must agree.
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.
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.
Keep real stock in Excel.
Excel A:D = item, book qty, physical qty, unit value. Write E quantity variance if counts numeric, F value variance if value numeric, G flag missing/short/excess/match. Show known book and physical value totals for complete rows. Tell me where to paste.
Fill down and recount flagged items; accounts approves any adjustment.
- S1−₹500. 10 units short × ₹50.
- S2+₹200. 2 units extra × ₹100.
- S5Count missing. No variance; exclude until counted.
Then send this: Recalculate quantity and value for each row; reconcile known book and physical totals to net variance. Exclude missing counts.
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?
Doing this every week? Save it once.
Save the prompt in your AI tool, so next time you only drop the files in. Pick your tool at the top to see how.
What is that?
A Project is a folder in ChatGPT that keeps your instructions and files for every chat inside it. It's on the free plan too. Checked 14 Nov 2026.
What is that?
A Project in Claude is a workspace with its own instructions and files that every chat inside it uses. Checked 14 Nov 2026.
What is that?
A Gem is a custom Gemini that loads your instructions before every chat. Free on every plan; you create it on a computer. Checked 14 Nov 2026.
What is that?
Signed in with a work account, Microsoft's Copilot Chat applies enterprise data protection: your prompts aren't used to train its models. Checked 14 Nov 2026.
If your whole team does this, we'll set it up for all of them in one session.