PROMPT BRO
HR desk

Find attendance exceptions in your punch report

'Sir, punch nahi hua' – every single morning

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

By hand1 hr
With AI15 min
Per day · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Export the punch report

Export employee-code punch records and approved leaves. Include a roster or schedule of every employee's expected working dates for the review period, including employees with no punches at all.

Delete names

Keep only employee codes. Names, phone numbers, anything else personal: delete.

Privacy Use employee codes and approved schedules only. Remove names, phone numbers and biometric identifiers; keep actual payroll and identifiable records local.

Fill the orange boxes
You send (the "prompt": the message you paste into your AI tool)
Punch report.xlsxApproved leaves.xlsxEmployee roster.xlsx

I'm attaching three Excel files for [Review dates]: punch report (employee code, date, in/out), approved leaves (employee code, date, approved status), and expected roster (employee code, scheduled working dates or approved workday pattern). Only the roster defines expected employee-days; do not infer absence from a missing row or assume every calendar day is working. Approved rules: shift starts [Shift starts], grace [Grace] minutes. Elapsed in-to-out time at least [Full day] hours is full day, under [Half day under] hours is half day. If thresholds overlap or leave a gap, flag rule conflict or intermediate day for HR; do not invent break deductions. Same-day shifts unless the roster explicitly identifies a night shift. A. For every scheduled employee-day, validate roster, dates, unique punch rows and in/out times. Late only if in time is later than start plus grace. Missing in/out, duplicate/conflicting punches, invalid/reversed times without approved night shift, and partial/missing records go to review. No punch on a scheduled working day is absent only if there is no approved leave for that day; list approved leaves separately. A missing employee-day roster is unknown, not absence. B. Exception table: code, date, scheduled status, times, exact rule and reason. Count approved leave, late, half day, missing punch and absent without leave separately; overlapping flags may apply to one employee-day. C. Per employee summary and total scheduled days reconciled to present/half day, approved leave, absence and unresolved records. Show elapsed time, not actual payable hours. Ask HR to confirm exceptions and corrections; no salary deduction or pay decision. Use only the supplied roster, times and approved rules. Remove personal details and keep actual biometric records local if company policy requires. 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? This task is about times and counts, so use your tool's strongest model with thinking (or extended reasoning) turned on.

In your AI tool: attach the files with the + button, paste, send.

What you'll get back (example, from the practice files)
5to sort out
2late marks
1on approved leave
  • E10312 Nov, no out-punch. Missing punch, not a half day yet. Ask the employee and their manager first.
  • E10412 Nov, absent. No leave applied. 11 Nov is their approved CL, so that day is fine.
  • E10513 Nov, 4 hrs 35 min. Under 8 hours, so half day as per your rule, unless leave is applied.
Before you trust it

Then send this: Reconcile every scheduled employee-day to the roster, including employees with no punches. Recheck approved leave, late boundary, elapsed time, duplicate/missing punches and overlapping flags; no pay decision.

If it goes wrong
Times are read wrongly

Your export may have times as text or in 12-hour format. Add: "Times are in 24-hour HH:MM format."

Night shifts break it

Supply approved night-shift roster and dates. Hold reversed times without a confirmed night shift.

The answer stops halfway

Type "continue". For a big team, send one department at a time.

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?