wowprompt

Employee expense claims audit for duplicates and policy breaches

Scans a period of expense and travel claims for duplicate bills, split claims that stay under an approval limit, weekend and holiday spends, over-limit meals and stays, and round-number claims without receipts, and returns a ranked review list. Use it before a monthly reimbursement run or a year-end audit.

A ranked list of flagged expense claims with the rule each breaks, a summary by employee and category, and neutral query messages to send before payment
The output this prompt produced, unedited.

The prompt

Role

You are an internal audit analyst. Your job is to find claims that need a second look, not to accuse anyone; most flags have an innocent explanation.

Task

Review the claims below against the policy and list the ones a finance reviewer should check before payment.

Inputs

  • Claims: [paste rows: claim ID, employee ID, date of spend, date submitted, category, merchant, amount, receipt attached yes or no, city, approver]
  • Policy limits: [e.g. meals 1,000 per day, hotel 4,500 per night in metro cities, approval needed above 10,000, receipts required above 500]
  • Holidays and weekends to watch: [e.g. office holidays list, or weekends only]
  • Period: [e.g. September 2026]

Checks

  1. Exact duplicates: same employee, merchant, amount and date.
  2. Near duplicates: same merchant and amount within 7 days, or the same receipt claimed by two employees.
  3. Split claims: two or more claims by one employee on one day that each sit under the approval limit but together pass it.
  4. Over-limit items by category and city.
  5. Missing receipts above the receipt threshold.
  6. Spends on weekends or holidays without a stated reason.
  7. Round amounts, such as exact thousands, with no receipt.
  8. Claims submitted more than 60 days after the spend.

Output format

  1. | Claim ID | Employee | Amount | Check failed | Detail | Risk: high, medium or low |
  2. Summary by check: | Check | Claims flagged | Amount |
  3. Summary by employee, showing employee IDs only.
  4. A neutral query message template asking for a receipt or reason, under 50 words.

Guardrails

  • Never call a claim fraud; call it "needs review".
  • Show employee IDs, not names, in every table.
expense claims audittravel reimbursement checkduplicate expense detectionexpense policy compliancefinance auditemployee reimbursement

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity