Flat-Rate Price Book Builder for Electricians (Excel + Sheets)

Your overhead and salary in. A 75-task flat-rate price book out. One-time purchase, no software.

$39 one time

30-day money-back guarantee. Works in Excel 2016+ and Google Sheets. No macros, nothing protected, no subscription.

Price Book tab: 75 tasks priced in Easy, Normal and Hard grades

An overhead problem you cannot see

Most one-person electrical shops do not have a pricing problem. They have an overhead problem they cannot see. The truck, the insurance, the phone, the tools that walk off, the two hours a day nobody pays for - none of it shows up on an invoice, so the shop rate gets set by looking at what the guy down the road charges. Then March comes and there is no money.

This workbook fixes the math. You fill in twelve overhead lines, the salary you want, and how many hours you can actually bill. It computes your true hourly cost - the number below which every hour loses money - and the rate you need to charge on top of it. With honest inputs a real solo shop usually lands between $85 and $150 an hour. Now you know which end you are on.

Then it turns that rate into a price book. Seventy-five common residential jobs, from a receptacle swap to a 200-amp panel upgrade, priced in Easy, Normal and Hard grades, rounded to the nearest $5, with your material markup, trip fee and minimum job charge applied. Change any input and every price updates. Print the Price Book tab and put it in the truck. Use the Quick Quote tab in the driveway: pick the job IDs, pick the grade, read the total.

Yes, the big software companies give away a "flat rate template". Those price one job at a time, and the price of the download is a sales call about a $200-a-month subscription. This is different: it builds the whole book from your overhead, it is yours forever, and nobody is going to phone you.

And no, flat rate is not a rip-off. The Engine tab shows exactly how the number is built - cost, then margin, in the open. That is what lets you say the price out loud without flinching, which the included guide teaches you to do.

What is inside

Inputs tab: twelve overhead lines, salary target, billable hours

Engine tab: true hourly cost and the rate you need to charge

Quick Quote tab: pick job IDs and a grade, read the total

Task Library: editable hours and material cost for every task

Checks tab: flags thin margins, low billable hours, under-market rate

The workbook - 7 tabs: Start Here, Inputs, Engine, Task Library, Price Book, Quick Quote, Checks
75 tasks in 9 categories: Service & Troubleshooting; Receptacles & Switches; Lighting; Ceiling Fans; Circuits & Wiring; Panels & Service; GFCI/AFCI & Safety; Outdoor, EV & Generators; Low Voltage & Smart Home
Easy / Normal / Hard grades with editable multipliers; Quick Quote with dropdowns, subtotal, discount and total
Checks tab that flags thin margins, low billable hours and an under-market rate
The guide (PDF) - filling in the inputs (including the four overhead lines everyone forgets), reading the engine, setting a service call fee and minimum, ten worked examples, three scripts for saying the price out loud, and keeping the book current

Questions

Does it work in Google Sheets?

Yes. Upload to Drive, open with Sheets. Only functions both programs support are used. The dropdowns in Quick Quote carry over.

Is this a subscription?

No. One payment, download the files, keep them forever. Updates to the same version are free - email us and we send the new file.

How is this different from the free templates the software companies give away?

Those price one job from numbers you type in each time and exist to get you onto a trial. This computes your rate from your overhead, prices 75 jobs at once in three grades, and includes the guide. Nobody calls you.

My market is cheaper or more expensive than the defaults.

Every price comes from your overhead, your salary target and your billable hours. Change the twelve inputs and the whole book is yours. The defaults are only there so you can see it working.

I am not an electrician.

The engine works for any trade; the 75 tasks are electrical. Tell us your trade when you get the free rate finder - the trade with the most requests gets its own book next.

What if it does not help?

Email within 30 days for a full refund. No form, no questions.

Who this is not for

Shops with dispatchers, five-plus trucks and a software budget: you want ServiceTitan or similar, not a spreadsheet.
Anyone looking for a list of "what everyone charges": there is no such list, and this does not pretend to be one. It prices from your costs.
Commercial estimating with assemblies and bid forms: this is a residential service price book.

Not sure your rate is right yet? Run the free rate finder first - it is the same engine.