费用报告技能:财务与会计自动化 - Openclaw Skills
作者:互联网
2026-04-16
什么是 费用报告技能?
费用报告技能旨在弥合杂乱的交易数据与专业财务文件之间的差距。通过利用 Openclaw Skills 的力量,该工具可以处理收据描述或交易日志等原始输入,并将其转换为结构化的 Markdown 报告。它确保每个条目都映射到特定的业务类别或符合 IRS 标准的分类法,使其成为自由职业者、小企业主和企业员工不可或缺的工具。
无论您是在准备季度税务申报,还是在出差后提交报销申请,此技能都能提供维持财务清晰度所需的结构。它处理复杂的任务,例如分解差旅成本、计算每日津贴,并确保突出显示特定文件要求(例如商务餐的与会者名单)以供用户参考。
下载入口:https://github.com/openclaw/skills/tree/main/skills/lijie420461340/expense-report
安装与下载
1. ClawHub CLI
从源直接安装技能的最快方式。
npx clawhub@latest install expense-report
2. 手动安装
将技能文件夹复制到以下位置之一
全局模式~/.openclaw/skills/
工作区
/skills/
优先级:工作区 > 本地 > 内置
3. 提示词安装
将此提示词复制到 OpenClaw 即可自动安装。
请帮我使用 Clawhub 安装 expense-report。如果尚未安装 Clawhub,请先安装(npm i -g clawhub)。
费用报告技能 应用场景
- 生成标准化的费用报销报告供企业提交。
- 整理零散的收据和交易描述,用于年度税务准备。
- 创建带有每日津贴和差异跟踪的详细差旅费汇总。
- 对每月业务支出进行分类,以识别预算差异和异常情况。
- 将自由职业者或小企业的支出总结为符合 IRS 标准的类别。
- 直接在智能体中输入您的费用数据,例如原始文本描述、交易日志或收据详情。
- 定义报告的目的(例如差旅报销或税务准备)以及任何特定的公司政策或类别。
- 该技能会分析输入,将每个项目映射到最相关的类别,并标记缺失的信息(如所需的收据或业务用途)。
- 根据所选模板生成格式化的 Markdown 报告,提供专业摘要和详细的逐项细分。
费用报告技能 配置指南
要在您的环境中启用费用报告技能,请确保已安装核心框架。然后,您可以使用以下命令将技能配置添加到您的工作区:
# 安装 Openclaw Skills CLI
npm install -g openclaw-cli
# 向您的智能体添加 expense-report 技能
openclaw skill add expense-report
安装完成后,您可以立即开始向您的智能体提供费用数据,在 Openclaw Skills 生态系统中生成报告。
费用报告技能 数据架构与分类体系
该技能将数据组织成结构化层级,以确保与会计软件和审计要求的兼容性:
| 数据字段 | 描述 | 要求 |
|---|---|---|
| 页眉元数据 | 包括员工姓名、部门和期间 | 必填 |
| 类别映射 | 按类型(差旅、餐饮等)汇总总额 | 自动 |
| 明细项目 | 日期、供应商、描述和金额 | 必填 |
| 合规性标签 | 收据状态、与会者名单和业务用途 | 上下文 |
| 财务指标 | 货币换算和里程计算 | 可选 |
Openclaw Skills 生成的所有报告都以整洁的 Markdown 格式输出,方便导出为 PDF 或 CSV 格式。
name: expense-report
description: Organize, categorize, and summarize business expenses for reimbursement and tax preparation
version: 1.0.0
author: Claude Office Skills Contributors
license: MIT
tags: [finance, expenses, accounting]
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
相关推荐
专题
+ 收藏
+ 收藏
+ 收藏
+ 收藏
+ 收藏
+ 收藏
最新数据
相关文章
Minecraft 3D 建造计划生成器:AI 场景架构师 - Openclaw Skills
Scholar Search:自动化文献搜索与研究简报 - Openclaw Skills
issue-to-pr: 自动化 GitHub Issue 修复与 PR 生成 - Openclaw Skills
接班交班总结器:临床 EHR 自动化 - Openclaw Skills
Teacher AI 备课专家:K-12 自动化教案设计 - Openclaw Skills
专利权利要求映射器:生物技术与制药 IP 分析 - Openclaw Skills
生成 Tesla 车身改色膜:用于 3D 显示的 AI 图像生成 - Openclaw Skills
Taiwan MD:面向台湾的 AI 原生开放知识库 - Openclaw Skills
自学习与迭代演进:AI Agent 成长框架 - Openclaw Skills
HIPC Config Manager: 安全的 API 凭据处理器 - Openclaw Skills
AI精选
