Running the business

Job costing: how to know if a job made money

A job costing habit for small crews, with a free job costing sheet: labor, materials and overhead per job, estimate vs actual, and the next bid.

Adrian GluchowskiOwner of Superior Stain Solutions, builder of ChalkLast reviewed 12 min read

On this page

Most small contractors know whether the bank balance went up, but not which jobs made the money. A busy year can hide a handful of losing jobs behind a few good ones. Job costing is the habit that shows you which is which: after every job, compare what you thought it would cost to what it really cost, and use the gap to fix the next price.

You do not need software or a degree. You need three numbers per job (labor, materials and overhead), a ten-minute review, and the nerve to read the result. If you only came for the sheet, the free job costing template is further down, with a spreadsheet to download.

What counts as job cost

Split your costs into two groups.

Direct costs belong to one job:

  • Materials: paint, stain, chemical, sealer, caulk, tape, plastic, sandpaper, fuel for the job
  • Labor: every hour anyone worked on the job, at their loaded cost (below)
  • Subcontractors and rentals: a lift, a dumpster, a day of a sub's time
  • Job-specific fees: permits, disposal, a customer-specific insurance certificate
  • Warranty or callback work you did on this job, charged back to it

Overhead is the cost of running the business that is not tied to one job:

  • Truck, trailer and fuel for general driving
  • General insurance, licenses and registrations
  • Phone, software and your accountant
  • Marketing and advertising
  • Office, storage and your own pay for selling and running the business
  • Tools and equipment wear

Direct costs you track per job. Overhead you spread across jobs as a percent of revenue. Take last year's overhead and divide by last year's sales. If overhead was $54,000 on $450,000 of work, overhead is 12% of sales, so every job carries 12% of its price.

Labor at loaded cost, not wages

The most common job costing error is using the hourly wage. A $22 an hour helper costs more than $22 for every hour on a job: payroll taxes, workers' comp, and the hours you pay but nobody bills. Our hourly rate guide works the same helper out at about $30.91 for each billable hour, 1.4 times the wage.

Use your loaded rate:

Labor cost on a job = hours worked x loaded hourly cost

The examples below use $31 an hour, close to the guide's number. Replace it with yours.

Count every hour on the job, including:

  • Driving to the job, if you pay for it
  • Setup, masking and moving furniture
  • Cleanup and loading the truck
  • Return trips for touch-ups
  • Your own time on the job, at the rate you would pay someone to do it

Leaving out your own hours is the quiet reason jobs look more profitable than they are.

Materials and receipts

Estimates guess. Receipts tell you.

  • Keep every receipt, and write the job name on it. A photo on your phone at the counter is enough.
  • Count leftover product honestly. If you bought 10 gallons and used 7, decide whether the 3 go back to stock (credit the job) or are waste (leave on the job).
  • Count the trip. Extra store runs cost fuel and labor.
  • Subtract returns.

If a job's receipts never get recorded, you are guessing your profit.

Overhead per job

A simple way: take your overhead percent (12% in the example above) and multiply it by the job price. On a $9,600 job:

Overhead = $9,600 x 0.12 = $1,152

That is not what the job "used" in a literal sense. It is the share of your fixed costs the job should help pay for. If a job covers its direct costs but not its overhead share, you are paying to work.

Check your percent once a year. If your overhead grows faster than your sales, your percent rises and your jobs are underpriced. Once you know your variable costs as a share of sales, the break-even calculator shows the sales you need each month.

Estimate vs actual: a worked review

An exterior paint job, sold for $9,600. Here is the estimate.

Estimate
Materials$1,300
Labor: 140 hours x $31$4,340
Overhead at 12% of price$1,152
Total cost$6,792
Profit$2,808
Profit as a share of price29.3%

Here is what happened. The crew found more scraping and loose caulk than expected, and a rainy week meant two return trips to finish the trim.

EstimateActualDifference
Materials$1,300$1,425+$125
Labor hours140165+25 hours (17.9% over)
Labor cost at $31$4,340$5,115+$775
Overhead at 12% of price$1,152$1,152$0
Total cost$6,792$7,692+$900
Profit$2,808$1,908-$900
Profit as a share of price29.3%19.9%

An 18% overrun on labor, with a small overrun on materials, took roughly a third off the job's profit ($900 of $2,808, or 32%) and dropped the margin from 29.3% to 19.9%. The customer paid the price they were quoted, so every extra hour came out of your pocket.

What to learn from it

