expense-report – OpenClaw Skill

---

name: expense-report description: Organize, categorize, and summarize business expenses for reimbursement and tax preparation version: 1.0.0 author: Claude Office Skills Contributors license: MIT tags: [finance, expenses, accounting]

Expense Report

Overview

This skill helps you organize business expenses into clear, categorized reports suitable for reimbursement requests, accounting, and tax preparation.

Use Cases:

• Creating expense reimbursement reports
• Organizing receipts for tax preparation
• Categorizing business expenses
• Summarizing travel expenses
• Preparing monthly/quarterly expense summaries

How to Use

1. Provide your expense information (receipts, transactions, or descriptions)
2. Specify the purpose (reimbursement, tax prep, budget tracking)
3. Tell me your expense categories or policies
4. I'll create a structured expense report

Example prompts:

• "Create an expense report from these receipts for my business trip"
• "Categorize and summarize my expenses for the month"
• "Format these expenses for reimbursement"
• "Help me organize my freelance business expenses for taxes"

Expense Report Templates

Standard Reimbursement Report

# Expense Report

**Employee:** [Name]
**Department:** [Department]
**Report Period:** [Start Date] - [End Date]
**Purpose:** [Business trip / Project / General]
**Submission Date:** [Date]

## Summary
| Category | Amount |
|----------|--------|
| Transportation | $XXX.XX |
| Lodging | $XXX.XX |
| Meals | $XXX.XX |
| Other | $XXX.XX |
| **Total** | **$XXX.XX** |

## Expense Details

### Transportation
| Date | Description | Vendor | Amount | Receipt |
|------|-------------|--------|--------|---------|
| [Date] | [Description] | [Vendor] | $XX.XX | ✓ |

### Lodging
| Date | Description | Vendor | Amount | Receipt |
|------|-------------|--------|--------|---------|
| [Date] | [Hotel name] | [Vendor] | $XX.XX | ✓ |

### Meals & Entertainment
| Date | Description | Attendees | Business Purpose | Amount | Receipt |
|------|-------------|-----------|------------------|--------|---------|
| [Date] | [Restaurant] | [Names] | [Purpose] | $XX.XX | ✓ |

### Other Expenses
| Date | Description | Category | Amount | Receipt |
|------|-------------|----------|--------|---------|
| [Date] | [Description] | [Category] | $XX.XX | ✓ |

## Approvals
- [ ] Employee Signature: _____________ Date: _______
- [ ] Manager Approval: _____________ Date: _______
- [ ] Finance Approval: _____________ Date: _______

## Notes
[Any additional context or explanations]

Travel Expense Report

# Travel Expense Report

**Traveler:** [Name]
**Trip Dates:** [Start] - [End]
**Destination:** [City, Country]
**Business Purpose:** [Reason for travel]

## Trip Summary
- **Duration:** [X] days
- **Total Expenses:** $X,XXX.XX
- **Per Diem Allowance:** $XXX.XX
- **Variance:** +/- $XX.XX

## Pre-Trip Expenses
| Item | Vendor | Amount | Date Paid |
|------|--------|--------|-----------|
| Flight | [Airline] | $XXX.XX | [Date] |
| Hotel Booking | [Hotel] | $XXX.XX | [Date] |
| Conference Registration | [Event] | $XXX.XX | [Date] |

## Daily Expenses

### Day 1 - [Date]
| Category | Description | Amount |
|----------|-------------|--------|
| Transport | Airport taxi | $XX.XX |
| Meals | Dinner | $XX.XX |
| **Day Total** | | **$XX.XX** |

### Day 2 - [Date]
| Category | Description | Amount |
|----------|-------------|--------|
| Meals | Breakfast/Lunch/Dinner | $XX.XX |
| Transport | Uber to meeting | $XX.XX |
| **Day Total** | | **$XX.XX** |

## Expense by Category
| Category | Amount | % of Total |
|----------|--------|------------|
| Airfare | $XXX.XX | XX% |
| Lodging | $XXX.XX | XX% |
| Ground Transport | $XXX.XX | XX% |
| Meals | $XXX.XX | XX% |
| Other | $XXX.XX | XX% |
| **Total** | **$X,XXX.XX** | 100% |

## Receipt Checklist
- [ ] Flight confirmation/receipt
- [ ] Hotel invoice
- [ ] Ground transportation receipts
- [ ] Meal receipts over $[threshold]
- [ ] Other expense receipts

Monthly Expense Summary

# Monthly Expense Summary

**Period:** [Month Year]
**Prepared by:** [Name]
**Business:** [Business Name]

## Overview
| Metric | Amount |
|--------|--------|
| Total Expenses | $X,XXX.XX |
| vs Last Month | +/-XX% |
| vs Budget | +/-XX% |

## Expenses by Category

### Operating Expenses
| Category | Amount | Budget | Variance |
|----------|--------|--------|----------|
| Rent/Utilities | $XXX.XX | $XXX.XX | $XX.XX |
| Software/Subscriptions | $XXX.XX | $XXX.XX | $XX.XX |
| Office Supplies | $XXX.XX | $XXX.XX | $XX.XX |

