Skip to content
True Trade Cost

Roofing Estimate Calculator That Prices Every Roof by the Square

Price every tear-off, re-roof and repair from your own costs, so every roof pays you.

One-time download for Excel and Google Sheets.

Watch it price the example job, start to finish (2:30)

This roofing estimate calculator is a spreadsheet that builds your quote price from your own costs. It is a one-time download for Excel and Google Sheets.

Price tear-offs, re-roofs and repairs from your own costs

You tell it once what your roofing company costs to run. From then on, every roof is priced from your crew, your trucks and your supplier, not from the number another roofer gave a neighbour.

  • Know what an hour on the roof really costs you Rent, insurance, the comp audit, trucks and every wage, yours included, become one break-even rate per billable crew hour.
  • Price the whole roof, not just the shingles Set-up, tear-off, decking, underlayment, shingles, flashing, vents and clean-up each get their own line.
  • Still quote by the square You get the job total and the price per square from the same numbers, so you can compare it with what you are used to charging.
  • Stop paying for the estimate visit yourself Easy-to-miss costs like the climb-and-measure visit, follow-up calls and rain days sit on a checklist that must be answered before the quote is done.
  • Hand the homeowner a clean quote A one-page customer quote with the scope, deposit and roofing terms, ready to print or save as a PDF.
  • See which roofs made money The Job Log keeps every roof you quoted, won or lost, and the crew hours each one really took.
Roofing Pricing Calculator$49.95
Buy now
  • One-time payment, no subscription
  • Instant download
  • Excel and Google Sheets

How it turns squares, pitch and crew hours into a re-roof quote

The file has six tabs. You set up the company once, update shingle and underlayment prices when your supplier changes them, and fill in one Quote per roof.

  1. Start HereThe order to set things up in, from crew and trucks to your supplier's prices. Most roofers finish it in one evening.
  2. Shop SetupYour yearly costs, your crew (you included) and your trucks and hoist, turned into one break-even rate per billable hour on a roof.
  3. Price ListShingles by the square, starter and ridge cap by the bundle, underlayment and ice and water by the roll, drip edge, vents and pipe boots, each with the date you last checked it.
  4. QuoteType the squares and pick the materials, and it adds waste. Add the crew hours for each stage from set-up to clean-up, the dumpster and permit, answer the checklist, and it gives the price and the price per square.
  5. Customer QuoteThe page the homeowner signs: scope of work, price, deposit and your roofing terms.
  6. Job LogAfter the roof is done, the real crew hours go in, so you know whether it paid.

What is a break-even rate? It is what one hour of your crew on a roof has to bring in to pay the wages, the comp and every other cost of the company, before any profit. Estimate visits, time on the road and rain-outs are paid but not billed, so they push the rate up. The true hourly rate guide explains it step by step.

Prefilled example built-in

The file comes filled in with a made-up roofing company and its $14,599 re-roof quote, so you see a finished quote before you type in your own numbers.

The example company is an owner who estimates plus a crew of three, with a break-even of $68.55 per billable crew hour. Its sample job tears off one layer and re-roofs 20 squares at 6/12 pitch with architectural shingles, ice and water at the eaves and valleys, new drip edge, ridge vent and new pipe boots.

AB
1 Part of the price Amount
2 Materials, labour, equipment, dumpster and permit $10,928
3 Easy-to-miss costs $809
4 Markup, cushion and profit $2,862
5 Price to the customer $14,599

That works out to about $730 a square. The $2,862 is left over once every cost is paid, the owner's own wage too, and the crew's time on this roof earns about $101 per labour hour against the $68.55 break-even. How to charge for a roof step by step is on how much to charge for roofing, and how the crew rate is built is on roofer hourly rate and markup.

$809

That is what the easy-to-miss lines alone added to this one example quote. It is about 16 times what the calculator costs. Miss them once and the file has paid for itself.

Roofing Pricing Calculator$49.95
Buy now
  • One-time payment, no subscription
  • Instant download
  • Excel and Google Sheets

Why one price per square loses money on steep and cut-up roofs

Most roofers sell by the square, and many keep one per-square number in their head for every roof. The trouble is that a square only measures area. It says nothing about the pitch, the valleys, a second layer to tear off, or a two-storey drop to the ground.