Look at each line and ask why it moved:

  • Labor +25 hours. Was it prep (more scraping than expected), rework, weather, a slow crew, travel, or a customer change? Each has a different fix.
  • Materials +$125. Waste, a color change, thirstier siding than the can's coverage figure, or a price increase since the quote?
  • A line that came in under. If something was under, was it luck or a better method? Keep it if it is repeatable.

What to change when a job runs over

Callbacks are a job cost too. See workmanship warranties and callbacks for how to count them.

Fix the cause, not the number. A few patterns:

What went overLikely causeFix
Prep hoursYou priced prep from looking at the surface, not testing itAdd a prep level to the estimate and a line for extra scraping at an hourly rate
Hours across the boardYour production rate is too fastUse your last five jobs' actual rate, not your best day
Return tripsWeather, drying time, a missed itemAdd a trip charge or build the extra visit into the price
MaterialsRough surfaces use more, waste is higherRaise your coverage allowance for old, thirsty surfaces
Change orders you did freeCustomer asked, you did itWrite it down, price it, get a yes before the work
Overhead shareYour percent has crept upRecalculate it yearly

Then reprice the next similar job. Using the real cost from this review:

Direct cost = $1,425 + $5,115 = $6,540
Overhead 12% and profit 29.25% of price
Price = $6,540 / (1 - 0.12 - 0.2925)
      = $6,540 / 0.5875
      = $11,131.91

At the real hours, this job needed a price of about $11,132 to earn the margin you wanted, not $9,600. That is 16.0% more. An 18% labor overrun turned into a 16% price increase. This is the use of job costing: it turns surprises into price changes, one job at a time. If your jobs run over like this on average, the raise your prices guide shows how to roll it out.

The weekly 10 minutes

A habit beats a system. Once a week, on the same day:

  1. List the jobs finished this week.
  2. For each one, write the estimate, the actual hours, the actual materials and the price.
  3. Calculate profit and margin. Our markup and margin calculator does it.
  4. Mark any job more than 10% off the estimate on labor or materials, and write one line about why.
  5. Update your numbers (production rates, coverage, loaded hourly rate) when a pattern shows up in three or more jobs.
  6. Check what is still open: jobs you finished that have no invoice or no costs entered. A job you have not costed is a job you do not know about.

After a few months you will see which job types pay and which do not, which crews run over, and which customers send the best work. That is the information to steer by. If you pay a crew a share of profit, as in our profit share guide, job costing is the base for it. For a sheet to copy, use the free job costing template below. The monthly habit that goes with it, matching the bank and sorting receipts, is in bookkeeping basics for contractors.

Free job costing template

A job costing sheet puts what you expected to spend next to what you actually spent, line by line, and works out profit and margin. Use the same sheet on every job and, after ten jobs, you will know which kinds of work pay and where your estimates run low.

Download:

Both are plain CSV files with the formulas already in place, so they open in Excel, Google Sheets or Numbers. If your program shows the formulas as text instead of numbers, import the file instead of opening it, and keep "detect formulas" or "evaluate formulas" on. Nothing about your job is sent anywhere. The sheet is yours.

To print the blank sheet, use your browser's Print command (Ctrl+P or Cmd+P). The printout shows only the sheet, not this guide.

How to fill it in

  1. Start with the price. What you sold the job for, and later, what change orders added. The total sold is the top of the sheet.
  2. Estimate before the job. For labor, the hours you expect for each person and their loaded hourly cost, not just the wage. For materials and other costs, the dollars you expect.
  3. Record actuals after the job. Hours from your time sheets or time clock, and receipts for materials, rentals, dump fees and fuel. Do it the week the job ends.
  4. Count the drive. Time on the road to the job and to the supply store is a cost even when it is not on the clock.
  5. Add overhead as a percent of the price, worked out the way the overhead section shows. The hourly rate calculator helps if you do not know yours yet.
  6. Read the bottom and the difference column. Profit is total sold minus total cost, and margin is profit divided by total sold. For a cost, a positive difference means you spent more than you estimated.
  7. Write one lesson down. The note line is the most valuable part.

Job costing sheet

Fill in the estimate columns before the job and the actual columns after it. Difference is actual minus estimate.

Job name
Customer
Job number
Date finished
LineEst. hoursActual hoursRate per hourEstimate $Actual $Difference $
Sold for
Contract price
Change orders
Total sold
Labor
Crew member 1
Crew member 2
Crew member 3
Crew member 4
Materials
Main product (paint, stain, sealer)
Cleaners, primer, other products
Supplies (tape, plastic, blades)
Other direct costs
Rentals
Subcontractors
Fuel and drive time not on the clock
Dump fees and permits
Card and processing fees
Direct cost (labor + materials + other)
Overhead (percent of price: ____ %)
Total cost
Profit (total sold minus total cost)
Margin (profit divided by total sold)

