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
Prepare dealer report copies
Map dealer, SKU, opening stock, receipts, secondary sales and closing stock into common units. Use one period.
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.
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.
Keep your actual records in your own workbook; ask AI for the local method using headings and rules only.
Excel A:G dealer, SKU, unit, opening, receipts, secondary sales, reported close. Rule [Stock movement rule]. Give formulas for expected close, difference, missing movement, stock flag; group known sales and complete stock by SKU/unit using SUMIFS or pivot. Label partial where inputs missing. Tell me exactly where to paste formulas or set up the local steps. Use fictional examples only; do not ask for actual customer, employee or vendor records.
Run the method locally; verify every exception against source records and obtain approval before acting.
- 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.
Then send this: Recalculate each closing, reconcile complete-row totals, verify missing rows excluded and units not mixed.
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?
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.