The tool, in your browser
The supplement worksheet
One row per line item the roof actually needs. Write what the carrier allowed and what the item really takes, and the page works out the gap — the money you’re supplementing for. It handles both cases the same way: an item their estimate missed entirely, and one they listed but under-priced. Two boxes split the gap by where it stands, so one glance tells you how much you’ve clawed back and how much you’re still fighting for.
Free, and it asks for nothing. No email, no account, no sign-up. What you type stays in this browser on this device.
Read this first
This page holds one job at a time. The file is one copy per claim, and that is a real advantage of the download — you keep last month’s Reyes claim in a folder while you work this month’s. Here, clearing the worksheet to start the next roof takes the last one with it. Fill in the job and claim number at the top so the saved copy still tells you whose roof it is, and download the-supplement-worksheet.xlsx for the ones you need to keep.
And it only knows about this browser. Nothing you type is sent to us and nothing syncs, so the phone and the shop computer each keep their own copy — and anyone who opens this page on that computer can read the homeowner’s name, the claim number and every figure on it.
The worksheet fills in right here in your browser. If this line stays put, JavaScript is off — the spreadsheet below does the same job.
How it gets used
- Pull one open storm job and name it at the top. Put the carrier’s estimate next to what the roof actually takes.
- Start with what the estimate is missing — ice-and-water, drip edge, starter, steep or two-story charge, flashing, code items. Leave Carrier $ blank on those and the whole value shows as the gap.
- Proof is the whole game. The adjuster can add what you show him, not what you claim. Photo, measurement, code requirement, manufacturer spec — if that box is empty, the item isn’t ready to submit.
- Set the answer as the adjuster responds. Only approved moves money into “won”. Pending and denied both stay open, because a denied item often gets approved on a second, better-documented try — resend it with more proof.
Where these numbers go next
An approved supplement moves two boxes on another sheet
When a line item comes back approved, that money is on the claim. If you track the job on the depreciation tracker, raise the total claim (RCV) there by the approved amount and raise received so far when the check for it lands. Raise only one and the held figure moves by the size of the supplement for no reason. Type it across yourself. These tools don’t read each other on purpose: on paper you copy a number between two sheets and you can see what you copied, and nothing here quietly changes a figure on a page you aren’t looking at.
Before you act on it
It tracks the gap; it prices nothing
Carrier $ and your $ are both numbers you type. What a line item is worth is your call and your local pricing — the page only does the subtraction and the totals. It has no price list in it and never will.
This is the line-item supplement. The ACV/RCV split — the first check and the depreciation released after the work is proven — is job-level, and its timing is carrier- and policy-specific. Keep those figures in the notes column per job and read the play for what they mean.
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.
Want it in a spreadsheet?
The same worksheet as a spreadsheet
the-supplement-worksheet.xlsx is this worksheet as a spreadsheet — same columns, same gap, same two boxes — for the computer at the office. Five differences in the page’s favour: there’s no ten-item ceiling on what gets totalled; the example rows are placeholder text here, so there’s nothing to delete before you start; the two Yes/No columns open on not marked rather than answering for you; an amount that isn’t a number says so and is left out of the gap, where the file would total around it; and it counts the items with a gap and no proof behind them, which the file leaves you to notice. Two the other way: the file is one copy per claim, so last month’s job is still in the folder while you work this one, and it opens on any computer you send it to. The sheets ask for your email once; this page never does.
The play behind it — M6-08 The Carrier's First Number Is a Starting Point, Not the Check — is how the scope gets corrected, and what the adjuster can and can't add, and the sheet notes spell out every column and formula.