Payroll Timesheet Calculator Spreadsheet, Excel and Google Sheets, Employee Time Sheet, Overtime, Pay Stub Template, Small Business

Payroll Timesheet Calculator Spreadsheet for Microsoft Excel and Google Sheets, instant digital download. Turn clock in and clock out times into gross-to-net payroll, overtime, pay stubs and labor cost reports for your small team. Perfect for small businesses with hourly staff.

🎥 WATCH THE FULL WALKTHROUGH VIDEO before you buy, every tab explained: https://youtu.be/hCPISHoyuQM

✨ NOW INCLUDES 4 FILES: Excel + Google Sheets, each in a SAMPLE version (filled with example data so you can see how it works) and a BLANK version (ready for your own numbers).

★ WHAT'S INCLUDED ★
• 15 tabs with a clickable Start Here page
• Dashboard: 16 KPI tiles, your last 8 paydays, labor cost by department, overtime leaders, an alerts panel and 4 charts
• Employees: roster for up to 12 people, hourly or salary, personal withholding %, pre-tax retirement and health, other deductions and PTO accrual
• Time Log: 3,000 rows for clock in, clock out and unpaid breaks, with flags for missing punches, long shifts and no break
• Weekly overtime worked out for you, with your own threshold and multiplier (salaried staff treated as exempt)
• Weekly Timesheet: printable, pick an employee and week, with signature lines
• Payroll Run: gross to net for every employee in any pay period, with checks
• Pay Stub: printable, pick employee and pay period, this period and year to date
• Pay Register (53 pay periods x 12 employees), Pay Periods with paydays, and a YTD Summary per employee
• Labor Cost by department and month, PTO Tracker with a 200-row request log, and Bonuses & Extras (bonus, tips, commission, reimbursements, deductions)
• Weekly or every-two-weeks pay schedules
• 12 charts in total

★ PERFECT FOR ★
✓ Small businesses with hourly staff
✓ Cafes, shops, salons, cleaning and trades crews
✓ Owners who want to check payroll before it's paid

★ COMPATIBILITY ★
• Microsoft Excel (desktop, Mac, web)
• Google Sheets (upload to Google Drive and open with Google Sheets)
• 4 files included: an Excel version + a Google Sheets edition, each as a Sample and a Blank copy
• Not designed for Apple Numbers

★ HOW IT WORKS ★
1. Download the files right after purchase.
2. On Setup, choose your pay schedule, overtime rule and the withholding % you use.
3. Add your employees and log every shift on the Time Log.
4. Pick a pay period on Payroll Run and print timesheets and pay stubs.

Works in any currency ($, £, €, C$, A$ and more): just change the currency symbol.

★ PLEASE NOTE ★
• This is a digital download. Nothing will be shipped.
• Withholding uses percentages you enter. The file has no tax tables, wage caps or tax law, doesn't file or pay taxes, and is not tax, legal or accounting advice. Check your rates with your payroll provider or accountant.
• Because it's a digital file, returns aren't accepted, but if you have any trouble with the file, message me and I'll fix it or help you right away.