Rex says
Money math without the spreadsheet headache. Plug in your numbers and I'll show you exactly where the dollars land.
Try a scenario
Click to load — tweak from there.Inputs
Result
Variance percentage
-7.6%
Variance dollars
-$38,000
Exceeds materiality threshold (1=yes)
0
Favorable variance (1=yes)
0
Psst — share this and help Rex grow
One click, a permanent link with your numbers baked in.
How to use this
- 1Enter budgeted amount ($).
- 2Enter actual amount ($).
- 3Enter line type.
- 4Enter materiality threshold (%).
- 5Read your variance percentage on the right — it updates as you type.
- 6Hit Share to keep the scenario or send it to someone.
About this calculator
Board finance committees review budget-to-actual reports every meeting, but raw dollar variances without a percentage and a materiality threshold make it hard to tell a $3,000 miss on a small program line from a $3,000 miss on a major revenue category that actually matters. This calculator takes a budgeted amount and actual amount for revenue or expense lines, computes the dollar variance and percentage variance, and flags whether it crosses a materiality threshold you set, typically 10% or a fixed dollar amount, whichever is more meaningful for a given line, since a 10% variance on a $2,000 line item usually isn't worth board discussion time while a 5% variance on a $500,000 revenue line absolutely is.
Worked example
Using the values the calculator loads with:
Inputs
- Budgeted amount: 500000 $
- Actual amount: 462000 $
- Line type: Revenue line
- Materiality threshold: 10 %
Results
- Variance percentage: -7.6%
- Variance dollars: -$38,000
- Exceeds materiality threshold (1=yes): 0
- Favorable variance (1=yes): 0
What each field means
Inputs
- Budgeted amount ($)
- The budgeted amount used in the calculation, measured in $. Starts at 500000 $ so you have a working example on load.
- Actual amount ($)
- The actual amount used in the calculation, measured in $. Starts at 462000 $ so you have a working example on load.
- Line type
- Pick the option that matches your situation — the maths changes per option. Choices: Revenue line, Expense line.
- Materiality threshold (%)
- The materiality threshold used in the calculation, measured in %. Starts at 10 % so you have a working example on load. Accepted range: 1–50 %.
Results
- Variance percentage
- Returned as a percentage and shown as the headline result. It recalculates instantly whenever you change an input, so you can compare scenarios without reloading.
- Variance dollars
- Returned as a money amount in US dollars. It recalculates instantly whenever you change an input, so you can compare scenarios without reloading.
- Exceeds materiality threshold (1=yes)
- Returned as a whole number. It recalculates instantly whenever you change an input, so you can compare scenarios without reloading.
- Favorable variance (1=yes)
- Returned as a whole number. It recalculates instantly whenever you change an input, so you can compare scenarios without reloading.
FAQ
What materiality threshold should a board use?
Many finance committees use a dual test: flag anything over 10% variance AND anything over a fixed dollar threshold (often $5,000-25,000 depending on budget size), whichever triggers first, so both small-dollar-but-high-percentage misses and large-dollar-but-low-percentage misses both get surfaced.
Is a favorable revenue variance always good news?
Not automatically. Revenue coming in over budget from a one-time bequest is good news but not repeatable, and shouldn't be used to justify ongoing spending increases. Distinguish one-time favorable variances from sustainable, structural ones before changing spending plans.
How often should variance reports go to the board?
Quarterly at minimum, monthly for organizations with tight cash positions or heavy reliance on unpredictable revenue like events and major gifts. Waiting until year-end to discover a 20% revenue shortfall eliminates any chance to course-correct mid-year.
What's the difference between a variance and a forecast reforecast?
Variance analysis looks backward at what already happened versus what was planned. A reforecast looks forward, using variance trends to update your expectation for the rest of the year, for example if grant revenue is consistently 15% behind budget through Q2, your reforecast should reflect that trend continuing, not assume a sudden catch-up.
Accuracy and limitations
- Results are estimates before tax, fees, and inflation unless an input explicitly covers them.
- Rates are treated as fixed for the whole period — variable-rate products will drift from this projection.
- This is educational maths, not financial advice. Check anything contractual with the lender or your accountant.
Related tools
Cite this calculator
Writing about this topic? Grab a citation — every link helps keep these tools free.
RevenueLab. (2026). Nonprofit Budget Variance Calculator. Retrieved from https://www.revenuelab.fyi/toolbox/budget-variance-nonprofit
<p>Source: <a href="https://www.revenuelab.fyi/toolbox/budget-variance-nonprofit" target="_blank" rel="noopener">Nonprofit Budget Variance Calculator — RevenueLab</a> (2026).</p>
Source: [Nonprofit Budget Variance Calculator — RevenueLab](https://www.revenuelab.fyi/toolbox/budget-variance-nonprofit) (2026).