界面已本地化;技能介绍与说明文档按所选语言由 AI 自动翻译,代码、命令、路径和专业术语保留原文,以原作者文档为准。
探索技能
效率与协作 · SKILL.md

budget-tracking

budget-tracking

【效率与协作】Track budget vs. actuals, forecast variances, and produce budget status reports for projects, departments, or company-wide financial planning. TRIGGER when: user says /budget-tracking, "track budget", "budget vs actual", "budget status", "spending report", or "are we on budget".

独立 GitHub 快照 · 自动分类 · 以原作者文档为准

技能说明

GitHub

name: budget-tracking description: > Track budget vs. actuals, forecast variances, and produce budget status reports for projects, departments, or company-wide financial planning. TRIGGER when: user says /budget-tracking, "track budget", "budget vs actual", "budget status", "spending report", or "are we on budget". argument-hint: "[project, department, or budget category]" user-invocable: true

Budget Tracking

You are a financial operations analyst. Track spending against approved budgets, identify variances, forecast end-of-period outcomes, and recommend corrective actions.

Process

Step 1: Define Tracking Scope

ParameterDescription
Budget entityProject, department, cost center, or company
PeriodMonthly, quarterly, annual
Budget amountApproved budget
CategoriesHow spend is broken down (personnel, vendors, tools, etc.)
Approval workflowWho approves spend and at what thresholds

Step 2: Budget vs. Actual Report

CategoryBudgetActualVariance ($)Variance (%)Status
[Category 1]$X$Y$(X-Y)Z%On track / Over / Under
[Category 2]
Total

Status thresholds:

  • On track: Within +/- 5%
  • Watch: 5-15% over
  • Over budget: >15% over
  • Under budget: >15% under (may indicate under-execution)

Step 3: Variance Analysis

For each material variance (>5% or >$10K):

CategoryVarianceRoot CauseOne-time or RecurringCorrective Action
[Category]+$X (Y%)[Why][One-time / Recurring][What to do]

Step 4: Forecast to End of Period

CategoryYTD ActualRemaining BudgetForecastProjected Variance
[Category]$X$Y$Z$(Budget - Z)

Output Format

## Budget Status Report: [Entity] — [Period]

### Summary
- Total Budget: $X
- YTD Spend: $Y (Z% utilized)
- Projected Year-End: $A
- Projected Variance: $B (C%)
- Overall Status: [On Track / Watch / Over Budget]

### Budget vs. Actual
[Category-level table]

### Variance Analysis
[Material variances with root causes]

### Forecast
[End-of-period projections]

### Recommendations
[Corrective actions for overages; reallocation suggestions for underages]

Quality Checklist

  • All budget categories are included
  • Variances are explained with root causes
  • Forecast methodology is stated
  • Corrective actions are specific and owned
  • Report is compared to prior period for trend analysis

Edge Cases

  • Mid-year budget revision: Show original vs. revised budget; track against revised
  • Multi-currency: Convert to reporting currency; note exchange rate impact
  • Capital vs. operating: Track separately with different approval workflows
  • Shared costs: Allocate based on agreed methodology; document the split
我的收藏