跳到主要内容

💰 个人财务仪表盘

上传银行对账单,获得带图表的支出分析报告。

你: $Finance Analyzer
(拖入 3 个 CSV 银行对账单到文件浏览器)
分析我这 3 个月的支出情况。我的钱主要花在哪里?

AI 的工作流程

  1. 读取所有 CSV 文件并标准化不同格式
  2. 对交易分类:食材、餐饮、订阅服务、交通等
  3. 识别定期费用并标记异常项目
  4. 创建包含月度趋势、类别分布和主要商家的仪表盘
  5. 标记异常项目:异常大额费用、新增订阅、可能的重复费用

技能内容

将下面的内容复制到工作区 → 技能 → 创建

---
name: finance-analyzer
description: Analyzes bank statements and creates spending reports with charts
---

## Financial Analysis

When analyzing bank statements:

1. **Read all files** and normalize columns (date, description, amount, type). Handle different CSV formats (detect delimiters, date formats, debit/credit conventions)
2. **Categorize transactions** using keyword matching:
   - Groceries: walmart, costco, trader joe, whole foods
   - Dining: restaurant, cafe, doordash, uber eats
   - Subscriptions: netflix, spotify, recurring monthly charges
   - Transport: gas, uber, lyft, parking
   - (Add more categories as needed)
3. **Generate charts**:
   - Monthly spending trend (line chart)
   - Category breakdown (pie chart)
   - Top 10 merchants (bar chart)
4. **Detect anomalies**: charges >2x average for that merchant, new recurring charges, possible duplicates (same amount within 3 days)
5. **Create an HTML dashboard** viewable in the file browser

Use proper currency formatting and round to 2 decimal places.
本内容仅供参考,不构成任何保证、担保或合同承诺。Open WebUI 按“现状”提供。请参阅您的许可协议 以了解适用条款。