• Payroll Template with pay period hours summary and overtime and gross pay calculator spreadsheet cover image for Google Sheets and Excel, showing a preview of the sheet with feature labels.
  • May include: A digital payroll tool from TeamTimeTools featuring an Excel spreadsheet and Google Sheets PDF. It includes seven tabs: Start Here, Pay Period, Export, Settings, Employees, Hours Log, and Pay Calendar, with built-in instructions and sample data for tracking hours, overtime, and gross pay.
  • May include: A digital time tracking interface titled TeamTimeTools with the heading Log hours as you go. It displays a table with columns for Date, Employee, Hours, Type, Note, Work hrs, Leave hrs, and Check, followed by three informational boxes.
  • May include: A data table titled Overtime done per workweek from TeamTimeTools showing employee hours, overtime eligibility, and pay. It includes columns for employee names, OT eligible status, weekly hours, regular hours, overtime hours, and overtime pay.
  • May include: A digital interface titled Export for payroll by TeamTimeTools displaying two tables. The top table lists employee payroll data including period dates, regular hours, overtime, leave, total hours, and gross pay. The bottom table shows a Pay Calendar with period numbers, start and end dates, work hours logged, and paid leave hours.
  • May include: An infographic titled Built for small businesses by TeamTimeTools. It displays three white cards with teal text: 30 employees, 3,000 log rows, and 2 pay schedules. Below are two text boxes labeled Hand off clean numbers and Good to know.
  • May include: A digital product information graphic titled Works in Google Sheets + Excel by TeamTimeTools. It features two white boxes explaining compatibility with Google Sheets and Microsoft Excel, plus a dark blue footer detailing instant download, pay period logging, and sample data inclusion.
  • May include: An infographic titled How it works by TeamTimeTools showing three steps. Step 1: Download. Step 2: Open. Step 3: Set up & log hours. Includes a green button labeled Built-in Start Here tab walks you through it and a disclaimer.
  • May include: A digital spreadsheet titled Pay Period Summary displaying employee payroll data. Columns include Employee, Department, Pay rate, OT eligible, Week 1 and 2 work hours, Regular and Overtime hours, Paid leave, and Gross pay totals.
  • Payroll Template with pay period hours summary and overtime and gross pay calculator spreadsheet cover image for Google Sheets and Excel, showing a preview of the sheet with feature labels.
  • Product video
  • May include: A digital payroll tool from TeamTimeTools featuring an Excel spreadsheet and Google Sheets PDF. It includes seven tabs: Start Here, Pay Period, Export, Settings, Employees, Hours Log, and Pay Calendar, with built-in instructions and sample data for tracking hours, overtime, and gross pay.
  • May include: A digital time tracking interface titled TeamTimeTools with the heading Log hours as you go. It displays a table with columns for Date, Employee, Hours, Type, Note, Work hrs, Leave hrs, and Check, followed by three informational boxes.
  • May include: A data table titled Overtime done per workweek from TeamTimeTools showing employee hours, overtime eligibility, and pay. It includes columns for employee names, OT eligible status, weekly hours, regular hours, overtime hours, and overtime pay.
  • May include: A digital interface titled Export for payroll by TeamTimeTools displaying two tables. The top table lists employee payroll data including period dates, regular hours, overtime, leave, total hours, and gross pay. The bottom table shows a Pay Calendar with period numbers, start and end dates, work hours logged, and paid leave hours.
  • May include: An infographic titled Built for small businesses by TeamTimeTools. It displays three white cards with teal text: 30 employees, 3,000 log rows, and 2 pay schedules. Below are two text boxes labeled Hand off clean numbers and Good to know.
  • May include: A digital product information graphic titled Works in Google Sheets + Excel by TeamTimeTools. It features two white boxes explaining compatibility with Google Sheets and Microsoft Excel, plus a dark blue footer detailing instant download, pay period logging, and sample data inclusion.
  • May include: An infographic titled How it works by TeamTimeTools showing three steps. Step 1: Download. Step 2: Open. Step 3: Set up & log hours. Includes a green button labeled Built-in Start Here tab walks you through it and a disclaimer.
  • May include: A digital spreadsheet titled Pay Period Summary displaying employee payroll data. Columns include Employee, Department, Pay rate, OT eligible, Week 1 and 2 work hours, Regular and Overtime hours, Paid leave, and Gross pay totals.
Report this item to Etsy

Payroll Spreadsheet Google Sheets & Excel, Weekly, Biweekly Pay Period Hours Summary, Overtime, Gross Earnings Calculator, Small Business

Item highlights

  • Digital download
  • Digital file type(s): 1 ZIP

Seller's description

This payroll spreadsheet turns your team's hours into a clean pay-period summary. Log hours as you go. Then type any date to see that weekly or biweekly pay period. Each employee gets regular hours, overtime, paid leave and gross pay. Overtime is counted per workweek, not averaged. Hand the summary to your payroll provider or accountant. It does not calculate taxes or run payroll. It works in Google Sheets and Excel.

