Saved in this browser — each rep gets a default branch, so picking them auto-fills it on the estimate.
NELA·Estimator
Materials
$0
Retail Price
$0
$ / Square
$0
GP %
0%
Net Profit
$0
Net %
0%
Estimate Builder
Roof Estimator
Type in the numbers off any Hover measurement report and this builds the full material order, job cost, and retail price — solved to your target gross profit. Every price and formula input is editable, so update supplier costs any time.
01Job Info
Auto-fills on a new blank job, remembered in this browser — edit freely if you need a different number
Drop in a measurement report — PDF or Excel (Hover, EagleView, or RoofR) — to auto-fill the fields below, or type them in by hand as decimal feet (e.g. 182' 7" = 182.58). PDF and Hover's Excel export are both tuned against real reports; still worth a quick glance before trusting it.
or drag & drop the PDF anywhere in this box
Roof Facets total
Ridges 155.08 + Hips 27.5
Combined totals feeding the material calc: —
03Field Shingle
Item
Calc
Area incl. Waste
Qty
Cost
Field Shingles(area × (1+waste)) ÷ 100 → squares → bundles (×3), rounded up
—
—
bundles
$0
Flat / Torch-Down Area (0–1 Pitch)Excluded from field shingle squares above — tracked here so it's easy to order flat roof material separately
—
—
sq ft
—
04Auto-Calculated Materials
Driven directly by the Hover measurements above, using your standard ordering formulas. Quantities and unit prices are both editable — type over any quantity to override it, or hit ↻ to snap it back to the calculated value.
Enter quantities per job. Prices are pre-filled from your Beacon list — edit any of them if you're ordering elsewhere.
Item
Qty
Unit Price
Cost
Manual Material Entries
Description
Qty
Unit Price
Cost
06Materials Subtotal
Total Materials
$0
Supplier Price Comparison
Same quantities, priced under each supplier's sheet — no need to switch the Supplier dropdown to see both.
Supplier
Materials Total
QXO
$0
SRS
$0
07Labor — Insured Contractor Rates
Pull area per pitch tier off the Hover Roof Pitch page and sum into the bands below. Squares include your waste factor from section 01 — same as field shingle ordering. Insured and uninsured use different pitch splits, so switching the dropdown reloads the band structure — re-check your area entries against the new bands.
Drives the Hip & Ridge and Starter labor rate below — same rate table for insured & uninsured
Pitch Band
Area (sq ft)
Area incl. Waste
Squares
Rate / sq
Cost
Total Labor
$0
Hip & Ridge / Starter / Decking Labor
Item
Basis
Squares / Qty
Rate
Cost
Hip & Ridge Labor(hip+ridge length × 1.10) ÷ 100, rate by primary pitch — editable
Decking Install Labor$25 per sheet — pulls qty from Ventilation & Accessories
0 sheets
—
$0
Hip/Ridge + Starter + Decking Labor Subtotal
$0
Total Labor Total Labor (pitch tiers) + Hip/Ridge/Starter/Decking
$0
07bAdditional Labor Items
Manual entry — check the box for anything on this job and set the quantity.
Item
Qty
Rate
Cost
Additional Labor Subtotal
$0
08Job Costs
Its own job cost line — not part of labor
Dumpster, steep add-on, decking repair, etc.
Electrical, gutters, painters, or any other sub brought onto the job
Auto-sets to 0% for Jackson (no material tax there)
Auto-sets to 0% for Shreveport & Jackson, 1% otherwise
Auto-sets to 7% for Jackson — applied to retail + approved supplements, not materials
6% supplement override goes to Dominic as a job cost
09Margin & Overhead Targets
GP target = Net Target + Overhead Rate. Under Profit Split, the company can never net below 15% no matter how low this is set — the rep's split adjusts to protect it, not this floor.
GP and Net calculate from the Insurance Approved Price you entered above
Applied to Total Contract, all branches
Profit Split zeroes out the % commission and pays the PM a share of Net Profit instead
Based on Contract Price minus Referral and Appraisal fees — not the full contract price. Counted as a job cost, reduces Gross Profit.
The PM's share — set to your actual split agreement
09bDescription of Services
This is what shows on the customer-facing estimate — write it the way you'd want the homeowner to read it.
Company Net (GP minus Overhead minus PM's split)$0
Total Job Cost$0
Retail Price$0
+ Supplement Amount$0
Total Contract Price$0
Gross Profit — Contract minus Job Cost
Gross Profit $$0
Gross Profit %0%
Net Profit — Gross Profit minus Overhead
Overhead (21% of contract)$0
Net Profit$0
Net Profit %0%
Contract Info
Contracts
Everything that feeds the Create Contract and Create GoodLeap Contract buttons — kept separate from the estimate so that tab stays focused on numbers and margin.
C0Job Status
Marking a job sold feeds the leaderboard immediately using the contract price. Once Job Closeout is finalized, whatever's entered as Actual Revenue Collected there automatically replaces that number.
✓ Marked Sold — feeding the leaderboard
C1Contract Details
Property, pricing, and payment info for the legal contract.
Combines with Job/Address for the contract's property line
Flows into the contract's color line
Balance due on completion is calculated automatically below
Total Contract Price minus the deposit above — always adds back up to the full total
Only shows on the GoodLeap contract, if filled in
For the Accountant
Job Closeout — Actual vs. Estimate
Once the job is complete and every bill is in, enter the real dollar amounts below. Materials, labor, and misc trades get itemized line by line — everything else is a single actual total. The variance table compares all of it against what was estimated.
C1Variance Summary
Metric
Estimated
Actual
Variance
Total Job Cost
$0
$0
$0
Revenue / Contract Price
$0
$0
$0
Gross Profit $
$0
$0
$0
Gross Profit %
0%
0%
0 pts
Overhead actual revenue × overhead rate
$0
$0
$0
Net Profit $
$0
$0
$0
Net Profit %
0%
0%
0 pts
C2Actual Materials, Labor & Misc Trades
Materials up to 15 lines · Labor and Misc Trades up to 5 lines each.
Materials
Description
Amount
Total
$0
Labor
Description
Amount
Total
$0
Misc Trades
Description
Amount
Total
$0
C3Other Actual Job Costs
Everything else — single dollar totals, not itemized.
Total money in — including any approved supplements
Insurance Supplement Review
Supplements
Drop in the adjuster's scope/Xactimate estimate and the roof measurement report — this checks the scope against Louisiana code, policy, and manufacturer requirements, then drafts a supplement letter. Every flagged item needs a code/policy basis and photo or measurement backup before it goes to a carrier — nothing here should be submitted without that.
S1Job Info
Pulled from the Estimate tab if entered there — edit if this job is different
S2Adjuster Scope / Xactimate Estimate
Drop in the carrier's estimate — PDF export from Xactimate, or an ESX/PDF summary. If you only have a photo of a page, type the line items into the box below instead.
or drag & drop the PDF anywhere in this box
S3Measurement Reports
Drop in the Hover/EagleView/RoofR report(s) for this job — add one per structure if it's a multi-structure property. This is independent from the measurement drop zone on the Estimate tab.
S3bJob Photos
Drop in tear-off/damage photos that back up the items you expect to flag — roof photos are sent to the reviewer alongside the scope and measurements. Large photos are resized automatically before sending.
or drag & drop image files anywhere in this box
S4Generate Supplement
S5Findings & Draft Supplement Letter
Confirm the current code edition and any parish amendments with the local permitting office, attach the manufacturer's install instructions for the specific shingle product where relevant, and only submit items your photos and measurements actually support.
Local Job History
Saved Jobs
Every time you click Save Job, a copy is kept here too — click any job to reopen it. This list lives in this browser only, not shared across devices yet.
No jobs saved yet. Fill out an estimate and click Save Job — it'll show up here automatically.
Customer
Address
Total
Saved
Admin
Settings
Admin
Manage reps, material prices by supplier, and add new materials — no code changes needed for any of this.
A1Sales Reps
Add, edit, or remove reps and their default branch.
A2Add a New Material
Adds a permanent new line item to Ventilation & Accessories on every job going forward — simple quantity × price, no formula.
A3Material Prices by Supplier
Edit the starting price for either supplier — this changes what new jobs default to. A job you've already priced keeps whatever it was set to when you priced it.
Material
QXO
SRS
A4Manage Users
This tool doesn't have real user accounts yet — right now, anyone with the file (or the hosted link, once it's live) can use it. Actually controlling who's allowed in requires Cloudflare Access on the hosted version, which is a separate setup step from anything in this file. Once that's live, user management happens in Cloudflare's own dashboard, not here.
A5Default Labor Rates
Changes what every new job starts with — a job already in progress keeps whatever rate it's currently using.
Labor Item
Default Rate
Sales Performance
Leaderboard
Feeds automatically when a job is marked sold, and updates automatically once Job Closeout's Actual Revenue Collected is entered for that job.
NELA·Estimator