Electrician Estimate Template: Price Book, Invoice & Job Costing

Price electrical work consistently instead of rebuilding every quote from scratch. This electrician estimate template connects a 45-item price book, labor rates, invoices and job costing in Excel or Google Sheets—without monthly estimating software.

Most electrician invoice templates are a blank form. This is the engine behind the form: a real flat rate price book, your labor rates and markup set once, and every quote, invoice and job priced from them automatically. No macros, no login, no monthly fee — you own the file.

WHAT THE ENGINE ACTUALLY DOES
· A 45-item flat rate price book built for electrical work — outlets, GFCI and AFCI protection, dedicated circuits, 200A panel and service upgrades, Level 2 EV chargers, whole-home rewires and more.
· Apprentice, journeyman and master labor rates plus your material markup, set once in Settings — every line prices itself from there.
· A panel upgrade quote or an EV charger estimate in minutes — pick items from the book, set quantities, and the subtotal, tax and deposit calculate themselves.
· Invoice from the same price book and the same formulas — consistent flat rate pricing, no calculator, no manual math.
· A Jobs tab that tracks quote vs actual, profit and margin — with permit and inspection status on the same row.
· An Expenses log that rolls materials and purchases into job costs.
· A job costing dashboard where the tiles reconcile — Revenue minus Material minus Labor equals Gross Profit — alongside margin, win rate and outstanding invoices. The workbook passed 225 automated checks before listing.

THE EIGHT TABS
1. Start Here — a quick setup path
2. Settings — business details, license number, labor rates, markup, tax and deposit defaults
3. Price Book — the 45-item flat rate catalog; edit any price or add your own
4. Estimate — a printable quote that prices off your book
5. Invoice — a printable invoice with a payments-received log
6. Jobs — job tracker and costing: quote vs actual, profit, margin, permit, inspection
7. Expenses — a material and purchase log that rolls into job costs
8. Dashboard — revenue, costs, gross profit, margin, win rate and outstanding invoices, all live
A hidden LISTS tab powers the dropdowns — you never need to touch it.

HOW MUCH IT HOLDS
All 45 price book items are editable — change prices, rename lines, add your own. The included sample workbook shows a fictional electrical business (Bright Spark Electric of Dayton, Ohio) flowing through every tab, so nothing looks empty while you learn the file.

WHAT YOU RECEIVE — ONE ZIP, INSTANT DOWNLOAD
· ElectricianBusinessSystem.xlsx — the full system, all 8 tabs
· A filled sample workbook — explore a fictional electrician's book before you add your own
· User Guide (PDF) — plain English, written for electricians
· Google Sheets Instructions (PDF) — the 30-second import
· Setup Tutorial (MP4) — a short, silent screen walkthrough
· Single-business Licence (PDF) — plain-language terms
· START-HERE.txt — open this first

COMPATIBILITY
Microsoft Excel 2016 or newer, including Microsoft 365, and Google Sheets via a 30-second import — the import instructions PDF is included. No macros, so nothing to enable and no security warnings. Works on Mac and PC. Light blue cells are where you type; white and grey cells calculate; yellow cells are optional overrides.

PAIRS WITH
For the money side of the whole year — overhead, cash flow, profit and loss across every job — see the Contractor Spreadsheet with Job Costing, Profit & Loss and Cash Flow Dashboard in this shop. Bidding bigger construction work? The Construction Bid Template covers takeoff-to-proposal estimating.

FAQ
Q: Will this work in Google Sheets?
A: Yes. It is engineered without macros, and the formulas and dropdowns work after the 30-second import. The included PDF walks you through it.
Q: Is this a subscription?
A: No. One-time purchase, instant download, and the file is yours to keep and use offline.
Q: Does the estimate turn into the invoice automatically?
A: No — the estimate and invoice are two separate printable forms that price off the same price book with the same formulas. Your pricing stays consistent, but changing one never changes the other.
Q: Can I change the prices, rates and markup?
A: Yes. Set them once in Settings and the Price Book and everything updates; override any single line where you need to.
Q: Is the sample data real?
A: No — the sample electrician and jobs are fictional, there so nothing looks empty while you learn the file.
Q: Can I edit the formulas or add my branding?
A: Yes. Tabs are protected with a blank password so a stray click cannot wipe a formula — unprotect any tab in one click, no password needed.
Q: Can my whole team use it?
A: The licence covers one business. A colleague with their own company needs their own copy.

THE FINE PRINT
This is an editable spreadsheet template, not advice — it is not electrical-code, licensing, permit, tax or accounting advice, and the pre-loaded prices are placeholders to replace with your own.
If a file won't open or a formula misbehaves, message me here on Etsy and I'll fix it or replace the file. I read and answer every message myself.
All numbers shown in the images are from a fictional sample business used for demonstration.
Designed and built by me with AI assistance, then tested against independently computed check-numbers before listing.
Microsoft, Excel and Microsoft 365 are trademarks of Microsoft Corporation. Google Sheets is a trademark of Google LLC. This product is an independent template and is not affiliated with, endorsed by, or sponsored by these companies.