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