Project Budget Template: A Worked Example, and the Column Most Budgets Are Missing

Quick answer: A project budget lists every cost your project will incur, grouped by category, with a contingency reserve on top. Build it from the bottom up: estimate each line item, add the subtotals to get your base cost, add contingency to get your cost baseline, then add management reserve for the total budget.

Most budget templates give you three columns: Budget, Actual, Variance.

Those three columns will tell you that you’re fine, right up until the invoices land. Then you discover that the money was gone two months ago — you just hadn’t been billed yet.

This guide gives you a complete worked budget with every number adding up, and a fourth column that fixes the problem. In the example below, “Actual” says you’ve spent 46.5% of the budget. The fourth column says 70.3% is already gone.

What Is a Project Budget?

A project budget is the total money approved for a project, broken down into the costs that make it up.

A project budget plan does two jobs, and they’re different:

Job	What it means	When it matters
Authorising	Getting the money approved	Before the project starts
Controlling	Checking spend against plan	Every week after that

Most budget problems come from doing the first job well and the second badly. A beautiful spreadsheet approved in January tells you nothing in June unless somebody is updating it.

What a project budget is not

Not the same as	Difference
A cost estimate	An estimate is your calculation. A budget is the approved money
A quote	A quote is one supplier’s price for one piece of work
A cash flow forecast	A budget says how much. Cash flow says when it leaves the bank
A business case	The business case justifies the spend. The budget plans it

That third one catches people out. You can be perfectly on budget and still run out of cash, because the money was all due in month two. A budget with a timing column is a budget you can actually fund.

What’s the Difference Between a Cost Estimate, a Cost Baseline, and a Project Budget?

These three terms get used interchangeably, and they mean three different amounts of money. Getting them straight is the most useful ten minutes you’ll spend on this subject.

Term	What it is	Who controls it
Base cost estimate	The sum of your line items, with no buffer	Project manager
+ Contingency reserve	A buffer for risks you identified	Project manager
= Cost baseline	What you measure performance against	Project manager
+ Management reserve	A buffer for things nobody saw coming	Sponsor
= Total project budget	The whole authorised amount	Sponsor

The stack, in order

  Line items added up        →  BASE COST ESTIMATE
  + contingency reserve      →  COST BASELINE
  + management reserve       →  TOTAL PROJECT BUDGET

Why the layers matter

You’re measured against the cost baseline, not the total budget. That’s the number that matters when someone asks “are we over budget?”

You can spend contingency yourself. It’s yours, set aside for risks you already wrote down. Using it isn’t failure — it’s the reserve doing its job.

You cannot touch management reserve. It sits above your baseline and belongs to the sponsor. Reaching for it means going back and asking, which is a different conversation entirely.

This is why “are we on budget?” is a sloppy question. The honest answer is usually two numbers: where you are against baseline, and how much contingency you’ve used. The worked example below shows a project that is under baseline and has used nearly half its contingency at the same time. Both are true. They feel completely different.

What Should a Project Budget Include?

How to create a project budget starts here: work through these seven categories. Most forgotten costs live in the bottom three.

Category	Examples	Commonly forgotten
Internal labour	Your own team’s days × day rate	People often leave this out entirely
External services	Consultants, contractors, agencies	Travel and expenses on top of day rates
Software and licences	Subscriptions, seats, integration tools	Year-one cost vs ongoing; extra seats
Hardware and equipment	Devices, servers, kit	Delivery, setup, disposal of the old kit
Training and change	Trainers, materials, backfill cover	The time learners spend away from their job
Travel and facilities	Trips, room hire, shipping	Currency moves on overseas suppliers
Contingency and reserve	Risk buffer	Treated as padding instead of a plan

The five costs people forget most often

1. Your own team’s time. It feels free because the salaries are already paid. It isn’t free — it’s the largest line in most projects, and leaving it out makes the project look cheaper than it is.
2. The cost of people being trained. Forty staff away from their desks for a day is a real cost, even if no invoice appears.
3. Year two. A licence bought in month nine renews in month twenty-one. State clearly whether your budget covers year one only.
4. Decommissioning the old thing. Data extraction, contract exit fees, disposal.
5. Your own time managing it. The project manager is a project cost.

What Does a Completed Project Budget Example Look Like?

Here’s a full budget for a CRM implementation. Every line, every subtotal, every total.

Internal labour

Line item	Calculation	Cost
Project manager	60 days × $400	$24,000
Business analyst	40 days × $350	$14,000
IT lead	25 days × $450	$11,250
Subtotal		$49,250

External services

