Budget
$621,000
Forecast at completion
$617,356
Projected over (−) or under budget
$3,644
Job Cost Tracker
Budget, committed and actual cost by cost code, with a forecast at completion and the variance to budget.
9 free cost tracker templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 9 spreadsheets from Investment Tracking, Project Planning and Construction Project Management. Start with Job Cost Tracker, Dividend Income Tracker and Project Budget Tracker: each comes with realistic sample content, working formulas or ready-to-use wording, and a step-by-step guide.
Budget
$621,000
Forecast at completion
$617,356
Projected over (−) or under budget
$3,644
Budget, committed and actual cost by cost code, with a forecast at completion and the variance to budget.
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.
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.
Total spend
$19,800
Leads
712
Blended CAC
$183
Compare campaigns on spend, leads, cost per lead, revenue and ROI.
Portfolio value
$49,891
Unrealised gain
$4,034
Realised gains this year
$1,270
Holdings built from your buys, sells and staking rewards, with average cost, unrealised and realised gains, allocation and rebalancing.
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.
Event spend
$139,300
Blended cost per lead
$75
Pipeline per $1 spent
18.6
Total every event’s cost, leads, pipeline and won revenue, see cost per lead and ROI, and follow up hot leads on time.
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.
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.