What I will do differently next time:

Notes

A worked example on the sheet

A deck stain job. It was sold for $4,200, and the customer added a $300 change order. You expected 40 hours for the lead at $30 and 40 hours for a helper at $20. Overhead is 15% of the price, and the customer pays by card at 2.9% plus 30 cents.

LineEstimateActualDifference
Total sold$4,200$4,500+$300
Labor: lead, 40 hours estimated, 46 actual, at $30$1,200$1,380+$180
Labor: helper, 40 hours estimated, 48 actual, at $20$800$960+$160
Main product$480$528+$48
Cleaners and other products$90$90$0
Supplies$60$72+$12
Fuel and drive time$40$55+$15
Card and processing fees$122$131+$9
Direct cost$2,792$3,216+$424
Overhead (15% of the price)$630$675+$45
Total cost$3,422$3,891+$469
Profit$778$609-$169
Margin18.5%13.5%

What the sheet says: the job took 14 more labor hours than planned, and the $300 change order did not cover the extra labor and materials it brought. Profit fell from $778 to $609, and margin from 18.5% to 13.5%. The lesson might be that the change order was priced too low, or that the estimate for the helper's hours was short. Either way, you only know because you wrote the numbers down.

A text version

If you would rather keep it in a notes app or an email, copy this:

JOB COSTING: (job name), (customer), job #____

                       ESTIMATE    ACTUAL    DIFFERENCE
Contract price         $_____      $_____
Change orders          $_____      $_____
TOTAL SOLD             $_____      $_____    $_____

Labor (hours x rate)   $_____      $_____
Materials              $_____      $_____
Rentals and subs       $_____      $_____
Fuel, drive, dump      $_____      $_____
Card fees              $_____      $_____
DIRECT COST            $_____      $_____    $_____

Overhead (___% of price) $_____    $_____
TOTAL COST             $_____      $_____    $_____

PROFIT (sold - cost)   $_____      $_____    $_____
MARGIN (profit / sold) ____%       ____%

Next time I will: ____________________

Tips for the sheet

  • Track hours per person, not per job. It tells you who is fast at what, and where your production rates are wrong.
  • Keep the same lines on every job. A pattern only shows when the sheet is the same each time.
  • Compare margin, not profit. A $1,500 profit on a $5,000 job (30%) is not the same as $1,500 on a $15,000 job (10%). See markup vs margin for how the two relate.
  • Look at the ten worst jobs. The jobs that lost money usually have a reason in common: a kind of work, a kind of customer, or a number in your estimate.
  • Feed it back into your estimates. If painting trim always takes 30% longer than you guessed, change the guess.

How Chalk helps

This part is about our software. Skip it if you only want the method.

  • A job profitability report. Reports > Overview has a Jobs card: every job finished in the period you pick, with what it sold for, its direct costs, gross profit, overhead, profit shares and net profit. It shows 25 at a time, can narrow to one job type, one salesperson or the jobs under your margin target, and has a CSV button. Tap a row to open the job. See reports.
  • Costs come from what really happened. Labor comes from the hours your crew clocked, at each person's rate when they clocked in. Materials: until you press Materials are final on the job, its materials cost is the larger of the receipts logged on it and the quote's materials estimate, so one small receipt from the field does not wipe the estimate out. Once they are final, the receipts are the materials cost, even when lower. The report notes any materials still estimated from the quote. See log an expense and attach a receipt photo and clock in and fix timesheets.
  • Other costs on the job. The card fees recorded on its payments, and any payouts split out of the job, count against it too.
  • Overhead and fixed costs. Under Pay > Pay setup, Overhead is a percent of what each job sold for, and Fixed job cost is a dollar amount on every job. Both start at zero, and a job can override them. Labor counts at pay rate, so add your payroll burden through one of those two settings. If you have set them, do not take overhead off the report's profit again when you fill in the sheet.
  • Only what is recorded counts. Hours count only if people clock in on the job, and expenses only if they are filed against it.

Chalk shows the numbers. It does not decide why a job ran over. That is the part where you look at the job and ask.

Sources

  • Labor burden and the $30.91 loaded rate come from our hourly rate guide, which cites the IRS for payroll tax rates.
  • The review example uses made-up hours, costs and an overhead rate of 12%. All math is arithmetic you can check with the markup and margin calculator.
  • The sheet's worked example uses made-up numbers for a deck stain job, and the card fee is 2.9% plus 30 cents. They are not typical figures for any trade or place.
  • Chalk behavior: the Job profitability report and its CSV export, and the job cost rules, are as the app works today.