FP Academy · INSIGHTS

How to calculate a budget variance in Excel

Calculate the difference between budget and actual in DKK and percent, then explain what the sign means.

Mohammad Amar · Founder & Owner · 08.10.2026

A budget variance measures the difference between a plan and the actual outcome. The arithmetic is straightforward. Interpretation depends on what the item represents.

Choose a definition

Here, variance means actual minus budget. State the convention and use it consistently. A fictional company budgets DKK 100,000 for wages and spends DKK 110,000. Its variance is 110,000 − 100,000 = DKK 10,000.

Calculate the amount

Put budget in B2 and actual in C2. In D2 enter =C2-B2. The result is 10,000. Apply a number or currency format so the amount is easy to read.

Calculate the percentage

In E2 enter =D2/B2 and format the cell as a percentage. The result is 10%. The percentage format already scales the display by 100.

If the budget is zero, the percentage is undefined. In English-language Excel, use this formula to flag it:

=IF(B2=0,"Not calculable",D2/B2)

Show the DKK variance and explain the circumstances separately.

Interpret the sign

A positive cost variance under this convention means spending exceeded budget. A positive revenue variance means income exceeded budget. Higher spending may reflect additional activity that also generated income. Assess the cause before judging performance.

Add a brief explanation

FP Academy teaches budget variance analysis as part of a practical Excel review. The aim is to calculate the difference and explain it in terms the reader can use. The figures are fictional and use the convention stated above.