Expense Report Analyzer

Prompt

Analyze the uploaded expense data and produce a structured expense report analysis.

Expense period: [DATE RANGE]
Department or scope: [ALL COMPANY / SPECIFIC DEPARTMENT]
Total spend in the dataset: [APPROXIMATE AMOUNT]
Policy limits to check against: [LIST ANY RELEVANT LIMITS — E.G., MEAL LIMIT $75/PERSON]

**ANALYSIS REQUIRED**

1. **Spend Summary** — Total spend by: category, department, employee, and month.

2. **Policy Compliance Audit** — Flag any transactions that:
   - Exceed per-transaction limits
   - Are in restricted categories
   - Are submitted more than [NUMBER] days after purchase
   - Lack a clear business purpose

3. **Top Spenders** — Ranked list of top 10 employees by total expense amount. Flag any outliers.

4. **Category Trends** — Which categories are growing fastest? Any unusual spikes?

5. **Duplicate Detection** — Flag transactions with the same amount on the same or adjacent dates.

6. **Vendor Analysis** — Top 10 vendors by spend. Any vendor concentration risks?

7. **Savings Opportunities** — 3 specific areas where spend could be reduced or controlled.

8. **Executive Summary** — 1 page suitable for CFO review.

Flag all items requiring follow-up with the submitting employee. Include a recommended approval/rejection for flagged items.