Budgets are forecasts. The moment the fiscal year begins, actual results start diverging from what you planned. The question is not whether variances will occur — they always do. The question is whether your team will see them early enough to respond, or discover them at year-end when it is too late to make adjustments.
A budget vs. actual variance report compares what your nonprofit planned to spend and earn against what actually happened — identifying favorable and unfavorable variances that require investigation and action.
This article covers the methodology for variance analysis, how to set materiality thresholds, and how to present the report in a way that drives board action rather than just reporting numbers.
The Purpose of Variance Analysis
A variance report is not a scorekeeping exercise. It is an early warning system. When expenses are running significantly higher than budget in a program that is also producing lower-than-expected revenue, the organization needs to know in March — not October.
Variance analysis serves three purposes:
Operational accountability: Program managers and department heads are accountable to their budgets. A monthly variance report creates the visibility that makes that accountability meaningful.
Decision support: When the development team sees that individual giving is tracking 15% below budget in Q2, leadership can decide whether to increase activity, revise the year-end projection, or implement expense controls. Without the variance report, the decision is made by instinct.
Board governance: The board is responsible for financial oversight. A variance report — with narrative explanation — gives board members the information they need to discharge that responsibility without requiring them to interpret raw financial statements.
The Structure of a Variance Report
A complete variance report contains six columns for each line item:
| Column | Description |
|---|---|
| Annual Budget | The approved annual budget for this line |
| Budget YTD | Pro-rated budget through the current period |
| Actual YTD | Actual results through the current period |
| Dollar Variance | Actual minus Budget YTD |
| Percent Variance | Dollar Variance divided by Budget YTD |
| Projected Year-End | Revised full-year projection based on current trajectory |
Revenue lines: Favorable means actual exceeds budget (more revenue than planned). Unfavorable means actual falls short.
Expense lines: Favorable means actual is below budget (less spent than planned). Unfavorable means actual exceeds budget.
The projected year-end column is optional but powerful. Rather than just showing what happened, it tells the board what is likely to happen — enabling corrective action while there is still time.
Setting Materiality Thresholds
Not every variance warrants investigation. Applying finite management attention to immaterial fluctuations is inefficient. Materiality thresholds define which variances require explanation and which can be noted without action.
A common threshold structure: investigate variances that exceed both a dollar threshold and a percentage threshold.
Example: investigate any line with a variance greater than $5,000 and greater than 10%.
This dual-threshold approach prevents two failure modes:
- A $50,000 budget line with a $4,999 variance (9.9%) — significant in absolute terms — passes through unexamined on a percentage-only screen.
- A $500 budget line with a $300 variance (60%) — immaterial in absolute terms — triggers unnecessary analysis on a percentage-only screen.
Thresholds should be calibrated to organizational size. A $10 million organization uses different thresholds than a $500,000 organization. Review and adjust annually.
Budget YTD: Prorating the Annual Budget
The Budget YTD column should reflect the portion of the annual budget expected to be earned or spent through the current month — not simply the annual total divided by 12.
Many revenue and expense lines are not perfectly linear. Giving is seasonal, with a large proportion arriving in Q4 for most organizations. Some grant revenue is back-loaded due to reimbursement timing. Some program expenses are front-loaded due to hiring or supply purchases at the start of the year.
If you use a straight-line proration when the budget is seasonal, you will show consistent "unfavorable" variances through Q3 (when giving has not yet arrived) and consistent "favorable" variances in Q4 (when everything comes in). This pattern makes the variance report misleading for most of the year.
Better approach: enter monthly budget targets by line item at the beginning of the year, reflecting the expected seasonality of each item. This makes the Budget YTD column meaningful at any point in the year.
Narrative Variance Commentary
Numbers without narrative are insufficient for board reporting. For every material variance, the report should include a brief explanation:
- What caused the variance
- Whether it is temporary (timing) or structural (the budget assumption was wrong)
- What action, if any, management is taking
- Whether the projected year-end needs revision
Examples of narrative commentary:
Individual Giving — Unfavorable ($42,000, -18%): Year-end appeal campaign was mailed two weeks later than planned due to designer availability. Revenue is expected to normalize by month-end. Annual projection unchanged.
Program Salaries — Favorable ($28,000, +12%): Program Director position remained unfilled for six weeks longer than budgeted due to an extended search. Position filled as of March 15. Q2 expense will increase accordingly; full-year projection revised to ($15,000) favorable.
Government Contracts — Favorable ($0, 0%): City contract renewal delayed 60 days from budget assumptions. Revenue will be recognized in Q2; annual total unchanged.
This level of explanation lets board members read the report and understand organizational performance without requiring a 20-minute verbal briefing for each line.
Variance Report Frequency
Monthly: Management review of all material variances, with narrative commentary. Controller or CFO should distribute within 10-15 business days of month-end.
Quarterly: Board presentation with summarized variances, narrative explanations for material items, and updated year-end projections. This is typically part of the Finance Committee or full board meeting.
As-needed: Grant-specific budget vs. actual reports should be prepared whenever a grant report is due, when spending is approaching the grant ceiling, or when a deadline is approaching with significant unspent balance.
Multi-Fund Variance Reporting
For organizations managing multiple restricted grants, a consolidated variance report is necessary but insufficient. Each grant needs its own budget vs. actual analysis, because grant budgets are legal documents — the organization must spend within approved budget categories and cannot overspend or underspend material amounts without funder notification.
A grant-level variance report shows: the approved grant budget by category, actual spending to date by category, the remaining balance, and the remaining grant period. This is the report a program manager and a grants administrator need to manage grant compliance.
The consolidated organizational variance report shows the overall picture. The grant-level reports show the compliance-critical detail. A nonprofit managing 15 grants needs both.
The Efficiency Gap: Spreadsheet Assembly at Month-End
The most common variance reporting workflow in nonprofits without purpose-built software: export actuals from QuickBooks, paste them next to last month's budget spreadsheet, update the formulas, write the narrative in a separate document, combine everything into a PDF for the board, discover that someone updated the budget spreadsheet this morning and now the version you exported does not match, start over.
This process takes two to three days in most organizations. It produces a report that is accurate as of the date of the export — not as of the date the board reviews it. And because it lives in a spreadsheet, there is no audit trail, no version history, and no guarantee that next month's budget column reflects the correct figures.
The budget management module in sherbertOSOS stores annual budgets by fund, program, and category directly in the accounting system. Variance calculations update in real time as transactions post. The budget vs. actual report is not a spreadsheet — it is a live view of the ledger, available to any authorized user at any time. No assembly required.
For the cash flow dimension of financial monitoring, see Cash Flow Management for Nonprofits: Forecasting by Fund. For the grant-level monitoring that complements organizational variance reporting, see the grant management resources.
Frequently Asked Questions
What is a material variance threshold?
Most organizations investigate variances exceeding both a dollar amount (commonly $5,000) and a percentage (commonly 10%). Adjust thresholds based on budget size — a $10 million organization uses larger dollar thresholds than a $500,000 organization. Dual thresholds prevent both over- and under-investigation.
How often should variance reports be prepared?
Monthly for management review. Quarterly for board reporting. More frequently for restricted grants with spending deadlines or budget compliance requirements.
What is the difference between a favorable and unfavorable variance?
For revenue: favorable means actual exceeds budget. For expenses: favorable means actual is below budget. But context matters — an organization that is significantly under-spending on programs may be failing to deliver on its mission, which is unfavorable even if the accounting variance is labeled favorable.
What should go in the narrative commentary?
The cause of the variance, whether it is temporary (timing) or structural (budget assumption was wrong), any corrective action being taken, and whether the year-end projection needs revision. Keep commentary concise — two to three sentences per material item.
The Bottom Line
A budget vs. actual variance report is only useful if it is current, accurate, and accompanied by narrative that helps decision-makers understand what the numbers mean. A report produced two weeks after month-end, assembled from an export, and presented without explanation does not enable action — it just creates a record that no one reads closely.
The investment in a reporting process that is automated, timely, and narrative-equipped pays dividends in board engagement, management accountability, and the ability to course-correct before small variances become large problems.
→ Start your free trial and see real-time budget vs. actual variance reporting in sherbertOSOS.
Frequently Asked Questions
What is a material variance threshold?
Most organizations investigate variances exceeding 10% AND $5,000. Adjust thresholds based on your budget size — a $50M organization uses different thresholds than a $500K one.
How often should variance reports be prepared?
Monthly for management review. Quarterly summaries for the board. More frequent monitoring for restricted grants with spending deadlines.
What's the difference between a favorable and unfavorable variance?
Favorable means actuals are better than budget (more revenue or less expense). Unfavorable means the opposite. But context matters — under-spending on programs might be unfavorable if it means you're not delivering on mission.
Related Articles
Try sherbertOS free
See how sherbertOS simplifies your nonprofit operations.