Get WeekClose

• Google Sheets: our listing is in Google's review. Email support@weekclose.com and we'll tell you the day it goes live.
• Excel (Microsoft 365, Windows, Mac and the web): our listing is in Microsoft's review. Email us and we'll tell you the day it goes live.
• Phone clock-in: free, no install: see Phone clock-in below.

Get started in a minute

1. Open the sheet with your punches. Google Sheets: Extensions, WeekClose, Calculate payroll hours. Excel: Home, Payroll hours.
2. Check the columns WeekClose matched (name, time, In/Out or Clock in and Clock out).
3. Pick the day your workweek starts (the same as your payroll) and the overtime rule.
4. Press Calculate payroll hours. Results appear in a tab called WeekClose Hours.

No punches yet? Choose Try it with sample punches.

Which layout do I have?

• One row per punch: each clock-in and each clock-out is its own row, with a column saying In or Out. Form time clocks look like this. Accepted words: In, Clock in, Start, Arrive; Out, Clock out, End, Leave.
• One row per shift: a row has both the clock-in and the clock-out. Most punch-clock exports and paper time cards look like this. If the times have no date, also pick the Date column.

Breaks: pick a column with unpaid break minutes (30, 45 or 0:30). A decimal like 0.5 is flagged, because it could mean hours or minutes: write 30.

The overtime rules

• Federal: hours over 40 in a workweek are overtime at 1.5x. Each workweek is counted on its own (U.S. Department of Labor Fact Sheet #23).
• California (Pro): over 8 hours in a workday at 1.5x, over 12 at 2x; on the seventh day in a row in one workweek, the first 8 hours at 1.5x and the rest at 2x; regular hours over 40 a week at 1.5x. Workdays run midnight to midnight (California DLSE overtime FAQ).
• Other states with their own daily overtime rules are not built in. Use the federal rule and check with your payroll provider.

Departments and supervisor timesheets (Pro)

1. Add a Department column to your punches, or a Department question to your clock-in form.
2. Add a tab named Departments with these columns: Department, Supervisor name, Supervisor email, Approval form link.
3. Calculate. Then under Supervisor timesheets pick the week and choose Make timesheets: one printable tab per department.
4. Email supervisors shows exactly who gets what. Nothing is sent until you press Send. In Excel, the email goes through a Power Automate flow in your own Microsoft 365: set it up once.

Supervisor sign-off form

Make a form in Google Forms or Microsoft Forms with four questions: Timesheet ID, Fingerprint (the timesheet's check code), Decision (Approve or Send back) and Comment. Optional fifth: "Type your full name to sign". Require sign-in so each response records who submitted it:

• Microsoft Forms: only people in your organization can respond, and record names.
• Google Forms: collect verified email addresses.

Link the responses to your spreadsheet. Make a pre-filled link and put {id} and {fp} where the Timesheet ID and Fingerprint answers go, then paste that link on the Departments tab. Check approvals writes the WeekClose Approvals tab: Approved, Waiting, Sent back, Approved by someone else, or Changed after approval (a punch was edited after the supervisor approved: ask them to approve again).

Comp time (Pro, public employers)

• Each overtime hour banks 1.5 hours of comp time, up to 240 hours (480 for public safety, emergency response and seasonal work). Past the cap, overtime is paid in cash (29 U.S.C. 207(o); 29 CFR 553.20 to 553.28).
• Comp time needs an agreement with the employee before the work is done (29 CFR 553.23). Add a Comp balances tab: Employee, Starting balance (hours), and Comp or Pay. Only employees marked Comp bank comp time; everyone else is paid cash overtime.
• Comp time used and leave (vacation, sick, holiday) are paid but are not hours worked, so they never create overtime.
• Unused comp time paid when someone leaves is at the higher of their average regular rate over their last 3 years or their final rate (29 CFR 553.27(b)). WeekClose shows the balance; your payroll system pays it.

Leave, call-back and pay periods

• A Type column can say Regular, Call-back (or On-call worked), Vacation, Sick, Holiday, PTO, or Comp time used. Leave rows can use an Hours column instead of in and out times. A row that says only "On-call" is flagged for you to check, because waiting on call is not always hours worked.
• Pay periods: weekly, every 2 weeks (pick a date one started), twice a month, or monthly. Overtime is always counted per workweek; a workweek that crosses a pay-period line is reported in the period where it ends, and the results tab says so.

Phone clock-in (WeekClose Punch)

1. Make a clock-in form in your organization's Microsoft Forms or Google Forms (sign-in required) with a question "Clock in or out" (Clock in, Clock out) and, if you like, Department and Type.
2. Open the Punch setup page, paste your form's pre-filled links, and press Make my links. You get one link and a printable poster with a QR code for employees.
3. Employees open the link on their phone and save it to the home screen. Clock in opens your form with the answers filled in; one more tap on Submit records it.

Our web host never receives your data: the setup travels in the link, and each phone keeps only that employee's name, department, last tap and the setup link. If your form tool can't pre-fill answers, the poster's second QR code opens the plain form.

Problems list

Every row WeekClose skipped or wants you to check is listed with its row number. Fix the row on your tab and run again. WeekClose never edits your rows.

License keys

A license is a one-time payment that never renews on its own. You get a key by email; open WeekClose, choose I have a key, paste it and unlock Pro. Google Sheets keys start with WC-, Excel keys with WCX-. A Pro key is licensed to one person at a time: use "Remove key from this account" before moving it to someone else. Lost your key? Email support@weekclose.com from your order email.

Known limits

• A shift during a daylight-saving change can be off by one hour.
• Text dates like 02/11/2026 are read as month/day/year (US). Real date cells work in any format.
• Gross pay is an estimate at one rate per person; bonuses, commissions, shift differentials and several pay rates change what is owed.
• Not built in: police and fire 7(k) work periods, other states' daily overtime, a weighted regular rate.
• WeekClose is a calculator, not legal or payroll advice.