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.
Prepare count sheet
Use SKU, book qty, counted qty and approved unit value. Recount discrepancies.
Privacy Remove bank account numbers, PAN, personal phone numbers and emails. Use vendor business names or codes, item codes and approved commercial details.
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.
Keep your actual records in your own workbook; ask AI for the local method using headings and rules only.
Excel A:D SKU, book qty, count, approved unit value. Basis [Value basis]. Give formulas for physical minus book qty, variance value if numeric, shortage/excess/match/missing status; sum known book and physical value and net variance for complete rows. Recount exceptions. Tell me exactly where to paste formulas or set up the local steps. Use fictional examples only; do not ask for actual company records.
Run the method locally; check every exception against physical stock, contracts or source records as applicable, and obtain approval before acting.
- P1−₹500. 5 short × ₹100.
- P2+₹200. 2 extra × ₹100.
- P5Count missing. Exclude until counted.
Then send this: Recalculate differences and reconcile known values.
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?
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.