PROMPT BRO
Purchase desk

Stock issue register and negative balances

Issue slip is signed. The stock register is still on yesterday.

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

By hand1–2 hrs
With AI20 min
Per day · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Prepare issue records

Use SKU, opening qty, receipts, issued qty and slip ref in same unit. Check physical stock.

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-issues.xlsx

Whenever I send the next details, use this format. Date: [Date] Stock rule: [Stock rule] I'm attaching stock-issues.xlsx. A. Calculate closing per SKU; flag missing issue ref or negative balance. B. List valid and held rows and reasons; no cross-SKU total if different items. C. Draft stock update rows for stores review, not posting. 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.

Set it up once. Save the approved format and comparison rules, without vendor records. Pick your tool at the top to see how.

After that, each time: send the new details and confirm the latest approvals and stock.

First time? Try it in a normal chat: paste and send.

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)
3pass checks
2held
5SKUs
  • P2−2 closing. 5 + 3 − 10.
  • P3Slip missing. Issue needs source ref.
  • P112 closing. 10 + 5 − 3.
Before you trust it

Then send this: Recalculate closing per SKU and check slip references.

If it goes wrong
Sets negative zero

Reply: "Flag negative."

Invents slip ref

Reply: "Hold missing."

Combines units

Reply: "Per SKU only."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?