BUDGET & VARIANCE · FREE FP&A CALCULATOR

Know what changed. Then ask why.

I’ve seen plenty of variance reports where every positive number is green. Unfortunately, expenses don’t work that way. Let’s check what the numbers actually mean.

← All FP&A calculators

RUN THE NUMBERS

Budget vs. Actual Variance

Enter a budget and actual result. Choose whether the line represents revenue or an expense so favorable and unfavorable results are classified correctly.

Actual minus budget
Variance %
Operating profit impact

Method: variance = actual − budget; variance % = variance ÷ |budget| × 100. Expense variances reverse the favorable/unfavorable interpretation. Operating-profit impact assumes all revenue or expense changes flow through to operating profit, with no offsetting costs or other effects. A zero budget has no meaningful percentage variance. Results are illustrative and stay in your browser.

Advanced variance review (optional)

Actual vs. latest forecast:

Materiality review:

Download your scenario

Export the current inputs and results. For PDF, select “Save as PDF” in the print dialog.

All calculator inputs, advanced options, and export buttons are available on mobile. For the best download and printing experience, use a desktop browser. Mobile downloads and printing depend on your browser.

Email results to someone

Share a formatted summary and CSV attachment. Sender verification is required before delivery.

The form is a preview while secure sender verification and SMTP delivery are being configured. No information is sent or saved.

HOW TO USE THE RESULT

A variance is a starting point, not a conclusion.

Revenue above budget is generally favorable. Expense above budget is generally unfavorable. The sign alone doesn't tell you which one you're looking at.

Dollar variance equals actual minus budget. Percentage variance divides that difference by the absolute value of budget. A zero budget has no meaningful percentage variance.

Sarah's note: An underspend might mean a delayed project. A revenue beat might arrive with higher costs. Investigate the driver before celebrating the spreadsheet.

NEXT TOOL: Break-Even Analysis →

Numbers are only half the conversation.

Need help translating the result into a decision your business can actually use?

TALK WITH SARAH →