Percentage Over Budget Calculator: Formula and Examples

A percentage over budget calculator shows how much actual spending exceeds a planned budget, expressed as a percentage of that budget. Enter your budget and actual spending to get the over-budget amount and percentage; if spending is at or below budget, the percentage over budget is zero.

Formula

The percentage over budget is the amount above the budget divided by the budget, multiplied by 100. Negative differences are treated as zero because spending below budget is an underspend, not a negative over-budget percentage.

• B = planned budget, in dollars.
• A = actual spending, in dollars.
• O = amount over budget, in dollars: max(0, A − B).
• P = percentage over budget, in percent: max(0, (A − B) ÷ B × 100).

The budget must be greater than zero: a percentage relative to a zero budget is undefined. The calculator therefore sets a minimum budget input of $0.01. It accepts actual spending of zero or more and assumes both figures use the same currency and cover the same period and scope.

Worked Example

Using the calculator’s default values, the budget is $1,000 and actual spending is $1,200.

1. Subtract the budget from actual spending: $1,200 − $1,000 = $200 over budget.
2. Divide the overage by the budget: $200 ÷ $1,000 = 0.2.
3. Convert the ratio to a percentage: 0.2 × 100 = 20%.

The result is 20.00% over budget, with an over-budget amount of $200.00. The percentage uses the original budget as its denominator, not actual spending.

What the Percentage Means

A result of 20% means spending exceeded the budget by an amount equal to one-fifth of the budget. It does not mean the total spending was 20% of the budget. In this example, total spending is 120% of the budget: the original 100% plus the 20% overage.

That distinction matters when reading budget reports. “Percentage over budget” measures the excess relative to the planned amount. “Actual spending as a percentage of budget” is a different calculation: actual spending divided by budget, multiplied by 100. With the example figures, that second measure is 120%.

If actual spending is less than or equal to the budget, this calculator reports 0% over budget and $0 over budget. It does not show how far below budget the spending is. For that, subtract actual spending from the budget and divide by the budget to calculate the percentage under budget.

When to Use the Calculator

This calculation is useful whenever a planned amount can be compared with a corresponding actual amount. Examples include tracking a household category, a project cost, a department allocation, or a trip budget. It can help summarize the size of a variance, but it does not explain why the variance occurred.

• Compare like with like: the same category, time period, and included costs.
• Use the approved or planned budget as the baseline, rather than a revised figure, unless the revised budget is the comparison you intend.
• For several categories, calculate each percentage separately. A total percentage should generally be based on total actual spending and total budget, not a simple average of category percentages.
• Keep the dollar overage alongside the percentage. A small budget can produce a large percentage from a modest dollar difference.

Common Problems and Misconceptions

Using the wrong denominator: The overage is divided by the budget, not by actual spending. Dividing $200 by $1,200 would give about 16.67%, but that answers a different question: the overage as a share of actual spending.

Comparing different scopes: A budget for materials alone cannot be fairly compared with actual costs that also include labor, taxes, or delivery. Similarly, a monthly budget should not be compared with spending across a different number of days without adjusting the period.

Confusing a percentage with percentage points: A budget variance of 20% is a relative difference, not a 20-percentage-point change in some other rate. Percentage points describe the subtraction of two percentages; this calculator compares dollar amounts.

Rounding too early: Keep the full dollar inputs through the calculation and round the displayed result at the end. The calculator shows percentages and overages to two decimal places, but rounded values may not reproduce every intermediate calculation exactly.

Trying to use a zero budget: There is no meaningful percentage increase relative to zero. If a category had no budget but incurred spending, report the actual dollar amount and explain that the percentage comparison is undefined rather than presenting a finite percentage.

Limits and Useful Alternatives

A percentage alone is not a forecast, diagnosis, or explanation. It does not distinguish a one-time cost from recurring spending, account for timing, or establish whether a budget should be changed. Those questions require information about the underlying plan and transactions.

To measure an underspend instead, use (budget − actual spending) ÷ budget × 100 when actual spending is below budget. To measure actual spending as a share of the budget, use actual spending ÷ budget × 100. To compare total performance across categories with very different budget sizes, add the budgets and actual amounts first, then calculate the overall variance from those totals.

Frequently Asked Questions

How do I calculate the percentage over budget?
Subtract the budget from actual spending, divide the positive overage by the budget, and multiply by 100. If actual spending is at or below budget, the over-budget percentage is zero.

What is 20% over a $1,000 budget?
Twenty percent of $1,000 is $200, so spending 20% over that budget is $1,200 in total.

Can the percentage over budget be negative?
Under the usual definition, no. A negative difference indicates spending was below budget; report that separately as an underspend rather than a negative over-budget percentage.

What if there was no budget?
A percentage over budget cannot be calculated against a zero budget because division by zero is undefined. State the actual spending amount and identify the missing budget baseline.

Should I average percentages from several budget categories?
Usually not for an overall variance. Add the category budgets and actual spending, then compare the totals. A simple average gives equal weight to categories even when their budgets differ substantially.

Related

• Budget Calculator: Plan Monthly Income and Spending
• Budget Balance Calculator: Income Minus Expenses
• Budget Calculator Based on Income: Plan Monthly Spending

in b | Budget | $ | 1000 | 0.01 | 100000000
in a | Actual spending | $ | 1200 | 0 | 100000000
out pct | Percentage over budget | % | max(0, (a - b) / b * 100) | 2
out amt | Amount over budget | $ | max(0, a - b) | 2