Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesProject & Task ManagementProject PlanningProject Budget Tracker

SpreadsheetProject PlanningFree

Project Budget Tracker

Budget, commitments and actual spend by work package, with earned value, cost performance and forecast at completion.

Shown with sample data

Colour

Project Budget Tracker

Budget, commitments and actual spend by work package, with earned value, cost performance and forecast at completion.

Total budget
$119,000
Spent to date
$66,340
Cost performance (CPI)
0.9
Below 1.0 means over-spending for the work done
Forecast at completion
$131,036
Forecast variance
-$12,036
Negative means forecast overspend
Forecast vs budget by work package
  • Discovery and design$900
  • Laptops for project team$300
  • Workshops travel$14
  • Cloud hosting (year 1)-$250
  • Training and rollout-$3,000
  • Development-$10,000
Cumulative spend
2026-082027-01

Latest: $66,340

How to use it

  1. 1List each work package with its budget and cost type.
  2. 2Log every invoice, purchase and timesheet cost on the Spend log; actuals add up by package.
  3. 3Record open purchase orders as Committed and update % complete monthly.
  4. 4Read CPI and Forecast at completion: below 1.0 means each $1 of work is costing more than planned.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Know early whether a project will finish on budget. Set a budget for each work package, log every invoice and expense in the spend log, and record % complete. The tracker totals actual spend and open commitments, then uses earned value (the budgeted cost of the work actually done) to work out a cost performance index and a forecast cost at completion for each package and the whole project, flagging overspend before it happens.

Who it’s for

  • Client and capital projects with a fixed budget
  • Monthly budget reports to sponsors
  • Agencies tracking project profitability

What’s included

  • Budget sheet: Budget, actual and forecast for each work package.
  • Spend log sheet: Every invoice, purchase and cost booked to the project.
  • By month sheet: Spend by month and cumulative burn against the total budget.

How to use it

  1. 1List each work package with its budget and cost type.
  2. 2Log every invoice, purchase and timesheet cost on the Spend log; actuals add up by package.
  3. 3Record open purchase orders as Committed and update % complete monthly.
  4. 4Read CPI and Forecast at completion: below 1.0 means each $1 of work is costing more than planned.

Tips

  • Keep a contingency line of 10% for unknowns.
  • Update % complete from real progress, not from money spent.
  • Raise a change request as soon as a package's forecast exceeds its budget.

Questions

What is earned value?

The budget for the work actually done: a $10,000 package that is 40% complete has earned $4,000, whatever has been spent.

How is the forecast worked out?

Actual spend plus the remaining work at the rate you are currently spending (budget ÷ CPI). It is the standard EAC formula.

Related searchesproject budgetbudget trackerearned valuecost trackingestimate at completionproject finance

Details

Format
Spreadsheet
Category
Project Planning
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetProject PlanningFree

Project Budget Tracker

Budget, commitments and actual spend by work package, with earned value, cost performance and forecast at completion.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Project Planning
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More project planning templates

View all
Project Plan with Gantt Timeline
Task
W1W2W3W4W5W6W7W8W9W10
Kick-off and charter sign-off
Stakeholder interviews
Requirements document
Budget and resource plan
Plan approved
Wireframes
SpreadsheetProject Planning

Project Plan with Gantt Timeline

A real Gantt chart: tasks by phase with dates, owners, dependencies, progress bars across 16 weeks and schedule status.

10 min setupPreview
Project Tracker
Task
OctNov
Customer survey launched
Pricing page copy
Partner contract signed
Onboarding email sequence
Analytics dashboard
Sales training deck
SpreadsheetProject Planning

Project Tracker

Deliverables with owner, priority, dates, progress, health and a workload view by person.

10 min setupPreview
Work Breakdown Structure (WBS)2 sheets

Work packages

9

Total effort (hours)

386

Total cost

$42,040

ABCD
1WBS codeStageDeliverableWork package
21.11 DiscoveryRequirementsStakeholder interviews
31.21 DiscoveryRequirementsRequirements document and sign-off
42.12 DesignExperience designUser flows and wireframes
52.22 DesignVisual designDesign system and page designs
WBS
SpreadsheetProject Planning

Work Breakdown Structure (WBS)

Break a project into phases, deliverables and work packages with effort, cost and owner rolled up by phase.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