Electrical Estimate Template, Invoice and Job Tracker in One Workbook
Ampsmith is an electrical estimate template and job tracker built for electricians and small electrical contractors. Count the devices and circuits on a job, and the workbook prices every line from your own Price Book. It applies labor units, a labor factor for the job type and your material markup. It prints a professional estimate, adds approved change orders, plans progress billing with retainage, prints invoices and shows the profit on every job, estimate vs actual. One Excel / Google Sheets file replaces the separate estimate template, invoice template, permit list and job-cost spreadsheet most shops juggle.
Who it is for
- Licensed electricians and electrical contractors with 1 to 15 people
- Residential service and remodel work: panel upgrades, EV chargers, generators, lighting, kitchens and basements
- New construction and light commercial fit-outs that need progress billing, retainage and inspection tracking
- Office managers who write estimates and invoices for the field crew
Main benefits
- Faster, more consistent bids. Pick an item, type a quantity, and labor hours, materials with markup and the line price fill in.
- Know your profit. Every job compares budget hours and cost with actual crew hours and purchases, so you can see which work pays.
- Get paid on time. Plan deposits, rough-in and trim draws, final invoices and retainage release. Overdue invoices show up on the dashboard.
- Never miss an inspection. Permit numbers, fees, expiry dates and inspection results live in one place with automatic alerts.
Features
Electrical estimating spreadsheet with labor units
- Price Book with 70+ starter items (devices, lighting, circuits, panels and service, EV/generator/solar, low voltage, wire and conduit) and room for 150
- Material cost, labor units (hours per unit) and optional markup override for each item; sell price per unit calculates automatically
- 8 editable job types with labor factors (for example remodel / old work 1.30, new construction 1.00)
- Estimate Builder with 1,000 lines for all your jobs, custom items, overrides, areas/phases and a live summary: labor hours, crew days, materials, labor, tax, total and estimated margin
Printable estimate, change order and invoice
- Estimates fill automatically from the job #: your business name and license # in the header, customer, job site, scope, up to 30 lines, permit fees, discount, sales tax, deposit, valid-until date, terms and acceptance signatures
- Show or hide line prices per estimate
- Change order log with materials, extra hours, fees, tax, days added and status; a printable change order form shows the contract impact
- Invoice with work performed (itemized or one summary line), approved change orders, contract summary, retainage, payments and balance due
Progress billing and payments
- Bill by % of contract, fixed amount, balance remaining or retainage release
- Automatic invoice numbers, due dates, retainage withheld, amount due, balance and status (Planned, Due, Part paid, Paid, Overdue)
Job tracking and profitability
- Customer records with won work, invoiced, paid and balance owed
- Job log for 200 jobs with status, dates, permit fees, discount and retainage, plus automatic contract total, estimated and actual cost, hours used, profit and margin
- Time & Costs log (2,000 rows) for crew hours by role and job purchases
- Permit & inspection tracker (300 rows) with alerts such as “In 4 days”, “Enter result”, “Corrections open” and “Permit expires soon”
Business dashboard
- Invoiced and collected this year, outstanding A/R, overdue, gross and net profit, average margin, estimate win rate, pipeline and backlog
- Charts: invoiced vs collected by month, jobs by status, gross profit by job type and an estimate vs actual job snapshot
- Lists of upcoming inspections, overdue invoices and active jobs near or over their labor budget
What is included
- Ampsmith-Electrical-Job-Tracker.xlsx: 14 tabs (Start Here, Dashboard, Settings, Price Book, Customers, Jobs, Estimate Builder, Estimate, Change Orders, Change Order Form, Permits & Inspections, Time & Costs, Billing, Invoice)
- Ampsmith-User-Guide.docx: a 14-page illustrated guide with setup steps, every tab explained, the pricing math, troubleshooting and FAQ
How it works
- Enter your business details, labor rate, labor cost, markup, tax and currency on Settings, and adjust the Price Book.
- Add a customer and a job, then count devices and circuits on the Estimate Builder.
- Pick the job # on the Estimate tab and print or save it as a PDF.
- Log change orders, permits, crew hours and purchases as the job runs.
- Plan progress billing, print invoices, record payments and watch the dashboard.
File formats and software requirements
One .xlsx workbook plus a .docx user guide. Works in Microsoft Excel 2016 or later (Windows and Mac, including Microsoft 365) and Google Sheets (upload, then File > Save as Google Sheets). No macros, add-ins or subscription. Apple Numbers is not supported. Printouts are set up for US Letter and can be saved as PDF.
Customization
Choose your currency symbol and position, sales tax rate and base (materials only, whole price or none), deposit, retainage, payment terms, job and invoice number prefixes, terms text and payment instructions. Rename job types and labor factors, crew roles and costs, and every dropdown list. Formula cells are locked without a password, so nothing breaks by accident.
Digital download
This is a digital product. No physical item will be shipped. You can download the files right after purchase.
Use cases
- Pricing a 200A panel upgrade with an EV charger circuit and sending a PDF estimate the same day
- Billing a new-construction house in rough-in, trim and final draws with 10% retainage
- Tracking a commercial tenant fit-out with change orders, inspections and a failed rough-in that needs corrections
- Checking at month end which job types earn the best margin and which customers owe you money
FAQ
Does this electrician estimate template work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and save it as a Google Sheet. All formulas, dropdowns and charts work. It also works in Excel 2016 or later.
Are the prices and labor units accurate for my area?
They are starter values only. Replace them with your supplier pricing and your crew’s real production rates. After a few jobs, the estimate vs actual hours help you fine-tune them.
Can I use my own currency?
Yes. Pick it once on Settings and every printed amount follows it. Dollars are the default.
How does it handle sales tax?
You set the rate and choose whether tax applies to materials only, the whole price or nothing. Tax rules for contractors vary by state, so check with your accountant.
Can I bill large jobs in stages?
Yes. Plan deposits and progress draws by percent or fixed amount, bill the balance and release retainage. Approved change orders update the contract automatically.
How many jobs can it hold?
200 jobs, 1,000 estimate lines, 200 change orders, 300 inspections, 2,000 cost entries, 400 invoices and 300 customers per file.
Does it need macros or a subscription?
No. It’s a one-time purchase with no macros or add-ins.
License: personal use, or use within your own business. You may not resell, share or redistribute the files. This template is a business tool, not legal, tax or electrical code advice.




Reviews
There are no reviews yet.