How to build construction dashboards owners actually use
A construction dashboard gets used when it answers the owner's three or four standing questions (Do we have cash? Are jobs making money? Is enough work coming?) on one screen, with numbers the owner trusts, clear thresholds, and a weekly meeting where it is the first thing opened.
Plan reviews connect field conditions, drawings, and the next decisions on a job. AI-generated illustration.
Owners use a construction dashboard when it answers their real questions on one screen, the numbers match what the bookkeeper and PMs say, and it is the first thing opened in a regular meeting. Most dashboards fail because they start from the data the software happens to have instead of the decisions the owner has to make. You end up with 30 charts, two of which matter, and an owner who goes back to asking the controller for "the real numbers."
Start with the owner's questions, not the charts
Sit down with the owner and write down the questions they ask every week. In most companies doing $3 million to $30 million, the list looks like this:
Do we have enough cash for the next six weeks of payroll and supplier payments?
Which jobs are making money and which are fading?
Are we billing what we have earned, or carrying work we have not billed?
Who owes us money, and how late is it?
Is enough work coming in to keep crews busy next quarter?
Every chart on the dashboard should answer one of those questions. If a chart does not, it goes on a secondary page or gets deleted.
Define each number in writing. "Gross margin" means projected gross margin at completion from the latest cost-to-complete update, not margin to date. Write the definition next to the chart so nobody argues about it later.
Name the source and the owner of each number. Cash comes from the bank feed, AR aging from accounting, job margin from the PMs' monthly projections. Each number has a person responsible for keeping it current.
Set thresholds. Green, yellow, red only works if the lines are set ahead of time. For example: any job whose projected margin drops more than 3 points from bid turns red.
Show trend, not just today. A single number tells the owner where things are. A 13-week line shows which direction they are going.
Worked example: a $9 million GC's one-page dashboard
Say a general contractor running 11 active jobs builds a dashboard with the seven rows above. In the first week it shows cash at $610,000 with a projected low of $240,000 in week five because two owner payments are expected late. AR over 60 days is $380,000, most of it one retainage balance. Net underbilling across jobs is $145,000, and one $1.4 million medical office job shows projected margin at 8.5 percent against a 13 percent bid.
That one screen gives the owner three actions for the week: call the owner on the retainage balance, ask the PMs why $145,000 of earned work has not been billed, and schedule a cost review on the medical office job. None of it required a chart with 40 lines. The underbilling flag, in particular, is the kind of thing that sits unseen in a spreadsheet; overbilling and underbilling explained with examples covers why it matters.
Get the data right before you design anything
A dashboard is only as good as the data under it. Before building charts, check three things.
Cost codes are consistent across jobs. If one PM codes drywall to 09-200 and another to 09-250, labor and margin comparisons are noise. See how to build a construction cost code structure.
Committed costs are captured. Margin projections that ignore signed subcontracts and open POs look great until the invoices arrive.
PM projections happen on a schedule. If cost-to-complete is updated whenever someone remembers, the job health row is fiction.
Owner, PM, and superintendent views are different
One dashboard for everyone ends up serving no one. The owner needs the company picture and the few jobs that need attention. A project manager needs every line of their own jobs: budget, committed, cost to date, projected cost, open change orders, and what is billed against the schedule of values. A superintendent needs the next three weeks, labor hours against budget for the crews on site, and open RFIs and deliveries. Build the owner's page first, since it is the one that forces the data cleanup, then give each role a filtered view of the same data rather than a separate spreadsheet.
The rule that keeps all three honest is simple: every number on the owner's page must be traceable, in one or two clicks, to the PM's job page and then to the transactions under it. If the owner sees red on a job and the PM's page shows green, fix the definition before adding anything new.
Mistakes to avoid
Too many charts. If the owner has to scroll, the bottom half is never seen.
Vanity metrics. Total revenue year to date is nice to know but rarely changes a decision this week.
No drill-down. When a job turns red, the owner should be one click from the job cost report behind it.
Manual rebuilds. If someone spends Monday morning pasting exports into a spreadsheet, the dashboard dies the first busy week. Automate the feeds or keep the dashboard small enough to update in 15 minutes.
Numbers the PMs do not recognize. Walk each PM through their jobs' numbers before the owner sees them. Surprise data starts arguments, not decisions.
Smart Business Automator provides job costing and WIP views fed from the same project, invoicing, and change order data the team enters every day, so the owner's numbers come from the work itself. See job costing and WIP automation.
Frequently asked questions
What should be on a construction owner's dashboard?+
Usually cash and projected cash, AR aging, over and under billing, projected margin by job, labor hours against budget, backlog, and bid activity. Keep it to the 6 to 8 numbers that drive weekly decisions.
How often should a construction dashboard update?+
Cash, AR, and labor hours weekly. Job margin and WIP usually monthly, with weekly updates on the largest or riskiest jobs.
Can I build a construction dashboard in Excel?+
Yes. Many owners start in a spreadsheet. The risk is the manual work of updating it, so keep it small and automate data feeds when you can.
Why don't owners use the dashboards their software provides?+
Default dashboards show what the software tracks, not what the owner asks. They also often rely on data the team does not keep current, which destroys trust.
Who should own the dashboard?+
One person, usually the controller or office manager, keeps it running. Each number has a named source owner, such as the PM for job projections.
52.3% of construction business owners are over 55. Only 54% have a succession plan. Only 20-30% of listed construction businesses actually sell. The median sale is $825K on $1.5M revenue. This episode covers all 5 exit paths, EBITDA multiples by subsector, and the 7-step preparation timeline every owner needs.
Starts muted when the player comes into view.
Read the full episode transcript
Published transcript from Scaling Legends. It may contain transcription errors. View the source transcript.
Welcome to the Deep Dive. I'm Justine. And I'm Nicole. So imagine pouring 20, maybe 30 years of, you know, just blood, sweat and... absolute grinding stress into building a business from the ground up. Oh, yeah. Weathering the brutal recessions, the supply chain nightmares where materials just vanish for months. Right. You survive all of that and you build a crew that basically feels like family. And then at the very end of it all, it just culminates in a liquidation auction. Wow. Yeah. You lock the doors, you sell off your heavy equipment for, I mean, pennies on the dollar, and you walk away with just a tiny fraction of what your life's work was actually worth. It is a totally devastating image, Justine. But looking at the industry, it's really not an exaggeration. It is the default reality happening
every single day in the construction sector right now. Which is terrifying. It really is. I mean, if we look at the demographic landscape, 52 .3 % of construction business owners are over the age of 55. Yet only 54 % of them have any form of a formalized succession plan. Which makes the failure rate at the finish line just incredibly high. Like only 20 to 30 % of listed construction businesses actually managed to complete a sale. That's a massive drop off. Right. Think about the mechanics of that. 70 to 80 % of the businesses that actively go on the market, you know, they hire a broker, they try to sell, and they just fail to do so. Yeah, they just close up shop. or they liquidate their assets, or they're forced to transfer ownership to someone internally at a massive, catastrophic loss of value. Exactly.
And that mass wave of retiring owners hitting the market all at once, it's going to compress valuations even further for those who just aren't prepared. Oh, without a doubt. So, we're doing this deep dive today to make sure that does not happen to you. Consider this your ultimate 2026 guide to construction succession planning. I love that. Yeah. Our mission today is to unpack the mechanics of a successful exit, ensuring your business becomes a fully funded, stress -free retirement rather than a closed down shop with a padlock on the gate. And to set our baseline today, we're pulling from Smart Business Automator's Market Intelligence Report. Just a quick note up front. Our goal today is to analyze what these sources are arguing about the state of construction exits, not to necessarily endorse their specific financial predictions or take a side. We just
want to decode the realities of the market for you. And the baseline reality is, well, it's sobering. According to Smart Business Automator's market intelligence report. The median construction business sale is only $825 ,000. Wow. Right. And that is on $1 .5 million in annual revenue. Furthermore, the business sits on the market for an agonizing... 207 days. Over six months of limbo? I mean, why does it take so long? Is it just trying to find a buyer or is the actual transaction dragging out? It's the due diligence phase. When a buyer submits a letter of intent, they then spend months just tearing through your financials, your contracts, and your operations. Oh, that sounds exhausting. It is. For 207 days, you still have to run your business at absolute peak performance to prove its value. all while
managing the intense stress of lawyers, accountants, and buyer negotiations. So you can't take your eye off the ball at all. Exactly. If your revenue dips during month four of due diligence, the buyer will use that to slash their offer price. It's a grueling endurance test. So before we even think about who you're going to sell to, we have to understand exactly how buyers calculate your worth in the first place, right? Definitely. Like you wouldn't try to sell a commercial property without getting an appraisal and an inspection. You cannot sell a business without knowing your EBITDA. And more importantly, knowing how a buyer adjusts it. Right. EBITDA. Earnings before interest, taxes, depreciation, and amortization. It is the fundamental metric that buyers use to determine your cash flow. and then they multiply that number
to arrive at your purchase price. But EBITDA in construction isn't just a simple number on a spreadsheet. I look at it like a load -bearing wall in a building. Oh, that's a great way to frame it. yeah like if your entire revenue structure every single dollar of profit you bring in is built on the owner doing absolutely everything that wall is structurally unsound right if you are the one doing all the estimating if you're playing dispatcher every morning and if you're personally putting out every single client fire That valuation collapses the second you walk out the door. It really does. The buyer isn't buying a business. They're just buying a very demanding job. And buyers price that structural integrity directly into the multiple they offer you. And, you know, those multiples vary wildly
based on the size and maturity of the operation. So break that down for us. What does it look like for the smaller guys? Well, for small contractors, those doing zero to one million dollars in revenue. They're rarely valued on an EBITDA multiple at all. Usually a buyer is purchasing them purely on an asset basis. Meaning they're literally just paying the fair market value for your used trucks, your excavators, and your tools. Pretty much. Why won't they pay for the cash flow, though? Because at that size, there is almost always no middle management. The owner is the business. If the owner leaves... the relationships and the operational knowledge leave too. That makes sense. So if they do somehow get an EBITDA multiple, it's a meager two to three times. Okay, so stepping
up to the mid -market, say one to five million in revenue, the multiple bumps up to three to five times EBITDA. But from what I'm reading... At this tier, the quality of your backlog becomes the main obsession for buyers. Oh, absolutely. It's everything. But how does a buyer actually audit a backlog? Because, I mean, I could just show them a list of signed contracts and say, look, we have $3 million in future work. A sophisticated buyer won't just look at the top line contract value. They look at your WIP, your work in progress schedules, and they look specifically for something called margin fade. Margin fade? What is that exactly? They'll look at your historical projects and say, OK, when you bid this job, you projected a 15 profit margin but when you finally closed it out you only made eight percent oh wow okay right so if you have a history of margin fade
The buyer will look at your current $3 million backlog and heavily discount its value, assuming you won't actually realize the profit you're projecting. That makes perfect sense. The buyer is buying your future cash flow, so they have to trust your estimating accuracy. Exactly. Then we hit the upper mid -market, $5 to $25 million in revenue. This is where multiples reach 4 to 7 times EBITDA. Why the big jump? Well, at this level, the business must have a functioning management team to survive. A buyer at this scale cannot personally step in and manage 10 different crews across three counties. Right. They're paying a premium because the systems and the people are in place to generate revenue independent of the founder. But let's look at the outliers here, Nicole, because the specialty trades operate
in a completely different stratosphere. Oh, they really do. If you're in the electrical or civil space, the multiples just defy the standard averages. Electrical contractors are seeing 11 .4 times multiples and civil or heavy construction is hitting 11 .9. It's math. If I'm doing $10 million in revenue as a general contractor, why is an electrical contractor of the exact same size worth more than double my business? It really comes down to... Barriers to entry in labor moats. Heavy, civil, and electrical require highly specialized, licensed labor pools that take years to develop. Plus the equipment. Exactly. They require massive capital investments in specialized equipment, and they deal with intense regulatory and safety compliance. So you can't just spin one up overnight.
No. If a large conglomerate wants to enter a new regional market, they can't just start a competing heavy civil firm from scratch. The friction is way too high. So they pay a massive premium to acquire an existing, well -oiled machine that already holds the licenses, the union relationships, and the specialized fleet. That is fascinating. Yet even within those high multiple sectors, your specific business has value drivers and value killers. What actually moves the needle during a negotiation? Well, value drivers are all about predictability and risk reduction for the buyer. Recurring client relationships are massive. Like maintenance contracts. Yes. If you have master service agreements or guaranteed multi -year maintenance contracts, buyers will pay top dollar because they know the revenue won't just vanish on day one. They also look for CPA -reviewed financials and heavily diversified
revenue. Meaning no single client makes up too much of the pie. Right. If no single client makes up more than 15 % of your total revenue, your multiple goes up. And the value killers. I mean, we touched on key man risk where the owner is the sole linchpin. But what else actively destroys the sale price? Customer concentration is a huge one. If 80 % of your revenue comes from one massive general contractor and that GC decides they just don't like the new owner. The entire business goes bankrupt. Exactly. Buyers will severely penalize you for that. The other massive killer is pending litigation or safety record issues. Wait, wouldn't a buyer just structure the deal so the seller indemnifies them against past lawsuits? Why does it kill the deal entirely? Because indemnification clauses are only as good as the seller's ability
to pay them and lawyers are expensive. Oh, true. A buyer doesn't want to spend their first two years of ownership dealing with depositions for a roof collapse that happened under your watch. Right. Even if you're footing the legal bill. It's a massive distraction. Yeah, nobody wants that headache. Exactly. If due diligence uncovers pending litigation or a terrible OSHA safety record, the buyer will often just walk away entirely. Okay, so assuming you have built a structurally sound business, you've diversified your clients, and you understand your valuation, now you actually have to find a buyer. Who is going to purchase the building? Right. According to the research, there are five doors to the exit and they function very differently. Yes, and the choice of door
dictates not just your payout, but the legacy of your business and your post -sale lifestyle. Let's start with Path 1. This is the third -party sale to a strategic buyer. Yeah, this is usually a larger competitor in your region. They're buying you for your cruise, your regional client list, and your bonding capacity. And you get, what, a three to five times multiple? Generally, yeah. And typically, you can walk away relatively cleanly after a short transition period of maybe six to 12 months. Okay, that sounds ideal for a lot of folks. But Path 2 is where the money gets much bigger, but the strings get tighter. Private equity. Oh, PE firms are highly active right now, rolling up fragmented construction markets. They offer those massive five to eight times multiples. Let me challenge that for a second, though. If I'm an owner in that $10 million range
and a private equity firm is offering me an eight times multiple, why would I ever consider any of the other paths? Why wouldn't everyone just take the biggest check? Because of the golden handcuffs, Justine. Private equity firms usually aren't buying your company to just let it sit there. They are buying it as a platform. A platform. Meaning what? Their model is to buy your solid company and then bolt on five smaller companies to boost the aggregate value and then sell the whole thing again in five years. Oh, I see. And to do that, they need you. The transaction is rarely 100 % cash at closing. A huge chunk of that eight times multiple is tied up in an earn out. So you're stuck there. Yes. You have to stay on as the CEO working under a corporate board and hit aggressive growth targets for the
next three to five years to actually see the rest of your money. If you are burned out and want to move to Florida tomorrow, a P .E. deal will feel like a prison sentence. Wow. OK, so you're trading immediate freedom for maximum lifetime payout. Precisely. That brings us to path three, the ESOP or employee stock ownership plan. This is where your employees actually become the owners of the company. The mechanics of an ESOP are fascinating and they're highly tax advantaged. You basically form a trust. That trust takes out a loan to buy your shares, paying you out. Then the company uses its future tax -free profits to pay back that loan over time. Wait, tax -free? Yeah. If you operate as an S -corporation and transition to an ESOP, the company essentially stops paying federal income tax, and those savings
fund the buyout. That sounds incredible, but there has to be a massive catch. There is. The setup costs are brutal. Forming an ESOP requires specialized lawyers, valuation experts, and trustees. How much are we talking? It can cost anywhere from $100 ,000 to $250 ,000 just to set it up, and there are strict ongoing compliance costs. It really only works for highly profitable, stable firms with 20 or more employees, where preserving the internal culture is the owner's top priority. Which is actually a perfect segue into path four, the management buyout, or MBO. This is the direct alternative to private equity. Your existing leadership team, your project managers, your lead estimators, they buy the business from you. But the multiple is almost always lower. Why
would an owner knowingly take a discount? Well, beyond preserving the legacy and protecting the employees from corporate layoffs, it really comes down to financing mechanics. Your project managers likely do not have $5 million in cash sitting around. Right. And traditional banks will not lend them the full amount based purely on the blue sky value of the business. So to make the deal happen, it is almost always financed by seller notes. Meaning the exiting owner essentially becomes the bank. Exactly. You take a down payment, and then they pay you the rest out of the company's profits over the next five to seven years. So you get a lower initial price and you carry the risk of them running the company well enough to pay you back. Right. But it is often the smoothest, most emotionally satisfying transition for founders who treat their team like family. And speaking of family, Path 5 is the actual family transfer,
passing the business down to the next generation. It sounds like the American dream, but the research shows it's often the most legally complex route. It really is. It requires years of intentional mentoring. You can't just hand your child the keys on Friday and expect the general contractors to trust them on Monday. Right. The relationships don't just transfer automatically. No, they don't. Plus, it involves incredibly dense estate planning, utilizing gift tax exclusions and gradual share transfers to avoid crushing the next generation with tax burdens. And as we mentioned at the start, there's a secret sixth path. And it is the absolute worst one. No plan at all. The liquidation route. Yeah. When an owner faces a sudden health crisis or just absolute burnout without a runway, they are forced to liquidate. The depreciation
recapture hits you on taxes. You get auction prices for your iron. And the millions of dollars of goodwill and brand reputation you built over decades just evaporates into thin air. It's a tragedy when it happens. Which brings us to the execution. Whether you choose the tax -advantaged ESOP, the family transfer, or enduring a private equity earn -out, none of these paths can be pulled off in six months. It's mechanically impossible. The standard in M &A is a rigid five -year timeline. If you want to sell in 2031, you are in year one of the prep phase right now. I view this exactly like site prep on a major commercial build. You know, you can't just show up to a raw sloping dirt lot and try to pour a concrete foundation on day one. No, it would be a disaster. Right. You have to grade the dirt, trench the
utilities, bring in the structural fill, let the soil settle. You have to do the subterranean dirt work years in advance or the whole building sinks under its own weight. And the penalty for skipping that dirt work in a business sale is severe. In year one, your only mandate is to get a formal third -party business valuation. You have to know your baseline number. Why is that so critical in year one? Because you might think your business is worth $10 million, but the valuation comes back at $6 million. You need to know that $4 million gap now, so you have time to change your operations and close it before you want to retire. Okay, so you get that baseline, and you move into year two, which is financial cleanup. What is the actual mechanism here? Why do buyers care so much about how your accountant files your taxes? Because your tax CPA's primary
job has historically been to hide your profit from the IRS to minimize your tax burden. True. They run personal vehicles, country club memberships, and aggressively accelerated depreciation through the business. But a buyer's bank is looking for actual provable cash flow to underwrite the acquisition loan. Ah, I see. If your books are a mess of personal expenses and cash accounting, The buyer's bank will simply refuse to fund the deal. You have to transition to CPA audited or at least reviewed financial statements using accrual accounting. You aren't just cleaning up for the buyer, you're cleaning up for the buyer's bank. Then we hit year three, which I think is the biggest psychological hurdle. Reducing owner dependence. You have to document your internal processes and empower your management team to run the day -to -day
operations. You have to prove the business doesn't collapse if you take a month -long vacation. Right. Which sets up year four, building transferable value. This is where you secure long -term client contracts so the revenue is guaranteed. You renew and expand your bonding capacity, proving to the buyer that the surety company trusts the business, not just your personal guarantee. And you aggressively settle any pending disputes or litigation to offer a clean slate. Finally, year five, engaging a specialized construction M &A advisor. But why can't I just use the local business broker who helped my friend sell his car dealership? Because general brokers do not understand construction accounting. They don't know how to analyze overbillings versus underbillings on a WIP schedule. They don't understand union
liabilities or bonding limits. So they could really mess up the valuation. If they miscalculate your WIP, they will drastically misprice your business. You need an advisor who speaks construction and already knows the strategic buyers operating in your specific trade. And throughout this entire five -year site prep, there is ongoing operational maintenance. You have to keep your fleet right sized and heavily maintained. If a buyer's due diligence team walks your yard and sees deferred maintenance on all your excavators, they immediately deduct the cost of replacing that fleet from your purchase price. It's a dollar for dollar hit. And critically, you have to maintain your backlog, a declining backlog at the moment you try to sell signals to the buyer that the market is drying up. And that is a deal killer. Let's focus on the biggest bottleneck in that timeline,
though. Year three, extracting the owner from the weeds. It is the hardest transition because the founder has spent decades being the chief problem solver. How do you practically achieve that? And the urgency to solve this is very real right now. According to Smart Business Automator's market intelligence report, private construction starts are facing headwinds and Moody's is predicting roughly 50 -50 odds of a recession. That's a scary thought. It is. You absolutely must sell from a position of flawless operational strength. If the market dips and your business relies entirely on your personal hustle to survive, you are trapped. You won't be able to sell and you won't be able to step away. The mechanism to extract the owner is building institutional memory. A buyer wants
to see that the company itself remembers how to operate. And the answer today is technology. You have to systematically digitize your operational knowledge. How does that actually change the buyer's math during due diligence, though? By directly mitigating the buyer's risk. Let's look at financial and schedule oversight. When you adopt a smart operational system, it provides budget and variance insights alongside automated schedule risk detection. It flags cost overruns and material delays automatically. So it's proactive. Exactly. When a buyer's due diligence team looks at your operations, they don't see an owner relying on gut instinct. they see a bulletproof proactive system that catches errors before they erode margins. It essentially removes the owner from having to play air traffic controller every single day. Precisely. If you are leveraging technology
for daily log summaries, automated report generation, and AI -assisted RFI drafting, the heavy administrative lifting is being handled by the system. The project managers are getting automated recaps based on historical project data. The owner isn't spending three hours every morning decoding messy field notes and dispatching crews. Right. And the optics of that are massive. Imagine the document intelligence aspect. When a buyer's team comes in, if they see a chaotic web of the owner's personal emails, physical manila folders stuffed with change orders, and a disjointed spreadsheet from five years ago, they price in massive operational risk. Totally. But if they look under the hood and see smart document organization where anyone in the company can use natural language to search across all project data, specs, and drawings,
they aren't just buying your past relationships. They are buying an API. integrated, scalable machine. They were buying an asset that can scale to double its size without breaking and without them having to personally fix the plumbing. Exactly. Which leads me to a final thought I want you to mull over. We have spent this time decoding multiples, EBITDA, and the mechanics of a five -year exit runway. But consider the macro landscape over the next decade. As millions of boomer -owned construction businesses flood the market, and as the ones who fail to digitize are liquidated or bought for pennies, we're likely going to see a massive consolidation. Unprecedented consolidation. By 2035, we might see the rise of entirely tech -run, decentralized construction conglomerates that operate across dozens of states with ruthless
efficiency. Will the traditional, localized, family -owned contractor who runs everything on paper even exist in 10 years? Or will they be entirely swallowed up by systems -driven operations? It is a profound shift. The barrier to survival won't just be doing good work. It will be proving your business can function as a digitized entity. Which is exactly why you need to start the dirt work now. The ultimate flex as a business owner isn't being the smartest person in the room who solves every fire. The true asset you are selling to a buyer tomorrow is your company's digital and operational memory today. If your knowledge isn't digitized and systematized, you don't own a sellable business. You just own a really demanding, high -paying job. If you know a contractor who is dealing with an agent management team and hasn't thought about their exit strategy, send
them this episode. It could literally save their retirement and preserve their life's work. So true. Hit follow on whatever app you're listening on so you don't miss tomorrow's Intel. And if you want to start building that institutional memory and turning your founder -dependent job into a highly valued sellable asset, you can start that process right now by visiting smartbusinessautomator .com. Do not let 30 years of building end with a padlock on the gate. Start your runway today.