name: generate-alipay-wechat-report description: Generate an interactive local HTML spending report from native Alipay CSV exports and WeChat Pay XLSX exports. Use when an agent needs to turn 支付宝交易明细 or 微信支付账单流水文件 into a digital dashboard for expense categorization, monthly trend review, recurring merchant analysis, spending habit diagnosis, and budget optimization.

小葱技能7w4.net有完整的技能分类。

Generate Alipay Wechat Report

Overview

Turn native Alipay and WeChat Pay bill exports into a self-contained local HTML report. Prefer the bundled script so the workflow stays deterministic and does not depend on the current repo.

Workflow

1. Look for native bill files first.
2. Use scripts/generate_spending_report.py to build the report.
3. Open the generated HTML if the user wants to review it immediately.
4. Summarize the key findings in plain language after generation.

Inputs

Support these native exports: - Alipay CSV named like 支付宝交易明细(...).csv - WeChat Pay XLSX named like 微信支付账单流水文件(...).xlsx

If only the WeChat ZIP exists, stop and ask the user to unzip it locally first. The ZIP is commonly password-protected and this skill expects the extracted .xlsx file.

Commands

Use auto-discovery inside a directory:

python /Users/codefriday/.codex/skills/generate-alipay-wechat-report/scripts/generate_spending_report.py \
  --input-dir /path/to/bills \
  --output /path/to/bills/reports/spending_report.html

Use explicit files:

python /Users/codefriday/.codex/skills/generate-alipay-wechat-report/scripts/generate_spending_report.py \
  --alipay /path/to/支付宝交易明细(...).csv \
  --wechat /path/to/微信支付账单流水文件(...).xlsx \
  --output /path/to/reports/spending_report.html

Open the report after generation:

python /Users/codefriday/.codex/skills/generate-alipay-wechat-report/scripts/generate_spending_report.py \
  --input-dir /path/to/bills \
  --open

Output

Generate a self-contained HTML report with: - total outflow, consumption-only spend, and habit pool - category structure and merchant concentration - monthly trend, daily line chart, weekday/time heatmap - top transactions and recurring merchants - habit diagnosis and concrete optimization suggestions

Notes

Explain the three report scopes when handing results back: - 账户总流出: all effective outflow - 消费型支出: outflow excluding tax and pure transfers - 习惯池: outflow excluding non-routine major items so habit analysis stays clean

Do not treat rent, tax, renovation, travel, or one-off major purchases as ordinary daily bad habits.

这是一款实用的账单可视化工具，能把支付宝和微信账单自动生成为图表报告，支持消费分类、趋势分析和习惯诊断。功能较为完善，输出内容丰富，使用说明清晰。但分类逻辑偏向固定场景，特定商户或金额阈值的判断可能不够灵活，通用性有局限。整体质量中上，适合有一定技术基础、能自行调整规则的用户使用。