Line item	Calculation	Cost
Implementation partner	Fixed fee	$38,000
Data migration specialist	15 days × $600	$9,000
Subtotal		$47,000

Software and licences

Line item	Calculation	Cost
CRM licences, year 1	45 users × $85 × 12 months	$45,900
Integration middleware	Annual	$6,200
Subtotal		$52,100

Hardware

Line item	Calculation	Cost
Tablets for field team	12 × $540	$6,480
Subtotal		$6,480

Training

Line item	Calculation	Cost
Trainer	6 days × $700	$4,200
Materials and room hire		$1,800
Subtotal		$6,000

Travel

Line item	Calculation	Cost
Site visits	8 trips × $320	$2,560
Subtotal		$2,560

Putting it together

Category	Subtotal
Internal labour	$49,250
External services	$47,000
Software and licences	$52,100
Hardware	$6,480
Training	$6,000
Travel	$2,560
Base cost estimate	$163,390
Contingency reserve (10% of base)	$16,339
Cost baseline	$179,729
Management reserve (5% of baseline)	$8,986
Total project budget	$188,715

Check the arithmetic yourself

Every budget should survive three checks. This one does:

• Subtotals add to the base. 49,250 + 47,000 + 52,100 + 6,480 + 6,000 + 2,560 = 163,390 ✓
• Base + contingency = baseline. 163,390 + 16,339 = 179,729 ✓
• Baseline + management reserve = total. 179,729 + 8,986 = 188,715 ✓

A note on untidy numbers. $163,390 isn’t a round figure, and neither is $16,339. That’s what a real budget looks like when you build it from line items rather than working backwards from a number someone already had in mind. If your budget comes out at exactly $150,000, check whether you estimated it or just agreed to it.

How Do You Estimate Costs?

Five methods. Most projects use three of them in the same budget, which is fine — different lines need different approaches.

Method	How it works	Accuracy	Use when
Expert judgement	Ask someone who’s done it	Varies wildly	You have a genuine expert and little data
Analogous	“The last one cost $140k, this is bigger, so $180k”	−25% to +75%	Very early, or for a rough order of magnitude
Parametric	Cost per unit × number of units	−15% to +25%	The work scales with something countable
Bottom-up	Estimate every line, add them up	−5% to +15%	You know the scope. This is the one to aim for
Three-point	Combine best, likely and worst cases	Depends on inputs	A line item is genuinely uncertain

How to pick

Bottom-up is the target. The example above is bottom-up — 45 users at $85, 60 days at $400. It takes longest and it’s by far the most defensible, because every number traces to something.

Analogous is for the first conversation only. It’s fast and it’s wide. The range on an analogous estimate is roughly minus a quarter to plus three quarters, which is a way of saying you don’t know yet. Never present one as a budget.

Parametric is the quiet winner. Where work scales with a countable thing — users, square metres, pages, records — cost per unit times quantity is quick and surprisingly accurate. The CRM licence line is parametric.

Three-point is for the scary lines. You don’t need it for everything, only for the handful you’re genuinely unsure about.

The rule that matters more than the method

Ask the person who’ll do the work. An estimate you invented at your desk is a guess with a dollar sign on it. Ask for a range rather than a single number, and ask what would have to be true for the optimistic end to happen.

When the work is going out to suppliers, a request for proposal is how you turn guesses into priced quotes. Three real quotes beat any estimating technique.

How Do You Use a Three-Point Estimate?

Three-point estimating takes your uncertainty and turns it into a single number you can put in a budget.

You need three figures for the task:

• O — Optimistic: everything goes right
• M — Most likely: the realistic case
• P — Pessimistic: it goes badly, but not catastrophically

The formula

Expected cost or duration = (O + 4M + P) / 6

The most likely case is weighted four times, because it’s the most probable. The two extremes pull the answer slightly in their direction.

A worked example

Take the data migration from the budget above. Ask the specialist for three numbers:

	Days
Optimistic (clean data, no surprises)	8
Most likely	15
Pessimistic (duplicate records, bad formats)	34

Three-point estimate: (8 + 4 × 15 + 34) ÷ 6 = (8 + 60 + 34) ÷ 6 = 102 ÷ 6 = 17 days

Compare it to a simple average: (8 + 15 + 34) ÷ 3 = 57 ÷ 3 = 19 days

The simple average gives 19 days. The weighted formula gives 17. The weighting is what stops one alarming worst case from dragging your whole estimate upward.

What this tells you about the budget

The budget above used 15 days — the most likely figure — at $600 a day, so $9,000.

The three-point estimate says 17 days, which is $10,200. That’s $1,200 more than the budget line.

