Track time. Get paid.
Free project budget tracker spreadsheet
See what your agreed fee can still cover. Put recorded hours and expenses beside the work left, then spot a thin buffer before the project ends.
Editable XLSX for Excel or Google Sheets · no signup or email
Download budget tracker (XLSX)Check your budget as the work moves on
1. Set your fee and buffer
Replace the example fee, ISO currency and your own hourly delivery cost. Choose how much fee you want left after forecast costs.
2. Update each work stage
Add planned and recorded hours. Estimate remaining hours, then separate expenses already incurred from those still expected.
3. Review both warnings
The sheet compares forecast costs with your fee and projected hours with planned hours. Adjust the remaining estimate when scope changes.
Example
A website refresh with review work left
A fictional designer agreed a USD 3,000 fee. They planned 30 hours and have recorded 12. Their revised estimate is 20 more hours. At an internal delivery cost of USD 70 an hour, plus USD 150 in actual expenses and USD 250 expected, forecast cost is USD 2,640.
Hours forecast
32 hours
2 above the original plan
Cost forecast
USD 2,640
Labour and listed expenses
Fee left
USD 360
Below the chosen USD 600 buffer
The warning is a prompt to review the estimate and agreed scope. The buffer is this designer’s choice, not a recommended target.
What the numbers mean
Actual delivery cost is recorded hours × your hourly delivery cost, plus actual expenses. Forecast delivery cost uses recorded and remaining hours, plus actual and expected expenses. Fee left is the agreed fee minus those costs. The workbook rounds money to two decimals and uses one currency throughout.
A negative forecast balance shows “Over fee”. A positive balance below your chosen buffer shows “Below chosen buffer”. Hours have a separate warning when recorded plus remaining hours exceed the original plan. These are planning checks, not a claim that the work is complete or the client has paid.
Enter zero for a known zero. A named stage with missing, negative or non-numeric values blocks the totals. The fee, hourly cost and buffer must also be non-negative numbers. The sheet does not include tax, overheads you have not entered, invoice payments or contractual change approval.
The download contains a fictional example and amber cells to edit. Your project details stay in the file you save or upload to your chosen spreadsheet service; this page does not ask for them.
Questions before you use it
Is the fee left the same as profit?
Only if your hourly delivery cost and listed expenses include every cost you want to count. Add overheads or tax to your own review separately.
Can I use the tracker for an hourly project?
Yes, if you have an agreed fee cap to compare with costs. It does not calculate client billings from hourly rates.
Will it open in Google Sheets?
You can upload the XLSX to Google Sheets. Check imported formulas and print layout before sharing your edited copy.
Keep actual hours close to your plan.
Track project time in TimeLodge, then update your workbook before you invoice. See time tracking or see pricing.
Start freeFree for 14 days — every feature, no credit card, no automatic charge.
Start free, record your next project hour, then check the budget before your next invoice.