Free template
Gutters estimate and invoice templates
Gutters are priced per linear foot, with downspouts, guards and removal as separate lines. These spreadsheets come set up for that, with working totals, tax and deposit, and an example seamless aluminum gutters and guards to start from.
Free, no sign-up. Works in Excel, Google Sheets and Apple Numbers.
What's in the template
The example line items for a seamless aluminum gutters and guards. Prices are illustrative only; replace them with your own.
| Item | Qty | Unit | Unit price | Taxable | Line total |
|---|---|---|---|---|---|
| Seamless gutter, 6 in. aluminum.032 gauge, hidden hangers | 165 | lf | $11.00 | Y | $1,815.00 |
| Downspouts, 3x4 in.Including elbows and straps | 60 | lf | $9.00 | Y | $540.00 |
| Gutter guardsMicro-mesh, installed | 165 | lf | $9.50 | Y | $1,567.50 |
| Remove old guttersTear-off and haul-away | 165 | lf | $1.50 | N | $247.50 |
| Fascia repair allowanceRotted fascia replaced as found | 12 | lf | $14.00 | Y | $168.00 |
| Subtotal (before tax) | $4,338.00 | ||||
| Deposit (25%) | $1,084.50 | ||||
| Balance | $3,253.50 | ||||
The spreadsheet adds sales tax on lines marked Y once you enter your rate, and has spare rows for more items.
How to use it
- 1Download the template. Download the gutters estimate or invoice (.xlsx). It opens in Excel, Google Sheets and Apple Numbers.
- 2Add your company and customer. Fill in the shaded company, customer and service-address cells, and set the document number and date.
- 3Replace the example lines. The example is a seamless aluminum gutters and guards. Gutters are priced per linear foot, with downspouts, guards and removal as separate lines. Change the items, quantities and unit prices to your own; line totals and the subtotal update automatically.
- 4Set tax and deposit. Mark each line taxable (Y) or not (N), enter your sales tax rate, and set the deposit percent (the example uses 25%).
- 5Review terms and send. Edit the terms to match your policies, save a copy for the customer, and export to PDF to send.
Tips for gutters estimates
- Measure runs along the eaves and enter totals per material.
- Quote guards as an optional line so the customer can add them.
- Use the same template for cleanings with a per-foot or per-story price.
Gutters terms included
- Fascia repairs are billed per foot at the rate shown, only where rot is found.
- Downspout discharge placement is agreed with the homeowner before install.
Plus standard validity and payment terms. Edit all of them to match your policies and local law.
FAQ
Gutters template questions
Have a question we didn't cover? Book a demo and ask a product specialist.
How do I price gutter cleaning with this?
Replace the lines with a cleaning line priced per linear foot or by home size, plus a downspout flush line.
Should fascia repair be on the estimate?
As an allowance, yes. It's common to find rot once old gutters come off.
Do the formulas work in Google Sheets?
Yes. The line totals, subtotal, taxable amount, tax, deposit and balance use standard functions (SUM, SUMIF, ROUND, IF) that work in Excel, Google Sheets and Numbers.
Send estimates customers can approve online.
Homeforce builds estimates from your pricebook, collects deposits, and turns approved work into invoices customers can pay online. We're onboarding early customers now.
Onboarding early customers · Month-to-month · Free data migration