PROMPT BRO
Sales desk

Dealer stock and secondary sales combined

30 dealers. 30 Excel formats. One has merged cells.

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

By hand1 day
With AI1 hr
Each time · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Prepare dealer report copies

Map dealer, SKU, opening stock, receipts, secondary sales and closing stock into common units. Use one period.

First time? Try it on fake data first:

Confirm the stock basis

Only compare matching SKU/unit combinations. Keep unknown quantities separate.

Privacy Remove phone numbers, email IDs and payment details where not needed. Use only approved business names and facts.

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

I'm attaching dealer stock and sales rows for [Period]. Rule: [Stock movement rule]. A. Standardise columns, calculate expected closing and compare reported closing for complete rows. Flag missing movement or stock mismatch; do not fill unknowns. B. Group by SKU and unit; show known sales quantities and complete-row stock totals separately; label partial where data missing. C. List dealer queries with row references and quantities. No replenishment order or stock commitment. Use only supplied facts. Never invent customer names, testimonials, urgency, prices, discounts, delivery dates or credit terms. A person reviews before sending or deciding.

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)
5report rows
2stock flags
1missing sales
  • D2/P15 units mismatch. 20 + 10 − 15 = 15, reported 20.
  • D3/P1Sales missing. Cannot reconcile closing; query dealer.
  • P130 known sales. 10 + 15 + 5; D3 sales unknown, total partial.
Before you trust it

Then send this: Recalculate each closing, reconcile complete-row totals, verify missing rows excluded and units not mixed.

If it goes wrong
It sums unlike units

Reply: "Group by SKU and unit."

It fills missing sales zero

Reply: "Mark partial; ask dealer."

It fixes closing automatically

Reply: "Show expected vs reported; don't overwrite."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?