Enter daily hours per tech. Overtime and payroll calculated automatically.
Free spreadsheet to track daily hours, calculate overtime, and run weekly payroll for your pool service team.
Free. Just enter your email.
Daily hours for each employee with auto-calculated total hours, regular hours, and overtime.
Hourly rates, regular pay, overtime pay, and total pay for each employee with payroll totals.
Accurate time tracking is both a legal requirement and a business necessity. Federal labor law requires employers to maintain records of hours worked for all non-exempt employees, including daily start/stop times, weekly totals, and overtime calculations. This spreadsheet provides a compliant weekly timesheet with automatic payroll calculations.
Each employee has a row with columns for Monday through Saturday hours. The spreadsheet auto-calculates total weekly hours, regular hours (up to 40), and overtime hours (above 40). Overtime is calculated at 1.5x the regular hourly rate per FLSA requirements.
The Payroll Summary sheet pulls hours from the timesheet, applies each employee's hourly rate, calculates regular pay and overtime pay separately, and totals payroll for the period. This provides a clear record of pay calculations that can be referenced if disputes arise.
The Department of Labor requires payroll records to be retained for at least 3 years. Time cards or time tracking records must be retained for at least 2 years. Store completed timesheets digitally (scan or save the spreadsheet) with backups. These records are your primary defense in wage disputes or labor audits.
This spreadsheet was built to solve these exact problems.
You're calculating payroll by hand every two weeks. It takes forever and you've made errors before.
A tech says they worked 45 hours but you only counted 40. No records to settle it.
Techs text you their hours at the end of the week from memory. Those numbers are never accurate.
You don't know your true labor cost per pool because you've never tracked hours against stops.
This spreadsheet fixes all of it. Free.
When spreadsheets stop scaling, PoolDial picks up where they leave off.
Start Free Trial