Expense Report

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

• Provide your expense information (receipts, transactions, or descriptions)
• Specify the purpose (reimbursement, tax prep, budget tracking)
• Tell me your expense categories or policies
• 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