Every electrical contractor keeps more records than it uses. Estimates, timesheets, payroll, supplier invoices, the accounting file, the dispatch board. Each one was set up to do a single job, and almost nobody goes back later to ask it anything.
Here are twelve questions worth asking. For each, where the answer usually lives and what you'd do once you have it. You won't need all twelve. Start with the one that bugs you most.
Jobs and estimates
1. Which job types beat the estimate, and which run over? Put estimated hours next to actual hours from timesheets or payroll, grouped by type of work. Raise the labor allowance where jobs run long and sharpen your price where they come in under. Enhanced Electrical, a Nevada shop, said in a customer story published by Simpro, the software it bought, that tracking estimated against actual hours changed how it bids.1 There's a monthly routine for this one.
2. Which GCs or customers generate the most change work, and does it get billed? Change orders live in project files and email. Billing lives in accounting. If one GC's extras keep getting paid late or not at all, tighten the sign-off before the next job with them.
3. Which job types bring the most callbacks? Look in your dispatch or service history for return visits to the same address soon after a job, usually unbilled. A cluster on one job type points to a training gap, a material problem or a rushed estimate.
Billing and cash
4. How many days pass between finishing a job and sending the invoice? Compare the completion date in scheduling or dispatch with the invoice date in accounting. In a customer story from Jonas Construction Software, Day-View Electric, a Canadian shop in Ottawa, said clients sometimes got bills three to five weeks after the work.2 If your gap runs to weeks, that's money you've already earned sitting still.
5. Is there finished work that never got invoiced at all? Match completed jobs and logged hours against invoices. Anything with hours and no invoice deserves a look. We wrote a whole post on this one.
6. Which customers pay slowest? Your accounting software's aging report has it. Ask for deposits, change terms or follow up sooner with the repeat offenders.
Materials and suppliers
7. Which supplier invoices don't match the prices you agreed to? Compare invoice line prices against your quotes or price agreements. Middlebury Electric in Indiana runs a supplier price discrepancy report about once a week, and its president told Simpro the money it recovers pays for the software.3 A monthly spot check of your biggest supplier is a fair start.
8. What van stock hasn't moved? Compare what each van carries with the material that's actually been used on jobs. Middlebury used this to drop items techs carried and never used, one of them untouched in six years.3 Pull the dead stock and stop reordering it.
9. Are you billing for all the material you buy? Set supplier invoices charged to a job beside the material lines on that job's invoice. Gaps usually mean receipts that never got matched to a job.
Service, sales and the crew
10. Which service agreements cost more to service than they bring in? Agreement revenue sits in accounting. The labor and material spent on each agreement sits in timesheets and job records. Reprice the losers at renewal, or change what's included.
11. Which lead sources turn into profitable jobs? Lead source is often a field in your scheduling software or a column in a spreadsheet. Profit per job comes from job costing. Some sources bring plenty of calls and thin margins, so spend your marketing money where the profitable jobs come from.
12. How much paid time goes to driving? Compare clock-in and clock-out times with time logged on site, from your time-tracking app or GPS records. If travel eats a big share of the day, group calls by area or build travel into your service call price.
Where to begin
Pick one question. Pull three months of records for just that question, in whatever shape they're in. Messy is fine. The first pass mostly tells you which records you have and which ones you'd need to start keeping.
Want to see what other shops turned up? Here's a roundup of electrical contractors who looked hard at their own records.
And if you're not sure which question to start with, or whether your records can answer it, here's how a first conversation with us works.
Sources
- Simpro, "Enhanced Electrical" customer case study (undated). Vendor marketing. cdn.featuredcustomers.com
- Jonas Construction Software, "Day-View Electric case study" (undated). Vendor marketing. jonasconstruction.com
- Simpro, "Middlebury Electric" customer case study (undated). Vendor marketing. cdn.featuredcustomers.com
What would you ask your own records?
Send us the one question you can't answer today, in your own words. We'll talk through whether the records you already keep can answer it. The Tiber River Business Data Platform is accepting design partners, and you can click around the live demo with a fictional company first.
Email Josh your questionOr write to josh@tiberriverconsulting.com