
Estimate, take off, and mark up a job in one workbook. The Bid Calculator tab is where the whole bid gets built. Pick ◯ to start a section and ◆ for each line. Every line carries a cost type, quantity, unit and unit cost, plus its own markup. Codes number themselves, each section adds itself up, and the top of the sheet shows cost by type and one bid price. Uncheck a line and it drops out of the bid without being deleted.
Excel 2010 or newer
Microsoft 365
Excel Table · grows as you add lines
No macros
Nothing locked
Built for any trade that bids line by line. The columns are the same for everyone: cost type, quantity, unit, unit cost and markup. Only the lines change. Pick your trade to see a sample bid.
Sample jobs for illustration. Numbers vary by market.
01
Every line has a cost type: subcontractor, labor, material, equipment or other. The table at the top shows what each one costs and its share of the job before you send a number.
02
Type a markup % on each line. Markup dollars, the price, markup on cost and margin on price all update on their own, so the math is right every time.
03
Pick ◯ to start a section and ◆ for each line. Codes like 02.03 number themselves and every section adds itself up. Uncheck a line and an option drops out of the bid without being deleted.
04
The Proposal tab puts the bid on your letterhead with your logo and one accent color from Setup. Show or hide the line items with one switch. The Terms page prints behind it with a payment schedule and signatures.
Guide
Why I built a construction bid template
Every contractor knows presentation is key. The way you present yourself matters, all the way down to your bid.
Before I joined the family business, my dad wrote his bids in Microsoft Word. It was simple and it got the job done. But it was anything but presentable.
So I put together a bid template, and it had to do two things. It had to be easy to use, and the math had to be automatic. My dad is old school. He doesn't know what a SUMIFS formula is, and he doesn't want to learn Excel. The template had to be dad-proof.
That meant every subtotal adds itself up. Every markup gets applied without anyone touching a formula. And when it's time to print the bid, it's ready to go, on your letterhead, with the terms and a place to sign.
That's what I built.
What is a construction bid?
A construction bid is the price you commit to for a defined scope of work. It's what you send the owner or the GC, usually with the scope, the terms and a date the price is good until.
An estimate is the number underneath it: what you think the job will cost you. Add your markup to the estimate and you have the bid. Most contractors use the two words for the same thing, and this page does too.
There are a few ways to price a bid:
Lump sum: one price for the whole scope. This is what the template builds.
Unit price: a price per unit, like per square foot or per cubic yard, paid on the quantities actually installed.
Cost-plus: your actual cost plus an agreed fee.
Even a lump-sum bid is built from units. You price the slab by the square foot and the grading by the cubic yard, then roll it all up into one number. The template works the same way.
How to write a construction estimate, step by step
Every estimate follows the same steps, whether it's a $9,000 rough-in or a $1.8 million shell.
Break the scope into sections. General conditions, site work, concrete, framing and so on. Each section gets a code, like 02, and each line under it gets its own, like 02.01.
Do the takeoff. A takeoff is counting and measuring the quantities from the plans: cubic yards of grading, square feet of slab, the number of units. It takes the longest, and the rest of the bid depends on it.
Price each line. Quantity times unit cost. Tag each line with the kind of cost it is: subcontractor, labor, material, equipment or other.
Mark up each line. Your own crew's hours carry different risk than a sub's fixed quote. Marking up line by line lets you price that difference instead of putting one percentage on the total.
Price the options separately. Anything the owner might add gets its own line, priced and ready, but left out of the base bid.
Turn it into a proposal. The scope, the price, the terms and a place to sign.
In the template, steps 3 through 6 are the sheet's job. You type the quantity, the unit cost and the markup, and the totals, the proposal and the terms fill themselves in. The takeoff is still yours. The template doesn't measure plans, so you bring the quantities.
A construction bid example with real numbers
Here's the sample bid that comes in the file: Northline Construction bidding a shell and site package for a retail center called Harbor Plaza.
The lines. 23 lines in 6 sections, from general conditions to mechanical and electrical. Two of them, worked out:
Mass grading: 6,800 CY at $9.50 is $64,600. With an 8% markup, the line prices at $69,768.
Superintendent: 26 weeks at $3,200 is $83,200. With a 15% markup, it prices at $95,680.
The totals. The cost is $1,665,955. Markup adds $144,631. The bid price is $1,810,586.
Where the money goes. The top of the sheet splits the cost by type:
Subcontractors: $1,360,975 (82%)
Labor: $172,280 (10%)
Material: $78,800 (5%)
Equipment: $29,600 (2%)
Other: $24,300 (1%)
82% subs means most of this bid rides on other people's numbers. That's worth knowing before you send it. It's also why the markups differ: 8% on most subs, 15% on Northline's own labor, where the risk is theirs.
The options. Three lines are priced but unchecked, so they're not in the $1,810,586:
Sanitary sewer tap: $45,360
Polished concrete finish: $41,958
R-30 insulation upgrade: $28,577
Check the box and an option goes into the bid. Uncheck it and it drops out without being deleted.
Northline won the job, and the owner approved the first two options as change orders. You can follow the same job into the Job Costing Tracker, where they show up as CO-01 and CO-02.
Markup vs. margin: the math that trips up bids
Markup and margin use the same dollars, measured against different numbers.
Markup is profit as a share of your cost.
Margin is profit as a share of the price.
On the sample bid, $144,631 is 8.7% of the $1,665,955 cost, but only 8.0% of the $1,810,586 price. Same money, two percentages.
The gap matters when you have a target. If you want a 10% margin, a 10% markup won't get you there. It gets you 9.1%. You need about 11.1% markup to clear a 10% margin. And the bigger the target, the wider the gap: a 20% margin takes a 25% markup.
The top of the Bid Calculator shows both, markup on cost and margin on price, and updates as you change any line. You never have to do the conversion in your head.
Construction estimate template for Excel: what's in the file
This construction estimate template has five tabs, in the order you use them.
Setup. Your company, license number, logo and one accent color. Fill it in once and every bid picks it up.
Bid Calculator. The estimate itself. Pick ◯ to start a section and ◆ for each line. Every line has a description, cost type, quantity, unit, unit cost and markup. Codes number themselves, sections add themselves up, and the top of the sheet shows cost by type, total markup, markup on cost, margin on price and the bid price.
Proposal. The bid on your letterhead, ready to print.
Terms. The payment schedule, the terms and signature lines, printed behind the proposal.
Export. For after you win the job. More on that below.
Type in the blue cells only. Everything in black calculates, and there are no macros.
Each file holds one bid, with about 500 lines ready to fill. The download comes with a blank file and the Harbor Plaza sample, plus a PDF guide, in two editions: one for Excel 2021 and newer, and one for Excel 2010 and newer.
Whether you call it a bid sheet, a contractor estimate template or a bid calculation sheet, it does the same job: one place where the price gets built and the math is always right.
Estimate templates by trade
The columns are the same for every trade: cost type, quantity, unit, unit cost and markup. Only the lines change. The samples above show it for eight trades:
Roofing estimate: a 32-square re-roof with architectural shingles, bid by the square. Tear-off, shingles, flashing and labor each get their own line. Bid price $15,510.
Plumbing estimate: a two-bath rough-in and trim on a new build, with rough-in, trim-out and the water heater priced on their own. $9,109.
Electrical estimate: a 200A panel upgrade with kitchen circuits. The panel, circuits and devices are on their own lines, with your hours at your labor rate. $8,504.
HVAC estimate: a 3-ton heat pump changeout, with equipment, install and startup broken out. $12,142.
Remodeling estimate: a 180 SF kitchen, with your own crew and your subs on one bid. $30,459.
Concrete estimate: a 1,100 SF driveway and front walk, by the square foot and the yard, with the pump truck and finishing as their own lines. $12,246.
Painting estimate: a 2,400 SF interior repaint. Walls, ceilings and trim by the foot, paint by the gallon. $13,014.
General contractor: a 4,800 SF office fit-out with general conditions, every sub and your own crews, and your fee on top. $186,958.
Landscaping, framing, drywall and flooring work the same way. If you bid it line by line, the template fits.
From estimate to a client-ready proposal
This is the part that replaced the Word document.
The Proposal tab puts the bid on your letterhead, with the logo and accent color from Setup. The client, the project, the bid number, the date and how long the price is good for all come from the Bid Calculator. You type two things on the page: the client's address and the scope of work.
One switch decides how much the client sees. With line items on, every line prints with its price. With them off, the client sees section totals only. Either way, the amounts already include your markup, so the markup itself never shows.
The Terms page prints behind the proposal, with a payment schedule, the terms and signature lines. Print the two together and the pages number themselves.
Estimating software or an Excel template?
Estimating software is worth a look if you bid a lot of work from PDFs. The good ones do digital takeoffs and keep cost databases, and that saves real hours at volume.
For most small contractors, though, it's a monthly fee for features they won't use, plus a program everyone in the office has to learn.
A blank spreadsheet has the opposite problem. It's free and flexible, but nothing stops a subtotal from missing a row or a markup from getting typed over.
This template sits in between. It's Excel, so there's nothing new to learn and nothing to renew. But the formulas are already built and tested: sections total themselves, markups apply line by line, and the proposal prints from the same numbers. It's a dad-proof spreadsheet.
After you win: from bid to budget
A won bid turns into two more documents: the schedule of values you bill from, and the budget you track costs against.
The Export tab lays out the bid's included lines for both, and leaves out the options you didn't include. For the Schedule of Values, each line comes over at its price, so the schedule adds up to the bid. For the Job Costing Tracker, each line comes over at its cost, without markup, as the budget. Each one is a copy and a paste.
The numbers you bid are the numbers you bill and the numbers you track.
Construction bid template FAQ
Is there a free version?
No. It's an Excel file, not software, so there's no way to give you a limited version. Cutting rows, formulas or tabs would just hand you a spreadsheet that doesn't work. You get the whole file as part of the template library: $97, one time, for every template.
Does it work in Google Sheets?
No. It's built for Excel only.
Which versions of Excel?
The download has two editions: one for Excel 2021 and newer, and one for Excel 2010 and newer.
Does it work on a Mac?
Yes, in Excel for Mac.
Does it do takeoffs from plans?
No. You measure the plans and type the quantities. The template handles everything after that.
Can my client see my markup?
No. The proposal shows each line at its price, with the markup already in it.
Can I bid by the square foot, the yard or the hour?
Yes. Pick a unit on each line: EA, LS, SF, SY, CY, LF, HR, DAY, WK or MO. A lump sum works with or without a quantity.
Unlock the library and get this ready-to-use template, with all tabs, formulas, and workflows already connected, plus every other template in the collection.
once
This template plus the other three, built and tested.
- Construction Bid Template
- Job Costing Tracker
- Construction Project Tracker
- Schedule of Values
