Construction Job Cost Tracking Spreadsheet (Budget vs. Actual)

Most small contractors find out whether a job made money a month after it’s finished, when the last invoices come in. By then it’s too late to do anything about it. A job cost spreadsheet fixes that. You set a budget for every cost code, log costs against it as they come in, and once a week you ask one question per line: where will this finish?

This page gives you a free construction job cost tracking spreadsheet (budget vs. actual, change orders, cost to complete and over/under billing) plus an online version you can fill in right here. Below it, we walk through a full worked example and explain every formula.

Free, no sign-up. Works in Excel, Google Sheets and LibreOffice. Up to 40 cost codes, 250 cost entries and 30 change orders per job.

Free online job cost calculator: budget vs. actual

Enter the contract, then one row per cost code: the original budget, any approved change order cost, the actual cost to date and your estimate of how complete that line is. Or click Load example. The report shows the estimated cost at completion for every line, flags the lines that are over budget, and works out projected profit and whether you’re over- or underbilled. You can print it, save it as a PDF, download it as Excel, Word or CSV, or send a link to your partner or bookkeeper.

1. Job and contract

2. Budget vs. actual by cost code

CodeDescriptionCategoryOriginal budgetChange order costActual to date% complete

Enter % complete as your field estimate of the work done on that line (0–100). Leave it blank and the tool assumes the rest of the budget will be spent. Your data stays in your browser. Nothing is sent to our server unless you choose to save it to your account.

3. Job cost report

Budget vs. actual by cost code

Where each line will finish

Revised budgetActual to dateEstimated cost at completion

By category

Profit and billing position

Cost to complete = revised budget × (1 − % complete). Job % complete uses the cost-to-cost method (actual cost ÷ estimated total cost). Prepared by: ______________   Reviewed by: ______________

Made with the free job cost tracker at bookkeepingsheets.com

What is job costing?

Job costing means tracking revenue and costs per job instead of only for the business as a whole. Your profit and loss statement can tell you the company made 12% last quarter. It can’t tell you that the Oak Avenue addition made 25% and the Maple Street remodel lost money. Job costing can.

For a contractor, every job has a budget (the estimate you bid from, broken into cost codes) and actual costs (labor, materials, subcontractors, equipment and other direct costs as they’re incurred). Comparing the two while the job is still running is what lets you catch a problem early: a sub that billed more than quoted, materials that went up, a crew that’s taking longer than planned.

What’s inside the template

  • Job Setup: job name, client, job number, original contract price, billed to date and the report date.
  • Budget: one row per cost code with a description, a category (Labor, Material, Subcontract, Equipment, Other), the original budget and your % complete. Approved change orders and actual costs pull in automatically.
  • Costs: a log for every invoice, receipt and payroll allocation. Pick the cost code from a dropdown; the description and category fill in, and a Check column flags codes that aren’t in the budget.
  • Change Orders: number, date, description, cost code, the cost each change adds to the budget, the price it adds to the contract, and status. Only Approved change orders count; pending ones are shown separately so you don’t forget them.
  • Job Report: budget vs. actual for every cost code with % used, % complete, cost to complete, estimated cost at completion (EAC), projected variance and a status flag; a summary by category; projected gross profit and margin; and the over/under billing position.

How to use it

  1. Set up the budget before the job starts. Use the same cost codes you used in your estimate. If the estimate is one lump sum, split it into at least 6–10 lines. You can’t spot a problem in a line you never budgeted.
  2. Log costs weekly. Every supplier invoice, sub’s progress bill, equipment rental and labor allocation goes on the Costs sheet with its cost code. Labor should include the burden (payroll taxes, workers’ comp and benefits), not just the hourly wage.
  3. Record change orders when they’re signed. Add the cost to the budget line it affects and the price to the contract. If the client hasn’t signed yet, leave it as Pending.
  4. Update % complete for each line. Walk the job or ask your foreman. This is a field estimate of the work done, not the share of the budget spent. That difference is the whole point.
  5. Read the Job Report. Look at the lines marked Over budget or Watch, then at projected profit. If it’s dropping week after week, find out why before the next invoice.

Worked example: Maple Street kitchen & bath remodel

A remodeling contractor signed a $132,000 contract for a kitchen and bathroom remodel and budgeted $101,500 of cost. The client later approved change order CO-1 (extra pantry cabinets) for $6,500, which adds $4,800 to the cabinets budget. So the revised contract is $138,500 and the revised budget is $106,300, for a planned gross profit of $32,200 (23.2%). A second change order for a heated bathroom floor ($2,600) is still pending, so it isn’t in the numbers yet.

Ten weeks in, the cost codes look like this. This is the same data the Load example button and the template use.

Cost codeRevised budgetActual to date% completeCost to completeEACVariance
01-100 General conditions$9,000$5,85060%$3,600$9,450−$450
02-200 Demolition & disposal$4,500$4,920100%$0$4,920−$420
06-100 Framing & carpentry$12,000$10,26090%$1,200$11,460$540
09-200 Drywall & paint$8,800$3,52040%$5,280$8,800$0
11-300 Cabinets & countertops$32,800$25,35075%$8,200$33,550−$750
15-400 Plumbing$14,500$11,60080%$2,900$14,500$0
16-100 Electrical$11,200$7,56070%$3,360$10,920$280
09-300 Tile & flooring$9,500$2,28030%$6,650$8,930$570
01-500 Equipment rental$2,400$1,38050%$1,200$2,580−$180
01-900 Permits & fees$1,600$1,745100%$0$1,745−$145
Total$106,300$74,465$32,390$106,855−$555

