Short answer
A contractor estimate template in Excel needs line items for materials, crew-hours with a loaded labour rate, an overhead share, a break-even line and a price set by margin. Most free templates stop at quantity x unit price. Example: $4,523.44 of cost at a 30% margin is a $6,462.06 estimate, not the $5,880.47 a 30% markup gives.
- An estimate template needs five blocks: materials lines, labour, overhead share, break-even and price.
- Labour = crew-hours x wage x (1 + burden %). 48 crew-hours at $33.28 is $1,597.44.
- Overhead share = crew-hours x yearly overhead / sellable hours: 48 x $12.00 = $576.00.
- Price = break-even / (1 - margin): $4,523.44 / 0.70 = $6,462.06.
- Keep the internal cost sheet and the client-facing bid sheet on separate tabs.
On this page
- What should a contractor estimate template in Excel include?
- What free estimate templates usually miss
- Worked example: a construction estimate spreadsheet, filled in
- How do I create a construction estimate in Excel?
- Excel formulas for a contractor estimate template
- How do I create a bid sheet? What the client sees vs what you keep
- Free template vs paid template vs estimating software
- Can ChatGPT do construction estimates?
- Step-by-step
- FAQ
What should a contractor estimate template in Excel include?
A usable estimate template has two layers: the internal cost build-up that decides the price, and the client-facing sheet that shows it. Most free downloads only have the second layer, which is why the price in them is a guess.
| Block | Columns or cells | Why it's there |
|---|---|---|
| Job header | Client, site address, date, estimate number, valid-until date | So the estimate can be found and expires |
| Materials lines | Description, quantity, unit, unit cost, line cost | What you pay, including delivery and waste |
| Subs and rentals | Description, quoted cost | Direct costs of this job |
| Labour | Crew-hours, workers, wage, burden % | Loaded cost, not the bare wage |
| Overhead | Yearly overhead, people in the field, billable days | This job's share of running the business |
| Break-even | One cell: labour + materials + subs + overhead | The floor under the price |
| Price | Target margin %, price, profit, markup equivalent | Price set by margin, checked in dollars |
| Terms | Deposit, payment schedule, exclusions, change-order rule | What the client is agreeing to |
I'm not a contractor; I build pricing math. The example below shows every calculation so you can check a template, this one or any other, against it.
What free estimate templates usually miss
Invoice-style estimate templates multiply quantity by a unit price and add tax. They don't load the wage, don't carry overhead and don't set the price by margin, so the total is only as good as the unit prices someone typed in.
- Labour burden. A $26 wage with a 28% burden assumption costs $33.28 an hour. The labor burden calculator guide builds that percentage from payroll lines.
- Overhead share. A job that runs 48 crew-hours uses 48 hours of the truck, insurance and office. Leave it out and it comes out of profit.
- Margin by division. A "markup %" cell applied to cost bills less than the same % as margin: on this job $581.59 less.
Test any template with the calculator below: enter the same job and compare its total with the break-even and price here.
Worked example: a construction estimate spreadsheet, filled in
Two workers for three 8-hour days with $2,350 of materials and disposal comes to a break-even of $4,523.44 and an estimate of $6,462.06 at a 30% margin.
| Line | Cost |
|---|---|
| Lumber and sheet goods | $1,100 |
| Finish materials | $800 |
| Dumpster and disposal | $300 |
| Fasteners, adhesives, consumables | $150 |
| Materials total | $2,350 |
Worked example: Two-person, three-day job estimate (all inputs are example assumptions)
| Item | Value |
|---|---|
| Workers (input) | 2 |
| Hourly wage paid (input) | $26.00 |
| Labour burden % (input) | 28% |
| Materials (input) | $2,350.00 |
| Overhead for the year (input) | $42,240.00 |
| People in the field (input) | 2 |
| Billable days a year (input) | 220 |
| Target margin % (input) | 30% |
| Jobs a week (input) | 1 |
| Hours on the job (input) | 24 |
| Loaded labour rate (per hour) | $33.28 |
| Crew-hours | 48 |
| Labour cost | $1,597.44 |
| Overhead per sellable hour | $12.00 |
| Overhead share | $576.00 |
| Break-even cost | $4,523.44 |
| Price to quote | $6,462.06 |
| Profit on the job | $1,938.62 |
| Price if you MARK UP instead | $5,880.47 |
| Margin you actually keep with markup | 23.08% |
| Lost per job by marking up | $581.59 |
| Lost per year by marking up | $30,242.43 |
Computed with the same formulas as the free calculators on this site. Change any input in the calculator above to see your own numbers.
Working: 2 workers x 24 hours = 48 crew-hours. $26 x 1.28 = $33.28, so labour is $1,597.44. Overhead is $42,240 a year over 2 people x 220 days x 8 hours (3,520 hours) = $12.00 an hour, so the job carries $576.00. Break-even: $1,597.44 + $2,350 + $576.00 = $4,523.44. Price: $4,523.44 / 0.70 = $6,462.06, with $1,938.62 of profit. A 50% deposit on that estimate is $3,231.03.
How do I create a construction estimate in Excel?
Build it on two tabs: a Cost tab that computes break-even and price, and a Bid tab that pulls the totals into a client-ready layout. Six steps get you there.
- On the Cost tab, add a materials table: description, quantity, unit, unit cost, and line cost = quantity x unit cost.
- Add subcontractor and rental lines at quoted cost.
- Add labour inputs: crew-hours, workers, wage, burden %.
- Add overhead inputs: yearly overhead, people in the field, billable days. Compute overhead per hour.
- Compute break-even, then price = break-even / (1 - margin).
- On the Bid tab, reference the price and scope, and add terms, deposit and a valid-until date.
Excel tables (Ctrl+T) help: new materials rows are picked up by the totals automatically. The same layout works in Google Sheets.
Excel formulas for a contractor estimate template
These formulas cover the parts free templates skip. Adjust the cell references to your layout; the notes give the layout they assume.
Materials total
=SUMPRODUCT(C2:C30,E2:E30)C = quantity, E = unit cost, rows 2-30 on the Cost tab.
Loaded labour
=B33*B34*B35*(1+B36)B33 = hours, B34 = workers, B35 = wage, B36 = burden %.
Overhead share
=B33*B34*B37/(B38*B39*8)B37 = yearly overhead, B38 = people in the field, B39 = billable days.
Price from break-even
=B41/(1-B40)B41 = break-even (labour + materials + subs + overhead), B40 = target margin %.
Deposit
=ROUND(B42*B43,2)B42 = price, B43 = deposit % (e.g. 50%).
Keep margin and burden as percentage-formatted cells. A 30 typed where 30% was meant turns the price formula negative.
How do I create a bid sheet? What the client sees vs what you keep
A bid sheet is the client-facing summary of the estimate: scope, price, schedule and terms. It should not show your wage rates, burden, overhead or margin; those stay on the internal cost tab.
| Item | Internal cost tab | Client bid sheet |
|---|---|---|
| Materials lines | Your cost per line | Grouped description, or omitted |
| Labour | Crew-hours, wage, burden | Scope of work in words |
| Overhead and margin | Shown, with break-even | Never shown |
| Price | Computed from break-even | One total, or grouped by phase |
| Terms | - | Deposit, payment schedule, exclusions, valid-until date |
If you split the price into lines for the client, allocate the final price, not your costs, so the lines add up to the total and don't reveal your margin.
Try it with your numbers — free
The free calculator does this whole method in about a minute: loaded labour, overhead share, break-even and the price to quote at your margin. No signup, nothing to download, and your numbers stay in your browser.
Open the free calculator →Get the free spreadsheetWant it built around your own rates, services and branding? Done-for-you custom calculator ($497).
Free template vs paid template vs estimating software
Free templates are fine for layout; check that the math loads labour, carries overhead and prices on margin. Estimating software suits businesses that need takeoffs, cost databases, scheduling or team access. A spreadsheet suits someone who wants every number visible and editable.
| Option | Cost | Good for | Watch for |
|---|---|---|---|
| Free invoice-style templates | Free | Presentation and layout | No burden, overhead or margin logic |
| Free Job Pricing Starter | Free | Loaded labour, overhead, break-even and margin in Excel or Google Sheets | One job per sheet; no line-item bid page |
| Estimating software | Usually a subscription | Takeoffs, cost databases, teams, scheduling | Learning time; check how it applies margin |
| Custom-built estimate workbook | $497 one-time | Your line items, rates, branded quote page with 50% deposit, job log | 2-3 business days to build |
For one quick number, the free job pricing calculator needs no download at all. If you need to track actual costs against the estimate after the job, see the job costing spreadsheet guide.
Can ChatGPT do construction estimates?
An AI chatbot can draft a scope, list likely materials and lay out a template, but it doesn't know your wage, burden, overhead or supplier prices, and it can make arithmetic slips. Use it for the checklist and your spreadsheet for the numbers.
A sensible split: ask it for a materials checklist for the scope, then enter quantities and your supplier's prices into the estimate yourself. Recompute the totals in the sheet rather than trusting a total in chat. The pricing method stays the same either way; how to price a contractor job walks through it, and the markup vs margin guide has the conversion chart for templates that only accept a markup.
Step-by-step: Contractor Estimate Template in Excel: Columns, Formulas and a Free Sheet
- List materials and subs. Enter each line with quantity, unit and unit cost; line cost = quantity x unit cost. Add subcontractor and rental quotes.
- Enter labour inputs. Crew-hours, workers, wage and burden %. Labour = crew-hours x workers x wage x (1 + burden).
- Add the overhead share. Overhead per hour = yearly overhead / (people in the field x billable days x 8); multiply by crew-hours.
- Compute break-even. Add labour, materials, subs and overhead. This cell is the floor under the price.
- Set the price by margin. Price = break-even / (1 - margin). Show profit and the markup equivalent beside it.
- Build the client bid sheet. Pull the price and scope onto a separate tab with deposit, payment schedule, exclusions and a valid-until date.
Run your own numbers — free
The free calculator does this whole method in about a minute: loaded labour, overhead share, break-even and the price to quote at your margin. No signup, nothing to download, and your numbers stay in your browser.
Open the free calculator →Get the free spreadsheetWant it built around your own rates, services and branding? Done-for-you custom calculator ($497).
Frequently asked questions
How do I create a construction estimate in Excel?
Make a Cost tab with materials lines (quantity x unit cost), subs, labour (crew-hours x wage x one plus burden) and an overhead share, add them for break-even, then price = break-even / (1 - margin). Put scope, price and terms on a separate Bid tab for the client.
Can I get a contractor estimate template for free?
Yes. Many sites offer free layouts, and the ProSheet Studio Job Pricing Starter at /free/ is free for Excel and Google Sheets. It covers loaded labour, overhead, break-even and margin pricing on one sheet; a free layout template can then present the result to the client.
What does a bid sheet look like?
A bid sheet shows the client the job header, scope of work, price (one total or grouped by phase), schedule, deposit, payment terms, exclusions and a valid-until date. It leaves out your wage rates, burden, overhead and margin, which stay on your internal cost sheet.
Can ChatGPT do construction estimates?
It can draft a scope and a materials checklist, but it doesn't know your wages, burden, overhead or supplier prices and can make arithmetic slips. Use it for the checklist, then enter your own quantities and costs into a spreadsheet and let the formulas compute the price.
How do I write a bid for contractor work?
Price it first from your costs: break-even is labour, materials, subs and overhead, and the bid is break-even / (1 - margin). Then write the scope in plain words, state what is excluded, set the deposit and payment schedule, and give the bid an expiry date.
What is the best free construction estimating software for Excel?
There isn't one answer; it depends on whether you need takeoffs, a cost database or just correct pricing math. For the math, a spreadsheet that loads labour, carries overhead and prices on margin is enough. Check any tool by entering a job you have already priced by hand.
How do I add profit to an estimate in Excel?
Divide break-even by one minus your margin: =B41/(1-B40). Don't multiply cost by one plus the percentage; that is a markup and keeps less. On this example a 30% markup gives $5,880.47 and keeps 23.08%, versus $6,462.06 at a true 30% margin.
I'm not a contractor, landlord or accountant. I build the pricing maths, and every number on this page shows its working so you can check it instead of trusting it. Watch the breakdowns on YouTube →