Templates
Electrician timesheet with circuit and permit columns
For electrical contractors who need to know where the hours went inside a job. Each row records the circuit or area and the permit number, so when a rough-in fails inspection or the customer adds work halfway through, you can see the hours spent on that part of the job.
The Excel file works out hours and pay. The first three rows are examples.
Electrician timesheet
What’s in the template
Scroll sideways to see all columns.
| Date | Electrician | Job / site | Circuit / area | Permit no. | Start | Finish | Break (min) | Hours | Hourly rate | Pay | Notes |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 10/5/26 | Alex Kim | Birch Rd. remodel | Kitchen circuits | E-24-1187 | 07:00 | 15:30 | 30 | 8 | 38.00 | 304.00 | |
| 10/5/26 | Chris Park | Birch Rd. remodel | Kitchen circuits | E-24-1187 | 07:00 | 15:30 | 30 | 8 | 27.00 | 216.00 | |
| 10/6/26 | Alex Kim | Elm St. panel upgrade | Main panel | E-24-1203 | 08:00 | 14:00 | 30 | 5.5 | 38.00 | 209.00 | Inspection booked |
What each column is for
| Column | What to write |
|---|---|
| Date | The workday. |
| Electrician | The electrician’s name. Apprentices get their own rows and rate. |
| Job / site | The job name or address. |
| Circuit / area | The part of the job: “kitchen circuits”, “main panel”, “parking lot lighting”. Keep the names short and use the same ones all job. |
| Permit no. | The electrical permit number for the work, so hours match up with inspections. Leave it blank for work without a permit. |
| Start | When work started, for example 07:00. |
| Finish | When work ended, for example 15:30. |
| 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 electrician’s hourly rate. |
| Pay | Calculated: hours × hourly rate. |
| Notes | Inspection booked, passed or failed, materials still needed, anything the customer asked for on site. |
When an inspection fails, filter Circuit / area and Permit no. to see who did that part and how long it took. Log the rework as new rows with the same circuit name, and the cost of the fix is there in Hours and Pay instead of disappearing into the job.
When a spreadsheet stops working
- Rates are typed on every row. One wrong rate makes that row’s pay wrong, and after a raise someone has to remember the new rate on every new row. In HiVis each person has an hourly rate with a start date, and every hour is priced at the rate that applied that day.
- Corrections leave no trail. In a shared file anyone can overwrite a number. In HiVis an approved entry changes only after a reviewer sends it back with a correction note, and closed pay periods stay locked.
- You need cost per job, not per sheet. HiVis shows hours and labor cost against each job’s budget, and reports by job and person export to CSV. See crew timesheets 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.
Add one row per electrician, job and area
If someone spends the morning on the panel and the afternoon on lighting, that’s two rows with different Circuit / area names.
Check the totals and approve
The Total row adds up hours and pay. Before signing off in Approved by, check that permitted work has its permit number.
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.