Moving an Electrical Business Off Paper and Spreadsheets
Plenty of good electrical businesses run on paper. A carbon-copy invoice book in the truck, a customer spreadsheet on the office computer, a whiteboard for the schedule and a group text for everything else. It works, until it doesn't: an invoice book gets left in the rain, the spreadsheet has three versions, and a new tech can't find the gate code in four hundred messages.
When Paper Starts Costing You
The routine in A Weekly Office Routine for an Electrical Business assumes the office can see the board, the estimates, the invoices and the plan visits in one place. On paper, each of those lives somewhere different, and the routine takes twice as long.
Common signs it's time to move:
- Invoices get written days after the job, or not at all.
- Nobody is sure which customers are due for a yearly visit.
- The second tech calls the owner for every address and every panel.
- Customers ask for copies of old invoices and you can't find them.
- The schedule only exists in one person's head or one whiteboard.
What to Bring Over
You don't need to move everything. Bring the things that make the next call easier:
- Clients and addresses. Your customer spreadsheet comes in by CSV import, and imported addresses are placed on the map automatically, ready for routing.
- Your services and prices. Build your service list once. Estimates and invoices pull from it.
- Plan customers. Anyone on a yearly safety inspection or generator maintenance, set up with 365 minimum days between visits so their next visit comes due on its own.
- Commercial and property manager accounts. One client with many addresses, set to Monthly billing if they get one statement.
- Key equipment. For your best customers, the generators, panels and EV chargers you know about.
What to Leave Behind
Old paper invoices and years of past jobs don't need to be typed in. Keep the paper in a box for reference and let the new system build history from today. Within a season or two, the customers you see most will have full records, and the rest fill in as they call.
The same goes for equipment. You don't need to document every house before you start. Have techs save what they see on each visit. The “From House” picker uses it on the next job, and changes on a job flow back to the house.
A Simple Order for the Switch
Switching everything in one day is stressful. A calmer order:
- Week one: import clients and addresses, set up your service list, add office users with roles and employees with PINs and van assignments.
- Week two: start booking new work on the dispatch board. Techs use the tech app on their own iPhones and Android phones — it runs in the browser and installs to the home screen, with no app store.
- Week three: invoice from the system when techs tap Complete. Start collecting cards on file.
- Week four: set up plans, turn on customer alerts, and point customers to the customer app.
Run paper and software side by side for a few days if it helps, but set a date to put the invoice book away for good. Tell customers too. A short text letting regular customers know they will now get reminders, arrival texts and invoices they can pay from their phone turns the switch into good news rather than a surprise.
Getting the Crew On Board
Techs who are used to paper sometimes resist. Keep it simple: show them that the phone gives them the address, the navigation, the equipment, the access notes and the customer's history, and that tapping Complete means no more writing invoices in the truck. Most techs come around once they realize they're doing less paperwork, not more.
The group text should go too. Customer details belong on the address, where only signed-in employees with a personal PIN can see them. When someone leaves, turning off their PIN turns off their access.
Try It Before You Move
Before importing anything, click around the live demo, a fully stocked sample electrical company with no signup. Then start the 14-day free trial with no credit card and try a week of real work. If you want a broader look at what to check before choosing a system, the next article covers it: Choosing Electrical Business Software: What to Check Before You Switch.
For everything else about the business side of an electrical shop, head back to the electrical business software page.
Put the Invoice Book Away
ElectricalBossPro imports your customers by CSV, places them on the map and runs the schedule, the tech app and billing from day one.
Start Free Trial