Skip to content
Roofer MBA

No Paper, No Roof

On the list of fires: “the sub with no paper

Module 11 · Safety & the Comp Bill · Play 5 of 5

In a hurry? ↓ Do this this week

The problem in one breath

A sub crew you've run for two years pulls into the yard Monday. Somebody asks about his insurance, he says it's all current, he'll email it tonight — and he never does. Five weeks later one of his men comes off a garage roof, the first thing anybody asks you for is what you had on file, and what you have is a text message.

Why it happens

Nobody turns away a crew standing in the yard ready to work. The schedule's tight, the shingles are on site, and paper feels like the office's problem while the roof is the real one. So the certificate gets promised on the phone and nobody chases it. That holds up for years, right until the day it doesn't.

The play

Run the paperwork gate: no sub crew rolls until his paper is on file and the dates are good. It isn't a filing problem — it's your money.

  1. Two certificates before the first job. Current workers' comp and general liability from every sub company you use. "He's run for us for years" is not a certificate, and neither is "he's self-employed" — a genuinely self-employed person with no employees isn't covered by the federal OSH Act, but that says nothing about who carries a claim, and it's no cover for you when your own men are working next to a hazard his work created. The gate belongs to the office, not to a foreman on a roof.
  2. Take the dates off the certificate, not off the phone call. He isn't lying; he doesn't know what his agent did in March. A certificate shows the state of a policy on the day it was issued, not proof it's alive this morning — ask your own agent what notice, if any, you'd get if it lapsed. Type in what the paper says.
  3. One list, with both expiration dates. Every sub company goes on the certificate log, both dates, so a lapse surfaces weeks before the crew is standing in your yard. Read it when you build next week's schedule.
  4. Give the chase to one name. A person, not "the office" — he calls the sub and the sub's agent until the renewal certificate is in hand, with that chase on the promise list (Module 2, Play 1).
  5. Ask your own agent before the season. Straight out: "If an uninsured sub gets hurt on my job, what happens on my policy, and how do you treat what I paid him at audit?" Write the answer down. Your policy language and your state settle that — not a guess in the middle of the season. And what you end up carrying prices every bid (Module 11, Play 3).

Do this this week

Pull the last two jobs a sub crew worked and check the file on each: both certificates, both dates, both good on the day he was on your roof. Half an hour at the filing cabinet. Every hole gets a phone call before you go home.

The tool

Or fill it in here — no download

Opens in Excel, Google Sheets, Numbers or LibreOffice. Grab it on the phone now — it’ll be waiting on the computer at the shop.

the-certificate-log.xlsx — the certificate log. One row per sub company. You type the two expiration dates off his certificates, and the sheet counts the days left on each and puts a flag in the Flag column: NO PAPER when a date is missing, EXPIRED when one has gone by, EXPIRES SOON inside thirty days. A box at the top counts your crews, how many are missing paper, how many are expired, and how many run out inside thirty days. A yellow example row ships filled in — delete it when your first real crew goes in. the sheet notes below has the formulas and the judgment behind them. Print the card below and tape it where the schedule gets built:

THE PAPERWORK GATE — what the office checks before a sub rolls

Sub company: _____________________________   Checked: __________

[ ] Workers' comp certificate on file      expires: ____________
[ ] General liability certificate on file  expires: ____________
[ ] Dates read off the certificate, not off a phone call
[ ] Both dates cover every day he is on our schedule
[ ] Company on the paper = company on his invoice
[ ] Typed into the log     Chasing it: ______________ (one name)

Any box empty, he does not go on the schedule. Make the call first.

If your crew is 1099

Get this line right. There's a test for whether a man is really a sub, every state runs its own, and it comes down to who is actually running his crew. Asking another company for proof of insurance before you hire it is normal business, and that's all this is — a condition in the contract, like a warranty or a finish date. Using the paper as a handle on his men is different: picking who shows up, setting their hours, running them through your training, disciplining them. That's directing his crew, and it's what can cost you his 1099 standing. Set the outcome, the spec, and the site rules that apply to everyone on your job, then let him run his men.

One more thing: this play is how we run a shop — it's not legal advice. Rules change by state and by contract, so before you act on the legal-sounding parts, run them past your own attorney or accountant. It's your business, and what you do with any of this is your call and your responsibility.

The sheet notes

How the sheet works — the columns and the formulas

The columns, the formulas behind them, and the judgment calls — so you can rebuild it by hand if you ever need to.

What it does

