Expense Tracker

费用跟踪器

全面的费用管理技能，用于跟踪、处理和自动化费用工作流。

核心工作流

1. 收据处理流程

RECEIPT TO REIMBURSEMENT:
┌─────────────────┐
│  Receipt Image  │
│  (Photo/PDF)    │
└────────┬────────┘
         ▼
┌─────────────────┐
│  OCR Extract    │
│  - Vendor       │
│  - Amount       │
│  - Date         │
│  - Items        │
└────────┬────────┘
         ▼
┌─────────────────┐
│  Auto-Categorize│
│  - Travel       │
│  - Meals        │
│  - Software     │
└────────┬────────┘
         ▼
┌─────────────────┐
│  Policy Check   │
│  - Limits       │
│  - Approvals    │
└────────┬────────┘
         ▼
┌─────────────────┐
│  Submit Report  │
└─────────────────┘

2. 费用类别

类别	示例	默认限额
差旅	航班、酒店、交通	$500/天
餐饮	团队晚餐、客户餐饮	$100/人
软件	SaaS 订阅	$200/月
设备	硬件、外围设备	$1000/件
办公用品	用品、打印	$50/月
培训	课程、会议	$2000/年

3. 审批工作流

approval_matrix:
  - amount_range: [0, 100]
    required_approvers: []
    auto_approve: true
  
  - amount_range: [100, 500]
    required_approvers:
      - direct_manager
    
  - amount_range: [500, 2000]
    required_approvers:
      - direct_manager
      - department_head
    
  - amount_range: [2000, null]
    required_approvers:
      - direct_manager
      - department_head
      - finance_director

收据 OCR 模板

提取字段

receipt_extraction:
  required:
    - vendor_name
    - total_amount
    - transaction_date
    - payment_method
  
  optional:
    - line_items
    - tax_amount
    - tip_amount
    - currency
    - receipt_number
  
  validation:
    date_format: "YYYY-MM-DD"
    amount_precision: 2
    currency_codes: ["USD", "EUR", "GBP", "CNY"]

提取数据示例

{
  "vendor": "Uber Technologies",
  "date": "2024-01-15",
  "total": 45.50,
  "currency": "USD",
  "category": "Travel - Ground Transport",
  "line_items": [
    {"description": "UberX ride", "amount": 38.00},
    {"description": "Tip", "amount": 7.50}
  ],
  "payment_method": "Corporate Card ****4242",
  "receipt_id": "RCP-2024-0115-001"
}

费用报告模板

月度报告结构

# Expense Report - {Month} {Year}

**Employee:** {name}
**Department:** {department}
**Submission Date:** {date}
**Report Period:** {start_date} to {end_date}

## Summary

| Category | Amount | Budget | Variance |
|----------|--------|--------|----------|
| Travel | $1,250 | $2,000 | -$750 |
| Meals | $380 | $400 | -$20 |
| Software | $150 | $200 | -$50 |
| Equipment | $0 | $500 | -$500 |
| **Total** | **$1,780** | **$3,100** | **-$1,320** |

## Itemized Expenses

### Travel
| Date | Description | Amount | Receipt |
|------|-------------|--------|---------|
| 01/05 | Flight to NYC | $450 | ✓ |
| 01/05 | Hotel (2 nights) | $600 | ✓ |
| 01/06 | Uber to client | $45 | ✓ |
| 01/07 | Train return | $155 | ✓ |

### Meals
| Date | Description | Attendees | Amount | Receipt |
|------|-------------|-----------|--------|---------|
| 01/06 | Client dinner | 4 | $280 | ✓ |
| 01/10 | Team lunch | 6 | $100 | ✓ |

## Approval Status
- [ ] Direct Manager: Pending
- [ ] Finance Review: Pending

政策合规

自动检查规则

compliance_rules:
  receipt_required:
    threshold: 25
    message: "Receipt required for expenses over $25"
  
  meal_per_person:
    limit: 75
    message: "Per-person meal limit exceeded"
  
  advance_booking:
    travel_days: 14
    savings_expected: 0.20
    message: "Book travel 14+ days ahead for savings"
  
  preferred_vendors:
    hotels: ["Marriott", "Hilton", "Hyatt"]
    airlines: ["United", "Delta", "American"]
    message: "Use preferred vendors when available"

违规处理

violation_actions:
  soft_violation:
    - flag_for_review
    - notify_submitter
    - allow_justification
  
  hard_violation:
    - reject_expense
    - notify_manager
    - require_correction
  
  repeated_violations:
    - escalate_to_hr
    - training_required

集成工作流

Slack 费用机器人

slack_commands:
  /expense:
    - upload_receipt
    - check_balance
    - submit_report
    - view_status
  
  notifications:
    - expense_approved
    - expense_rejected
    - report_due_reminder
    - policy_update

信用卡同步

card_integration:
  providers:
    - amex_corporate
    - chase_business
    - brex
    - ramp
  
  auto_import:
    frequency: daily
    categorize: true
    match_receipts: true
  
  reconciliation:
    flag_missing_receipts: true
    flag_personal_charges: true

分析仪表板

支出趋势

MONTHLY SPENDING BY CATEGORY:
Travel    ████████████░░░░ $12,500
Meals     ██████░░░░░░░░░░ $5,800
Software  ████░░░░░░░░░░░░ $3,200
Equipment ██░░░░░░░░░░░░░░ $1,500
Office    █░░░░░░░░░░░░░░░ $800

TOP VENDORS:
1. Delta Airlines    $4,200
2. Marriott Hotels   $3,800
3. AWS              $2,100
4. Uber             $1,500
5. Zoom             $600

预算与实际支出

DEPARTMENT BUDGET STATUS:
Engineering  ████████░░ 78% ($15,600/$20,000)
Sales        ██████████ 95% ($28,500/$30,000)
Marketing    ██████░░░░ 62% $9,300/$15,000)
Operations   ████░░░░░░ 45% ($4,500/$10,000)

报销处理

付款计划

reimbursement:
  processing_days: [1, 15]  # Bi-monthly
  payment_methods:
    - direct_deposit
    - payroll_addition
    - check
  
  timing:
    submission_deadline: 5  # Days before processing
    approval_deadline: 3
    payment_delay: 2  # Business days after processing

最佳实践

1. 及时提交：在交易后 7 天内提交费用
2. 附上收据：务必附上电子收据
3. 正确分类：使用标准类别
4. 补充说明：为每笔费用注明业务用途
5. 提交前检查：检查是否符合政策
6. 记录里程：实时记录公务里程