Budgeting template
Project Budget Template
Keep a project on budget. See planned and actual cost per task, the difference and how much of the budget is used.
Starts with 25 free credits. No card needed.
What's inside
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Task | Planned | Actual | Variance | % used |
| 2 | Design | 40,000 | 38,000 | =B2-C2 | =C2/B2 |
| 3 | Development | 120,000 | 131,000 | =B3-C3 | =C3/B3 |
| 4 | Total | =SUM(B2:B10) | =SUM(C2:C10) | =B11-C11 | =C11/B11 |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
D2 =B2-C2
Positive means under budget, negative means over.
E11 =C11/B11
Share of the total budget used.
Make it yours by asking
Try a request like this in Tabstra:
"Create a project budget with tasks, planned cost, actual cost, variance and percent of budget used"