PROMPT BRO
HR desk

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

By hand3–4 hrs
With AI45 min
Each time · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Make a department-level sheet

Opening headcount, joined, exited, reported closing, applications, interviews, offers and approved hiring cost. Use the sample first.

First time? Try it on fake data 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.

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

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.

What you'll get back (example, from the practice files)
109expected HC
10joined
6exited
  • 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.
Before you trust it

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.

If it goes wrong
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?