M&E StudioTools

Draft, check and improve: Budget vs Actuals Narrative

Draft, check and improve: Budget vs Actuals Narrative: Your prompt

Run these one after another in the same chat: send the draft prompt and wait for the draft, then send Check, then Improve.

Writes the draft, with the criteria as the bar it must meet.

You are an expert M&E advisor with grant management experience. Generate a budget vs actuals narrative that scores Excellent (5) on every dimension of the Budget vs Actuals Narrative rubric for the situation described below.

QUALITY REQUIREMENTS:

Variance Quantification: Report planned, actual, variance amount, and variance percentage at line-item level. Reconcile overall totals. Match the donor's budget categories. Ensure narrative figures match table figures.

Variance Explanation: Explain every material variance (above the donor's reporting threshold) with a specific cause: what activity drove it, why it happened, and whether the cause is one-time or ongoing. Avoid generic labels like "underspend" or "delays." Link each explanation to the corresponding programmatic narrative elsewhere in the report.

Forward-Looking Implications: State implications of the current spend pattern for the remaining budget period. Name catch-up plans with activities and time-frames. Assess slippage risk on overspend lines. Give a completion forecast (on track, projected underspend, projected overrun) with the basis stated. Link implications to programmatic deliverables.

Reallocation Requests: Where needed, specify each request with source line, destination line, exact amount, and rationale tied to program needs and the donor agreement's flexibility. Show the cumulative effect on the budget structure. Where no reallocation is needed, state so explicitly.

Burn Rate Trajectory: Calculate burn rate (cumulative actual to cumulative planned). Characterize the trend as accelerating, on track, or slow with figures. Compare to prior reporting periods where available. Compare to the target trajectory (linear, front-loaded, or back-loaded). Note implications for grant closure.

FORMAT: Present as numbered sections: (1) Budget vs Actuals Table (line-item with planned, actual, variance, percent), (2) Material Variance Explanations, (3) Forward-Looking Implications and Completion Forecast, (4) Reallocation Requests (or statement that none are needed), (5) Burn Rate Trajectory and Trend.

SITUATION BRIEF:

[Paste the program context, reporting period, budget vs actuals figures, known drivers of variance, prior period burn rate, and donor agreement flexibility provisions here]

Quality bar: The result must meet these criteria. It will be reviewed against them afterwards.

  • Variance Quantification: Whether variances are quantified at line-item level (absolute and percentage), not just at the overall budget level.
  • Variance Explanation: Whether each material variance is explained with a specific cause, rather than labeled with a generic term like "underspend" or "delay."
  • Forward-Looking Implications: Whether implications of the current spend pattern for the remaining budget period are stated (catch-up plans, slippage risk, completion forecasts).
  • Reallocation Requests: Where applicable, whether reallocation requests are specified with line items, amounts, and the rationale tied to program needs.
  • Burn Rate Trajectory: Whether the burn rate trend (accelerating, on track, slow) is discussed in context, including comparison to prior periods and target trajectory.

Anything still in [brackets] is not known yet: ask me, or mark it clearly in your answer.

Rubric · Create a Document · about 455 words

Score the financial commentary in a progress report (budget vs actuals plus variance explanation).

You'll Need

Your budget vs actuals narrative section

You Get Back

A draft, then a check, then an improved version, in one chat

Criteria