Free Electrical Estimate Template (Excel, Google Sheets & PDF)
A bid that holds up needs nine things: the client name and job address, a scope description, per-device pricing (receptacles, switches, fixtures, panel), a separate material takeoff, labor hours at your shop rate, a permit allowance, a markup percentage, a contingency line for unknowns, and a validity date (typically 30 days). Below is a free layout for Excel, Google Sheets, or PDF — plus a real rough-in bid broken down device by device.
An electrical estimate is not a guess — it is a takeoff. The bids that win without a race to the bottom, and that still make money once the job starts, price the panel, the devices, and the labor separately instead of quoting a round number off a gut feel. Here is exactly how to build one that a homeowner or GC can trust and that protects your margin.
What every electrical estimate needs
Leave one of these off and you either lose the bid to a clearer one or eat the difference mid-job:
- Client name, job address, and a dated scope of work — specific enough that a change order is obvious later.
- Per-device pricing: a unit price for each receptacle, switch, fixture, and smoke detector, multiplied by a counted quantity — not a lump-sum guess.
- A separate material takeoff for wire, boxes, panel, breakers, and miscellaneous hardware, priced at your supply-house cost.
- Labor hours at your real crew size and hourly shop rate, not a flat day-rate that hides under- or over-staffing.
- A permit allowance for any job that will pull one.
- Markup for overhead and profit, shown as its own line so the client sees it is not padding the labor rate.
- A contingency line (5–10%) for hidden conditions — undersized existing wiring, an aluminum feed, an attic that turns out to be foam-insulated.
- A validity date, usually 30 days, since material prices move.
A real electrical estimate, line by line (new-construction rough-in)
Here is how a 1,800 sq ft, 3-bed/2-bath new-construction rough-in prices out at the device level:
| Line item | Detail | Amount |
|---|---|---|
| Receptacles (42 @ $28) | standard duplex, code-height | $1,176 |
| Switches (18 @ $32) | single-pole and 3-way | $576 |
| Recessed/can lights (14 @ $45) | 6-inch LED housings | $630 |
| Ceiling fan/light boxes (5 @ $60) | rated boxes with blocking | $300 |
| Main panel & breakers | 200A, 30-space panel | $950 |
| Hardwired smoke/CO (6 @ $85) | interconnected, battery backup | $510 |
| Material takeoff | wire, boxes, staples, misc. | $1,850 |
| Labor (72 hrs @ $85/hr) | 3 electricians, 3 days | $6,120 |
| Permit & inspection | city electrical permit | $275 |
| Subtotal | $12,387 | |
| Markup (12%) | overhead & profit | $1,486 |
| Contingency (5%) | unforeseen conditions | $619 |
| Total bid | $14,492 |
Pricing the devices, materials, and labor as separate lines means the client can see exactly what the $14,492 buys, and it gives you a clean audit trail if the scope changes — add three receptacles mid-job and the change order is $84 plus labor, not a renegotiation of the whole bid.
Per-device pricing vs. a flat bid
Per-device pricing (a set price per receptacle, switch, or fixture) is faster to build for repeatable residential work and easy for a GC to sanity-check against a plan set. A flat bid — one number for the whole rough-in — reads cleaner on a one-page proposal but hides your assumptions; if the plan changes, you have no line to point to. Most electricians price commercial and custom work per-device internally, then present the client a flat total with the device breakdown available on request.
Contractor Estimate & Bid Calculator (Excel, Google Sheets & PDF)
The same per-device, material-takeoff, and markup structure above — already built with auto-totaling, a contingency slider, and a 30-day validity field. Works for electrical, HVAC, or concrete bids. Instant download.
Markup, contingency, and where bids leave money on the table
Most electricians run 10–20% markup on a rough-in bid to cover overhead and profit — too thin and a single callback erases it, too high and you lose bids you should win. Layer a separate 5–10% contingency on top for the things a walkthrough cannot catch: an underspec’d panel, framing that is not square, or an inspector who wants an extra AFCI breaker. Quote the contingency as its own line rather than folding it into markup — it is easier to defend to a client and easier to track against actual cost once the job closes.
Load calcs and permits belong in the bid, not after it
On a service change or new panel, a quick load calculation confirming the panel size is adequate for the home’s square footage and appliance load should be a line item, not an assumption — it is the difference between a bid that survives inspection and a change order mid-rough-in. Same with the permit: price it as its own line at your jurisdiction’s actual fee schedule, not a round-number guess, so the client is not surprised when the number matches the receipt.
Once the job’s done, the bid becomes the invoice: send an itemized electrical invoice that mirrors the same device counts and line items the client already approved — nothing to re-explain, nothing to argue.
Frequently asked questions
How do I price electrical work per device?
Set a unit price for each device type (receptacle, switch, fixture, smoke detector) based on your typical material and labor cost per install, then multiply by the counted quantity from the plan or walkthrough. List the count so the client can verify it.
What markup should electricians use on a bid?
10 to 20 percent is typical for overhead and profit on a rough-in or service upgrade. Show it as its own line rather than folding it into labor so the client sees what it covers.
Should I include a contingency line on an electrical estimate?
Yes, 5 to 10 percent is standard for conditions a walkthrough cannot fully verify — existing wiring condition, framing issues, or an inspector requiring an extra circuit. Keep it separate from markup.
How long should an electrical estimate stay valid?
30 days is standard. Material prices, especially copper wire and panels, move enough that a bid older than a month should be re-priced before you honor it.
Flat bid or per-device pricing for a rough-in?
Per-device pricing is easier to defend and adjust if the scope changes; a flat bid reads cleaner but hides your assumptions. Many electricians build the estimate per-device, then present a flat total with the breakdown available if asked.
Get the Tuesday Template
One field-tested back-office template and a get-paid-faster tip in your inbox each week. No fluff.