The Waterfall

The business looked healthy.

The sales team was closing. Lead volume was stable. Monthly revenue was hitting plan. The operator had been in home improvement for eleven years. He understood his numbers. He ran weekly sales meetings. He reviewed his CRM every Monday morning.

Then someone built the waterfall.

Not a dashboard. Not a new report. A single document that tracked what happened to every dollar of contract value signed in a ninety-day period, from signature to deposited cash.

The picture that emerged was not the picture the monthly close had been producing.

Most home improvement operators have never seen a waterfall.

Not because the concept is complicated. Because no one in the industry talks about it. The vocabulary of home improvement operations runs on close rate, CPL, monthly revenue, and cancel rate. These are activity metrics. They measure what happened at a point in time.

A waterfall measures something different.

It measures what happened to a cohort of contracts over time.

The distinction sounds subtle. It is not.

Here is how the waterfall works.

Start with every contract signed in a given period. Call it ninety days. That pool of signed contracts represents a total contract value. Call it the starting point.

Now track what happens to that contract value as it moves through the operation.

Stage One: Pre-Contract Dropout

Not every signed contract survives the rescission window. Buyers change their minds. Financing falls through at first application. A spouse who wasn't present at the appointment becomes involved and objects. Some percentage of what was signed never becomes a real job.

Most operators know their cancel rate. Few track it by stage. Pre-contract dropout is the first exit point in the waterfall. It happens within days of signature. The acquisition cost is fully sunk.

Stage Two: Finance Fallout

Financing-contingent contracts face a second exit point. The application goes through. The approval comes back conditional or denied. The job falls out. The operator didn't know this was happening at a meaningful rate because the CRM showed the contract as closed. Operations knew. Finance knew. Sales didn't.

This is Wall One of the visibility problem. The data exists. It lives in a different system than the number being managed.

Stage Three: Pre-Install Cancellation

The contract survived rescission. Financing was approved. The job was scheduled. Then it cancelled.

This is the most expensive stage in the waterfall. Every acquisition cost has been incurred. Scheduling resources have been consumed. The job is on the calendar, then it is not. The revenue was real until it wasn't.

Pre-install cancellation is where the waterfall diverges most sharply from what the monthly close reports. A job cancelled the week before installation was never in the revenue number. But the cost to acquire it was.

Stage Four: Post-Install Dispute and Refund

The job was installed. The revenue was recognized. Then a dispute arose. A partial refund was issued. A chargeback was processed. The revenue that was booked is now partially reversed.

This stage is the smallest in most operations. It is also the most invisible. Revenue that has already been recognized and partially reversed creates a distortion in the financial picture that most monthly reporting never fully resolves.

When the operator saw his waterfall for the first time, the number that stopped him was not the total.

It was Stage Three.

Pre-install cancellation was running at 9% of his total signed contract value. Not 9% of his reported cancel rate. 9% of total signed value was reaching the installation stage and falling out before a crew arrived.

He had been tracking cancel rate as a single blended number. The blended number was 18%. He had been managing toward 18% for two years. He had run training sessions on it. He had adjusted his sales process around it. He had hired a sales manager specifically to address it.

The 18% was accurate.

It was also useless.

Because it told him that cancellations were happening. It did not tell him where. And Stage Three cancellations require a completely different intervention than Stage One cancellations.

Stage One is a sales process problem. Qualification is failing. Buyers are being signed who are not ready to buy.

Stage Three is an operations problem. Something is happening between signature and installation that is breaking the customer's commitment. Scheduling delays. Communication gaps. Timeline misalignment. The job was sold correctly and lost operationally.

These are not the same problem. The same metric was masking both of them.

The waterfall does something that close rate, cancel rate, and monthly revenue cannot do.

It shows where the money exits.

Not that money exits. Where.

Every stage of the waterfall has a different cause. Every cause has a different intervention. Every intervention requires a different owner. Sales owns Stage One. Finance owns Stage Two. Operations owns Stage Three. Customer service owns Stage Four.

When cancel rate is reported as a single blended number, none of those owners can see their contribution to the problem. When the waterfall is built, each stage becomes attributable. Each owner can see what they are responsible for and what they are producing.

This is what institutional operators mean when they talk about visibility.

Not more data. Not better dashboards.

The ability to see where value exits the system before the monthly close explains it away.

Building the waterfall requires connecting three data sources most home improvement operations have never linked.

The CRM holds contract signatures and early dropout. The financing platform holds approval, conditional approval, and denial data. The operations system holds scheduling, installation completion, and cancellation events with dates and reasons.

Each system was built for a different purpose. None was built to produce the waterfall. The connection is manual, analytical, and invisible to any single department.

This is why most operators have never seen their waterfall. Not because the data doesn't exist. Because no one has connected it.

The operator who saw his waterfall for the first time did not discover a new problem. He discovered where a problem he already knew about was actually living. The cancel rate didn't change. His understanding of it did.

That understanding is worth more than the rate itself.

Most operators can tell you what they sold.

Few can tell you what survived.

The waterfall exists to answer the second question.

Settlement reporting closes the month. The waterfall reveals what the month was actually made of.

Those are not the same thing.