Expense Report

作者 claude-office-skills9c4c7d5cd281MIT499 个星标收录于 2026年10月8日更新于 2026年10月8日仓库8个月前更新

仅含说明Business & Finance

AI 生成的概览

将业务支出整理为分类清晰、结构化的费用报告，用于报销、会计和税务准备。

功能: 该技能接收收据、交易记录或文字描述等费用信息，并将其整理为结构化的费用报告。它提供标准报销、差旅和月度汇总报告的模板，并按常见业务类别及美国国税局（IRS）对齐的类别对费用进行分类。它还列出收据、货币换算和里程的办理准则，并生成包含汇总表和明细行的 Markdown 格式报告。
适用场景: 当你需要把一串业务支出整理成报销申请、差旅费用报告或月度、季度费用汇总时使用。它也适合为报税整理收据，或按预算对业务支出进行分类。
运行要求: 不附带脚本，仅为说明性指令。它引用了一个 office-mcp 服务器及 read_xlsx、create_xlsx、analyze_spreadsheet 工具，但该技能本身无法扫描或读取收据图像，也无法向费用系统提交报告。

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

markdown

# 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]

# 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

markdown

# 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

# 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

markdown

# 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]

# 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

markdown

# 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]

# 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 $45flight to NYC $380hotel 2 nights $420dinner with client john from acme $125coffee and breakfast $35uber to meetings $28lunch meeting $65return flight $395uber home $42

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

Output:

Travel Expense Report

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

Summary

Detailed Expenses

Airfare

Lodging

Ground Transportation

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

来源与署名

来源：claude-office-skills/skills位于expense-report提交9c4c7d5

许可证： MIT

内容归原作者所有。SourceWeft 从公开仓库中收录这些内容。

举报或申请下架

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

Expense Report

Expense Report

Overview

How to Use

Expense Report Templates

Standard Reimbursement Report

Travel Expense Report

Monthly Expense Summary

Expense Categories

Common Business Categories

IRS Category Alignment (US)

Processing Guidelines

Receipt Requirements

Currency Conversion

Mileage Calculation

Output Format

Limitations

Examples

Example: Quick Expense Organization

Travel Expense Report

Summary

Detailed Expenses

Airfare

Lodging

Ground Transportation

Meals & Entertainment

Action Items

来源与署名

更多来自 claude-office-skills/skills 的技能

Whatsapp Automation

Xlsx Manipulation

Web Search

Weekly Report

Tiktok Marketing

Template Engine

更多Business & Finance技能

Tax Prep

Plan Payroll

Job Post Builder

Contract Review

Close Month

Business Pulse