Your biggest customer is not automatically your most profitable customer.
A customer relationship can generate substantial Revenue while producing weaker job margins, slower payments, greater Accounts Receivable exposure, or more demands on your team.
This worksheet helps you compare customer relationships using the same types of financial and operating evidence.
The goal is not to rank customers with one score. It is to identify meaningful differences, recognize patterns, and determine what deserves a closer look.
Use completed jobs and reliable financial information whenever possible. Compare customers over a period that gives you enough information to evaluate the relationship rather than relying on one isolated project.
Define the Customers You Are Comparing
Start by identifying the customer relationships you want to review.
Choose customers you can compare using reasonably consistent financial information. They do not need to be identical, but you should understand important differences in the type, size, or complexity of work performed for each customer.
Consider differences such as project type, size, complexity, location, schedule demands, or other factors that could affect the comparison.
Establish the Comparison Period
Customer relationships should be compared using information from a consistent period whenever possible.
A shared review period makes it easier to distinguish actual differences between customers from differences caused simply by looking at different timeframes.
For example, one customer may have more completed work, more active jobs, or a different mix of projects during the period.
Compare Revenue and Job Profitability
Revenue tells you how much work a customer contributes. It does not tell you by itself how profitable that work has been.
Compare Revenue with the profitability of the jobs performed for each customer. Look for differences in Gross Profit, Gross Margin, and actual job performance rather than assuming the customer with the most Revenue creates the most financial value.
Swipe for other customers →
Review Job Performance Across the Relationship
One unusually strong or weak project can distort how you think about an entire customer relationship.
Look across the jobs performed for each customer. Consider whether actual results repeatedly differ from estimates and whether labor, materials, subcontractors, change orders, or other job-cost factors show recurring patterns.
Look for repeated differences between estimated and actual performance rather than treating one unusual job as proof of a customer-wide pattern.
Compare Payment Behavior
A profitable customer relationship can still create financial pressure when payment consistently takes longer.
Review how each customer actually pays. Look beyond the amount billed and consider payment timing, overdue balances, retainage, and whether collection problems repeatedly require additional attention.
Swipe for other customers →
Review Financial Exposure
Customer value is not only about the profit already recorded.
Consider how much money remains tied up in the relationship. Accounts Receivable, retainage, billing timing, and other payment conditions can affect Cash Flow and Working Capital even when the underlying jobs appear profitable.
Swipe for other customers →
Consider Resource Demands
Two customers with similar financial results may place very different demands on the business.
Consider the administrative effort, management attention, scheduling pressure, communication demands, billing complexity, change-order effort, and other resources required to support each relationship.
These factors should add context to the financial evidence. They should not replace it.
Compare the Whole Customer Relationship
Now bring the evidence together.
Do not choose one measure and let it decide the answer. Look at how Revenue, job profitability, payment behavior, financial exposure, and resource demands interact.
The purpose is to understand how the customer relationships differ—not to force every customer into a single score.
Identify the Pattern You Need to Investigate
The comparison becomes useful when it leads to a better question.
Look for differences that repeat across jobs or over time. A pattern may involve profitability, estimating performance, payment timing, receivable exposure, retainage, resource demands, or a combination of factors.
Record what the evidence suggests you should investigate next rather than jumping directly to a conclusion about the customer.
Start With the Customer Profitability Decision
This worksheet is designed to help you apply the customer-profitability framework explained in the primary guide.
If you have not reviewed that framework yet, start there before interpreting the comparison.
Better Customer Decisions Require More Than Revenue
A customer can contribute significant Revenue without necessarily creating the strongest financial relationship for your construction business.
Financial Visibility comes from understanding the larger picture: how the work performs, how reliably the customer pays, how much money remains tied up, and what the relationship requires from the business.
Comparing those factors consistently can help you recognize patterns, ask better questions, and make customer decisions using financial evidence instead of assumptions.
NEED CLEARER FINANCIAL VISIBILITY?
Understand What Your Customer Relationships Are Really Producing
Reliable financial information can help you understand customer profitability, payment patterns, job performance, and the financial pressures affecting your construction business.