A monthly HR report with checks
The monthly MIS is due today. Three departments are still counting who joined last month.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Make a department-level sheet
Opening headcount, joined, exited, reported closing, applications, interviews, offers and approved hiring cost. Use the sample first.
Check the month and totals
Use one period for all departments. Don't include individual salaries or employee records.
Privacy Use department totals only. Remove names, employee codes, individual salaries, contact details and case notes.
I'm attaching department totals for [Reporting month]. Cost means [Cost column means]. A. Table by department: opening headcount, joined, exited, expected closing = opening + joined minus exited, reported closing, gap (reported minus expected). Add grand totals. Calculate exits / opening headcount × 100 for the company, labelled simple monthly exit rate, not annualised. B. Hiring funnel by department and grand totals: applications, interviews, offers, joined; flag offers fewer than joins for a period check, not a proven error. C. Known cost total, missing cost rows, and short commentary separating facts from suggested follow-ups. Do not treat missing costs as zero or give a complete cost total. Use only supplied figures. No individual pay or headcount decisions. HR confirms numbers before reporting.
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 report in Excel if company policy does not allow uploads.
My Excel columns A:I are Department, opening HC, joined, exited, reported closing, applications, interviews, offers, cost. Write formulas for J expected closing = B+C-D, K reported minus expected, L funnel flag if joined exceeds offers, M missing cost flag. Show totals and company exit rate = total exits / total opening × 100 with zero guard. Missing costs must be flagged. Tell me where to paste.
Fill the formulas down, add totals, check every gap with HR, and label cost as incomplete if any row is missing.
- AdminClosing gap +1. 8 + 0 minus 1 = 7, reported 8.
- ProductionOffers 3, joins 4. Check whether a join came from an earlier month's offer.
- ₹3.05 LKnown cost only. Service cost is missing; no complete total yet.
Then send this: Sum each column again, reconcile expected and reported closing, calculate exit rate from totals, and list missing cost rows and funnel checks.
Closing doesn't tie
Reply: "Show expected vs reported and the gap per department."
Costs missing
Reply: "Show known total and missing rows, not zero."
It claims an attrition cause
Reply: "Separate facts from suggestions; no causes without evidence."
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.