Contractor Job Profitability Comparison Worksheet

Knowing whether your construction business is profitable is only part of the picture. You also need to understand which jobs are producing profit and how their financial results differ.

This worksheet helps you compare job-level profitability information so you can see where performance differs between jobs and identify what deserves a closer look.

Use reliable job-cost and financial information for completed jobs or jobs that can be compared meaningfully. The objective is not to judge a job from one number. It is to organize the financial evidence, compare the results, and identify the next question you need to investigate.

Choose two jobs that will give you a meaningful profitability comparison.

You might compare jobs with similar scopes, customers, contract sizes, or types of work. You can also compare two jobs that produced noticeably different financial results when you want to understand what may have contributed to the difference.

Whenever possible, use completed jobs or jobs that are far enough along for the financial information to provide a useful comparison. Avoid drawing conclusions from jobs that are at substantially different stages of completion.

Use your job-cost and financial information to enter the results for each job.

The purpose is to compare how much revenue each job generated, what it cost to perform the work, and how much gross profit remained after direct job costs.

Use information prepared on a consistent basis for both jobs so the comparison is meaningful.

Do not judge the jobs by revenue alone.

A larger job can generate more gross-profit dollars while producing a lower gross margin. A smaller job may generate fewer gross-profit dollars but retain a larger percentage of its revenue after direct job costs.

Look at revenue, direct job costs, gross profit, and gross margin together before deciding which job performed better.

Now compare the two jobs.

You are not trying to explain every difference yet. First, identify what is actually different in the financial results.

Look at the four measures together so you can see whether one job generated more revenue, carried higher direct job costs, produced more gross-profit dollars, or retained a stronger gross margin.

Revenue and direct job costs help explain how each job produced its gross-profit result.

A job with higher revenue does not automatically perform better if the direct costs required to produce that revenue are also significantly higher.

Compare the two jobs and record what you notice about the relationship between the revenue earned and the direct costs incurred.

Gross profit and gross margin show two different views of job profitability.

Gross profit shows the dollars remaining after direct job costs. Gross margin shows those gross-profit dollars as a percentage of job revenue.

Review both measures together. A larger job may produce more gross-profit dollars while retaining a lower gross margin, so neither measure should be interpreted by itself.

The comparison should help you see which job raises the more important profitability question.

That does not necessarily mean the job with the lower gross profit or gross margin is a bad job. Differences in scope, job size, cost structure, and other factors may affect the result.

Use what you observed to identify the job that deserves further investigation and the financial result that led you there.

A difference in job profitability tells you where to investigate. It does not automatically tell you why the difference exists.

Use the question raised by your comparison to decide what financial information deserves your attention next.

If the job results make you question whether the business is profitable overall:

If a profitable job is not producing the cash you expected:

If the job’s gross margin raises questions about what you charged:

If the job comparison raises broader questions about where the business’s money is going:

Comparing job profitability helps you see which jobs are producing stronger financial results and where important differences deserve investigation.

The objective is not simply to identify the job with the highest revenue, gross profit, or gross margin.

It is to understand what the financial information is telling you, ask better questions about job performance, and use those insights to make better business decisions.