PROMPT BRO
Sales desk

Sales achievement and incentive working

The target sheet says 99.9%. The incentive sheet suddenly needs a meeting.

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

By hand3–5 hrs
With AI30 min
Per month · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Make a dummy sales sheet

Use rep codes, target and approved eligible sales. Practise on the sample; keep actual personal incentive amounts in your company file.

First time? Try it on fake data first:

Confirm the scheme

Use the exact approved threshold and calculation basis. No assumed slabs, deductions or payments.

Privacy Upload only fictional practice data. Actual rep pay, incentive amounts and employee details stay in your payroll and sales files.

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

I'm attaching fictional rep-level sales data for [Month]. Scheme: [Approved scheme]. Basis: [Sales basis]. A. For each rep calculate achievement % = eligible sales / target × 100 if target positive. Hold duplicate rep codes (all copies), missing sales or target not positive; calculate incentive for valid rows using supplied rule. B. Count achieved, below target and held; sum known valid target, sales and incentive separately. Do not treat held rows as zero. C. Draft a short explanation of the scheme and list questions for payroll/sales manager. No pay decision, no personal salary records. Use only supplied facts. Never invent customer names, testimonials, urgency, prices, discounts, delivery dates or credit terms. A person reviews before sending or deciding. Do not repeat personal identifiers from the data (personal names, phone numbers, email or postal addresses, bank account numbers, UPI IDs, PAN, Aadhaar, GSTIN or other registration numbers) unless the output genuinely needs one; use the code, ref or row instead, and copy any needed identifier exactly. Keep masked values masked; never guess, complete or unmask them.

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)
2achieved
₹6,000incentive draft
2held rows
  • R01100%. ₹3 L sales on ₹3 L target; incentive ₹3,000.
  • R03Target zero. Achievement cannot be calculated; hold.
  • R04Sales missing. Hold until eligible sales confirmed.
Before you trust it

Then send this: Recalculate each achievement and incentive from the supplied approved scheme, including its exact threshold and equality rule. Verify held rows are excluded and valid totals tie.

If it goes wrong
It adds a slab

Reply: "Only apply my approved scheme."

It divides by zero

Reply: "Hold zero target."

It assumes missing sales zero

Reply: "Hold missing value."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?