In this guide 6 sections
Excel works while one person holds every job in their head and the team installs only a few rooftop systems each month. It breaks the moment quotes, site stages, inverter serial numbers and warranty dates need several people editing together, because two copies of the same price column will disagree. That is the moment to move.
Where a spreadsheet holds up fine
A single workbook with one tab per job suits a one person shop, where the same person quotes, climbs the roof and remembers the customer. The sheet is only a memory aid. It works.
It costs nothing. Everyone already knows the cells, and for a handful of rooftop jobs a month that familiarity outweighs any feature list. A shared drive and a naming habit cover the gaps until a second installer joins, and protected price ranges stop the classic overwrite.
The trouble is not the tool. It is the habit of keeping the quote, site notes, material list and warranty dates in one workbook that only one person dares to open.
Quotes and proposals
A solar quote carries system size in kilowatts, module and inverter model, roof type, mounting structure, cable run, subsidy forms and a payback sketch. Excel copies the last quote. Stale cable rates linger in forgotten cells and reach the next customer unchanged, long after the supplier moved the price.
Dedicated software keeps one price list for modules, string inverters, DC cable, earthing kits and structure, then builds every quote from it. A revision becomes version two instead of a file named final_v7, and the approved discount limit stops a rushed salesperson from underpricing a job.
Try one test on your own files: find the quote you sent a customer last March, with the exact module price, the cable rate and the discount given. A minute is the limit. Longer is a warning sign.
- Module and inverter models with current rates
- Revision history for each quote
- Approved discount limits
- Subsidy form and utility approval checklist
Stage tracking and site work
A real job passes through survey, design, material dispatch, structure, module mounting, DC and AC wiring, utility inspection and commissioning. A sheet shows only the stage someone last remembered to type, so the office runs a day behind while crews resent entering everything twice.
With software the supervisor updates a stage from a phone and attaches photos and the inverter serial, so the office books the net meter inspection that afternoon. Nobody phones the crew.
Reports follow from stages. Software lists every job waiting for utility inspection, every job with structure done but no wiring, and every commissioned system still missing its handover pack. A sheet needs a filter nobody sets.
Material issue and warranty records
Modules, inverters and batteries each carry serial numbers and a different warranty period, and in a sheet those serials end up pasted into a notes column. Tracing one faulty batch then means opening tab after tab by hand, one customer at a time, while the recall notice waits on someone’s desk.
A dedicated product ties every serial to a job, a customer and a commissioning date, so a recalled batch is one filter and one call list. Warranty claims move quicker. Recalls stop being a panic.
Service calls change too. A customer rings about a dead inverter display and the desk opens one record showing model, firmware, installer and warranty end date, with no hunt through three files.
When to make the switch
Count the warning signs. Two people editing one file, a stage question you cannot answer, or a warranty request that eats an afternoon each deserve a look, and two together mean act.
Do not migrate everything at once. Move new jobs into the software, leave open jobs in the sheet until they close, and review after one month with the crew who must enter the data.
Ask one hard question before buying anything. Who will enter the data on site, and from which device, when the roof is hot, the gloves are on and the signal is weak? Software the crew refuses to open is worse than the sheet it replaced, because the sheet at least got filled in on Friday afternoons.
Spreadsheet or software scorecard
A worksheet of eight rows: quote revisions, stage visibility, serial tracking, warranty dates, subsidy documents, crew updates, reporting and access by role. Tick whether Excel copes today, and write one real example from last month beside each row, such as the quote you could not find.
Open a blank worksheet to printQuestions owners ask
Can I add serial numbers in Excel and call it done?
For a while. Trouble starts when you need every job that used one pallet of modules, because searching across tabs is slow and a missed row means a customer nobody warns.
Will crews actually use software on site?
They will if the screen is short. Stage, photo and inverter serial take under a minute on a phone, but a long form with twenty fields gets skipped by the second week.
Do I lose my old data?
Nothing is lost. Export the workbook to CSV and import the open jobs with their quotes, while closed jobs stay in an archive folder that you can still search.
Is dedicated software only for large installers?
Size is not the trigger. The trigger is shared edits and warranty traceability, and even a five person crew feels it once several jobs overlap and two people reach for the same file.