Free template: Excel

Free roofing estimate template (Excel)

A roofing estimate spreadsheet with the line items a roof bid needs, squares worked out from plan area and pitch, and live totals.

Free. No sign-up and no email address.

Rather not fill it in? Send the plans and we return the takeoff and estimate. Fixed quote within 2 business hours.

Get a fixed quote

Short answer

A roofing estimate template is a spreadsheet that lists a roof job by line item (tear-off, disposal, underlayment, roofing, flashings, edge metal, ridge and penetrations) with quantity, unit and cost, and totals the price with overhead, profit and tax. The free Bidmere template also works out squares from plan area and pitch.

What is in the free roofing estimate template

The Estimate sheet has one row per line item with quantity, unit, material and labor cost per unit, and formulas for material, labor and line totals. Below the lines it totals the job and adds overhead, profit and sales tax on materials from percentages you enter. No price or percentage is filled in for you.

The Quantities sheet turns each roof plane’s plan area and pitch into roof area and squares: roof area equals plan area times the square root of 1 plus (rise / 12) squared, and a square is 100 SF of roof area, as the National Roofing Contractors Association defines it.

Roofing estimate template line items

Line itemUnit
Tear-off, existing roofingSQ
DisposalLoad
Deck repairSF
UnderlaymentSQ
Ice and water barrierSF
Roofing: shingles or membraneSQ
Starter course, drip edge and edge metalLF
Valley, step and wall flashingLF
Ridge and hip capLF
Pipe boots, penetrations and ventsEA
Equipment, permits and cleanupLS

Short on time? Send the plans and specs and we do this for you. Fixed quote within 2 business hours. Plan review is free, and you pay only after you accept.

Get a fixed quote

How to use it

  1. Enter each roof plane’s plan area and pitch on the Quantities sheet, with your waste.
  2. Copy squares and linear feet to the Estimate sheet.
  3. Enter your material and labor cost per unit.
  4. Enter overhead, profit and tax percentages.
  5. Check the total, then put the price on your proposal or bid form.

Worked example

One plane with 2,000 SF of plan area at a 6/12 pitch: pitch factor 1.118, roof area 2,236 SF, 22.36 squares, so 23 squares to order before waste. Add your waste for hips, valleys and cuts in the waste column.

From template to bid

Use the roofing estimate calculator for a quick check, the contractor markup calculator for overhead and profit, and how to bid a roofing job for the whole method. For a measured takeoff from your plans, see roofing estimating.

Frequently asked questions

How do I estimate a roofing job?

Measure each plane, adjust plan area for pitch, convert to squares (100 SF each), add waste, then price tear-off, disposal, materials, flashings and labor at your rates and add overhead and profit.

What is a square in roofing?

A unit of 100 SF of roof area, as the National Roofing Contractors Association defines it.

Is the template free?

Yes. Download it, change it and use it on your own bids. No sign-up.

Does it work in Google Sheets and Numbers?

Yes. It is a plain .xlsx file with ordinary formulas.

Get a fixed quote

Share the project basics. You get a fixed price and delivery date within 2 business hours. Plan review is free, and you pay only after you accept.

A sentence or two is enough. Leave private rates out of this box.
Add details (optional)
Share a view-only link if you have one. It lets us quote faster; you can also send documents after we reply.

Preparing the form…

* Required. We reply by email within 2 business hours. Plan review and quotes are free.

Sources

Need it done? Fixed price in 2 hoursGet a quote