Job Costing Sheet

Revenue only tells you a job happened. It doesn’t tell you whether the job made money. A job costing sheet closes that gap: you log what you expected a job to cost, then what it actually cost once the hours are in and the receipts are tallied, and the difference is the profit you can’t see from the invoice alone. Use the calculator above to build the numbers; this page covers how to run the sheet across any trade.

Estimate versus actual is the whole point

The estimate — or the quote you sent — is a prediction. The actual is what the crew, the supply house, and the clock actually delivered. Most operators stop at the quote: win the job, send the invoice, collect, and never circle back to compare. That missing comparison is exactly where margin leaks — the unplanned return trip, the material you under-counted, the two hours the job ran past the estimate. A costing sheet forces the comparison on every job, so the leak shows up as a number instead of a vague sense that you’re busy but broke.

Three buckets, costed the same way every time

Track every job in the same three buckets so the sheets are comparable:

• Labor at its loaded cost, not the bare wage. The hour a technician is on the job carries payroll taxes, insurance, and any benefits on top of the pay rate — that fully burdened figure is the real cost of the hour.
• Materials at what you actually paid to get them on site, including the small overages and the items that didn’t make it onto the original takeoff.
• Overhead — the share of fixed cost (the truck, the phone, the office, the software) that this job has to carry. You don’t guess the slice; you derive a recovery rate from your real fixed costs and billable capacity.

The job cost & quote calculator above drives the price side and your estimated inputs. The actuals come from your time records and receipts — that’s the half only you can fill in.

Read the gap, not just the bottom line

Subtract the three costed buckets from what the customer paid and you have gross profit; divide that by revenue and you have gross margin, the first honest read on whether the work was priced above what it cost to perform. Those three buckets are your cost of goods sold.

A single job’s margin is noise — one bad day, one warranty callback, one generous customer. The signal is the pattern across many jobs. Watch the variance: consistently over on labor means your production rate or your rate card is off; consistently over on materials means your takeoff runs light; a thin margin on one whole job type means that work is mispriced no matter how well the crew performs. The sheet turns a hunch into a direction.

Cost the job while it’s fresh

Fill in the actuals within a day or two of closing the job, while the crew still remembers the return trip and the receipts are still in the truck. Wait a month and you’re reconstructing, not recording. The person who priced the job should be the one who reads the variance — that short feedback loop is what makes the next estimate sharper, and it’s the entire reason the sheet exists. An owner-operator does this for every job; a larger shop has the estimator review a weekly sample rather than chase all of them.

From one sheet to a sharper price

One costed job is a receipt with hindsight. A stack of them is a pricing strategy. Once the variance points the same way job after job, you stop fixing it one quote at a time and fix it at the source — the burdened labor rate you build from, the markup you apply to materials, the overhead you recover per billable hour. The sheet’s job is to make that pattern impossible to ignore; what you do with the pattern is where the margin actually comes back.