expense-report
Compare original and translation side by side
🇺🇸
Original
English🇨🇳
Translation
ChineseExpense 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
该Skill可帮助您将商务费用整理成清晰、分类明确的报告,适用于报销申请、会计核算和税务筹备。
使用场景:
- 创建费用报销报告
- 整理收据用于税务筹备
- 对商务费用进行分类
- 汇总差旅费用
- 制作月度/季度费用汇总
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
undefinedmarkdown
undefinedExpense 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 |
| 分类 | 金额 |
|---|---|
| 交通 | $XXX.XX |
| 住宿 | $XXX.XX |
| 餐饮 | $XXX.XX |
| 其他 | $XXX.XX |
| 总计 | $XXX.XX |
Expense Details
费用明细
Transportation
交通
| Date | Description | Vendor | Amount | Receipt |
|---|---|---|---|---|
| [Date] | [Description] | [Vendor] | $XX.XX | ✓ |
| 日期 | 描述 | 商家 | 金额 | 收据 |
|---|---|---|---|---|
| [日期] | [描述] | [商家] | $XX.XX | ✓ |
Lodging
住宿
| Date | Description | Vendor | Amount | Receipt |
|---|---|---|---|---|
| [Date] | [Hotel name] | [Vendor] | $XX.XX | ✓ |
| 日期 | 描述 | 商家 | 金额 | 收据 |
|---|---|---|---|---|
| [日期] | [酒店名称] | [商家] | $XX.XX | ✓ |
Meals & Entertainment
餐饮与招待
| Date | Description | Attendees | Business Purpose | Amount | Receipt |
|---|---|---|---|---|---|
| [Date] | [Restaurant] | [Names] | [Purpose] | $XX.XX | ✓ |
| 日期 | 描述 | 参与人员 | 商务用途 | 金额 | 收据 |
|---|---|---|---|---|---|
| [日期] | [餐厅] | [姓名] | [用途] | $XX.XX | ✓ |
Other Expenses
其他费用
| Date | Description | Category | Amount | Receipt |
|---|---|---|---|---|
| [Date] | [Description] | [Category] | $XX.XX | ✓ |
| 日期 | 描述 | 分类 | 金额 | 收据 |
|---|---|---|---|---|
| [日期] | [描述] | [分类] | $XX.XX | ✓ |
Approvals
审批
- Employee Signature: _____________ Date: _______
- Manager Approval: _____________ Date: _______
- Finance Approval: _____________ Date: _______
- 员工签字:_____________ 日期:_______
- 经理审批:_____________ 日期:_______
- 财务审批:_____________ 日期:_______
Notes
备注
[Any additional context or explanations]
undefined[任何额外背景或说明]
undefinedTravel Expense Report
差旅费用报告
markdown
undefinedmarkdown
undefinedTravel 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
- 时长: [X] 天
- 总费用: $X,XXX.XX
- 每日津贴: $XXX.XX
- 差额: +/- $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] |
| 项目 | 商家 | 金额 | 支付日期 |
|---|---|---|---|
| 机票 | [航空公司] | $XXX.XX | [日期] |
| 酒店预订 | [酒店] | $XXX.XX | [日期] |
| 会议注册费 | [活动] | $XXX.XX | [日期] |
Daily Expenses
每日费用
Day 1 - [Date]
第1天 - [日期]
| Category | Description | Amount |
|---|---|---|
| Transport | Airport taxi | $XX.XX |
| Meals | Dinner | $XX.XX |
| Day Total | $XX.XX |
| 分类 | 描述 | 金额 |
|---|---|---|
| 交通 | 机场出租车 | $XX.XX |
| 餐饮 | 晚餐 | $XX.XX |
| 当日总计 | $XX.XX |
Day 2 - [Date]
第2天 - [日期]
| Category | Description | Amount |
|---|---|---|
| Meals | Breakfast/Lunch/Dinner | $XX.XX |
| Transport | Uber to meeting | $XX.XX |
| Day Total | $XX.XX |
| 分类 | 描述 | 金额 |
|---|---|---|
| 餐饮 | 早餐/午餐/晚餐 | $XX.XX |
| 交通 | 优步前往会议地点 | $XX.XX |
| 当日总计 | $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% |
| 分类 | 金额 | 占比 |
|---|---|---|
| 机票 | $XXX.XX | XX% |
| 住宿 | $XXX.XX | XX% |
| 地面交通 | $XXX.XX | XX% |
| 餐饮 | $XXX.XX | XX% |
| 其他 | $XXX.XX | XX% |
| 总计 | $X,XXX.XX | 100% |
Receipt Checklist
收据清单
- Flight confirmation/receipt
- Hotel invoice
- Ground transportation receipts
- Meal receipts over $[threshold]
- Other expense receipts
undefined- 机票确认单/收据
- 酒店发票
- 地面交通收据
- 超过$[阈值]的餐饮收据
- 其他费用收据
undefinedMonthly Expense Summary
月度费用汇总
markdown
undefinedmarkdown
undefinedMonthly 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% |
| 指标 | 金额 |
|---|---|
| 总费用 | $X,XXX.XX |
| 较上月变化 | +/-XX% |
| 与预算差额 | +/-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 |
| 分类 | 金额 | 预算 | 差额 |
|---|---|---|---|
| 房租/水电 | $XXX.XX | $XXX.XX | $XX.XX |
| 软件/订阅服务 | $XXX.XX | $XXX.XX | $XX.XX |
| 办公用品 | $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 |
| 分类 | 金额 | 预算 | 差额 |
|---|---|---|---|
| 法律服务 | $XXX.XX | $XXX.XX | $XX.XX |
| 会计服务 | $XXX.XX | $XXX.XX | $XX.XX |
| 咨询服务 | $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 |
| 分类 | 金额 | 预算 | 差额 |
|---|---|---|---|
| 广告 | $XXX.XX | $XXX.XX | $XX.XX |
| 活动 | $XXX.XX | $XXX.XX | $XX.XX |
| 差旅 | $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 |
| 排名 | 日期 | 描述 | 分类 | 金额 |
|---|---|---|---|---|
| 1 | [日期] | [描述] | [分类] | $XXX.XX |
| 2 | [日期] | [描述] | [分类] | $XXX.XX |
Notes & Anomalies
备注与异常
- [Explanation for any unusual expenses]
- [Budget variance explanations]
undefined- [对异常费用的说明]
- [预算差额的说明]
undefinedExpense 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 |
| 分类 | 示例 | 可抵扣税 |
|---|---|---|
| 差旅 | 机票、酒店、租车 | 通常可以 |
| 餐饮与招待 | 客户晚餐、团队午餐 | 50-100% |
| 交通 | 出租车、优步、停车费、里程费 | 可以 |
| 办公用品 | 纸张、笔、打印机墨水 | 可以 |
| 软件与订阅服务 | SaaS工具、应用 | 可以 |
| 职业发展 | 课程、书籍、会议 | 通常可以 |
| 通讯 | 电话、网络 | 部分可以 |
| 专业服务 | 法律服务、会计服务 | 可以 |
| 营销 | 广告、宣传材料 | 可以 |
| 设备 | 电脑、办公家具 | 折旧抵扣 |
IRS Category Alignment (US)
与美国IRS分类对应
| 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 |
| IRS分类 | 描述 |
|---|---|
| 广告 | 营销与宣传 |
| 汽车与卡车 | 车辆费用 |
| 佣金 | 支付给承包商的费用 |
| 合同工 | 自由职业者报酬 |
| 折旧 | 资产折旧 |
| 保险 | 企业保险 |
| 利息 | 企业贷款利息 |
| 法律与专业服务 | 律师、注册会计师费用 |
| 办公费用 | 常规办公支出 |
| 房租 | 工作场地租金 |
| 维修 | 设备维护 |
| 用品 | 商务用品 |
| 税费与执照 | 企业税费 |
| 差旅 | 商务差旅 |
| 餐饮 | 商务餐饮(50%抵扣) |
| 水电 | 企业水电 |
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
- 需保留收据的情况: 所有超过25美元(美国)或当地阈值的费用
- 必填信息: 日期、商家、金额、支付方式
- 餐饮: 需包含参与人员和商务用途
- 缺失收据: 在报告中注明说明
Currency Conversion
货币转换
- Use exchange rate from date of expense
- Document rate source (bank, XE.com, etc.)
- Keep in original currency + converted amount
- 使用费用发生当日的汇率
- 记录汇率来源(银行、XE.com等)
- 保留原货币金额+转换后金额
Mileage Calculation
里程计算
- Current IRS rate (2024): $0.67/mile (verify current rate)
- Document: Date, destination, purpose, miles
- Use odometer readings or mapping app
- 当前IRS费率(2024年):$0.67/英里(请核实最新费率)
- 记录:日期、目的地、用途、里程数
- 使用里程表读数或地图应用
Output Format
输出格式
markdown
undefinedmarkdown
undefinedExpense Report
费用报告
Period: [Dates]
Total: $X,XXX.XX
周期: [日期]
总计: $X,XXX.XX
Summary by Category
按分类汇总
[Category breakdown table]
[分类 breakdown 表格]
Detailed Expenses
费用明细
[Line items with all required info]
[包含所有必填信息的分项]
Missing/Notes
缺失项/备注
[Any issues to address]
undefined[需要解决的问题]
undefinedLimitations
局限性
- 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 $42Output:
输入:
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输出:
Travel Expense Report
差旅费用报告
Trip: NYC Client Visit
Dates: [Dates based on context]
Purpose: Client meeting with Acme Corp
出差: 纽约客户拜访
日期: [根据上下文确定的日期]
目的: 与Acme Corp客户会面
Summary
汇总
| Category | Amount |
|---|---|
| Airfare | $775.00 |
| Lodging | $420.00 |
| Ground Transportation | $115.00 |
| Meals & Entertainment | $225.00 |
| Total | $1,535.00 |
| 分类 | 金额 |
|---|---|
| 机票 | $775.00 |
| 住宿 | $420.00 |
| 地面交通 | $115.00 |
| 餐饮与招待 | $225.00 |
| 总计 | $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 |
| 日期 | 描述 | 金额 | 收据 |
|---|---|---|---|
| [第1天] | 飞往纽约 | $380.00 | 需要 |
| [第3天] | 返回航班 | $395.00 | 需要 |
| 小计 | $775.00 |
Lodging
住宿
| Date | Description | Amount | Receipt |
|---|---|---|---|
| [Day 1-2] | Hotel (2 nights) | $420.00 | Needed |
| 日期 | 描述 | 金额 | 收据 |
|---|---|---|---|
| [第1-2天] | 酒店(2晚) | $420.00 | 需要 |
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 |
| 日期 | 描述 | 金额 | 收据 |
|---|---|---|---|
| [第1天] | 优步前往机场 | $45.00 | ✓ 应用记录 |
| [第2天] | 优步前往会议地点 | $28.00 | ✓ 应用记录 |
| [第3天] | 优步回家 | $42.00 | ✓ 应用记录 |
| 小计 | $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 |
| 日期 | 描述 | 参与人员 | 用途 | 金额 | 收据 |
|---|---|---|---|---|---|
| [第1天] | 客户晚餐 | John(Acme) | 账户回顾 | $125.00 | 需要 |
| [第2天] | 早餐/咖啡 | 本人 | 工作餐 | $35.00 | 可选 |
| [第2天] | 午餐会议 | [待定] | [用途] | $65.00 | 需要 |
| 小计 | $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
- 收集机票确认邮件
- 获取酒店发票/账单
- 保存超过25美元的餐饮收据
- 记录客户晚餐的商务用途
- 确认午餐会议的参与人员
undefined