Small Business PTO Manager Excel Template – Support

Posted on
PTO Manager Excel Template - Product Features

Thanks for visiting the support page for PTO Manager Excel Template. The following are the support articles to help you get started with using the template. If there are any questions not addressed here, please drop a comment and I will add article/video demo about that topic.


Support Articles

80 thoughts on “Small Business PTO Manager Excel Template – Support

  1. Hi

    I recently purchased this software, so I am trying to figure out the calculations. For an employee, I entered the start PTO date as 12/15/19 with a carryover earned PTO was 98 hours for 2020. The employee used PTO for the entire pay period, except for a holiday. The total PTO used was 56 hours; however, the current balance shown on the spreadsheet is zero. I believe the PTO balance shout be 42. Please advise.

    Also, how do you show PTO not being accrued for several months? The employees received their salary while not working due to COVID-19.

    Thank you for your assistance.

    1. Thanks for using our template.

      Please ensure that the PTO availed has been put in the sheet correctly. For instance, if an employee avails two days leaves, you need to enter the hours as 8 and not 16. Also, the adjustment sheet can be used to show that PTO did not accrue during the time of COVID-19.

      Please check the details and if the issue is not resolved, please email your file along with the list of issues to

      Best wishes

  2. I have all my data in.(Sample Employee ) But I am finding that the PTO balance isn’t calculating on the PTO Report page. Can you help on this?

    1. Thanks for using our template.

      Please email your file along with the list of issues to

      Best wishes

  3. I’m finding that one cell o the PTO REPORT doesn’t display PTO days. May 25, 2020, cell AB22 doesn’t turn color to show PTO or Personal Day when that day is added in TIME OFF. I’ve seen this with two employees. If I change it to the 26th, it displays, or the 24th. The conditional formatting looks fine. Could someone offer a suggestion to troubleshoot, please? This is truly a great spreadsheet. Thanks!

    1. Thanks for purchasing. Can you please email file to and specify the question? We can review and get back to you with the solution.
      Best wishes.

  4. Hello,

    I’ve been using this PTO Template for about 2 years, and suddenly Cell AJ6 on the ‘PTO Report’ sheet has stopped displaying the selected employee’s balance. I tried reinputting all my data into a fresh copy of the template, and I’m getting the exact same problem there. How can I fix this?

    Thank you

    1. Nevermind, I found the support article.

      1. Thanks!!!

  5. Hello There

    I absolutely LOVE this template, however I can not for the life of me figure out how to change the PTO policy for front loading PTO on January 1 and not have it accrue on a monthly basis? We front load everyone with PTO at the beginning of the year to avoid the accrual hassle every month. Thoughts on how I can just add in the PTO amounts and not have it calculate on a monthly basis per employee. I love the tracking of the employees and their time off to show ownership. I appreciate your help!

    1. Thanks for purchasing.
      For annual front-loading, please Annual as the accrual period, 1/1/2020 as First Accrual period Begin Date and Beginning as the Accrual timing. This will front-load on Jan 1st for all employees. Explained with screenshots here:
      Please let us know if any questions.
      Best wishes.

  6. Good Day, is there an easy way to print a report of all available PTO instead of one by one?

    1. Thanks for using our template.

      We will try to incorporate your recommendations in the future release.

      Best wishes

  7. I would like to know if I can change the PTO Accrual Period to a Daily is this possible?

    1. Thanks for using our template.

      At present, the accrual period can be weekly or more than that. We will try to incorporate your recommendations in a future releases.

      Best wishes

Leave a Reply

Your email address will not be published. Required fields are marked *