This is exactly what contingency is for. You don’t inflate the line to $10,200 and hide the buffer inside it. You budget the realistic figure, and you hold the difference centrally where you can see it and manage it.

The spread tells you how worried to be

Rough standard deviation = (P − O) / 6

Here: (34 − 8) ÷ 6 = 26 ÷ 6 = 4.33 days.

A spread of 4.33 days on a 17-day estimate is wide — roughly a quarter of the task. That’s a signal to look harder at the data quality before you commit to a date, not just to add money.

A useful habit: when the pessimistic figure is more than three times the optimistic one, stop estimating and go find out more. A range that wide means you don’t understand the task yet, and no formula fixes that.

How Much Contingency Should You Add?

Project type	Typical contingency	Why
Repeat work you’ve done many times	5%	Few unknowns
Standard project, known approach	10%	The usual starting point
New technology or new supplier	15–20%	More can surprise you
Research, R&D, first-of-a-kind	25%+	Genuinely unpredictable
Fixed-price contract you’re delivering	Higher — the risk is yours	You absorb overruns

These are starting points, not answers.

The better way to size it

A flat percentage is a guess dressed up as a method. Sizing it from your actual risks is more work and much more defensible:

Risk	If it happens, it costs	Chance	Expected value
Data worse than expected	$8,000	50%	$4,000
Extra licences needed	$6,000	30%	$1,800
Partner delay extends PM time	$10,000	40%	$4,000
Hardware price rise	$1,500	60%	$900
		Total	$10,700

Multiply each cost by its probability, add them up. That total is your evidence-based contingency figure.

The $16,339 in the example above is 10% of base. That’s more than this risk analysis suggests, which is defensible on a project with a new supplier. What matters is that you can explain the number. “It’s 10%” is an answer nobody can argue with or learn from. “It’s these four risks plus a margin for the new partner” is a number you can defend in a steering meeting.

Your contingency plan is where the responses to those risks get written down.

Three rules for contingency

1. Hold it centrally. One contingency line, not padding hidden in every estimate. Hidden padding gets spent without anyone deciding to spend it.
2. Require a decision to release it. Even if that decision is just you writing a line in the log.
3. Log every release. What it was for, how much, what’s left. This log is the single most useful document when someone asks where the money went.

What’s the Difference Between Contingency and Management Reserve?

	Contingency reserve	Management reserve
Covers	Risks you identified	Things nobody foresaw
Sits	Inside the cost baseline	Outside the baseline
Controlled by	Project manager	Sponsor
To use it	Your decision, logged	Formal request to the sponsor
Typical size	5–25% of base cost	5–10% of baseline
In the example	$16,339	$8,986

The practical difference

Contingency is for the known unknowns. You wrote the risk down, you costed it, it happened. You release the money and log it. No meeting needed.

Management reserve is for the unknown unknowns. A regulation changes. A supplier goes bust. The thing nobody had on the list. Getting at it means going back to the sponsor and explaining, which is appropriate — a surprise that big deserves a conversation.

Why the baseline boundary matters

Spending contingency does not make you over budget. It’s inside your baseline; that’s what it’s there for.

Touching management reserve does change the authorised amount. Your baseline gets reset, and reported performance restarts from the new number.

That’s the whole reason for the boundary. One pot absorbs the risks you planned for, quietly. The other one makes a noise, because something happened that nobody planned for at all.

What Goes in the Project Budget Template?

Copy this. The Committed column is the one most templates leave out, and the next section explains why it matters.

PROJECT BUDGET

Project:
Version:                Date:
Prepared by:            Approved by:
Currency:               Covers: Year 1 only / full life

LINE ITEMS
| Cat | Line item | Basis of estimate | Qty | Rate | Budget | Month due |
|     |           |                   |     |      |        |           |

SUMMARY
| Category              | Budget |
| Internal labour       |        |
| External services     |        |
| Software and licences |        |
| Hardware              |        |
| Training and change   |        |
| Travel and facilities |        |
| BASE COST ESTIMATE    |        |
| Contingency reserve   |        |
| COST BASELINE         |        |
| Management reserve    |        |
| TOTAL PROJECT BUDGET  |        |

TRACKING
| Category | Budget | Actual | Committed | Remaining | Forecast |
Remaining = Budget − Actual − Committed

CONTINGENCY LOG
| Date | Released for | Amount | Approved by | Balance left |

ASSUMPTIONS
1. Day rates as at [date]; rises after [date] not included
2. Covers year 1 licences only
3. Internal labour at [rate]; excludes recruitment
4. Excludes [named exclusions]
5. Currency: [X]; no allowance for exchange movement

