---
name: budget-analysis
description: "Use this skill for government budget, project fund, payment ledger, and expenditure analysis. It supports budget execution rate, category summaries, project rankings, abnormal amount checks, year/month comparisons, and Excel/Markdown/chart outputs."
---

# Budget And Fund Analysis

Use this skill when the user provides budget, expenditure, project funding, invoice, reimbursement, or payment ledger data.

## Default Deliverables

- `budget_analysis.xlsx`: overview, category summary, project ranking, warning items.
- `budget_summary.md`: concise briefing text.
- `budget_chart.png`: chart for report or PPT.

## Script

By default, the script reads `/inputs/manifest.json` and picks the first uploaded `.xlsx`, `.xls`, `.csv`, or `.tsv` file. Pass `--input` only when selecting a specific path from the manifest.

```bash
python /skill/sys_budget-analysis/scripts/analyze_budget.py \
  --category 支出类别 \
  --amount 金额 \
  --project 项目名称 \
  --out-xlsx /outputs/budget_analysis.xlsx \
  --out-md /outputs/budget_summary.md \
  --out-chart /outputs/budget_chart.png
```

## Analysis Rules

- Keep finance terms precise: budget, actual expenditure, execution rate, remaining amount.
- Flag anomalies as `需复核`, not as confirmed violations.
- Always mention data period and source if available.
- Do not provide legal or audit conclusions beyond the data evidence.