Free Excel template · Cost control

Free Construction Budget vs Actual Template

One sheet, one row per cost code: revised budget, committed, actual to date, % complete, earned value, projected cost at completion and variance. Built for the monthly cost review.

  • ✓Original budget, approved changes, revised budget
  • ✓Committed (subs + POs) and actual to date
  • ✓Field % complete and earned value
  • ✓Projected cost at completion and variance $ / %
  • ✓In-cell bars: % spent next to % complete
  • ✓Summary block with cost performance

Budget vs Actual Template

We'll email you a copy + send the file to your browser right now.

Excel (.xlsx) · works in Excel, Google Sheets, Numbers

Want it with your logo on it?

A free account puts your logo, company info, and license # on every template, and adds one-click template packs. Free forever, even after the trial.

Get branded templates free →

By downloading you agree to receive occasional Field PM updates. Unsubscribe anytime. We don't share your email — read our privacy policy.

What's inside the workbook

Pre-formatted, print-ready, with embedded Field PM branding. Works in Excel, Google Sheets, and Numbers.

01

Budget vs Actual

Cost codes with inputs in yellow and formulas in blue, a totals row, and a summary at the top: projected over or under, % spent vs % complete, and cost performance.

02

Bars, no charts

Two in-cell bars per code show % spent against % complete, so the codes burning budget faster than they produce work stand out when printed.

03

Instructions

Where each number should come from, how to read earned value and cost performance, and when to move up to the full job cost report.

Share this live with your client

Your budget stays yours. What the owner relies on is progress by phase and invoices that match it.

In Field PM, your progress by phase code and invoices can be shared live with your client, item by item, from your own account.

Want this automated?

Stop re-typing the same form on every job.

Field PM has this exact form built in — crews fill it out from a phone, the data flows into the project record, and you get a clean PDF for the GC or owner with one click. No re-typing, no lost paperwork, no missed signatures.

30 days free · no credit card · every feature unlocked from day one.

Paper / Excel

  • ✗ Hand-writes the form on the jobsite
  • ✗ Re-types into Excel at the trailer
  • ✗ Emails the PDF back to the office
  • ✗ No audit trail, no signatures
  • ✗ Data never feeds payroll or the budget

Field PM

  • ✓ Fill out from a phone in under 3 min
  • ✓ Photos, signatures, and audit log built in
  • ✓ One-click PDF for the GC and owner
  • ✓ Data feeds payroll, budget, and reports
  • ✓ Replaces 5 forms with one platform

On your phone & tablet

Every template — in the app, in your pocket

This template and every other one is built into the Field PM app. Fill them out right from the jobsite on any iPhone, iPad, or Android — photos, signatures, and a clean GC-ready PDF included. Download free:

Download on theApp StoreGet it onGoogle Play

Frequently asked questions

What does a budget vs actual report show on a construction job?

It compares what each cost code was budgeted to cost with what has actually been spent, and, more usefully, with how much work is in place. Spending 60% of a budget is fine if the work is 60% done and a problem if it is 40% done. This template shows both side by side.

Why include % complete and earned value instead of just budget and actual?

Budget minus actual only tells you how much money is left, not whether it is enough. Earned value (% complete × revised budget) tells you what the installed work should have cost, so you can see overruns while there is still time to act.

How is projected cost at completion calculated?

Once work has started, the template divides actual cost by % complete, and never projects less than what is already committed. Before work starts it uses the larger of the revised budget, committed or actual. On any code where the PM knows better, overwrite the formula with the PM forecast.

How is this different from the job cost report template?

This is the one-sheet version for a monthly check. The job cost report template adds a cost-to-complete forecast tab, labor hour productivity and a cash flow projection. Start here and move up when you need the detail.

Can an owner use this to track a contractor's job?

Yes, at the level of the contract: use the schedule of values lines as the cost codes, approved change orders as approved changes, billed to date as actual, and the contractor's reported % complete. The owner side rarely sees the contractor's own cost, and this sheet does not need it to show whether billing is running ahead of progress.

Is this template free?

Yes. It is a standard .xlsx file with no macros or locked cells. Enter your email and it downloads right away.

Budget vs actual is only useful with % complete next to it

Most construction budget trackers stop at budget, actual and remaining. That number goes down every month on every job, good or bad. What tells you whether a cost code is in trouble is comparing what you have spent with how much of the work is actually in place. This template puts field % complete and earned value on the same row as the money, then projects where each code will finish.

Project managers and superintendents use it for the monthly cost review: every red number gets a cause and an action. Owners and program managers can use the same layout at the contract level, with schedule of values lines as the codes and billed to date as actual, to see whether billing is getting ahead of progress.

Need more depth? The job cost report template adds a cost-to-complete forecast, labor productivity and cash flow. For cost-plus or GMP work where the owner sees every dollar, use the open-book cost report template. To run the numbers quickly, try the earned value calculator.

In Field PM, budgets live by phase code and actual labor cost comes straight from crew hours on daily reports, so budget vs actual updates as the field reports instead of once a month from a spreadsheet.

Rated by contractors on

Field PM reviews on CapterraField PM reviews on GetAppField PM reviews on Software Advice