Dealer scheme claims checked against rules
Scheme terms fit in one WhatsApp. Claims reconciliation needs its own workbook.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Get the approved scheme working
Use dealer code, eligible net sales and claimed amount. Confirm returns already excluded and scheme thresholds approved.
Confirm payout basis
Use the exact approved scheme. No invented eligibility, tax or credit-note treatment.
Privacy Remove phone numbers, email IDs and payment details where not needed. Use only approved business names and facts.
I'm attaching dealer claim working for [Scheme period]. Scheme: [Approved scheme]. Basis: [Sales basis]. A. Calculate expected claim by dealer using supplied scheme; hold missing eligible sales or claim amount. Compare claimed minus expected, flag differences. B. Count exact matches, mismatches and held; sum expected and claimed for comparable rows, show gap. Do not approve claim or issue note. C. List queries to dealers and accounts; ask accountant / consultant about any tax or credit-note treatment. 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 the real dealer claims in Excel.
Excel A:C = dealer, eligible sales, claimed. Scheme [Approved scheme]; basis [Sales basis]. Write formulas for D expected if sales numeric, E difference if both numeric, F exact/mismatch/hold. Explain comparable-only totals. Leave missing values blank.
Fill down, reconcile claims and have sales/accounts approve before payout.
- D1₹2,000 expected. ₹1 L eligible sales, exact threshold.
- D2₹500 excess. ₹1.5 L × 2% = ₹3,000 vs ₹3,500 claimed.
- D4Sales missing. Hold ₹1,000 claim; no expected value.
Then send this: Recalculate the expected claim from the supplied approved threshold, equality rule and payout basis. Reconcile comparable totals and list missing rows separately.
It uses marginal slab
Reply: "Full eligible sales × supplied rate after threshold."
It assumes missing sales zero
Reply: "Hold missing inputs."
It issues credit note
Reply: "Working only; accounts approves."
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.