One row per sub crew you use. You put in the two expiration dates off their certificates — workers' comp and general liability — and the sheet counts the days left on each, flags anything expired or inside thirty days in red, and flags any crew with a date missing as NO PAPER. The box at the top right tells you in one glance how many crews on your list shouldn't go on next week's schedule until the paper is fixed.

Row 5 is filled in as an example. Delete it before you put your first real crew in.

How to use it

  1. One row per sub company you've used or plan to use. Not per man — per company.
  2. Put the comp cert expires and liability cert expires dates in from the certificate itself, not from what he told you on the phone. The date on the paper is the only date.
  3. Leave a date blank if you don't have that certificate. Blank is the point — it shows up as NO PAPER in red, which is exactly what it is.
  4. Put a real person in Who's chasing it. One name, not "the office."
  5. Look at the sheet the morning you build next week's schedule. Anything red gets a call before it gets a job.

Columns

ColumnWhat it is
A Sub companyThe company on the certificate. If the name on the paper isn't the name on your invoice, that's the first thing to sort out.
B Contact / phoneWho you call about the paper.
C Comp cert expiresThe expiration date on his workers' comp certificate.
D Days leftAuto: days from today to that date. Goes negative once it's past.
E Liability cert expiresThe expiration date on his general liability certificate.
F Days leftAuto: same, for the liability certificate.
G FlagAuto: NO PAPER if either date is missing, EXPIRED if either has passed, EXPIRES SOON inside thirty days, blank when both are current.
H Last job you used him onSo you can see who's actually on your roofs.
I Who's chasing itOne name.

Box on the right: Sub crews on the list, Missing a certificate, Expired, and Expires within 30 days.

Formulas (so you can rebuild it by hand)

  • Days left, comp (D5, fill down): =IF($C5<>"",$C5-TODAY(),"")
  • Days left, liability (F5, fill down): =IF($E5<>"",$E5-TODAY(),"")
  • Flag (G5, fill down): =IF($A5="","",IF(OR($C5="",$E5=""),"NO PAPER",IF(OR($D5<0,$F5<0),"EXPIRED",IF(OR($D5<=30,$F5<=30),"EXPIRES SOON",""))))
  • Box (L4:L7): =COUNTA($A$5:$A$24), =COUNTIF($G$5:$G$24,"NO PAPER"), =COUNTIF($G$5:$G$24,"EXPIRED"), =COUNTIF($G$5:$G$24,"EXPIRES SOON")

Only IF, OR, TODAY, COUNTA and COUNTIF are used, so it opens and computes in old Excel, Numbers, and LibreOffice.

Notes and judgment calls

  • The flag order is deliberate. Missing paper outranks an expired date, and expired outranks expiring soon, because a crew you have no certificate for is the one you know least about.

  • Thirty days is a starting point, not a rule. It's just enough warning to get a renewal certificate before the crew is standing in your yard. Change it in the formula if your renewals run slower.

  • A certificate is a snapshot, not a guarantee. It says a policy existed on the day it was issued. A policy can lapse the week after. That's why the sheet tracks the date and why the serious version of this is asking to be listed as a certificate holder, so you hear from the insurer directly — ask your own agent how that works on your policies.

  • What happens at your premium audit is your carrier's call, not this sheet's. How an uninsured sub's payroll is treated when your policy is audited is set by your policy language and your state's rules. The log exists so you find out before the audit does, not so it can predict the bill.

  • The example row ages. Its dates were real dates when the sheet was built, so in a few months the example will show EXPIRED. That's the sheet working. Delete the row.

  • The list stops at row 24. Every box formula counts rows 5 through 24 only, so a crew typed on row 25 is invisible to the counts while the sheet still looks right. Add rows by right-clicking inside the block and choosing Insert.

  • The sheet ships with its numbers already saved in it, so a phone preview shows real figures; they recalculate the moment you type.

The one thing

Do this this week

Pull the last two jobs a sub crew worked and check the file on each: both certificates, both dates, both good on the day he was on your roof. Half an hour at the filing cabinet. Every hole gets a phone call before you go home.

Take it with you

One email unlocks this and every other sheet and card on the site. The plays stay free.

Same fire

Your workers' comp bill keeps climbing

All the fires →

Fixed this?

Comp rides on your payroll, so a mod you never look at is quietly priced into every bid you write.

The fire right behind it is usually Jobs sell but the profit isn't there.

These plays are how we run a shop — they are not legal, tax, or accounting advice. Rules change by state and by contract, so before you act on the legal-sounding parts, run them past your own attorney or accountant. It's your business, and what you do with any of this is your call and your responsibility.

About this libraryWhat we do with your email