Close out the week's timesheets without the hand math.
WeekClose reads the clock-ins already in your Google Sheet or Excel workbook. It works out regular hours, overtime and comp time for every workweek, makes a timesheet for each department, and records each supervisor's sign-off.
Free for up to 5 employees. Your punches stay in your own spreadsheet. The Google Sheets and Excel listings are in Google's and Microsoft's review now.
| Employee | Mo | Tu | We | Th | Fr | Total |
|---|---|---|---|---|---|---|
| Ana Ruiz | 8.5 | 9 | 8 | 9.5 | 8 | 43 |
| Paul Kim | 8 | 8 | 8 | 8 | 8 | 40 |
| Ana: 3 h overtime, banked as comp | 4.5 h |
Works with the time clock you already have
A form on employees' phones
Microsoft Forms or Google Forms clock-ins land in your spreadsheet. Our free phone clock-in page makes each punch two taps.
A time-clock export
Name, date, time in, time out, break. WeekClose matches the columns from your header row and you confirm them.
Typed timesheets
One row per shift, typed by hand. Times without dates use a Date column; breaks can be minutes like 30 or 0:30.
What you get each week
- Regular, overtime and double time for each person, workweek by workweek, never averaged across a pay period
- Comp time for public employers: 1.5 hours per overtime hour, the 240 or 480 hour cap, cash past the cap, balances carried forward
- One printable timesheet per department, emailed to its supervisor from your own account
- An Approvals tab: approved, waiting, sent back, or changed after approval
- Totals per pay period: weekly, every two weeks, twice a month or monthly
What it catches
- Missed clock-outs and clock-ins with no match
- Overnight shifts, split at midnight
- Duplicate rows and overlapping shifts
- Shifts over 16 hours and breaks longer than the shift
- One person typed two ways ("Ana Ruiz" and "ana ruiz")
Every problem is listed with its row number. WeekClose never edits or deletes your rows.
Your data stays in your account
WeekClose runs inside your spreadsheet. We have no servers that receive your punches, names, hours or pay rates, and no database to hold them. In Google Sheets it can open only the spreadsheet you use it in.
Checked against the rules
Every overtime result is checked against a second calculator, written separately to count minute by minute, on 6,000 random sets of punches under the federal and California rules. Comp time has its own check against that calculator, and each rule has hand-worked examples: the federal 40-hour workweek (U.S. Department of Labor Fact Sheet #23), California daily overtime (DLSE), and public-employer comp time (29 CFR 553).
WeekClose is a calculator, not legal or payroll advice. Your policy decides who earns comp time.
Simple pricing, no subscriptions that renew on their own
Free for up to 5 employees on the federal rule. Pro is $29 a year or $59 once, for one person who runs payroll. Offices and whole organizations have their own plans, priced to fit a purchasing card.