Total budget
$119,000
Spent to date
$66,340
Cost performance (CPI)
0.9
Project Budget Tracker
Budget, commitments and actual spend by work package, with earned value, cost performance and forecast at completion.
7 free project expense tracker templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 7 spreadsheets from Project Planning, Construction Project Management and Budgeting & Expense Management. Start with Project Budget Tracker, Daily Expense Tracker and Earned Value Management Tracker: each comes with realistic sample content, working formulas or ready-to-use wording, and a step-by-step guide.
Total budget
$119,000
Spent to date
$66,340
Cost performance (CPI)
0.9
Budget, commitments and actual spend by work package, with earned value, cost performance and forecast at completion.
Spent this month
$653
Daily average
$36
Wants share
35%
Log every purchase in seconds and see this month’s spending by category, daily average and month-end forecast.
Budget at completion
$820,000
Earned value
$409,350
Project CPI
0.9
PV, EV, AC, cost and schedule variance, CPI, SPI, EAC, ETC and VAC for every work package and the whole project.
On hire now
3
Hire cost to date
$6,374
Long hires to review
1
Owned and hired equipment by site with hire days and cost (stopping at off-hire), long-hire reviews, service due dates for owned kit, and totals by site.
Hours this period
97.5
Overtime share
10%
Labour cost
$5,247
Daily crew hours by worker and cost code with regular and overtime pay, labour burden, and hours against budget for every code.
Portfolio budget
$3,305,000
Spent to date
$2,027,500
Portfolio CPI
1
Every project’s budget, spend, progress and RAG status in one place, rolled up by programme.
Forward annual income
$1,439
Per month
$120
Portfolio yield
2%
Forward annual income, yield and yield on cost per holding, plus every payment logged by month.