Budget vs Actuals Narrative

AI Prompt Templates

Copy a prompt into Claude, ChatGPT, or Gemini. Paste your document at the bottom and run.

Paste a document and get a scored quality assessment with evidence and revision priorities.

6,104 characters
You are an expert M&E advisor with grant management experience. Score the budget vs actuals narrative I will provide using the rubric below. A strong financial narrative is transparent about where money went, why variances occurred, and what it means for the remaining period.

SCORING RUBRIC - Budget vs Actuals Narrative
Score each dimension 1-5 using these criteria:

DIMENSION 1: Variance Quantification
- Score 5: Variances are quantified at line-item level with both absolute amount and percentage. Every budget line is reported with planned, actual, variance amount, and variance percentage. Overall totals are reconciled. Disaggregation matches the donor's budget categories. Figures are internally consistent across narrative and tables.
- Score 4: Line-item variances quantified for at least 80 percent of lines with both absolute and percentage figures. Overall totals reconciled. Minor inconsistencies between narrative and tables.
- Score 3: Variances quantified at category level (e.g., personnel, travel, supplies) but not at line-item level. Percentages stated for major categories only.
- Score 2: Variances stated at overall budget level only, OR only absolute amounts (no percentages), OR figures inconsistent between narrative and tables.
- Score 1: No quantified variance reporting. Narrative discusses spend without numbers.

