Templates
Solar installer timesheet with kW and panels per day
Solar crews are easy to compare once you know how many labor hours each kilowatt takes. This timesheet adds kW installed and Panels installed to every row, so a few weeks of sheets tell you which crew is faster and how many hours to price into the next install.
The Excel file works out hours and pay. The first three rows are examples.
Solar installer timesheet
What’s in the template
Scroll sideways to see all columns.
| Date | Installer | Job / site | kW installed | Panels installed | Start | Finish | Break (min) | Hours | Hourly rate | Pay | Notes |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 10/5/26 | Riley Brooks | Johnson residence | 4.4 | 10 | 07:00 | 16:00 | 30 | 8.5 | 30.00 | 255.00 | Racking done |
| 10/5/26 | Taylor Reed | Johnson residence | 4.4 | 10 | 07:00 | 16:00 | 30 | 8.5 | 24.00 | 204.00 | |
| 10/6/26 | Riley Brooks | Johnson residence | 4 | 9 | 07:00 | 13:00 | 0 | 6 | 30.00 | 180.00 | Inverter wired |
What each column is for
| Column | What to write |
|---|---|
| Date | The install day. |
| Installer | The installer’s name, one row per job they worked on that day. |
| Job / site | The customer or address. |
| kW installed | The kW the crew installed on this job that day. Put the same figure on each installer’s row, as in the example. |
| Panels installed | The number of panels the crew mounted on this job that day, again on each row. |
| Start | When work started, for example 07:00. |
| Finish | When work ended, for example 16:00. |
| Break (min) | Unpaid break in minutes. Leave it blank or enter 0 if there was none. |
| Hours | Calculated: finish minus start, minus the break. |
| Hourly rate | The installer’s hourly rate. |
| Pay | Calculated: hours × hourly rate. |
| Notes | The stage reached: racking done, panels on, inverter wired, waiting on inspection. |
To get labor hours per kW for a job, add up its Hours and divide by the job’s kW, counting each day’s kW once rather than once per installer. In the sample rows, the Johnson job took 23 labor hours for 8.4 kW, about 2.7 hours per kW. Those are example numbers: yours depend on roof type, system size and crew.
When a spreadsheet stops working
- The ratio is only as good as the hours. A day nobody logged makes a crew look faster than it is. HiVis emails the people who log time the morning after a workday when someone on an active job has no hours.
- Overruns show up after the install. In HiVis each job can have a labor budget. Labor spend is shown against it while the job is on, and HiVis emails when spend gets close to the budget or goes over.
- Materials leave without a record. In HiVis, stock issued to a job with its unit cost shows on the job’s Materials tab, next to the labor cost. See job costing in HiVis.
How to use it
Download it and clear the examples
Download the Excel file. Delete the three sample rows as whole rows, or clear only the columns you fill in: clearing Hours and Pay would remove their formulas.
Fill in the header
Company, the crew or foreman, the period and who approves the sheet. Keep one sheet per crew if you want to compare crews.
Add one row per installer, job and day
Write the day’s kW and panel count for the job on each installer’s row, along with their start, finish and break.
Check the totals and approve
The Total row adds up hours and pay. Before signing off in Approved by, check that every install day has its kW filled in.
Questions and answers
See your crews, hours and costs in one place
Book a 30-minute demo or start a 30-day trial. We set up your workspace and help move your data.