PROMPT BRO
Admin desk

Agency bill checks against attendance

Agency bill says 26 days. Attendance says 24. The difference needs a signature.

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

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

Prepare agency working

Use agency/role code, approved days, billed days and agreed day rate. Keep actual attendance and salary details local.

First time? Try it on fake data first:

Privacy Remove personal phone numbers, addresses, IDs, bank details and private records. Use employee or document codes and approved business facts only.

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

Month: [Month] Approved basis: [Approved basis] I'm attaching agency-attendance.xlsx. A. Calculate expected amount, compare billed days × rate and billed amount; flag day or amount difference and missing inputs. B. Sum comparable expected and billed amounts, list held rows. C. Questions for agency and accounts; no payment or wage calculation. Use only supplied facts and company policy. Mark missing dates, owners, amounts or approvals [confirm]. No bookings, payments, account changes or submissions by AI. A person checks 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.

What you'll get back (example, from the practice files)
2pass checks
3held
₹1,000day gap value
  • A22 extra days. ₹500 each = ₹1,000 difference.
  • A3Rate missing. Cannot compare.
  • A4Bill mismatch. 20 × ₹500 = ₹10,000, billed ₹11,000.
Before you trust it

Then send this: Recalculate all comparable rows and differences; hold missing rate.

If it goes wrong
Calculates salary

Reply: "Agency bill only."

Assumes rate

Reply: "Hold missing."

Approves bill

Reply: "Checks only."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?