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 微信支...

Security Scan

The skill's files, instructions, and requested resources are consistent with a local tool that parses Alipay CSV and WeChat XLSX exports and writes a local HTML report; nothing in the provided material indicates unexpected network exfiltration or unrelated credential access, though I could not review the very end of the bundled script.

Purpose & Capability

Name/description (generate local interactive HTML report from Alipay/WeChat exports) matches the included script and SKILL.md. No unrelated env vars, binaries, or cloud credentials are requested. Requiring only local files is proportionate to the stated purpose.

Instruction Scope

SKILL.md instructs the agent to discover local bill files, run the bundled Python script, optionally open the generated HTML, and summarize results — all within the expected scope. Commands reference the script path inside the skill; the script reads CSV/XLSX files and writes a local HTML file. I did not see instructions to read unrelated system configuration or to transmit data externally in the provided SKILL.md or the visible portion of the script.

Install Mechanism

No install spec is present (instruction-only with bundled script). That is low risk: nothing is downloaded or installed from external sources during install.

Credentials

The skill declares no required environment variables, credentials, or config paths. The script operates on user-supplied local bill files and writes a local HTML report, which is consistent with the lack of credential requests.

Persistence & Privilege

always is false and the skill is user-invocable. It does not request persistent system-wide privileges. Autonomous invocation is allowed (platform default) but not combined with elevated privileges in this package.

Assessment

This skill appears to do what it says: parse exported Alipay CSV and WeChat XLSX files and produce a local HTML report. Before installing or running it, consider: 1) review the entire scripts/generate_spending_report.py file yourself (the provided excerpt was large but truncated; ensure there are no network calls, telemetry, or subprocess invocations you don't expect); 2) run the script on sample or non-sensitive data first or inside a sandbox; 3) note the script will read files from the specified input directory and write an HTML file (default: <input>/reports/spending_report.html) — back up any important files if you have name conflicts; 4) if the --open behavior launches a browser, be aware this may reveal local file paths in the browser (normal for local reports); 5) if you need stronger assurance, search the full script for modules like requests, urllib, socket, subprocess, or any URL literals which would indicate network activity. If none are present, the tool is effectively local and proportionate to its stated purpose.

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.