Percent Variance Calculator
Calculate percent variance between two numbers instantly. Enter an original (expected) value and a new (actual) value to see the variance percentage, absolute difference, and direction of change. Ideal for budget analysis, price tracking, and performance reviews.
Format: original, new (one pair per line, comma-separated)
How Percent Variance Calculator Works
A percent variance calculator is a free, browser-based tool that compares a budgeted or expected value against an actual result and returns the percentage difference between them. It applies the formula ((New − Original) ÷ |Original|) × 100 in one click, flags the variance as favorable or unfavorable, and can process an entire budget line-item list at once in Batch Mode.
How to Calculate Percent Variance
Percent variance measures the relative difference between an expected (original) value and an actual (new) value, expressed as a percentage. It answers the question: how far off is my actual result from what I planned or expected? The formula is straightforward:
Percent Variance Formula
Percent Variance = ((New Value - Original Value) / |Original Value|) x 100
For example, if your budget was $10,000 but you spent $11,500, the percent variance is ((11500 - 10000) / 10000) x 100 = +15%. A positive result means you exceeded the original value (overspent), while a negative result means you came in under (saved money). The absolute value in the denominator ensures the formula works correctly even when the original value is negative.
Percent Variance vs Percent Change
While percent variance and percent change use the same formula, they serve different analytical purposes. Percent change focuses on how a value has evolved over time, such as a stock price moving from $50 to $65, representing a 30% increase. Percent variance is typically used in planning and budgeting contexts where you compare an expected figure against an actual outcome. The terminology matters in professional settings: accountants and financial analysts use "variance" when comparing budgets to actuals, while economists and data scientists use "change" when tracking trends. In both cases, the math is identical, but the framing helps communicate the right context to your audience.
Budget Variance Analysis
Budget variance analysis is a cornerstone of financial management. Organizations use it to monitor spending, assess department performance, and make informed decisions about resource allocation. A favorable variance means actual results beat expectations, such as spending less than budgeted or earning more revenue than projected. An unfavorable variance signals that actual results fell short. Most businesses consider a variance within 5% acceptable, while anything beyond 10% triggers a detailed review. Regular variance analysis helps identify trends early, allowing managers to correct course before small deviations become major problems. This calculator handles both positive and negative variances, giving you the complete picture instantly.
Common Percent Variance Examples
Percent variance applies across many real-world scenarios. In retail, a store budgeted $50,000 in monthly sales but achieved $47,000, a variance of -6%, prompting a review of marketing strategies. In manufacturing, a production line expected to produce 1,000 units but made 1,080, a favorable variance of +8% indicating improved efficiency. In personal finance, if you budgeted $400 for groceries but spent $450, that is a +12.5% variance. Project managers track hours: if a task was estimated at 40 hours but took 52, the 30% overrun signals a need for better estimation. Understanding these variances helps you make data-driven decisions rather than relying on gut feelings.
Percent Variance Calculator for 2026 Budget Planning
A percent variance calculator is the fastest way to compare your 2026 budgeted figures against actual results without opening a spreadsheet. Enter the budgeted (original) value and the actual (new) value above to see the variance, the absolute difference, and whether the change is favorable or unfavorable. The U.S. Government Accountability Office defines budget variance analysis as the comparison of planned versus actual financial outcomes used to evaluate program performance and identify deviations early (GAO Budget Glossary). Most public-sector reporting standards flag variances above 10% for explanatory notes. This tool runs entirely in your browser — no spreadsheet, no sign-up, and no data ever leaves your device.
Material Percent Variance Thresholds: What Auditors Flag
External auditors, financial controllers, and regulators do not investigate every variance — they focus on material ones. Under the PCAOB's Auditing Standard AS 2810 on evaluating audit results, materiality for public companies is typically 5% of pre-tax income or 0.5–1% of revenue, whichever is smaller. Practical thresholds most finance teams use with this percent variance calculator: under 3% = ignore (measurement noise), 3–5% = one-line note in monthly close, 5–10% = department explanation required, >10% = variance is material — root-cause analysis, corrective action, and potential re-forecast. Per the PCAOB AS 2810, a variance can be quantitatively immaterial (say 4%) but still qualitatively material if it hides a fraud pattern, misses a covenant, or crosses a segment reporting threshold. That is why the "favorable/unfavorable" label from this tool is only step one — always ask: does this variance flip a decision?
Percent Variance Formula in Excel and Google Sheets
If you need the same calculation inside a spreadsheet, the direct formula is =(B2-A2)/ABS(A2) with the cell formatted as a percentage, where A2 holds the budgeted value and B2 the actual. Wrap it to avoid the divide-by-zero error that breaks most budget templates: =IFERROR((B2-A2)/ABS(A2),"n/a"). Do not use =(B2-A2)/A2 — without ABS(), a negative budgeted figure (a credit line, a contra-revenue account, a planned loss) flips the sign and reports an overspend as a saving. Microsoft documents IFERROR as the supported way to trap the #DIV/0! result rather than suppressing it with conditional formatting (Microsoft 365 IFERROR reference). The Batch Mode panel above accepts pasted spreadsheet columns directly, so you can check a whole 2026 close without writing the formula at all. Updated 2026-08-02.
Frequently Asked Questions
What is percent variance?
Percent variance is a measure that expresses the difference between an expected (original) value and an actual (new) value as a percentage of the original value. It is widely used in budgeting, financial analysis, and performance tracking to quantify how far actual results deviate from plans.
How do you calculate variance between two numbers?
Use the formula: Percent Variance = ((New Value - Original Value) / |Original Value|) x 100. Subtract the original from the new value, divide by the absolute value of the original, then multiply by 100 to get the percentage.
What is the difference between percent variance and percent change?
The mathematical formula is the same, but they serve different purposes. Percent change describes how a value evolves over time (e.g., price went up 10%). Percent variance compares a planned or expected value against an actual result (e.g., spending was 10% over budget). The context and terminology differ in professional settings.
What is a good budget variance percentage?
Most organizations consider a variance within 1-5% acceptable for well-managed budgets. Variances between 5-10% may require explanation, while anything over 10% typically triggers a detailed review. The acceptable range depends on your industry and the specific budget category.
Can percent variance be negative?
Yes. A negative percent variance means the new or actual value is less than the original or expected value. In budgeting, a negative expense variance means you spent less than planned (favorable), while a negative revenue variance means you earned less than expected (unfavorable).
How is variance used in business?
Businesses use variance analysis to compare budgets vs actuals, track sales performance against targets, monitor production efficiency, evaluate employee KPIs, and assess project timelines. Regular variance reporting helps identify problems early and supports data-driven decision making across all departments.
What is a percent variance calculator?
A percent variance calculator is a tool that compares two numbers — typically a budgeted or expected value against an actual result — and outputs the percentage difference between them. It instantly applies the formula ((New - Original) / |Original|) x 100 so you can quantify deviations without manually working out the math. This tool runs entirely in your browser, so the values you enter are never sent to a server.
How do I calculate a 2026 budget variance for a department?
Take the 2026 budgeted amount (original value) and the actual amount spent or earned (new value), then divide their difference by the absolute value of the original and multiply by 100. The calculator above handles all three steps and shows whether the variance is favorable (under budget on expenses, over target on revenue) or unfavorable. For multi-line department reports, use the Batch Mode panel to paste all line items at once.
What percent variance is considered material for audit purposes?
Public-company auditors typically set materiality at 5% of pre-tax income or 0.5–1% of revenue (whichever is smaller) per PCAOB AS 2810. Practical thresholds most finance teams use with this percent variance calculator: under 3% = ignore, 3–5% = one-line note, 5–10% = department explanation required, over 10% = material, root-cause analysis needed. A variance can be quantitatively immaterial (say 4%) but still qualitatively material if it hides fraud, misses a debt covenant, or crosses a segment reporting threshold.
How is percent variance different for cost variance in project management?
In earned value project management (EVM), Cost Variance (CV) = Earned Value − Actual Cost, and Cost Variance Percent (CV%) = CV / EV × 100. So CV% is technically a percent variance where "original" is EV (what you should have spent to reach current progress) and "actual" is AC (what you actually spent). A negative CV% means over budget for work completed. The Project Management Institute PMBOK considers CV% under −10% a red-flag signal that the project needs re-baselining, not just monitoring.
What is the percent variance formula in Excel?
Use =(B2-A2)/ABS(A2) and format the cell as a percentage, where A2 is the budgeted (original) value and B2 is the actual (new) value. Wrap it as =IFERROR((B2-A2)/ABS(A2),"n/a") so a zero budget line does not return #DIV/0!. Always keep ABS() in the denominator — the plain =(B2-A2)/A2 version reports an overspend as a saving whenever the budgeted figure is negative.
Why does my percent variance show the wrong sign?
Two causes. First, a negative original value without ABS() in the denominator flips the sign — this calculator always uses the absolute value, so it stays correct. Second, sign and favorability are not the same thing: on an expense line a positive variance is unfavorable (you overspent), but on a revenue or production line a positive variance is favorable (you beat target). Pick the matching tab above and the tool labels the direction for you.