Landscaping Estimate & Bid Template
Free landscaping estimate & bid template (Excel): phase-grouped lines, a formula-driven materials + labor + equipment + markup + overhead + margin + tax roll-up, and a signature line. No signup.
How the bid roll-up is computed
Each line totals (Qty × Unit price) + (Labor hrs × Loaded rate).
The materials, labor, and equipment subtotals then roll up through markup,
overhead, a profit-margin grossup, and tax to a grand total — the corrected
landscape-bid identity:
total_cost = materials + labor + equipment + overhead (then markup + margin)
materials subtotal = Σ (Qty × Unit price) over non-equipment lines
labor subtotal = Σ (Labor hrs × Loaded rate) over all lines
equipment subtotal = Σ (Qty × Unit price) over equipment-flagged lines
markup = markup % × materials subtotal (materials only)
overhead = basis × cost (% of total / % of labor / fixed $)
cost subtotal = materials + labor + equipment + markup + overhead
pre-tax subtotal = cost subtotal / (1 − profit margin) (margin grossup)
tax = tax rate × pre-tax subtotal
grand total = pre-tax subtotal + tax The markup (20–30%), overhead (5–10%), and profit-margin (15–25%
residential) defaults are editable starting points, not prescriptions —
adjust them to your market; the roll-up recomputes from your own numbers.
Equipment-flagged lines route their materials portion to a separate
Equipment subtotal (their labor still counts as labor). Tax defaults
to blank — verify the rate and what's taxable for your area. Every money figure
is rounded to 2 decimals for presentation. (WE-2: six example lines at a 25%
markup roll up to $10,812.50; WE-4: $2,000 materials + 10 h ×
$60 labor, 10% overhead, 20% margin → $3,575.00.)
Nothing is saved. There is no saved-estimate library, no auto-numbering across sessions, no customer database, no payment capture, and no e-signature — just a bid document you fill in and hand off.
A landscape bid is the priced offer you hand the homeowner or property manager the same day you walk the site: every phase of the job — site prep, hardscape, softscape, irrigation, lighting, drainage, cleanup — broken into lines that roll up to a subtotal, markup, overhead, profit, tax, and a grand total they can sign. This is a free, no-signup Excel workbook: download it, type your lines, and the sheet totals everything automatically.
Phase-grouped, with the math wired in
Most free landscape templates make you choose between completeness and a clean
column model. This combines both: a single phase-grouped sheet where each line is
Phase · Description · Qty · Unit · Unit price · Labor hrs · Loaded rate ·
Equipment? · Line total, and the line total is a live formula —
(Qty × Unit price) + (Labor hrs × Loaded rate). The phase cell is a dropdown
seeded with the ten standard phases plus Other, and six example lines ship
greyed in so you see the shape before you overwrite them. Get the quantities
right before you price them — the
material takeoff list template
rolls a whole property’s dimensions into one buy list you can drop straight
into the materials lines here.
The roll-up at the bottom is all formulas, not typed numbers: materials, labor,
and equipment subtotals, then a material markup, overhead, a profit-margin
grossup, and tax, ending at the grand total — plus a deposit line, a balance, and
a client signature line. Flag a line as Equipment and its materials portion
routes to a separate equipment subtotal (its labor still counts as labor), so the
total follows the standard landscape identity:
materials + labor + equipment + overhead, then markup and margin.
Editable defaults, not baked-in quotes
The markup (25%), overhead (8%), and profit margin (20%) that ship in the sheet are editable starting points, not industry benchmarks — adjust them to your market and the roll-up recomputes from your own numbers. The loaded labor rate is defined in the sheet (wage + payroll tax + workers’ comp + benefits, not bare wage) so you don’t quote labor short, and the tax rate defaults to blank — never assume a jurisdiction.
The preview on this page lets you edit the lines and the markup / overhead / margin / tax knobs and watch the roll-up update before you download.
What it is — and isn’t
This is a bid document you own and reuse offline, not estimating software. It is a starting point you adapt — not financial, tax, or legal advice; the pricing ranges are editable defaults, not quotes; verify the rates, markup, and tax for your area. The optional license-number field is organizational only and confers no regulatory sufficiency.
Nothing is saved. There is no saved-estimate library, no cross-session auto-numbering, no customer database, no payment or deposit capture, and no e-signature — just a clean workbook you fill in and hand off. For fast on-screen math, the landscaping estimate calculator is the interactive counterpart; when the job is approved, turn these lines into a bill with the invoice template generator.