{"id":13062,"date":"2026-09-19T15:08:44","date_gmt":"2026-09-19T15:08:44","guid":{"rendered":"https:\/\/templacity.com\/?post_type=product&#038;p=13062"},"modified":"2026-09-27T15:14:02","modified_gmt":"2026-09-27T15:14:02","slug":"pto-tracker-payroll-spreadsheet","status":"publish","type":"product","link":"https:\/\/templacity.com\/nl\/product\/pto-tracker-payroll-spreadsheet\/","title":{"rendered":"PTO Tracker, Payroll &#038; Employee Records Spreadsheet (Google Sheets + Excel)"},"content":{"rendered":"<p>A PTO tracker and payroll register for small teams. Log leave requests and pay runs; workdays, balances, what unused PTO is worth and gross to net work themselves out.<\/p>\n<ul>\n<li><strong>Team Overview<\/strong>: headcount, who is out today, payroll this month, unused PTO value and anniversaries.<\/li>\n<li><strong>What If<\/strong>: the owed PTO as money, today and at the PTO year end, and who ends the year over a carry-over cap. Levers: the share taken before year end, and the cap.<\/li>\n<li><strong>Employees<\/strong>: role, department, hire date, pay, allowances and cost an hour.<\/li>\n<li><strong>Leave Log<\/strong>: every request; workdays counted, skipping weekends and your holidays.<\/li>\n<li><strong>PTO Balances<\/strong>: earned, carried in, taken, booked and left, with sick leave kept apart.<\/li>\n<li><strong>Leave Calendar<\/strong>: any month, everyone, each day of leave coloured by type.<\/li>\n<li><strong>Payroll Register<\/strong>: hours, overtime, bonus, deductions, gross and net per pay run.<\/li>\n<li><strong>Settings<\/strong>: PTO year and accrual, pay frequency, overtime, leave types and holidays.<\/li>\n<\/ul>\n<p><strong>What you get:<\/strong> a one-page PDF with two buttons. One makes a blank copy of the Google Sheet in your own Drive, the other a copy filled with an example so you can see every tab working first. The same workbook comes as two Excel files, blank and example, checked in Excel with every formula recalculated. No year is printed anywhere, so it starts the day you do.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PTO balances that accrue themselves, a colour-coded leave calendar, a payroll register with overtime, and one record per employee.<\/p>\n","protected":false},"featured_media":13445,"comment_status":"open","ping_status":"closed","template":"single-product-bundle.html","meta":{"rank_math_title":"PTO Tracker and Payroll Spreadsheet for Sheets and Excel | Templacity","rank_math_description":"A PTO tracker and payroll spreadsheet for Google Sheets and Excel: accruing leave balances, a leave calendar, payroll register and employee records.","rank_math_seo_score":"9","_templacity_copy_live":"","_templacity_faq":[]},"niche":[337],"template_type":[],"templacity_topic":[],"product_brand":[],"product_cat":[24],"product_tag":[44],"class_list":["post-13062","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\/13062","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=13062"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/media\/13445"}],"wp:attachment":[{"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/media?parent=13062"}],"wp:term":[{"taxonomy":"niche","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/niche?post=13062"},{"taxonomy":"template_type","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/template_type?post=13062"},{"taxonomy":"templacity_topic","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/templacity_topic?post=13062"},{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product_brand?post=13062"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product_cat?post=13062"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product_tag?post=13062"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}