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
Prepare agency working
Use agency/role code, approved days, billed days and agreed day rate. Keep actual attendance and salary details local.
Privacy Remove personal phone numbers, addresses, IDs, bank details and private records. Use employee or document codes and approved business facts only.
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.
Keep actual company records in your own workbook; ask AI for the local method using headings and rules only.
Excel A:E ref, approved days, billed days, rate, billed amount. Basis [Approved basis]. Give formulas for expected approved days × rate, billed days × rate, day gap and amount gap; flag missing rates, negative inputs or mismatches. Sum comparable expected and billed separately; do not calculate employee wages. Tell me exactly where to paste formulas or set up the local steps. Use fictional examples only; do not ask for actual company records.
Run locally, verify the figures and flags against your source records and ask the responsible person to approve before acting.
- A22 extra days. ₹500 each = ₹1,000 difference.
- A3Rate missing. Cannot compare.
- A4Bill mismatch. 20 × ₹500 = ₹10,000, billed ₹11,000.
Then send this: Recalculate all comparable rows and differences; hold missing rate.
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?
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.