Employee Timesheet Template, Weekly Timesheet and Time Card, Work Hours Tracker with Overtime and Pay Summary, Excel Google Sheets

An employee timesheet for small business owners who add up hours by hand every payday. Log each shift once, print a weekly time card to sign, and see hours, overtime and gross pay for every pay period.

🔗 TRY THE LIVE DEMO before you buy (view only, nothing to install): https://docs.google.com/spreadsheets/d/1O9CJCXX2OpC_-VuBsCA0F7_tuPyqidNMcvOczzZIddw/edit?gid=1206732470

📊 WHAT IT DOES

✓ Team: everyone who clocks in, with their role, hourly rate and status, and their hours this week.
✓ Time Log: one row per shift with the day, who, the time in and out, the unpaid break and a note.
✓ Hours work themselves out, even for a shift past midnight. A shift with no Out time shows as open.
✓ Overtime is weekly: hours past the limit you set (40 by default), paid at your multiplier (1.5 by default).
✓ Time Card: pick a person and any day in the week, and see each day with in, out, break, hours, the week so far and overtime.
✓ Each time card shows regular and overtime hours, the rate and gross pay, with lines for both signatures, ready to print.
✓ Pay Summary: everyone's rate, hours, regular, overtime, shifts and gross pay for a weekly or biweekly period.
✓ Your week can start on Monday or Sunday.
✓ Three charts: team hours for the last 8 weeks, hours by day, and regular and overtime hours by person.

📂 WHAT'S INSIDE: 5 TABS AND 3 CHARTS

✓ Start here: your business, the day your week starts and your overtime rule
✓ Team: four cards and everyone on the team
✓ Time Log: four cards and every shift
✓ Time Card: one person's week, ready to sign
✓ Pay Summary: four cards and the pay period for everyone

📝 HOW IT WORKS

1. Open the PDF and click the link to make your own copy in Google Sheets. Or open the Excel file.
2. On Start here, type your business, the day your week starts and your overtime rule.
3. On Team, add each person and their hourly rate. On Time Log, add one row per shift.
4. Print a Time Card at the end of the week, and open Pay Summary on payday.

📥 WHAT YOU GET

✓ Google Sheets version (the link is in the PDF)
✓ Excel version (.xlsx) for desktop Excel 2016 or newer and Microsoft 365, on Windows or Mac
✓ A filled example to look around, and a blank copy for your own team
✓ A PDF guide with screenshots, the links and the first steps
✓ A video guide for this spreadsheet (the link is in the PDF)

💻 GOOD TO KNOW

✓ Works with a free Google account. No app, no ads, no subscription.
✓ Room for 20 people and 1,000 shifts. No year is built in.
✓ Gross pay is before taxes and deductions. Some states also count daily overtime, so check your state's rules.
✓ Formulas are protected, so you can't break anything by accident.
✓ Set it up on a computer in a few minutes. After that, the Google Sheets app works for quick entries on your phone.
✓ The photos show Google Sheets. The Excel file has the same tabs and formulas.
✓ Free updates for life.

This is a digital download, so nothing is shipped. If anything is unclear after you buy, message me and I'll help you set it up.