Excel Invoice Template for Electricians
An electrical invoice carries more than labor and parts. There is a permit fee you fronted and need back at cost. There is material you marked up, and a customer who may ask what the markup was. There is an inspection that has not happened yet, and a job that cannot be closed out until it does. A generic invoice template has a column for description and a column for amount, and no idea what to do with any of that.
What an electrician’s invoice needs that a generic template does not
Permit fees are pass-through, and they need to look like it. You paid the county, you are getting reimbursed, and there is no margin on it. If that line is buried among your marked-up material, a customer comparing bids reasonably wonders whether you are making money on the permit. Showing it as its own line at cost removes the question before it gets asked. It also keeps your own numbers honest, because a job with a $185 permit in it did not earn $185 more than a job without one.
Material markup has to be deliberate, not accidental. Most electrical work bills material at a markup over supply-house cost, and the percentage is a real business decision. The problem with a template is that the markup lives in your head or in a separate spreadsheet, and by the time you have typed the customer price into the invoice, the original cost is gone. Six months later you cannot tell whether that job actually cleared what you thought it did.
The invoice is part of the paper trail. Circuit numbers, breaker sizes, wire gauge, panel location, permit number, inspection date. Some of that matters to the homeowner selling the house in three years, some of it matters to you when you are called back to the same panel. A generic template gives you a notes field, and most people leave it empty because there is nowhere sensible to put any of it.
Three kinds of electrical job, three different documents
Service and troubleshooting calls
A breaker keeps tripping, half the kitchen is dead, the outdoor outlet stopped working. These bill as a service call plus time plus whatever got replaced. The customer usually has not budgeted for it and is looking at the invoice closely, so the diagnostic time needs to be visible as work performed rather than an unexplained hour of labor.
Additions and installs
New circuits, added outlets, ceiling fans, EV charger installs, generator interlocks, hot tub disconnects. These are quoted up front, usually flat, and the customer is deciding between you and someone else. What separates the winning quote is often not price but clarity: what is included, what is not, whether the permit is in the number, and whether they are paying for a return trip when the inspector comes.
Panel upgrades, rewires, and new construction
Bigger jobs, longer timelines, and money that moves in stages. A deposit up front, progress billing through the work, a final invoice after inspection passes. New construction adds rough-in and trim-out as separate billing events, sometimes months apart, on the same job. This is where a folder full of one-off template files stops being workable, because you need to know what has been billed, what has been paid, and what is still outstanding across a job that is not finished yet.
Line items electricians actually bill
- Service and labor — service call, troubleshooting or diagnostic time, standard hourly, after-hours and emergency rates, apprentice rate, return trip for inspection
- Permits and fees — county or city electrical permit, inspection fee, utility disconnect and reconnect coordination
- Panel and service — load centers by amperage, main breakers, service mast and weatherhead, meter can, grounding electrode and conductor, surge protection
- Circuits and devices — breakers by amperage and type, GFCI and AFCI devices, receptacles, switches, dimmers, junction boxes, cover plates
- Wire and conduit — NM cable by gauge, THHN, MC, EMT and fittings, PVC, wire nuts and connectors
- Fixtures and equipment — ceiling fans, recessed cans, exterior and security lighting, EV charging equipment, generator interlocks and transfer switches, disconnects
Most of these repeat on job after job at the same price. The value of having them saved is that the twelfth panel upgrade is priced the way the first one was, and you can look back at a year of them and see what the job is really worth.
What a panel upgrade invoice looks like
A residential 200A service upgrade, itemized. The five columns on the left are what the customer receives. The three on the right stay in your workbook and never print.
| SKU | Description | Qty | Price | Amount | Taxable | Cost | Margin |
|---|---|---|---|---|---|---|---|
| PRM-CTY | County electrical permit (at cost) | 1 | 185.00 | 185.00 | ☐ | 185.00 | 0.00 |
| LBR-ELEC | Electrician labor — service upgrade | 8 | 105.00 | 840.00 | ☐ | 48.00 | 456.00 |
| ELE-PNL200 | 200A load center with main breaker | 1 | 420.00 | 420.00 | ☑ | 265.00 | 155.00 |
| ELE-BRKR20 | 20A single-pole breaker | 12 | 18.00 | 216.00 | ☑ | 9.50 | 102.00 |
| ELE-MAST | Service mast and weatherhead | 1 | 240.00 | 240.00 | ☑ | 155.00 | 85.00 |
| ELE-GRND | Grounding electrode and conductor | 1 | 95.00 | 95.00 | ☑ | 52.00 | 43.00 |
| Subtotal | 1,996.00 | — | 1,155.00 | 841.00 | |||
| Tax (6.5%, taxable lines only) | 63.12 | — | — | — | |||
| Total | 2,059.12 | Profit $841 (42.1%) | |||||
Permit #EL-2026-4471. Existing 100A fused service replaced with 200A load center. Twelve circuits transferred and labeled. Grounding electrode installed to current code. Final inspection scheduled. Workmanship warranted 2 years; equipment per manufacturer.
Three things there that a generic template cannot do. The permit sits at cost with no margin, so nobody has to wonder. Tax applies only to the lines that should carry it, rather than one rate smeared across the whole document. And the cost and margin sit beside every line where you can see them and the customer never will.
That last column is also where the markup question gets settled. Each line can be priced four different ways: enter the customer price directly, apply a markup percentage over your cost, work backward from a target margin percentage, or add a flat dollar markup. Set one mode for the whole document, or vary it line by line — permits at cost, material at your standard markup, labor priced directly. The printed invoice looks identical no matter which you used. The difference is that six months later you can still see what each line cost you and what it earned.
Where the template approach breaks down
Nothing above is difficult on a single invoice. It gets difficult on the two hundredth.
Your supply house prices change and your saved markup does not follow. The same customer calls back and you retype their address. A panel upgrade quoted in March becomes an invoice in April and you rebuild the whole document to do it. A deposit comes in and lives in your head until it does not. And when someone asks what you actually made on service work last year, the answer is spread across two hundred files with no way to add them up.
What we built instead
EG Quote & Invoice is a macro-enabled Excel workbook that turns Excel into an actual quoting and invoicing application. It keeps a client list and a priced catalog of your labor, material, and equipment, so the twelfth panel upgrade is priced like the first. It converts a won quote into an invoice in one click, records deposits and partial payments against it, and shows your margin on every line before you send it.
It runs on your own PC. No account, no cloud, no subscription. The free edition has no limit on how many quotes or invoices you create and does not expire.
See EG Quote & InvoiceFree edition · Windows Excel · 32-bit and 64-bit
Other trades: Browse all invoice templates by trade →
★★★★★
“David is a 10/10 pro. He asked all the right questions prior to getting the project started and once everything was set, he was quick and diligent with working through this complex project… he is clearly an expert in this field.”
Dashboard development client · via Upwork, 2024
5.0★ across 230+ client reviews · 100% Job Success on Upwork · Building Excel tools since 2010 · Read the reviews →