WHAT IT DOES
- Hours Log: one row per shift or day, with date, employee, hours and type (Work, PTO, Holiday, Sick... your own list). Up to 3,000 rows. The Check column flags missing fields, unknown names or types, and impossible hours.
- Pay Period: type any date and it finds the pay period. For each employee you get week 1 and week 2 hours, regular hours, overtime hours, paid leave hours, and regular, overtime, leave and gross pay, plus team totals.
- Overtime per workweek: hours over your threshold (default 40) in each workweek, at your multiplier (default 1.5). It's not averaged across a two-week period. Turn overtime off for anyone who isn't eligible.
- Export: the same summary as a plain table with period dates, ready to download as CSV.
- Pay Calendar: every pay period's dates and the hours logged in each.
- Weekly or biweekly pay periods, starting on the date you choose.

WHAT YOU GET
- 1 Excel file (.xlsx): Payroll-Hours-Summary.xlsx
- 1 PDF with your link to make your own copy in Google Sheets, plus quick-start steps
- A built-in "Start Here" tab with instructions, and sample data you can clear in a minute

HOW TO GET IT
1. After you buy, go to your Etsy account > Purchases and download your file. Etsy also emails you a download link.
2. Unzip it. Google Sheets: open the PDF, click the copy link and choose "Make a copy". The copy is saved to your own Google Drive.
3. Excel: open the .xlsx file in Excel 2010 or newer.
4. Follow the Start Here tab: set your pay frequency and first pay period, add your employees and rates, and log hours.

GOOD TO KNOW, PLEASE READ
- Gross pay only. It does NOT calculate taxes, withholding, deductions or net pay, and it is not a payroll service.
- One overtime rule: one weekly threshold at one multiplier. Daily overtime, double time, 7th-day rules and bonuses in the regular rate are not supported. Each person has one hourly rate.
- You decide who is overtime-eligible. Overtime rules vary by location, so check with your payroll provider or local labor rules. This is a calculation tool, not legal, tax or payroll advice.
- Paid leave is paid at the regular rate and does not count toward overtime.
- Weekly or biweekly only (no semi-monthly). Up to 30 employees and 3,000 log rows per file.
- This is a digital download. Nothing physical will be shipped.
- Compatible with Google Sheets (needs a free Google account) and Microsoft Excel 2010 or newer, on Windows or Mac. Not designed for Apple Numbers.
- Because this is a digital file, returns aren't accepted. If something isn't working, send me a message and I'll help.

HOW THIS WAS MADE
I designed this spreadsheet with help from AI tools, which assisted with building the formulas and layout. I chose the features, and before listing it I tested every calculation against an independent check (a 24-point test plan covering pay-period boundaries, overtime at exactly 40 hours, per-week overtime, non-eligible employees, paid leave, rounding to the cent, bad log rows, and 30-employee / 3,000-row capacity).

View more
Etsy's Purchase Protection

If something goes wrong with an order, we've got your back for all eligible purchases. View program terms

Price:$14.00

You can only make an offer when buying a single item

Delivery

Instant download

Your files will be available to download once payment is confirmed. Here's how.

Instant download items don't accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Seller's description

Specifications

Payroll Template with pay period hours summary and overtime and gross pay calculator spreadsheet cover image for Google Sheets and Excel, showing a preview of the sheet with feature labels.

This payroll spreadsheet turns your team's hours into a clean pay-period summary. Log hours as you go. Then type any date to see that weekly or biweekly pay period. Each employee gets regular hours, overtime, paid leave and gross pay. Overtime is counted per workweek, not averaged. Hand the summary to your payroll provider or accountant. It does not calculate taxes or run payroll. It works in Google Sheets and Excel.

WHAT IT DOES
- Hours Log: one row per shift or day, with date, employee, hours and type (Work, PTO, Holiday, Sick... your own list). Up to 3,000 rows. The Check column flags missing fields, unknown names or types, and impossible hours.
- Pay Period: type any date and it finds the pay period. For each employee you get week 1 and week 2 hours, regular hours, overtime hours, paid leave hours, and regular, overtime, leave and gross pay, plus team totals.
- Overtime per workweek: hours over your threshold (default 40) in each workweek, at your multiplier (default 1.5). It's not averaged across a two-week period. Turn overtime off for anyone who isn't eligible.
- Export: the same summary as a plain table with period dates, ready to download as CSV.
- Pay Calendar: every pay period's dates and the hours logged in each.
- Weekly or biweekly pay periods, starting on the date you choose.

WHAT YOU GET
- 1 Excel file (.xlsx): Payroll-Hours-Summary.xlsx
- 1 PDF with your link to make your own copy in Google Sheets, plus quick-start steps
- A built-in "Start Here" tab with instructions, and sample data you can clear in a minute

