generate-alipay-wechat-report

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.

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

Look for native bill files first.
Use scripts/generate_spending_report.py to build the report.
Open the generated HTML if the user wants to review it immediately.
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.