SCHEDULE SAID MINUS $6,200. JOB MADE $11,500.
Everybody argues about percent complete on a WIP schedule. On storm restoration work the field that's wrong is the one to the left of it, because an insurance job's contract value moves twice before the roof is signed off.
A carrier pays a storm job in pieces. The actual cash value comes first. The withheld depreciation comes once the work is complete and documented. Supplements come whenever the adjuster gets to them. A $48,000 roof with $11,000 of depreciation held and a $2,500 deductible pays a first check of $34,500. Post that $34,500 in the contract value column of your WIP schedule against $40,700 of cost, and the job reports 118 percent complete and $6,200 underwater. The true contract value with $4,200 of approved supplements is $52,200, so the job made $11,500 at a 22 percent gross margin. The schedule was wrong by $17,700 on one roof.
Percent complete was right the whole time. The contract value it was measured against was missing two pieces.
This post covers one column of the WIP schedule on one kind of job. That page covers the three things roofing margin is lost to and how the trade is managed. Read CFO for Roofing Contractors for the complete treatment, worked figures included.
WHAT IS THE CONTRACT VALUE ON AN INSURANCE JOB?
On a commercial job it's the number on the subcontract, and nobody thinks twice about typing it into a WIP schedule. A storm restoration job has no subcontract. It has a carrier estimate, a scope of loss, an actual cash value check, a depreciation holdback, a deductible the homeowner owes, and a supplement process that can last for weeks after the crew is off the roof.
So the roofer's office has to pick a number. The number in the file the day the schedule gets built is the first check. It's the only figure that has cleared a bank. Everything else is a claim, an expectation or a request waiting with an adjuster.
That's how the wrong number gets in there. Nobody decided to understate the job. Somebody entered the only figure they could prove.
ONE $48,000 ROOF, THREE DIFFERENT NUMBERS.
Replacement cost value on the carrier's estimate is $48,000. Depreciation withheld is $11,000, released once the work is complete and documented. The homeowner's deductible is $2,500, which the carrier subtracts and the roofer collects. So the first check is $34,500.
The crew does the roof. Cost comes in at $40,700 in materials, labor and burden. That's what a $52,200 job costs at the 22 percent gross roofing subs average at $1M to $5M. Two weeks after completion, the office submits supplements for ridge vent, ice and water shield the original scope missed, and a second layer tear-off. $4,200 of that gets approved.
True contract value is $52,200. True gross profit is $11,500. The WIP schedule built the week the crew came off the roof said $34,500 against $40,700 of cost. That's 118 percent complete and $6,200 in the hole.
WHAT THAT DOES TO THE WHOLE SCHEDULE.
One job wrong by $17,700 is a bookkeeping annoyance. Thirty storm jobs on the same convention is $531,000 of gross profit your own schedule says you never earned.
And the errors all go the same direction. Ordinary estimating misses go both ways. Every insurance job in the schedule is understated by its own depreciation holdback plus its own pending supplements. No job reads high to offset them. The whole storm book reads as a loss.
Then the money is released. Depreciation comes in, supplements get approved, and the next month's schedule turns positive by six figures with nothing different in the field. A roofer looking at those two months side by side has no reason to believe either one.
MOST SUBS MISS THIS: A SCHEDULE NOBODY TRUSTS COSTS MORE THAN NO SCHEDULE.
The $531,000 is the smaller half of the damage. A WIP schedule that jumps around with no explanation stops getting read. The office keeps producing it because the bonding company or the bank asks for it. The owner glances at the bottom line, and every real warning in it goes past unread.
So when a job really does go bad, the schedule says so and nobody reacts. The schedule has cried wolf on thirty storm jobs already. You lose the tool when you need it most, for a reason that has nothing to do with the job that went bad.
Screenshot this for the office. A good WIP schedule is boring. The month it changes by six figures, check the contract value column first. The crews come after that.
HOW TO POST AN INSURANCE JOB CORRECTLY.
Contract value is replacement cost value plus approved supplements. That's it. The depreciation holdback goes in accounts receivable as retention, because that's what it is: money earned and held pending documentation. It doesn't reduce the contract.
Pending supplements get their own column. They stay out of contract value until the adjuster approves them. That gives you a second number to check every month: total supplement dollars pending, and how old the oldest one is. Most roofers have never had that figure, and it's usually bigger than they expect.
The deductible is revenue, and collecting it is your job. Post it in contract value and in receivables, aged from the day the roof was signed off. An uncollected deductible is pure gross profit lost, because the cost of the roof is already spent.
THE ONE THING TO DO THIS WEEK.
Open your current WIP schedule and find every insurance job on it. For each one, write down what the contract value column says, then add the depreciation holdback and any approved supplements.
The total of those additions is what your schedule understates right now. If it's more than one month of your overhead, the schedule you've been giving your banker describes a company that doesn't exist.
