Your Cart
Loading

Payroll Timesheet with Automatic Overtime – Excel & Google Sheets (Weekly/Biweekly, CA/AK/CO/NV rules)

On Sale
$12.00
$12.00
Added to cart

Stop working out overtime by hand. Enter each day's clock-in and clock-out times, and this timesheet calculates regular hours, overtime, double time and gross pay for you, per day, per week and for the whole pay period.


What it does

- Overtime rules built in: Federal (FLSA) 40-hour week, plus California, Alaska, Colorado and Nevada daily overtime. Pick one from a dropdown.

- California double time: after 12 hours in a day, and the 7th-consecutive-day rule.

- Add your own rules: for example daily overtime after 10 hours under a union agreement. Type them on the Rules tab and they appear in the dropdown.

- Weekly or biweekly pay periods: each workweek is calculated separately, as US law requires.

- Punch rounding to 5, 6 or 15 minutes (optional).

- Overnight shifts handled: 10 PM to 6 AM = 8 hours.

- Prints on one page, with employee and supervisor signature lines.


What you get

- An Excel file (.xlsx) for Microsoft Excel 2010 or later

- A Google Sheets version: click the "Make a copy" link in the Quick Start Guide to get your own copy

- A Quick Start Guide (PDF)


Who it's for: small business owners, office managers, supervisors, caregivers, nannies, contractors, and anyone who needs to check their own pay.


Instant download. Re-use it every pay period and for as many employees as you like within your own business.


This template is a calculation aid, not legal or payroll advice. Check federal, state and local rules before paying wages.

You will get a ZIP (60KB) file