HOW TO GET IT
1. After you buy, go to your Etsy account > Purchases and download your file. Etsy also emails you a download link.
2. Unzip it. Google Sheets: open the PDF, click the copy link and choose "Make a copy". The copy is saved to your own Google Drive.
3. Excel: open the .xlsx file in Excel 2010 or newer.
4. Follow the Start Here tab: set your pay frequency and first pay period, add your employees and rates, and log hours.

GOOD TO KNOW, PLEASE READ
- Gross pay only. It does NOT calculate taxes, withholding, deductions or net pay, and it is not a payroll service.
- One overtime rule: one weekly threshold at one multiplier. Daily overtime, double time, 7th-day rules and bonuses in the regular rate are not supported. Each person has one hourly rate.
- You decide who is overtime-eligible. Overtime rules vary by location, so check with your payroll provider or local labor rules. This is a calculation tool, not legal, tax or payroll advice.
- Paid leave is paid at the regular rate and does not count toward overtime.
- Weekly or biweekly only (no semi-monthly). Up to 30 employees and 3,000 log rows per file.
- This is a digital download. Nothing physical will be shipped.
- Compatible with Google Sheets (needs a free Google account) and Microsoft Excel 2010 or newer, on Windows or Mac. Not designed for Apple Numbers.
- Because this is a digital file, returns aren't accepted. If something isn't working, send me a message and I'll help.

HOW THIS WAS MADE
I designed this spreadsheet with help from AI tools, which assisted with building the formulas and layout. I chose the features, and before listing it I tested every calculation against an independent check (a 24-point test plan covering pay-period boundaries, overtime at exactly 40 hours, per-week overtime, non-eligible employees, paid leave, rounding to the cent, bad log rows, and 30-employee / 3,000-row capacity).

Shop with confidence
Etsy Purchase Protection

If something goes wrong with an order, we've got your back on all eligible purchases. View program terms

Meet your seller

Joey
TeamTimeToolsDesigns ·

United States

No reviews yet
·
0 sales
·
New on Etsy

Buy together, get 15% off

Bundle price: $33.15

View more items
May include: A digital Payroll Hours Summary spreadsheet interface by TeamTimeTools. The table displays employee names, hourly rates, weekly hours, regular and overtime hours, leave, and calculated pay totals in dollars for the period of Oct 12-25, 2026. This listing

Payroll Spreadsheet Google Sheets & Excel, Weekly, Biweekly Pay Period Hours Summary, Overtime, Gross Earnings Calculator, Small Business

Sale Price $11.90

Original Price $14.00

15% off "buy together" offer

Digital Download

May include: A digital spreadsheet interface titled Weekly Timesheet + Overtime by TeamTimeTools. It displays a Weekly Summary table with employee hours, pay rates, and gross pay, followed by a Time Log table for clock-in, clock-out, and break times.

Timesheet Template Google Sheets & Excel, Weekly Employee Time Card, Overtime Calculator, Hours, Gross Pay Tracker, Small Business

Sale Price $11.05

Original Price $13.00

15% off "buy together" offer

Digital Download

May include: A digital employee shift schedule template titled TeamTimeTools. The interface displays a weekly schedule for November 2nd to 8th, 2026, featuring columns for employee names, roles, daily shifts, total hours, and maximum hours with status alerts.

Employee Schedule Template Google Sheets & Excel, Weekly, Monthly Shift Planner, Staff Rota, Coverage, Work Hours, Small Team Roster

Sale Price $10.20

Original Price $12.00

15% off "buy together" offer

Digital Download

May include: A digital Payroll Hours Summary spreadsheet interface by TeamTimeTools. The table displays employee names, hourly rates, weekly hours, regular and overtime hours, leave, and calculated pay totals in dollars for the period of Oct 12-25, 2026. This listing

Payroll Spreadsheet Google Sheets & Excel, Weekly, Biweekly Pay Period Hours Summary, Overtime, Gross Earnings Calculator, Small Business

Sale Price $11.90

Original Price $14.00

15% off "buy together" offer

Digital Download

May include: A digital spreadsheet interface titled Weekly Timesheet + Overtime by TeamTimeTools. It displays a Weekly Summary table with employee hours, pay rates, and gross pay, followed by a Time Log table for clock-in, clock-out, and break times.

Timesheet Template Google Sheets & Excel, Weekly Employee Time Card, Overtime Calculator, Hours, Gross Pay Tracker, Small Business

Sale Price $11.05

Original Price $13.00

15% off "buy together" offer

Digital Download

May include: A digital employee shift schedule template titled TeamTimeTools. The interface displays a weekly schedule for November 2nd to 8th, 2026, featuring columns for employee names, roles, daily shifts, total hours, and maximum hours with status alerts.

Employee Schedule Template Google Sheets & Excel, Weekly, Monthly Shift Planner, Staff Rota, Coverage, Work Hours, Small Team Roster

Sale Price $10.20

Original Price $12.00

15% off "buy together" offer

Digital Download

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 29, 2026
Homepage Paper & Party Supplies Paper Calendars & Planners