CHECKS
[ ] Subtotals add to the base cost estimate
[ ] Base + contingency = cost baseline
[ ] Baseline + management reserve = total budget
[ ] Actual + Committed + Remaining = Budget, every row
[ ] Every line has a basis of estimate
[ ] Internal labour is included
[ ] Someone named has approved it

The “basis of estimate” column is the one to protect. In six months, nobody will remember why the training line was $6,000. A column saying “trainer quote 14 Oct, 6 days” answers that in five seconds, and it’s the difference between a budget you can defend and one you have to rebuild.

Why Do You Need a Committed Cost Column?

This is the fix for the most common way budgets fail, and almost no template has it.

The three kinds of “spent”

Status	Meaning	On your bank statement?
Actual	Invoiced and paid	Yes
Committed	Contract signed or PO raised, not yet invoiced	No — not yet
Remaining	Not yet promised to anyone	No

Committed money is gone. You signed for it. But it hasn’t been invoiced, so it doesn’t show in Actual — and a three-column budget shows you nothing but Actual.

Remaining = Budget − Actual − Committed

What it looks like in practice

Here’s the CRM project at month four.

Category	Budget	Actual	Committed	Remaining
Internal labour	$49,250	$22,000	$0	$27,250
External services	$47,000	$19,000	$28,000	$0
Software and licences	$52,100	$45,900	$6,200	$0
Hardware	$6,480	$0	$6,480	$0
Training	$6,000	$0	$4,200	$1,800
Travel	$2,560	$900	$0	$1,660
Contingency reserve	$16,339	$0	$0	$16,339
Management reserve	$8,986	$0	$0	$8,986
Total	$188,715	$87,800	$44,880	$56,035

Check it: 87,800 + 44,880 + 56,035 = 188,715 ✓ — the three columns must always add back to the budget.

The number that changes the conversation

Measure	Amount	% of total budget
Actual spend only	$87,800	46.5%
Actual + committed	$132,680	70.3%

A three-column budget would report 46.5% at month four and everyone would relax.

The truth is that 70.3% of the money is already gone. Against the base cost estimate of $163,390 — the part that isn’t reserve — it’s 81.2%.

Look at the rows to see how it happens. External services shows $19,000 actual against a $47,000 budget, which looks like plenty of room. But $28,000 is committed, so Remaining is zero. That line is fully spent and the Actual column won’t admit it for another two months.

Hardware is the starkest: $0 actual, $6,480 committed, nothing left. The tablets are ordered. A three-column budget calls that line untouched.

Where to get the committed figure

Source	What to pull
Purchase order system	Open POs not yet invoiced
Signed contracts	Total value minus what’s been billed
Finance team	Accruals and commitments, usually monthly
Your own records	Anything you’ve emailed “yes, go ahead” about

That last row is where the leaks are. An email saying “yes, please proceed” is a commitment even if no PO exists. If you’ve told a supplier to start, the money is committed.

One warning

Don’t double-count. When an invoice arrives, the amount moves from Committed to Actual. It doesn’t appear in both. The check that catches this is the one above — if your three columns stop adding up to Budget, something has been counted twice.

How Do You Forecast the Final Cost?

Forecasting is one sum, done honestly.

Forecast at completion = Actual + Committed + Estimate of work not yet committed

Worked on the CRM project

At month four, the team estimates $38,500 of work still to be ordered.

Component	Amount
Actual spend	$87,800
Committed	$44,880
Estimate for the rest	$38,500
Forecast at completion	$171,180

Now read it against both benchmarks

Compared with	Amount	Result
Cost baseline	$179,729	$8,549 under
Base cost estimate	$163,390	$7,790 over

Both are true, and they sound like opposite news.

You are forecasting under baseline. Good. There’s $8,549 of headroom.

But you’ve consumed $7,790 of contingency — that’s 47.7% of the $16,339 you set aside — and you’re four months into the project.

That second sentence is the one to say out loud in a steering meeting. The headline number looks fine. The contingency burn rate says you’ll be out of buffer before you’re out of project. That’s the thing to act on now, while there’s still something to act with.

The simplest early-warning check

Check	How
Contingency burn	% of contingency used vs % of project elapsed
Committed share	Actual + Committed as a % of budget vs % elapsed
Zero-remaining rows	Any category where Remaining hit $0 early

The contingency burn check is the single most useful one. If you’re 25% through the project and 48% through your contingency, you have a problem that no other number on the page is showing you.

For how this fits into regular reporting, see the project control process and the project performance evaluation plan.

What Are the Most Common Project Budget Mistakes?

