BUSINESS SPREADSHEETS
Project budget template.
An editable project budget spreadsheet with cost categories, planned and actual costs, variance formulas and an optional contingency calculation.
See the completed example ↓WHEN TO USE IT
A clearer next step.
Use this before a project starts, then update the actual-cost column as work progresses. Keeping scope and costs together helps identify where assumptions changed.
SEE IT IN CONTEXT
A completed example.
EXAMPLE WORKBOOK · USD
| Category | Cost item | Planned | Actual | Remaining |
|---|---|---|---|---|
| Design | Design and production | 1800 | 1950 | -150 |
| Development | Website build | 2400 | 2100 | 300 |
| Content | Copy and illustrations | 800 | 600 | 200 |
The download includes Instructions, Summary and Entries sheets, with 200 prepared rows. Green cells contain formulas; blue cells are for your entries.
Budget lines
Category, cost item, planned cost, actual cost and remaining budget.
Variance convention
Remaining budget is planned minus actual. A negative value means the line is over its planned budget.
Summary
The workbook totals planned and actual costs and calculates an optional contingency on the planned total. The contingency is not counted as an incurred expense.
KEEP YOUR WORK MOVING
The next step, in your browser.
Use the project profitability calculator alongside this template to prepare your next document or work through the numbers.
GOOD TO KNOW
A few useful answers.
How do I use this template?
Download the workbook and open Instructions first. Set the currency label on Summary, then enter records in the blue cells on Entries. The green formula cells calculate the results. The completed workbook demonstrates the formulas with fictional data.
Can I edit and reuse it?
Yes. Adapt it for your own work and keep a copy for future use. The workbook has 200 prepared entry rows; extend the formulas and summary ranges if you need more.
Are the completed example details real?
No. Names, dates, amounts and scenarios in the completed example are illustrative. They show how to organize the document; they are not recommended fees, actual payment instructions or records of a real transaction.
Keep a good thing going.
All business spreadsheets ↗Business expense tracker template
Download an expense tracker spreadsheet with dates, merchants, categories, receipt references and totals for personal and company-paid expenses.
View template & exampleUnpaid-invoice tracker template
Track invoice totals, payments, credits, outstanding amounts and days overdue in a spreadsheet with an editable as-of date and working formulas.
View template & example