Budgeting template
Budget vs Actual Template (Variance Report)
See where you're over or under budget. Variance is shown in money and percent for every line.
Guide: Budget vs actual report with variance formulas
Opening a template uses no credits.
What's inside
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Category | Budget | Actual | Variance | Variance % |
| 2 | Sales | 500,000 | 538,000 | =C2-B2 | =D2/B2 |
| 3 | Salaries | -220,000 | -226,000 | =C3-B3 | =D3/ABS(B3) |
| 4 | Marketing | -40,000 | -36,500 | =C4-B4 | =D4/ABS(B4) |
| 5 | Result | =SUM(B2:B4) | =SUM(C2:C4) | =C5-B5 | =D5/ABS(B5) |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
D2 =C2-B2
Positive variance is better than budget.
E3 =D3/ABS(B3)
ABS keeps the sign meaningful for cost lines.
Make it yours by asking
Try a request like this in Tabstra:
"Create a budget vs actual report with categories, budget, actual, variance and variance percent, with totals"