1. Leaving out internal labour. The largest cost on most projects, left out because no invoice arrives for it.
2. No Committed column. Covered above. You find out two months late, every time.
3. Padding every line instead of holding central contingency. Hidden buffer gets spent without a decision.
4. Working backwards from a number. Somebody says “we’ve got about $150k” and the estimate is reverse-engineered to fit. The arithmetic looks fine and means nothing.
5. No basis of estimate. In six months nobody can defend any line, so the whole budget gets rebuilt.
6. No assumptions list. Then the argument about whether year two was included happens at the worst possible moment.
7. Forgetting the cost of change. Training, backfill, the productivity dip after go-live.
8. Never updating it. A budget that isn’t maintained is a historical document.
9. Confusing contingency with management reserve. Spending the sponsor’s reserve without asking is a quick way to lose their trust.
10. One currency, several countries. An overseas supplier’s price moves even when nothing about your project does.

How Do You Ask for More Money?

It happens on good projects too. How you ask decides how it goes.

Do	Don’t
Ask as soon as you know	Wait until you’ve already overspent
Bring one number, with the breakdown behind it	Bring a range and ask them to pick
Explain what changed since approval	Explain that estimating is hard
Show what you’ve already absorbed	Imply nothing could have been done
Offer options, including a reduced-scope one	Present it as pay-or-fail
Say what it buys	Say what it avoids

The structure that works

1. What changed. One or two sentences, factual. “The data was in worse shape than the sample suggested. Migration is 17 days, not 15.”

2. What you did about it. “We absorbed the first $7,790 from contingency and re-sequenced the training to save $1,400.”

3. What you need. One number, with the breakdown attached.

4. What happens if you don’t get it. Specific and undramatic. Which deliverable moves, by how long.

5. The options. Usually three: full scope at the new number, reduced scope at the old number, or delay the remainder to next year’s budget.

The thing that decides the answer

Whether you flagged it early. A sponsor asked for more money in month four, with the arithmetic shown and options offered, usually says yes. The same sponsor told in month nine that the money ran out in month seven says no — and stops trusting the numbers after that.

Bad news travels badly when it travels late. The contingency burn check above is how you spot it in time to be the one who raises it.

What Tools Can You Build a Project Budget In?

Tool type	Good for	Watch out for
Spreadsheets	Nearly everything. Full control, easy checks	No audit trail unless you add one; broken formulas are invisible
Project management platforms	Linking costs to tasks and resources	Often no Committed field — you may have to add a custom one
Finance and ERP systems	Real actuals and real PO data	Reports by cost code, not by your categories
Dedicated cost tools	Large capital programmes	Overkill under a few hundred thousand

Features worth more than the brand:

• A Committed field. If the tool only has Budget and Actual, you’ll be keeping the real picture in a spreadsheet anyway.
• Access to PO data. Ideally from the system that raises them, not retyped.
• A contingency log. Separate from the budget lines.
• Version history. So “what did we approve in January?” has an answer.

For most projects, a spreadsheet plus a monthly extract of open POs from finance beats any single tool. The spreadsheet gives you the structure in this guide; finance gives you the committed figures you can’t see yourself. Our project management tools page covers the wider set.

One habit worth more than any tool: reconcile against finance monthly. Your Actual column and their ledger will disagree. The disagreement is always informative, and it’s usually an invoice you didn’t know about.

How Does Writegenic AI Fit In?

A budget spreadsheet doesn’t explain itself, and the writing around it is what gets it approved.

Writegenic AI can help you:

• Write the basis of estimate for each line, so the numbers stay defensible
• Draft the assumptions and exclusions list — the section that prevents arguments later
• Turn the budget into a one-page summary for the people who won’t open the file
• Write the monthly budget update, including the contingency burn position
• Draft the request for more money using the five-part structure above
• Write the contingency release note when you draw on the reserve

It also helps with the documents around it. The project charter the budget is approved against. The project scope that decides what’s in it. And the contingency plan behind the reserve.

Explore AI for project management or sharpen your instructions with the prompt generator.

Draft with the tool, keep the judgement. AI can lay out a budget, write the assumptions and draft the update email in minutes. It cannot tell you that your implementation partner always bills at the top of their range, that your finance team closes the month three days late so your actuals are always stale, or that this sponsor needs bad news on a Tuesday and in person. Those three things will decide how your budget actually goes, and none of them is in the spreadsheet.

Try Writegenic AI free

Frequently Asked Questions

Related reading:

• Project Charter Templates With Real Examples
• How to Write a Project Scope Using AI
• Contingency Plan in Project Management
• What Is a Request for Proposal (RFP)
• Project Control Process: Steps + Template
• Project Performance Evaluation Plan