Free template
Fencing estimate and invoice templates
Fences are priced per linear foot by style and height, with gates and removal as separate lines. These spreadsheets come set up for that, with working totals, tax and deposit, and an example 6 ft cedar privacy fence, 160 linear feet 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 6 ft cedar privacy fence, 160 linear feet. Prices are illustrative only; replace them with your own.
| Item | Qty | Unit | Unit price | Taxable | Line total |
|---|---|---|---|---|---|
| Cedar privacy fence, 6 ftDog-ear pickets, 3 rails, posts set in concrete | 160 | lf | $38.00 | Y | $6,080.00 |
| Walk gate, 4 ftMatching style with hardware | 1 | ea | $425.00 | Y | $425.00 |
| Double drive gate, 10 ftMatching style with cane bolt | 1 | ea | $950.00 | Y | $950.00 |
| Old fence removalTear-out and haul-away | 140 | lf | $5.00 | N | $700.00 |
| Utility locate811 request and marking review | 1 | ea | $0.00 | N | $0.00 |
| Subtotal (before tax) | $8,155.00 | ||||
| Deposit (40%) | $3,262.00 | ||||
| Balance | $4,893.00 | ||||
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 fencing 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 6 ft cedar privacy fence, 160 linear feet. Fences are priced per linear foot by style and height, with gates 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 40%).
- 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 fencing estimates
- Enter linear feet as measured; the line totals do the rest.
- Quote gates as separate lines. Customers often add or remove them.
- If an HOA has to approve the fence, mention it in Terms.
Fencing terms included
- The property owner is responsible for identifying property lines; a survey is recommended.
- Rock or roots found when digging post holes may add cost, quoted before proceeding.
Plus standard validity and payment terms. Edit all of them to match your policies and local law.
FAQ
Fencing template questions
Have a question we didn't cover? Book a demo and ask a product specialist.
Who is responsible for property lines?
Usually the owner. Saying so in Terms, as the example does, protects you if a neighbor disputes the line.
How do I show different styles?
Duplicate the sheet per style and change the main line's description and rate.
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