Roofing Invoice Template (Free) Excel
A free Excel Roofing invoice with auto-calculating totals, tax and discount rows. Fill in the industry fields and the workbook does the math.
Get the free roofing Excel invoice
Open the generator, fill in your job details, and export a Excel in seconds. Everything stays in your browser.
Why roofers should bill in Excel
An Excel roofing invoice is the working version: totals, tax and discounts calculate themselves, and you keep a running history of every job in one workbook. Formulas add up line items and track what is still unpaid; drop-downs for your usual services keep data entry consistent across months; one workbook per client or per season makes year-end bookkeeping a copy-paste job.
Fields a roofing invoice must include
Every job is different, but these roofing fields belong on the invoice. Keep them on the template so nothing gets missed:
| Field | What to enter |
|---|---|
| Roof area (sq ft / squares) | Square footage or roofing squares (100 sq ft each) |
| Material type | Asphalt shingle, metal, tile or slate — each prices differently |
| Slope factor | Pitch multiplier that raises labor on steep roofs |
| Old roof removal | Tear-off, hauling and disposal of the existing roof |
| Underlayment | Waterproofing felt or synthetic underlayment layer |
| Warranty years | Materials and workmanship warranty term quoted to the owner |
| Worker insurance surcharge | Add-on when extra liability or OSHA compliance is required |
Real scenario: an asphalt shingle re-roof of a 20-square ranch
Roofing invoices are quoted per square with material type, slope and tear-off all affecting the rate, so owners need each factor visible. Here is a worked example using typical roofers pricing:
| Line | Qty | Rate | Amount |
|---|---|---|---|
| Asphalt shingle roof — 20 squares (per square) | 20 | $195 | $3,900.00 |
| Slope factor 6/12 — steep add-on | 1 | $380 | $380.00 |
| Old roof tear-off & hauling | 1 | $900 | $900.00 |
| Synthetic underlayment | 20 | $12 | $240.00 |
| New drip edge & flashing | 1 | $260 | $260.00 |
| Worker insurance surcharge | 1 | $180 | $180.00 |
Subtotal $5,860.00 before tax. The 25-year material warranty and 5-year workmanship warranty are noted on the contract; the insurance surcharge covers the steep-slope work. 50% deposit, balance on completion.
How to make a roofing Excel invoice in 3 steps
Download the workbook
Get the Excel roofing invoice with formulas and drop-downs already set up.
Fill the line items
Enter the Roof area (sq ft / squares), Material type, Slope factor and more lines — totals, tax and discounts update automatically.
Save or print
Print a PDF copy for the client or keep the workbook as your running history per client.
Roofing Excel invoice questions
Do roofers bill by the square or by the hour?
By the square (100 sq ft) is standard for re-roofs; hourly rates appear on small repairs and emergency tarp jobs where measuring is impractical.
Why is there a slope factor?
Steep pitches slow the crew and raise fall-protection costs, so the labor rate carries a multiplier instead of hiding it in the base price.
Should the warranty be on the invoice?
Yes — list the materials warranty and your workmanship warranty term, because the invoice is the record the owner will show a buyer or insurer.
When does tear-off become a separate line?
Always for re-roofs. Tear-off, hauling and disposal are big cost items and owners expect them itemized separately from the new material.