### Professional Services
| Category | Amount | Budget | Variance |
|----------|--------|--------|----------|
| Legal | $XXX.XX | $XXX.XX | $XX.XX |
| Accounting | $XXX.XX | $XXX.XX | $XX.XX |
| Consulting | $XXX.XX | $XXX.XX | $XX.XX |

### Marketing & Sales
| Category | Amount | Budget | Variance |
|----------|--------|--------|----------|
| Advertising | $XXX.XX | $XXX.XX | $XX.XX |
| Events | $XXX.XX | $XXX.XX | $XX.XX |
| Travel | $XXX.XX | $XXX.XX | $XX.XX |

## Top 10 Expenses
| Rank | Date | Description | Category | Amount |
|------|------|-------------|----------|--------|
| 1 | [Date] | [Description] | [Category] | $XXX.XX |
| 2 | [Date] | [Description] | [Category] | $XXX.XX |

## Notes & Anomalies
- [Explanation for any unusual expenses]
- [Budget variance explanations]

Expense Categories

Common Business Categories

Category	Examples	Tax Deductible
Travel	Flights, hotels, car rentals	Usually yes
Meals & Entertainment	Client dinners, team lunches	50-100%
Transportation	Taxi, Uber, parking, mileage	Yes
Office Supplies	Paper, pens, printer ink	Yes
Software & Subscriptions	SaaS tools, apps	Yes
Professional Development	Courses, books, conferences	Usually yes
Communication	Phone, internet	Partial
Professional Services	Legal, accounting	Yes
Marketing	Ads, promotional materials	Yes
Equipment	Computer, office furniture	Depreciated

IRS Category Alignment (US)

IRS Category	Description
Advertising	Marketing and promotional
Car and Truck	Vehicle expenses
Commissions	Payments to contractors
Contract Labor	Freelancer payments
Depreciation	Asset depreciation
Insurance	Business insurance
Interest	Business loan interest
Legal and Professional	Attorney, CPA fees
Office Expense	General office
Rent	Workspace rental
Repairs	Equipment maintenance
Supplies	Business supplies
Taxes and Licenses	Business taxes
Travel	Business travel
Meals	Business meals (50%)
Utilities	Business utilities

Processing Guidelines

Receipt Requirements

• Keep receipts for: All expenses over $25 (US) or local threshold
• Required info: Date, vendor, amount, payment method
• Meals: Include attendees and business purpose
• Missing receipts: Note explanation in report

Currency Conversion

• Use exchange rate from date of expense
• Document rate source (bank, XE.com, etc.)
• Keep in original currency + converted amount

Mileage Calculation

• Current IRS rate (2024): $0.67/mile (verify current rate)
• Document: Date, destination, purpose, miles
• Use odometer readings or mapping app

Output Format

# Expense Report

**Period:** [Dates]
**Total:** $X,XXX.XX

## Summary by Category
[Category breakdown table]

## Detailed Expenses
[Line items with all required info]

## Missing/Notes
[Any issues to address]

Limitations

• Cannot scan or read receipt images directly
• Tax advice should be verified with a professional
• Exchange rates should be verified for accuracy
• Company policies may have specific requirements
• Cannot submit reports to your expense system

Examples

Example: Quick Expense Organization

Input:

uber to airport $45
flight to NYC $380
hotel 2 nights $420
dinner with client john from acme $125
coffee and breakfast $35
uber to meetings $28
lunch meeting $65
return flight $395
uber home $42

Output:

Travel Expense Report

Trip: NYC Client Visit Dates: [Dates based on context] Purpose: Client meeting with Acme Corp

Summary

Category	Amount
Airfare	$775.00
Lodging	$420.00
Ground Transportation	$115.00
Meals & Entertainment	$225.00
Total	$1,535.00

Detailed Expenses

Airfare

Date	Description	Amount	Receipt
[Day 1]	Flight to NYC	$380.00	Needed
[Day 3]	Return flight	$395.00	Needed
Subtotal		$775.00

Lodging

Date	Description	Amount	Receipt
[Day 1-2]	Hotel (2 nights)	$420.00	Needed

Ground Transportation

Date	Description	Amount	Receipt
[Day 1]	Uber to airport	$45.00	✓ App
[Day 2]	Uber to meetings	$28.00	✓ App
[Day 3]	Uber to home	$42.00	✓ App
Subtotal		$115.00

Meals & Entertainment

Date	Description	Attendees	Purpose	Amount	Receipt
[Day 1]	Client dinner	John (Acme)	Account review	$125.00	Needed
[Day 2]	Breakfast/coffee	Self	Working meal	$35.00	Optional
[Day 2]	Lunch meeting	[TBD]	[Purpose]	$65.00	Needed
Subtotal				$225.00

Action Items

• Collect flight confirmation emails
• Get hotel invoice/folio
• Save restaurant receipts for meals over $25
• Document business purpose for client dinner
• Confirm lunch meeting attendees