{"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-10-17T09:17:33","modified_gmt":"2026-10-17T09:17:33","slug":"pto-tracker-payroll-spreadsheet","status":"publish","type":"product","link":"https:\/\/templacity.com\/zh\/product\/pto-tracker-payroll-spreadsheet\/","title":{"rendered":"PTO Tracker, Payroll &#038; Employee Records Spreadsheet (Google Sheets + Excel)"},"content":{"rendered":"<p><span class=\"eyebrow\">\u2116 \u00b7 Who is in, who is owed<\/span><\/p>\n<h2 id=\"a-pto-tracker-and-payroll-register-spreadsheet-for-a-team-of-up-to-forty\">A PTO tracker and payroll register spreadsheet for a team of up to forty<\/h2>\n<p>The PTO Tracker, Payroll &amp; Employee Records is for a small business owner or office manager who runs leave and pay runs without HR software. On Settings, choose when the PTO year starts, whether PTO is given monthly or all at once, your pay frequency (biweekly to start) and overtime multiplier (1.5), and your holidays. Then one row per person on Employees: hire date, pay type and rate, hours a day, and their PTO and sick hours a year.<\/p>\n<h3>Leave that counts itself<\/h3>\n<p>Log every request on Leave Log with its type. Workdays are counted for you, skipping weekends and your holidays; type hours only for a part day. Set a request to Approved and it comes off the right balance and shows on the Leave Calendar, colour-coded by type. PTO and sick leave have their own balances; parental leave, jury duty and unpaid leave are recorded but never counted against one.<\/p>\n<h3>Pay runs and what the owed time is worth<\/h3>\n<p>Payroll Register takes one line per person per pay run: hours, overtime at your multiplier, bonus and deductions to gross and net. Salaried pay fills in from the pay frequency. What If says what the owed PTO is worth if paid out today, what it grows to by the end of the PTO year, and who ends the year over a carry-over cap. The file keeps records and does sums; withholding comes from your payroll provider or official tables.<\/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>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":"1","_templacity_faq":[{"q":"How does PTO accrue?","a":"Your choice on Settings. Monthly: each person earns a twelfth of their yearly hours at the start of every month, from their hire date if they joined this year. At year start: the whole year on day one, prorated for new hires."},{"q":"Does it calculate tax withholding?","a":"No. It keeps records and does the sums. Type withholding and other deductions from your payroll provider or the official tables."},{"q":"How many employees does it hold?","a":"Up to forty."},{"q":"What happens at the end of the PTO year?","a":"Balances reset with the new PTO year. Type what each person carries over into PTO carried in, and What If shows beforehand who would end the year over a carry-over cap."},{"q":"Does it skip public holidays?","a":"Yes. Leave days are counted without weekends and the holidays on Settings. The list works out this year's dates, and you can add your own."},{"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."},{"q":"Is there a year printed in it?","a":"No. No year is printed anywhere in the files, so it starts the day you do and keeps working next year."}]},"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\/zh\/wp-json\/wp\/v2\/product\/13062","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/comments?post=13062"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/media\/13445"}],"wp:attachment":[{"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/media?parent=13062"}],"wp:term":[{"taxonomy":"niche","embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/niche?post=13062"},{"taxonomy":"template_type","embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/template_type?post=13062"},{"taxonomy":"templacity_topic","embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/templacity_topic?post=13062"},{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/product_brand?post=13062"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/product_cat?post=13062"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/product_tag?post=13062"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}