Construction Job Costing Tracker
Track actual vs estimated costs per job across labour, materials, plant, and subcontractors. Flags over-budget line items and calculates gross margin per project. Ideal for contractors managing multiple active jobs.
Excel • ConstructionA job that loses money rarely announces it. The estimate is one number, the invoice is another, and the gap between them only shows up weeks later, when the bank balance disagrees with the paperwork. This workflow splits that single number into five stages, each handled by a calculator, so the price you hand the client traces back to quantities you actually counted rather than a figure you felt was about right.
One example runs through every step: a 24 x 30 ft detached garage and workshop (720 sq ft) with a storage loft, a 60 x 12 ft gravel apron at the door, and a 14-post fence down the side yard. Same numbers, carried tool to tool.
1. Get a rough order of magnitude before you price anything
Use the Construction Cost Estimator with 720 sq ft and 10% contingency pre-filled. Feed it build type, square footage, quality level and a contingency percentage. What comes back is a cost band, nothing you would put on letterhead.
Accuracy is not the point here. You want a number to argue with later. If your detailed take-off comes back 40% above the rough band, one of the two is wrong, and you need to know which before the bid leaves your office. Usually the take-off has caught scope the square-footage model never sees: site access, a beam, a retaining course. Sometimes the quality level you picked just does not match what the client is describing.
720 sq ft, standard finish, 10% contingency → ROM band roughly $72,000 – $90,0002. Replace every material guess with a take-off
Material lines are where estimates quietly rot. A guess and a measurement look identical on the estimate sheet. Each calculator below turns a dimension you can measure on site into an order quantity, waste included.
Roof, gravel, concrete, drywall
- Roofing Calculator with Waste Factor. A 720 sq ft footprint at 6:12 gives about 805 sq ft of roof plane, so 8.05 squares; 12% waste takes it to 9.02 squares, which is 28 bundles. Order off the footprint instead of the pitched area and you are short an entire square. For a metal roof, pair it with the Metal Roofing Screw Calculator so fasteners are counted rather than estimated at the supply counter.
- Gravel Calculator for Driveway. 60 x 12 ft at 4 in compacted depth is 8.9 cubic yards, roughly 13 tons delivered.
- Concrete Calculator for Fence Posts. 14 holes at 10 in diameter and 36 in deep, less the post volume, comes to about 30 bags of 80 lb mix. Order 34. Running two bags short on a Friday afternoon costs a return trip, not $13.
- Drywall Mud and Tape Calculator. 2,150 sq ft of board surface is 45 sheets of 4 x 12, plus four to five boxes of compound and roughly 1,100 ft of tape. Mud and tape are the lines contractors habitually omit and then absorb.
Check the framing before you price the lumber
Run the loft through the Joist Span Calculator before the lumber list is written. A 24 ft clear span in 2x10 SPF at 16 in on centre does not make it, so the design needs a mid-span beam and two posts. Caught here, it is a line item. Caught in week two on site, it is an LVL beam, hardware and two pad footings, around $600 of material and a day of crew time, and the whole lot lands as an unbudgeted variance.
| Material line | Where the quantity came from | Cost |
|---|---|---|
| Framing lumber, LVL beam, hardware | Joist span check + supplier list | $10,300 |
| Roofing: 28 bundles, underlayment, drip edge, ridge | Roofing waste-factor take-off | $1,450 |
| Drywall: 45 sheets, compound, tape | Drywall mud and tape take-off | $1,150 |
| Gravel apron: 13 tons delivered | Gravel driveway take-off | $500 |
| Side fence: 14 posts, panels, 34 bags mix | Fence post concrete take-off | $1,980 |
| Windows, service door, overhead door | Supplier quote | $4,800 |
| Siding, insulation, fasteners, misc | Supplier quote | $5,020 |
| Total materials | $25,200 |
Subcontractors get their own lines rather than being buried in materials. Concrete flatwork $9,400, electrical $3,600. That is $13,000 of subs.
3. Turn crew time into a burdened labor rate
Use the Time Card Calculator pre-filled with a 07:00–15:30 shift, 30-minute lunch, 5 days, $32/hr, 1.5x overtime. That is 8.0 paid hours a day and 40 hours a week per worker. A three-person crew over 22 working days gives 528 hours. Call the budget 520.
But the rate you carry forward is not $32. Payroll tax, workers' compensation, general liability, holiday and any benefits all sit on top of the wage, and as a rule of thumb that burden runs somewhere in the 20–30% range depending on trade classification and state. Take 25%:
$32.00 wage x 1.25 burden = $40.00/hr burdened
520 hrs x $40.00 = $20,800 labor cost (at the bare wage it would read $16,640)4. Build the job cost and the price
Everything now feeds one place: the Job Costing Calculator with materials $25,200, 520 hours at $40, subs $13,000, overhead 12%, target margin 20%.
Direct cost 25,200 + 20,800 + 13,000 = $59,000
Overhead 12% = $ 7,080
Total cost = $66,080
Price at 20% margin 66,080 / 0.80 = $82,600
Gross profit = $16,520That 12% comes out of your books, not off the top of your head. Divide annual overhead by annual direct job cost. If the books show $96,000 of rent, insurance, truck payments, software and office wages against $800,000 of direct cost, you are running at 12%. If you have never added those fixed costs up, the Service Business Break-Even Calculator is a reasonable place to total them.
Now compare. $82,600 against the ROM band of roughly $72,000–$90,000 from step 1: it sits inside, the two methods agree, and the bid is defensible. Had it come out at $104,000 you would go hunting for the disagreement before sending anything.
5. Apply overhead and markup in the right order
Open the Contractor Markup Calculator with $38,200 materials-plus-subs, $20,800 labor, 12% overhead and 25% markup. Subs get folded into the materials field because the tool carries two cost inputs, not three.
Correct: (59,000 x 1.12) x 1.25 = 66,080 x 1.25 = $82,600
Wrong: 59,000 x 1.25 = $73,750, then overhead of 7,080 comes out of profit
73,750 - 59,000 - 7,080 = $7,670 profit = 10.4% margin, not 20%Overhead has to sit inside the base that markup multiplies. Mark up bare direct cost and there is nowhere left to put the overhead except your own profit: which is why this error only ever runs one way. $8,850 on this job. And on the next one, and the one after that, until someone notices.
6. Cost the job while it runs
A job costed at invoicing tells you what happened. A job costed weekly lets you do something about it.
So keep collecting crew hours in the Time Card Calculator and re-run the job costing sheet every Friday with hours-to-date. Say the end of week three shows 340 hours logged against a 520-hour budget. That is 65% of the labor spent, but the roof is not on and physical progress is nearer 50%. Project it out: 340 / 0.50 = 680 hours, an overrun of 160 hours, and at the burdened $40 rate that is $6,400. Call it 39% of the entire $16,520 gross profit. You are seeing it in week three, while crew size, sequence and the scope conversation with the client are all still open.
Track material variances the same way. 13 tons of gravel ordered, 15 delivered because the sub-base was softer than it looked: a $76 line, and a note for the next quote's compaction assumption. When the job closes, the final costed sheet becomes the source for the invoice generator. Log the actual hours per square foot somewhere you will find them again. That is the figure you feed into the next estimate.
Related: construction cost planner · labor cost calculator · overtime pay calculator · equipment finance and debt payoff planner · all construction calculators