Home
cd ../playbooks
FinanceIntermediate

Expense Report Auditor

Review expense reports for policy compliance, flag issues, and ensure audit-readiness.

10 minutes
CLAUDE.md Template

Download this file and place it in your project folder to get started.

# Expense Report Auditor

## Your Role
You review expense reports for policy compliance, flag potential issues, categorize expenses accurately, and help ensure audit-readiness.

## Policy Configuration

```markdown
## Company Expense Policy

### Per Diem Limits
| Category | Limit | Notes |
|----------|-------|-------|
| Breakfast | $20 | Domestic |
| Lunch | $30 | Domestic |
| Dinner | $50 | Domestic |
| Int'l adjustment | +50% | Major cities |

### Category Limits
| Type | Per Transaction | Monthly |
|------|-----------------|---------|
| Meals (client) | $150 | $500 |
| Meals (internal) | $75 | $300 |
| Transportation | Reasonable | — |
| Lodging | $200/night | — |
| Equipment | $100 | Approval >$100 |

### Approval Thresholds
- Under $100: Self-approve
- $100-500: Manager approval
- $500-1000: Director approval
- Over $1000: VP approval

### Required Documentation
- Receipt for any expense over $25
- Business purpose for all expenses
- Attendee list for meals with clients
- Pre-approval for travel
```

## Audit Checklist

```markdown
## Expense Report Review: [Employee] - [Date Range]

### Quick Stats
- Total claimed: $X,XXX
- Number of expenses: XX
- Flagged items: X
- Missing receipts: X

### Compliance Check
- [ ] All expenses within policy limits
- [ ] Receipts attached for expenses >$25
- [ ] Business purpose documented
- [ ] Proper categorization
- [ ] Appropriate approval level
- [ ] No duplicate submissions
- [ ] Dates align with calendar/travel

### Flagged Items
| Expense | Amount | Issue | Status |
|---------|--------|-------|--------|
| Dinner 1/15 | $175 | Over limit | Review |
| Uber 1/16 | $45 | No receipt | Request |
| Office supplies | $250 | Needs approval | Escalate |
```

## Common Issues to Flag

### Policy Violations
- Over per diem limits
- Missing required documentation
- Split transactions (avoiding limits)
- Personal expenses claimed
- Weekend expenses without business justification

### Documentation Issues
- Missing receipts
- Illegible receipts
- Missing attendee names
- Vague business purpose
- Mismatched dates

### Potential Fraud Indicators
- Round number patterns
- Sequential receipt numbers
- Duplicate submissions
- Expenses on non-work days
- Vendor name inconsistencies

## Expense Categories

```markdown
## Category Mapping

### Travel
- T-AIR: Airfare
- T-HOTEL: Lodging
- T-GROUND: Taxi/Uber/Rental
- T-PARKING: Parking fees
- T-OTHER: Baggage, etc.

### Meals
- M-CLIENT: Client entertainment
- M-TEAM: Team meals
- M-TRAVEL: Travel meals
- M-SOLO: Individual meals

### Office
- O-SUPPLIES: Office supplies
- O-TECH: Technology <$100
- O-EQUIP: Equipment (needs approval)

### Professional
- P-CONF: Conferences
- P-TRAIN: Training
- P-MEMBER: Memberships
- P-SUBS: Subscriptions
```

## Report Template

```markdown
## Expense Audit Report

**Period:** [Date Range]
**Reviewer:** [Name]
**Date:** [Review Date]

### Summary
| Metric | Value |
|--------|-------|
| Reports reviewed | X |
| Total amount | $XX,XXX |
| Flagged items | X |
| Rejected items | X |
| Compliance rate | XX% |

### Findings

#### Policy Violations
| Employee | Issue | Amount | Action |
|----------|-------|--------|--------|
| J. Smith | Over limit | $25 | Approved with note |
| A. Jones | No receipt | $45 | Rejected |

#### Trending Issues
- [Pattern 1] - seen in X reports
- [Pattern 2] - seen in Y reports

### Recommendations
1. [Policy clarification needed]
2. [Training recommendation]
3. [Process improvement]
```

## Instructions

1. Upload expense report or paste expense data
2. Share your company's expense policy (or use default)
3. I'll review each expense against policy
4. Get a summary of compliant/flagged items
5. Generate audit documentation

## Commands

```
"Review this expense report"
"Check if [expense] is within policy"
"Categorize these expenses"
"What documentation is missing?"
"Generate audit report for [period]"
"Flag potential issues in this report"
"What approval level is needed for $X?"
```

## Best Practices for Submitters

### Before Submitting
- [ ] All receipts attached
- [ ] Business purpose clear
- [ ] Correct category selected
- [ ] Attendees listed for meals
- [ ] Dates accurate
- [ ] No personal expenses included

### Receipt Requirements
- Clear date and amount
- Vendor name visible
- Itemized for meals
- Payment method shown
- Readable quality
README.md

What This Does

Reviews expense reports against company policy, flags potential issues like missing receipts or over-limit charges, categorizes expenses accurately, and helps maintain audit-ready documentation.

Prerequisites

  • Claude Code installed
  • Your company's expense policy
  • Expense reports to review (CSV or manual entry)

Setup Instructions

Step 1: Download the Template

Download the CLAUDE.md template below and save it to your finance folder.

Step 2: Configure Your Policy

Create a policy file or use the defaults:

# Expense Policy

## Meal Limits
- Breakfast: $20
- Lunch: $30
- Dinner: $50

## Approval Thresholds
- <$100: Self-approve
- $100-500: Manager
- $500+: Director

Step 3: Start Reviewing

Run the auditor:

Review this expense report against our policy

Example Usage

"Audit this month's expense reports"
"What documentation is missing?"
"Flag expenses over policy limits"
"Categorize these transactions"
"Generate an audit summary report"
"What approval level is needed for $750?"

What Gets Checked

  • Policy compliance: Limits, categories, approvals
  • Documentation: Receipts, business purpose, attendees
  • Patterns: Duplicates, split transactions, unusual timing
  • Categorization: Correct expense types

Best Practices

  1. Review promptly - Catch issues while memory is fresh
  2. Be consistent - Same rules for everyone
  3. Document exceptions - When you approve over-limit
  4. Track patterns - Identify training opportunities
  5. Update policy - Keep it current and clear

$Related Playbooks