{"product_id":"employee-hourly-tracker-google-sheets-semi-monthly-payroll-timesheet-digital-download","title":"Employee Hourly Tracker Google Sheets | Semi-Monthly Payroll Timesheet (Digital Download)","description":"Stop juggling separate timesheets for every employee. This Employee Hourly Tracker is a fully editable Google Sheets template built for semi-monthly payroll, with room for up to 30 employees and a full year of pay periods already set up.\n\nWHAT'S INCLUDED\n\n- Employee List tab: add your team's names once (up to 30) - every other tab pulls names from here automatically. Set your own 2-tier overtime rates here too.\n- 12 monthly tabs (Jan-Dec): each split into two semi-monthly pay periods, the 1st-15th and the 16th through month end.\n- Annual Summary tab: every employee's hours across all 24 pay periods for the year, their annual total, and their annual Regular\/OT1\/OT2 breakdown.\n\nHOW IT WORKS\n\nEnter daily hours in the cream cells on each month tab. Reg Hrs, OT1 Hrs, OT2 Hrs, and period totals calculate automatically using the two overtime tiers you set on the Employee List tab (defaults: 1.5x after 8 hrs\/day, 2x after 10 hrs\/day - fully adjustable to your own policy, including businesses that don't owe daily overtime at all). At the end of each month, both pay periods combine into a Month Total, and the Annual Summary rolls everything up for the year.\n\nWHY YOU'LL LOVE IT\n\n- Instant digital download, start today\n- 100% editable in Google Sheets, no software to install\n- Configurable 2-tier overtime rates - not locked to one rule\n- Built for a real semi-monthly payroll calendar, not a generic weekly template\n- Names entered once, pulled everywhere - no retyping or mismatched spelling\n- Clean, modern design that's easy on the eyes\n- Step-by-step instructions PDF included\n\nHOW TO GET STARTED\n\nAfter purchase, you'll receive a PDF with a link to make your own copy of the Google Sheets template. No account needed beyond a free Google login.\n\nThis is a digital product - no physical item will be shipped. Not payroll or legal advice; always confirm overtime and wage calculations against your local employment standards.","brand":"My Store","offers":[{"title":"Default Title","offer_id":55906664055106,"sku":null,"price":14.95,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1027\/6290\/5922\/files\/ac5d0d70-il_fullxfull.8416614491_7dh2.jpg?v=1786565087","url":"https:\/\/khoperations.com\/products\/employee-hourly-tracker-google-sheets-semi-monthly-payroll-timesheet-digital-download","provider":"KH Operations","version":"1.0","type":"link"}