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.
8 free es 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 8 spreadsheets from Project Planning, Estimates & Bids and Property Investment. 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.
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.
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.
Income
$7,575
Expenses
$2,577
Net cash flow
$4,998
Track rent and property expenses by category for cash flow and tax time.
Income this year
$33,050
Tax reserved
$9,254
Tax still to pay
$2,234
Split every client payment into tax, savings and spending, and plan each quarterly tax payment.