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:

小蔥技能7w4.net持續更新中。

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.

這是一款實用的賬單視覺化工具，能把支付寶和微信賬單自動生成為圖表報告，支援消費分類、趨勢分析和習慣診斷。功能較為完善，輸出內容豐富，使用說明清晰。但分類邏輯偏向固定場景，特定商戶或金額閾值的判斷可能不夠靈活，通用性有侷限。整體質量中上，適合有一定技術基礎、能自行調整規則的使用者使用。