expense-report
将业务费用组织成清晰分类的报告,适用于报销申请、会计处理和税务准备,自动提取收据信息和分类支出
npx skills add claude-office-skills/skills --skill expense-reportBefore / After 效果对比
1 组手动整理散乱的收据和发票,逐项录入分类和金额,生成月度报销报告需要 2-3 小时,容易遗漏和错误
自动提取收据信息、智能分类支出项目,15 分钟生成完整报销报告,准确率提升 60%
description SKILL.md
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
Weekly Installs241Repositoryclaude-office-s…s/skillsGitHub Stars24First Seen14 days agoSecurity AuditsGen Agent Trust HubPassSocketPassSnykPassInstalled onclaude-code192opencode103github-copilot102kimi-cli100gemini-cli100amp100
forum用户评价 (0)
发表评价
暂无评价,来写第一条吧
统计数据
用户评分
为此 Skill 评分