{"id":12974,"date":"2026-09-19T15:06:29","date_gmt":"2026-09-19T15:06:29","guid":{"rendered":"https:\/\/templacity.com\/?post_type=product&#038;p=12974"},"modified":"2026-10-17T09:17:48","modified_gmt":"2026-10-17T09:17:48","slug":"staff-schedule-timesheet-spreadsheet","status":"publish","type":"product","link":"https:\/\/templacity.com\/nl\/product\/staff-schedule-timesheet-spreadsheet\/","title":{"rendered":"Staff Schedule &#038; Timesheet Spreadsheet (Google Sheets + Excel)"},"content":{"rendered":"<p><span class=\"eyebrow\">\u2116 \u00b7 Schedule it once, pay it right<\/span><\/p>\n<h2 id=\"a-staff-schedule-and-timesheet-spreadsheet-that-flags-overtime-before-the-week-starts\">A staff schedule and timesheet spreadsheet that flags overtime before the week starts<\/h2>\n<p>The Staff Schedule &amp; Timesheet is for a cafe, shop, clinic or crew that schedules by the shift and pays by the hour. On Settings, set the day your week starts, the pay period (every two weeks to start) and when the first one began, the overtime limit (40 hours a week) and rate (1.5), and your roles. Add your people on Staff with their role, hourly rate and most hours a week.<\/p>\n<h3>Schedule, then what really happened<\/h3>\n<ol>\n<li>Schedule on Shifts, one row per shift: date, person, role, start, end and unpaid break. Leave the person blank and it is an open shift.<\/li>\n<li>Week turns the list into a rota, people against days, coloured by role, with hours and wages each. Anyone scheduled past the overtime limit shows Overtime before the week starts, when it is cheapest to fix.<\/li>\n<li>Timesheet records clock in, clock out and break, sets the hours worked against the schedule, and takes an Approved tick.<\/li>\n<li>Pay Period gives regular and overtime hours and gross pay per person for any weekly or two-week period.<\/li>\n<\/ol>\n<p>A shift that ends after midnight needs no trick: type the end time as it is. The same week again? Copy the week&#8217;s rows on Shifts, paste them below and add 7 to the dates.<\/p>\n<p>The download is a short PDF with two Google Sheets buttons, one for a blank copy in your own Drive and one for a copy filled with an example, the same workbook as blank and example Excel files, and a one-page Quick Start for each.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Build the rota, record the hours actually worked, and see pay for any pay period: overtime flagged, open shifts shown, timesheets approved with a tick.<\/p>\n","protected":false},"featured_media":17032,"comment_status":"open","ping_status":"closed","template":"single-product-bundle.html","meta":{"rank_math_title":"Staff Schedule and Timesheet Template, Sheets and Excel | Templacity","rank_math_description":"An employee schedule and timesheet spreadsheet for Google Sheets and Excel: weekly rota, open shifts, overtime flags, approved hours and pay per period.","rank_math_seo_score":"9","_templacity_copy_live":"1","_templacity_faq":[{"q":"How is overtime worked out?","a":"Per week. Hours past the limit on Settings, 40 to start, in any one week are paid at the overtime rate, 1.5 to start. Both are yours to change."},{"q":"What about a shift that ends after midnight?","a":"Type the end time as it is. The hours still come out right."},{"q":"Can it show open shifts?","a":"Yes. A shift with no person on it is open, and the Dashboard counts the open shifts in the next 14 days."},{"q":"Does it calculate net pay?","a":"It gives gross pay per person for the period, regular and overtime. Taxes and deductions come from your payroll provider."},{"q":"Does it work in Excel?","a":"Yes. The download carries native .xlsx files, one blank and one filled with an example, for Excel 2010 and later, Excel for Mac and Microsoft 365. Every formula is ordinary Excel, with no macros to enable."}]},"niche":[337],"template_type":[],"templacity_topic":[],"product_brand":[],"product_cat":[24],"product_tag":[44],"class_list":["post-12974","product","type-product","status-publish","has-post-thumbnail","niche-spreadsheets","product_cat-spreadsheets","product_tag-google-sheets","first","instock","downloadable","virtual","purchasable","product-type-simple"],"_links":{"self":[{"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product\/12974","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/comments?post=12974"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/media\/17032"}],"wp:attachment":[{"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/media?parent=12974"}],"wp:term":[{"taxonomy":"niche","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/niche?post=12974"},{"taxonomy":"template_type","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/template_type?post=12974"},{"taxonomy":"templacity_topic","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/templacity_topic?post=12974"},{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product_brand?post=12974"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product_cat?post=12974"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product_tag?post=12974"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}