Home
cd ../playbooks
FinanceIntermediate

Expense Report Auditor

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

10 minutes

Your team submits 200 expense reports a month and you're eyeballing each one for policy violations. You catch the obvious $500 dinner but miss the recurring $49 subscription that's been expensed for 18 months after the project ended.

Who it's for: finance managers reviewing employee expense submissions, controllers ensuring policy compliance before reimbursement, auditors preparing for year-end reviews, accounting teams processing high volumes of expense reports, CFOs wanting automated expense oversight

Example

"Audit this quarter's expense reports against our travel policy" → Review of 340 reports flagging 12 over-limit meals, 3 missing receipts, 2 personal charges miscategorized as business, and 1 recurring subscription that should have been cancelled — sorted by severity with policy references

CLAUDE.md Template

New here? 3-minute setup guide → | Already set up? Copy the template below.

# 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

Get new playbooks like this one

One email a week with new Claude Code workflows. Free, like everything here.

No spam. Unsubscribe anytime.

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

Finance

Financial Modeling Assistant

Build integrated financial models with 3-statement projections. Create income statement, balance sheet, and cash flow models with proper linkages.

10 minutes
Advanced
Finance

Financial Analyst Toolkit

Run DCF valuations, financial statement analysis, ratio analysis, comparable company analysis, budget variance reporting, and scenario modeling from your local data.

15 minutes
Advanced
Finance

Investment Memo Writer

Write professional investment memorandums for VC, PE, or public market investments. Structure thesis, risks, and recommendations clearly.

10 minutes
Advanced
Finance

Multi-Agent Financial Planner

Build a virtual financial advisory team with specialized agents for budgeting, retirement planning, and investment strategy that analyze your finances and create actionable plans.

15 minutes
Intermediate
Finance

Multi-Card Expense Tracker

Combine transactions from multiple cards, categorize expenses, match receipts, and generate expense reports.

10 minutes
Intermediate
Finance

Scientific Edgartools

Python library for accessing, analyzing, and extracting data from SEC EDGAR filings. Use when working with SEC filings, financial statements (income statement, balance sheet, cash flow), XBRL financial data, insider trading (Form 4), institutional...

10 minutes
Intermediate
Finance

Scientific Fred Economic Data

Query FRED (Federal Reserve Economic Data) API for 800,000+ economic time series from 100+ sources. Access GDP, unemployment, inflation, interest rates, exchange rates, housing, and regional data. Use for macroeconomic analysis, financial research...

5 minutes
Beginner
Finance

Scientific Hedgefundmonitor

Query the OFR (Office of Financial Research) Hedge Fund Monitor API for hedge fund data including SEC Form PF aggregated statistics, CFTC Traders in Financial Futures, FICC Sponsored Repo volumes, and FRB SCOOS dealer financing terms. Access time ...

10 minutes
Intermediate
Finance

Risk Manager

Run financial risk assessments, portfolio risk analysis, Monte Carlo simulations, VaR calculations, stress testing, and risk register management from local data.

15 minutes
Advanced
Finance

Scientific Alpha Vantage

Access real-time and historical stock market data, forex rates, cryptocurrency prices, commodities, economic indicators, and 50+ technical indicators via the Alpha Vantage API. Use when fetching stock prices (OHLCV), company fundamentals (income s...

5 minutes
Beginner
Finance

Scientific Denario

Multiagent AI system for scientific research assistance that automates research workflows from data analysis to publication. This skill should be used when generating research ideas from datasets, developing research methodologies, executing compu...

10 minutes
Intermediate
Finance

Scientific Usfiscaldata

Query the U.S. Treasury Fiscal Data API for federal financial data including national debt, government spending, revenue, interest rates, exchange rates, and savings bonds. Access 54 datasets and 182 data tables with no API key required. Use when ...

5 minutes
Beginner

Browse all Finance playbooks →