Request a walkthroughStart free
All public tools

Public municipal finance tools

Municipal Budget Variance Calculator

Compare budget and actual by line item, separate revenue from expenditure signals, and identify the largest variances to investigate.

No account required. Start with an editable sample.

Reviewed · Editorial responsibility: Aurelius Civic

Inputs

Compare budget and actual for the same reporting period and accounting basis. Amounts are displayed in USD.

Required, up to 80 characters. This label does not change or seasonalize the calculation.

Optional, from 0 to 1200. Leave blank to disable this threshold.

Optional, from 0 to 1 trillion. Leave blank to disable this threshold.

Material when absolute variance strictly exceeds either enabled threshold (OR rule). Equality is not material. A zero budget has no percentage test; the dollar test still applies. Both thresholds blank means materiality screening is off.

Line items

Signed amounts from −1 trillion to 1 trillion are supported for corrections or contra entries. Keep signs and accounting treatment consistent. Labels are required and may contain up to 100 characters. Maximum 50 rows.

Line item 1

Use a single-line label. Labels stay in the browser.

Revenue and expenditure signs have opposite interpretations.

Signed amount for this reporting period.

Signed amount for this reporting period.

Line item 2

Use a single-line label. Labels stay in the browser.

Revenue and expenditure signs have opposite interpretations.

Signed amount for this reporting period.

Signed amount for this reporting period.

Line item 3

Use a single-line label. Labels stay in the browser.

Revenue and expenditure signs have opposite interpretations.

Signed amount for this reporting period.

Signed amount for this reporting period.

Browser-only calculations. Entered financial values and labels stay on this page while it is open. They are not saved, sent to our servers, included in analytics, or added to the URL. Reset restores the sample.

Results

Sample reporting period

3 investigation candidates

Candidates exceed at least one enabled threshold.

Group totals

Revenue totals

2 line items · unfavorable

Budget
$5,400,000.00
Actual
$5,170,000.00
Raw variance
-$230,000.00
Variance percentage
-4.26%

Expenditure totals

1 line items · unfavorable

Budget
$3,100,000.00
Actual
$3,240,000.00
Raw variance
$140,000.00
Variance percentage
4.52%

Ranked line items

Largest absolute dollar variance first. Equal impacts keep input order. Favorable and unfavorable items are both screened.

  1. Property taxes

    Revenue · unfavorable · Material — investigate

    Raw variance (actual − budget)
    -$150,000.00
    Variance percentage
    -3.13%

    Exceeded: dollar threshold.

  2. Public safety

    Expenditure · unfavorable · Material — investigate

    Raw variance (actual − budget)
    $140,000.00
    Variance percentage
    4.52%

    Exceeded: dollar threshold.

  3. Building permits

    Revenue · unfavorable · Material — investigate

    Raw variance (actual − budget)
    -$80,000.00
    Variance percentage
    -13.33%

    Exceeded: percentage and dollar thresholds.

Questions to investigate

  • Timing: are collections, invoices, accruals, or reimbursements shifted between periods?
  • Volume/rate: did activity levels, demand, prices, tax rates, or fee rates change?
  • Recurring/one-time: is this a repeatable pattern or an unusual receipt or cost?
  • Baseline change: have assumptions, accounting treatment, or the budget changed?
  • Service-level effect: does the variance reflect changed services, deferred work, or unmet needs?

Favorable does not necessarily mean desirable. Unfavorable does not establish a root cause. These prompts suggest questions, not diagnoses.

Methodology

Enter budget and actual amounts for the same reporting period, fund, and accounting basis. The reporting period label is descriptive: this calculator does not prorate an annual budget, seasonalize amounts, or infer elapsed time. Add, remove, or reorder up to 50 line items directly; no upload is needed.

Formulas and direction

  • Raw variance = actual − budget.
  • Variance percentage = raw variance ÷ absolute budget × 100.
  • Revenue: a positive raw variance is favorable; a negative variance is unfavorable.
  • Expenditure: a negative raw variance is favorable; a positive variance is unfavorable.
  • A zero variance is neutral. A zero budget has no meaningful percentage; dollar variance remains available.

Materiality and ranking

A line is material when its absolute percentage variance strictly exceeds the enabled percentage threshold OR its absolute dollar variance strictly exceeds the enabled dollar threshold. Equality is not material. Leave either threshold blank to disable that test; leave both blank to turn screening off. With a zero budget, only the dollar threshold can trigger materiality. A tiny floating point tolerance prevents arithmetic roundoff from treating equality as an exceedance.

Both favorable and unfavorable lines may be material. All lines are ranked by absolute dollar variance, largest first; material lines are marked as investigation candidates. Equal dollar impacts keep their input order. Revenue and expenditure totals are shown separately; offsetting line variances can hide large individual drivers. Group percentages use the absolute summed budget, not an average of row percentages, and are not meaningful when the summed budget is zero.

Worked example

The sample compares property taxes (revenue, USD 4,800,000 budget and USD 4,650,000 actual), public safety (expenditure, USD 3,100,000 budget and USD 3,240,000 actual), and building permits (revenue, USD 600,000 budget and USD 520,000 actual). Thresholds are 5% and USD 50,000; the reporting label is “Sample reporting period”.

Property taxes are USD −150,000 (−3.13%), public safety USD +140,000 (+4.52%), and building permits USD −80,000 (−13.33%). All are unfavorable and material under the dollar test; permits also exceed the percentage test. Investigation ranking is property taxes, public safety, then building permits. Revenue totals are USD 5,400,000 budget and USD 5,170,000 actual (USD −230,000); expenditure totals are USD 3,100,000 budget and USD 3,240,000 actual (USD +140,000).

Input and precision policy

Signed budget and actual amounts from −1 trillion to 1 trillion are supported for corrections or contra entries. Use consistent signs and accounting treatment; direction always follows the formulas above, including with a negative budget. Nonfinite or unsupported numbers are rejected. Required line-item labels allow up to 100 characters and the reporting period up to 80, without control characters. Percentage thresholds range from 0 to 1200 and dollar thresholds from 0 to 1 trillion.

Results update as inputs change. Money and percentages display two decimal places; calculations and materiality use unrounded values. Reset and Load sample restore the exact three sample rows, their order, the period label, and both thresholds. Reload also opens the sample.

Sources and further reading

GFOA: Budget Monitoring describes comparing budget and actual results as part of financial performance monitoring. The formulas and threshold rule here are this tool’s explicit conventions.

Municipal budget variance reports provides additional municipal reporting context.

Limitations

Favorable does not necessarily mean desirable: spending below budget may reflect delayed work or unmet service needs. Unfavorable does not establish a root cause. The timing, volume/rate, recurring/one-time, baseline-change, and service-level prompts are questions to investigate, not diagnoses.

This calculation does not model seasonality, commitments, encumbrances, cash flow, forecast-to-year-end results, or statutory appropriation limits. Your reporting basis, budget amendments, local policy, and service priorities affect interpretation. Signed and offsetting entries can make aggregate percentages difficult to interpret. Materiality thresholds are user-selected screening tools, not a legal or accounting determination.