Look at general conditions. Only 65% of its budget is spent, so on a simple budget-vs-actual report it looks fine. But the job is only 60% done, and spending at the budgeted pace for the remaining 40% ($3,600) puts it at $9,450, $450 over. Now look at framing: 85.5% spent, 90% done, so it should finish $540 under. A report that only compares actual to budget gets both of these wrong. That’s why the template asks for % complete.

Overall the job is forecast to cost $106,855, $555 more than budgeted. Projected gross profit drops from $32,200 to $31,645, a 22.8% margin. Not a crisis, but five lines are already over, and two of them (demolition and permits) are finished, so that money is gone. The useful question is what happened on cabinets: is the extra $750 a one-off freight charge, or did the supplier raise prices on the rest of the order?

The formulas, explained

FigureFormulaExample
Revised budgetOriginal budget + approved change order cost$28,000 + $4,800 = $32,800
% of budget usedActual to date ÷ revised budget$25,350 ÷ $32,800 = 77.3%
Cost to completeRevised budget × (1 − % complete)$32,800 × 25% = $8,200
Estimated cost at completion (EAC)Actual to date + cost to complete$25,350 + $8,200 = $33,550
Projected varianceRevised budget − EAC$32,800 − $33,550 = −$750
Job % complete (cost-to-cost)Total actual cost ÷ total EAC$74,465 ÷ $106,855 = 69.7%
Earned revenueJob % complete × revised contract69.7% × $138,500 = $96,517.73
Over/(under) billingBilled to date − earned revenue$92,000 − $96,517.73 = −$4,517.73

In the spreadsheet, actual cost per cost code is a SUMIFS over the Costs sheet: =SUMIFS(CostAmt,CostCode,A2). Approved change orders use the same idea with a status condition: =SUMIFS(CoCost,CoCode,A2,CoStatus,"Approved"). If you leave % complete blank, cost to complete becomes MAX(revised budget − actual, 0): whatever is left of the budget. A line is flagged Over budget when its EAC is above the revised budget, and Watch when % of budget used is more than 10 points ahead of % complete. You can change that threshold on the Job Setup sheet.

The cost-to-complete method assumes the remaining work will cost what you budgeted for it. If you know it won’t (the tile sub already sent a higher quote, say), overwrite the estimate: lower the % complete for that line, or raise its budget with a change order line for the extra cost.

Over and under billing

The last block of the report compares what you’ve billed with what you’ve earned. In the example, the job is 69.7% complete, so the contractor has earned $96,517.73 of the $138,500 contract, but has only invoiced $92,000. The job is underbilled by $4,517.73: the work has been done and paid for, but the cash hasn’t been asked for yet. Bill it on the next draw. Our construction draw schedule template works out the payment due for each draw, including retainage.

Overbilling (billing ahead of the work) is the opposite: it brings cash in early, but that cash belongs to work you still have to do. Bonding companies and banks look at both numbers on a contractor’s work-in-progress (WIP) schedule. Consistent underbilling often means slow invoicing; consistent overbilling can hide a job that’s losing money.

The cost-to-cost percentage used here is the same input method commonly used for revenue recognition on construction contracts under ASC 606, and for the percentage-of-completion method for tax. Many small contractors qualify for exceptions and use simpler methods for tax and their own books, so treat these figures as a management tool and ask your CPA which method applies to you.

Common job costing mistakes

  • Using “% of budget spent” as “% complete”. If you do, every line will always look on budget until it’s finished. The field estimate is what makes the forecast work.
  • Leaving labor burden out. A $30/hour carpenter can cost $38–$42 an hour once payroll taxes, workers’ comp and benefits are added. Budget and record labor at the burdened rate, or the labor lines will always look better than they are.
  • Doing extra work without a signed change order. The cost lands on the job, the revenue doesn’t. Record the change order (even as Pending) the day the client asks for it.
  • Coding costs to “miscellaneous”. If a cost doesn’t fit a code, add a code. A big Other line hides exactly the overruns you’re trying to find.
  • Waiting for invoices. A material delivery that hasn’t been billed yet is still a cost. Log it from the delivery ticket, or add it to cost to complete.
  • Mixing overhead into job costs. Office rent and your accountant’s fee aren’t job costs. Keep them in the company’s books; cover them through your markup. Our margin vs. markup calculator helps set it.

FAQ

What’s the difference between job costing and a budget vs. actual report?

A budget vs. actual report compares what you’ve spent with what you planned. Job costing goes one step further: it adds the % complete and forecasts what each line, and the whole job, will cost when it’s finished. That forecast is what tells you the job’s final profit while you can still change it.

How often should I update the job cost spreadsheet?

Weekly for most small contractors, ideally on the same day you run payroll, so labor goes in with the materials and sub bills. On short jobs (under a month), update it at least at every draw.

Can I track several jobs in one file?

The template is built for one job per file, which keeps every cost code and change order clear. Save a copy for each job (for example 2026-014 Maple Street.xlsx). If you want a company-wide view, copy each job’s summary line onto one sheet at month-end.

What cost codes should a small contractor use?

Many builders use a short version of the CSI MasterFormat divisions (01 General requirements, 06 Wood, plastics and composites, 09 Finishes, 22 Plumbing, 26 Electrical and so on). The example uses the older 16-division numbering, which puts plumbing in 15 and electrical in 16. Any list works as long as your estimate, your budget and your cost log use the same codes.

Does the template work in Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. The dropdowns, formulas, checks and colour flags all carry over.

This guide and template are for general record-keeping and information. They aren’t tax, legal or accounting advice. For questions about your own situation, talk to a qualified accountant or tax professional.