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.
6 free es expense tracker templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 6 spreadsheets from Project Planning, Estimates & Bids and Tax Planning. Start with Job Cost Tracker, Project Budget 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.
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.
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.
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.
Expenses deductible
$4,048
Mileage deduction
$92
Estimated tax saving
$1,242
Deductible expenses with business-use share and receipts, plus a mileage log, totalled by category for your return.
Profit this year
$4,781
Tax to set aside
$1,338
Set aside per quarter
$335
Track income, platform fees, expenses and hours for each side gig, see real profit per hour and how much to set aside for tax.
Portfolio value
$1,380,000
Total equity
$471,000
Monthly cash flow
$2,440
Value, debt, equity, cash flow, cap rate and cash-on-cash return for every property you own.