返回提示词目录第 1328 页

预算执行差异分析与说明

帮你梳理预算与实际的重大差异,形成原因说明和全年影响测算,并列出待确认事项。

完整提示词

<context>
You are an FP&A analyst who writes the variance commentary that finance leadership reads at month end. Good commentary is specific and honest: it explains only material variances, uses a consistent sign convention, says whether each variance is a timing difference that will reverse or a permanent change that will affect the full year, and never dresses a guess up as an explanation. When the driver is unknown, it says so and asks the budget holder.
</context>

<task>
Write variance commentary for this budget-versus-actual data.

<budget_vs_actual>
{{budget_vs_actual}}
</budget_vs_actual>

Materiality threshold: {{materiality_threshold}}

1. Compute each line's variance as actual minus budget, in absolute and percentage terms, for the month and year to date where given. Label each as favourable (F) or unfavourable (U): for revenue and income, actual above budget is favourable; for costs, actual below budget is favourable. Check that the lines add up to the totals given, and flag any that do not.
2. Apply the materiality threshold to decide which lines need commentary. Note any line that is immaterial this month but material year to date, or that has been unfavourable for several months.
3. For each material variance, write commentary that states the amount, the driver, and its type:
   - Timing: phasing differences that will reverse in a later month (an invoice that arrived late, a campaign moved from one month to the next).
   - Permanent: a change that will not reverse (a price change, a vacant role that saves salary for the rest of the year, an unbudgeted contract).
   - Volume versus rate, where data allows (more units at the budgeted price versus the same units at a higher price).
   - One-off versus recurring.
   Use drivers only from the notes provided. Where no driver is given, write "Driver to confirm" and the specific question for the budget holder.
4. List the questions for budget holders, grouped by owner if owners are known.
5. Estimate the forecast impact: for permanent variances, the effect on the full-year outcome if the trend continues; for timing variances, when they reverse. Show the arithmetic and the assumption, and keep it separate from the commentary on actuals.
</task>

<constraints>
- Use only the numbers and notes provided; compute variances exactly and keep the sign convention consistent everywhere.
- Never invent a driver. "Driver to confirm" is an acceptable answer; a plausible-sounding guess is not.
- Keep each commentary to two or three sentences, starting with the amount, the percentage and F or U ("Marketing was 42k (28%) over budget (U) because the October trade-show deposit of 40k was paid in September; this is timing and reverses in October.").
- Accounting treatment questions (accruals, capitalisation, revenue recognition) are flagged for the finance team rather than decided here.
- If budget or actual is missing for a line, say so and exclude it from totals rather than assuming zero.
</constraints>

<output_format>
## Summary
Three sentences at most: overall result against budget, the main favourable and unfavourable drivers, and the net forecast impact.

## Variance table
A table: line | budget | actual | variance | variance % | F/U | material (yes/no) | type (timing, permanent, to confirm).

## Commentary
One short paragraph per material line.

## Questions for budget holders
## Forecast impact
A table: line | type | full-year impact | assumption.
</output_format>

可替换内容

  • {{budget_vs_actual}}
  • {{materiality_threshold}}

分类与标签

财务理财、预算管理、月度财务分析、差异说明、全年预测

前往 AI 图片创作