How WeekClose works
From the punches in your spreadsheet to approved, payroll-ready hours. Nothing to install on employees' computers and nothing stored outside your account.
Open it on the sheet with your punches
In Google Sheets: Extensions, then WeekClose. In Excel: the Home tab, then Payroll hours. WeekClose reads the header row and matches the columns it needs: name, time, and either an In/Out column or separate clock-in and clock-out columns. You check its choices.
New to it? Press Try it with sample punches to see a result on made-up data first.
Calculate each workweek
Pick the day your workweek starts (the same as your payroll) and the overtime rule. WeekClose writes a results tab of its own with each person's regular hours, overtime, double time and comp time, by workweek and by pay period, plus a list of every row it wants you to check.
Make one timesheet per department
Add a Department column to your punches and a small Departments tab listing each supervisor. WeekClose makes a printable timesheet for each department and week, with a short check code that changes if any number on it changes.
Send it for sign-off and see who approved
WeekClose shows exactly which supervisor gets which timesheet before anything is sent. Supervisors approve with one tap on a form in your own Google Forms or Microsoft Forms, signed in with their work account. An Approvals tab shows Approved, Waiting, Sent back, Approved by someone else, or Changed after approval.
Google Sheets and Excel
| Google Sheets | Excel (Microsoft 365) | |
|---|---|---|
| Where it runs | Inside Google Apps Script, attached to one spreadsheet | In Excel's add-in pane, on Windows, Mac and Excel on the web |
| Supervisor emails | Sent from your own Google account when you press Send | Sent from your own Outlook by a Power Automate flow you set up once |
| Approval form | Google Forms or Microsoft Forms | Microsoft Forms or Google Forms |
| Where to get it | Google Workspace Marketplace (in Google's review) | Microsoft Marketplace (in Microsoft's review) |
Phone clock-in for employees
Employees save the WeekClose Punch page to their home screen. A tap on Clock in opens your organization's own form with the answers filled in; one more tap on Submit records it. The punch lands in your spreadsheet, where WeekClose picks it up. The page holds none of your data: its setup travels in the link you give employees.
The overtime rules
- Federal: hours over 40 in a workweek at 1.5 times the regular rate. Each workweek stands on its own, even inside a two-week pay period (U.S. Department of Labor Fact Sheet #23).
- California (Pro): over 8 hours in a workday at 1.5x, over 12 at 2x, the seventh-day rule, and weekly overtime, without counting hours twice (California DLSE overtime FAQ).
- Comp time for public employers (Pro): 1.5 hours of comp time per overtime hour for employees with a comp time agreement, a balance cap of 240 hours (480 for public safety, emergency response and seasonal work), and cash for overtime past the cap (29 U.S.C. 207(o); 29 CFR 553.20 to 553.28).
Not built in: police and fire 7(k) work periods, other states' daily overtime rules, and a weighted regular rate for people paid several rates. The help page lists every limit.