Take two 20-square roofs. The example's simple 6/12 roof needs about 78 crew hours. Say a steep, cut-up roof of the same size needs 110. At a break-even of $68.55, those extra 32 hours cost about $2,194 before any profit. Quote both at the same price per square and the steep roof hands that money back.

The calculator prices each roof from its own materials and hours first, then shows the price per square at the end. You still give the homeowner a per-square number, but it covers what that roof really takes.

Climb-and-measure visits, rain days and the other roof costs it catches

The Quote tab won't call a quote finished until each of these has a Yes, No or N/A:

  • Climbing, measuring and photographing the roof before you quote, on the roofs you lose as well as the ones you win.
  • Follow-up calls and texts until they sign, hours of the owner's week that belong in the price.
  • The supplier's rooftop drop fee, rarely on the takeoff.
  • Chimney or wall flashing you find bad, noted to the homeowner in writing so the next leak call is not yours to eat.
  • Rain days, when the roof gets tarped and the crew goes home paid.
  • Steep or high roof time, and a rep's commission when a rep sold the job.
  • A leak callback reserve. Left as No in the example on purpose, so the warning stays until you set your own number.

Exactly what you get

A single .xlsx file, yours to download right after checkout. It works in Microsoft Excel and in Google Sheets, with no monthly fee, no app to install and no account to log in to.

  • The six-tab roofing calculator, ready for your crew, trucks and supplier prices.
  • A complete example roofing company, with a finished 20-square re-roof quote to study first.
  • Roofing customer terms you can edit, covering rotten decking found after tear-off, weather delays and extra work, which goes on a written change order.
  • A Job Log and a minimum charge, so small repairs never go out below the trip and you can see which roofs ran over their hours.

How it compares

Most owners price a job one of these ways. Here is what each one gives you.

Copying another company's priceA free estimate templateEstimating softwareThis calculator
Starts from your own costsNoNoVariesYes
Makes you answer the easy-to-miss costsNoNoVariesYes
Shows which jobs made moneyNoNoVariesYes
Works in Excel and Google Sheets–YesNoYes
CostFreeFreeUsually a monthly fee$49.95 once

Who it's for: residential re-roof and repair crews

It fits owner-operators and roofing companies of about 1 to 15 people doing residential tear-offs, re-roofs and repairs, and roofers who price per square from memory and want to know what that number covers. One roofer with a helper or three crews out at once, a patch job or a 40-square house, it works the same way, because the rate and the prices are all yours.

It is not for insurance restoration work priced line by line in Xactimate, large companies already estimating and job costing inside a CRM, or anyone who only wants a free squares calculator. Want your crew rate first? Work it out with the free true hourly rate calculator.

Stop pricing roofs from the number the company down the road uses. Price every re-roof and repair from your own costs, catch what usually gets missed, and see which roofs made money.

Roofing Pricing Calculator

$49.95 one-time

Buy now and download
  • One-time payment, no subscription
  • Instant download
  • Excel and Google Sheets

Questions owners ask

Is this a roofing estimate template or a calculator?

Both. The Quote tab works the price out from your materials, crew hours, outside costs and profit rules, and the Customer Quote tab turns it into a one-page quote. A free template gives you the form; this gives you the number on it.

Does it work in Google Sheets?

Yes. It is one .xlsx file that opens in Excel and in Google Sheets. No app and no login.

Is there a subscription?

No. You pay once, download the file and keep it.

Can I price by the square?

Yes. The Quote tab shows what the finished roof works out to per square. The worked 20-square tear-off comes to about $730 a square.

Are the shingle prices in the file current for my area?

No. The example prices are placeholders so you can see it work. Put in your own supplier prices, and the Price List flags any price that is getting old.

Can I use it for insurance claims priced in Xactimate?

No. It is built for retail re-roofs and repairs priced from your own costs, not line-item insurance estimates.

How long does the roofing calculator take to set up?

About one evening. You fill in Shop Setup and your supplier's prices once. After that, a new roof is the squares, the pitch, the crew hours for each stage and the checklist.

I'm not good with spreadsheets. Can I still use it?

Yes. You type only in the yellow cells and the grey cells do the math. A red cell means a price is old or a checklist line is still unanswered. The example roofing company shows a finished quote to copy from.

Every roof I do is different. Will it still work?

Yes. There is no fixed price per square inside it. Each roof gets its own tear-off, decking, valleys, pitch and crew hours, so a simple ranch and a steep cut-up two-storey are priced from what each one really takes.