DIMENSION 2: Variance Explanation
- Score 5: Every material variance (above the donor's reporting threshold, typically 10 percent or 15 percent) is explained with a specific cause: what activity drove the under or overspend, why it happened, and whether the cause is one-time or ongoing. Generic labels like "underspend" or "delays" are avoided in favor of specific drivers (e.g., "training rounds 3 and 4 postponed to Q3 because of seasonal access constraints, shifting trainer fees and venue costs"). Causes are linked to corresponding programmatic narrative elsewhere in the report.
- Score 4: Material variances explained with specific causes for at least 80 percent. Generic labels avoided in most cases. Links to programmatic narrative present for major variances.
- Score 3: Material variances named but explanations use general categories ("activities delayed," "lower than expected costs") without specific drivers. Links to programmatic narrative inconsistent.
- Score 2: Variances acknowledged but explanations are generic throughout, OR material variances unexplained.
- Score 1: No variance explanations. Numbers presented without commentary.

DIMENSION 3: Forward-Looking Implications
- Score 5: Implications of current spend pattern for the remaining budget period are stated explicitly. Catch-up plans for underspend lines name the activities and time-frames. Risk of slippage on overspend lines is assessed. A completion forecast is given (on track to spend full budget, projected underspend at year-end, projected overrun) with the basis stated. Where implications affect programmatic deliverables, this is linked to the results section.
- Score 4: Forward implications stated for major variances. Catch-up plans or slippage risks named for the most material. Completion forecast given.
- Score 3: Some forward implications stated but coverage is uneven. Catch-up plans general. Completion forecast absent or vague.
- Score 2: Forward implications mentioned only in passing, OR stated as intentions ("we will catch up") without specifics.
- Score 1: No forward-looking implications. Narrative reports the past period only.

DIMENSION 4: Reallocation Requests
- Score 5: Where reallocation is needed, requests are specified with source line, destination line, exact amount, and rationale tied to program needs and contractual flexibility allowed under the donor agreement. Each request is justified with reference to programmatic findings or implementation realities. The cumulative reallocation effect on the budget structure is shown. Where no reallocation is needed, this is stated explicitly with brief justification.
- Score 4: Reallocation requests specified with line, amount, and rationale for the major moves. Cumulative effect noted.
- Score 3: Reallocation needs mentioned with amounts and lines but rationale is general. Cumulative effect not shown.
- Score 2: Reallocation needs implied but not specified, OR stated as needed without amounts or lines.
- Score 1: No discussion of reallocation despite evidence in the variance figures that it is needed, OR reallocation requests with no rationale.

DIMENSION 5: Burn Rate Trajectory
- Score 5: Burn rate (cumulative actual to cumulative planned) is calculated and discussed. Trend is characterized as accelerating, on track, or slow with specific figures. Comparison to prior reporting periods is offered where data is available. Comparison to target trajectory (linear, front-loaded, back-loaded depending on program design) is stated. Implications of current trajectory for grant closure are noted.
- Score 4: Burn rate calculated and discussed. Trend characterized with figures. Comparison to prior periods or target trajectory present.
- Score 3: Burn rate mentioned at overall level but not trended. Comparison to prior periods or target trajectory absent.
- Score 2: Burn rate referenced without figures, OR cumulative spend stated without burn rate framing.
- Score 1: No discussion of burn rate or cumulative trajectory.

OUTPUT FORMAT:
Return your assessment as a table followed by a summary:

| Dimension | Score (1-5) | Evidence from Narrative | Priority Revision |
|-----------|-------------|------------------------|-------------------|
| Variance Quantification | | | |
| Variance Explanation | | | |
| Forward-Looking Implications | | | |
| Reallocation Requests | | | |
| Burn Rate Trajectory | | | |

**Total: X/25**
**Band:** Strong (22-25) / Adequate (17-21) / Needs Revision (11-16) / Substantial Revision (5-10)
**Single Most Important Revision:** [One specific sentence]

For any dimension scored 1 or 2, add a brief explanation and a concrete revision example.

BUDGET VS ACTUALS NARRATIVE TO SCORE:
[Paste your budget vs actuals narrative section here]

Scoring Criteria

Variance Quantification
5Excellent

Line-item variances with absolute amount and percentage. Overall totals reconciled. Categories match donor budget. Figures consistent across narrative and tables.

4Good

Line-item variances quantified for at least 80 percent of lines with absolute and percentage. Totals reconciled. Minor inconsistencies.

3Adequate

Variances quantified at category level but not at line-item level. Percentages for major categories only.

2Needs Improvement

Variances stated at overall budget level only, OR only absolute amounts (no percentages), OR figures inconsistent.

1Inadequate

No quantified variance reporting. Narrative discusses spend without numbers.

Variance Explanation
5Excellent

Every material variance explained with specific cause (activity, reason, one-time or ongoing). Generic labels avoided. Linked to programmatic narrative.

4Good

Specific causes for at least 80 percent. Generic labels avoided in most cases. Links to programmatic narrative present for major variances.

3Adequate

Material variances named but explanations use general categories without specific drivers. Programmatic links inconsistent.

2Needs Improvement

Variances acknowledged but explanations are generic throughout, OR material variances unexplained.

1Inadequate

No variance explanations. Numbers presented without commentary.

Forward-Looking Implications
5Excellent

Implications stated explicitly. Catch-up plans name activities and time-frames. Slippage risk assessed. Completion forecast given with basis. Linked to programmatic deliverables.

4Good

Forward implications stated for major variances. Catch-up plans or slippage risks named for the most material. Completion forecast given.

3Adequate

Some forward implications stated but coverage uneven. Catch-up plans general. Completion forecast absent or vague.

2Needs Improvement

Forward implications mentioned only in passing, OR stated as intentions without specifics.

1Inadequate

No forward-looking implications. Narrative reports the past period only.

Reallocation Requests
5Excellent

Each request specifies source line, destination line, amount, and rationale tied to program needs and donor flexibility. Cumulative effect shown. Where no reallocation is needed, stated explicitly.

4Good

Reallocation requests specified with line, amount, and rationale for the major moves. Cumulative effect noted.

3Adequate

Reallocation needs mentioned with amounts and lines but rationale is general. Cumulative effect not shown.

2Needs Improvement

Reallocation needs implied but not specified, OR stated as needed without amounts or lines.

1Inadequate

No reallocation discussion despite need, OR requests with no rationale.

5Excellent

Burn rate calculated and trended. Characterized as accelerating, on track, or slow with figures. Compared to prior periods and target trajectory. Implications for grant closure noted.

4Good

Burn rate calculated and discussed. Trend characterized with figures. Comparison to prior periods or target trajectory present.

3Adequate

Burn rate mentioned at overall level but not trended. Comparison absent.

2Needs Improvement

Burn rate referenced without figures, OR cumulative spend stated without burn rate framing.

1Inadequate

No discussion of burn rate or cumulative trajectory.

Score Interpretation

Total (out of 25)BandNext Step
22-25StrongSubmit with minor editorial check. Financial narrative is decision-ready.
17-21AdequateAddress flagged dimensions. Most common gaps: burn rate trending and forward-looking specifics.
11-16Needs RevisionRevise before submission. Rebuild explanations from generic labels to specific drivers.
5-10Substantial RevisionDo not submit. Rework variance quantification and explanations from line items upward.