Fence Estimate Template

Quote fence installs by fence type, linear feet, height and gates, including tear-out, permits and HOA approval.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Estimates

Tables

Estimates, Line items

Fields

36

Views

grid, kanban, calendar, form, dashboard

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Estimates

28 fields · 3 sample rows

  • All estimates (Grid)
  • Pipeline (Kanban)
  • Calendar (Calendar)
  • Request an estimate (Form)
  • Dashboard (Dashboard)
EstimateTextClientTextEmailEmailPhonePhoneJob addressAddressFence typeSingle selectLinear feetNumberHeight (ft)NumberGatesNumberRemove old fenceCheckboxHOA approval neededCheckboxStatusSingle selectEstimate dateDateValid untilFormulaDays to expiryFormulaLine itemsLink to another tableItemsCountSubtotalRollupDiscountCurrencyTax ratePercentTaxFormulaTotalFormulaDeposit %PercentDeposit dueFormulaPrepared byTextPhotosAttachmentNotes & termsLong textClient signatureSignature
F-7012 · Miller backyard privacyKaren Miller[email protected]+1 512 555 01474810 Ridgeview Dr, Austin, TX, 78745, USAWood privacy1806.01YesYesSent17 Nov 202617 Dec 202628Cedar privacy panels & rails, Steel posts set in concrete, Install labor, Tear-out & haul-away, Walk gate 4 ft with latch5$8,5378.25%$704$9,24150%$4,621Luis Ortega
F-7013 · Patel pool enclosureNikhil Patel[email protected]+1 512 555 0193219 Bluebonnet Ln, Round Rock, TX, 78664, USAAluminum / wrought iron1204.52Accepted10 Nov 202610 Dec 2026Aluminum pool-code panels, Self-closing pool gates, Install labor, City fence permit4$7,2708.25%$600$7,87040%$3,148Luis Ortega
F-7014 · Greenway Church lotGreenway Community Church[email protected]+1 512 555 01101200 Oak Hollow Rd, Austin, TX, 78748, USAChain link6406.02Draft19 Nov 202619 Dec 2026Galvanized chain link, 9 ga, Install labor2$11,520$250.008.25%$930$12,200
Field details
Estimate · Text
Client · Text
Email · Email
Phone · Phone
Job address · Address
Fence type · Single select
Wood privacy, Chain link, Vinyl, Aluminum / wrought iron, Picket
Linear feet · Number
Height (ft) · Number
Gates · Number
Remove old fence · Checkbox
HOA approval needed · Checkbox
Status · Single select
Requested, Draft, Sent, Accepted, Declined, Expired
Estimate date · Date
Valid until · Formula
IF({Estimate date}, DATEADD({Estimate date}, 30, 'days'), BLANK())
Days to expiry · Formula
IF(AND({Estimate date}, {Status} = 'Sent'), DATETIME_DIFF({Valid until}, TODAY(), 'days'), BLANK())
Line items · Link to another table
Links to Line items
Items · Count
Subtotal · Rollup
sum of Line total via Line items
Discount · Currency
USD
Tax rate · Percent
Tax · Formula
ROUND(({Subtotal} - {Discount}) * {Tax rate}, 2)
Total · Formula
{Subtotal} - {Discount} + {Tax}
Deposit % · Percent
Deposit due · Formula
IF({Deposit %}, ROUND({Total} * {Deposit %}, 2), BLANK())
Prepared by · Text
Photos · Attachment
Notes & terms · Long text
Client signature · Signature

Form view “Free fence estimate” asks for: Client, Email, Phone, Job address, Fence type, Linear feet, Height (ft), Gates, Remove old fence, HOA approval needed, Photos, Notes & terms.

Line items

8 fields · 8 sample rows

  • By estimate (Grid)
  • By category (Grid)
ItemTextEstimateLink to another tableCategorySingle selectQuantityNumberUnitSingle selectUnit priceCurrencyLine totalFormulaDetailsText
Cedar privacy panels & railsF-7012 · Miller backyard privacyMaterials180.00linear ft$22.00$3,960
Steel posts set in concreteF-7012 · Miller backyard privacyMaterials24.00post$38.00$912
Install laborF-7012 · Miller backyard privacyLabor180.00linear ft$14.00$2,520
Tear-out & haul-awayF-7012 · Miller backyard privacyRemoval & haul-away180.00linear ft$4.00$720
Walk gate 4 ft with latchF-7012 · Miller backyard privacyGates & hardware1.00each$425.00$425
Aluminum pool-code panelsF-7013 · Patel pool enclosureMaterials120.00linear ft$34.00$4,080
Self-closing pool gatesF-7013 · Patel pool enclosureGates & hardware2.00each$560.00$1,120
Install laborF-7013 · Patel pool enclosureLabor120.00linear ft$16.00$1,920
Field details
Item · Text
Estimate · Link to another table
Links to Estimates
Category · Single select
Materials, Labor, Gates & hardware, Removal & haul-away, Permits
Quantity · Number
Unit · Single select
linear ft, post, each, hr, lump sum
Unit price · Currency
USD
Line total · Formula
ROUND({Quantity} * {Unit price}, 2)
Details · Text

Fence Estimate Template: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates