Skip to main content
January 18, 2020
Solved

PTO hours accrued per hour paid - QB keeps changing the number

  • January 18, 2020
  • 2 replies
  • 0 views

Hello, I am changing our PTO accrual to be based on hours worked/every hour on paycheck. However, whenever I enter the numbers I want, e.g., 0.05769 (for 120 hours PTO annually) or 0.03846 (for 80 hours PTO annually), Quickbooks keeps changing the numbers to 0.05778 and 0.03833, respectively. I cannot get my numbers to hold. The PTO will be off if I go with the QB numbers.

I set up this same thing in TSheets and everything accrued correctly in there.

Please help, thank you. 

Best answer by AlcaeusF

Welcome to the Community, @Sloaney.

 

When entering an amount in the Hours accrued per hour paid field, QuickBooks can at most round it up to the nearest second only. Since the system can't calculate millisecond, the amount you enter will change to the nearest number possible.

 

Since there's a limitation with the information you need to enter into the program, I recommend adjusting the hours' available section (see screenshot below).

 

 

I understand how the workflow you're looking for is beneficial to your business. Since it's unavailable, you can visit our blog and sign up to our Newsletter for the time being.

 

Stay in touch whenever you have additional questions about QuickBooks Desktop. I’m here to make sure you’re taken care of. Have a great rest of the day.

2 replies

AlcaeusF
AlcaeusFAnswer
January 18, 2020

Welcome to the Community, @Sloaney.

 

When entering an amount in the Hours accrued per hour paid field, QuickBooks can at most round it up to the nearest second only. Since the system can't calculate millisecond, the amount you enter will change to the nearest number possible.

 

Since there's a limitation with the information you need to enter into the program, I recommend adjusting the hours' available section (see screenshot below).

 

 

I understand how the workflow you're looking for is beneficial to your business. Since it's unavailable, you can visit our blog and sign up to our Newsletter for the time being.

 

Stay in touch whenever you have additional questions about QuickBooks Desktop. I’m here to make sure you’re taken care of. Have a great rest of the day.

SloaneyAuthor
January 18, 2020

Thank you for the quick response. When you say adjust the hours available section, how do you mean? Put in more decimal places? Something else?

 

Since I am putting in the same number of decimal places, why is QB reverting to some other number with the same number of decimal places? 

 

Thanks again.

January 19, 2020

Hi there, Sloaney.

 

As what my colleague mentioned above means, you'll need to manually add the lacking hours in the Hours available box.

 

From your other concern about why is QB reverting to some other number with the same number of decimal places, this is how QuickBooks works when you enter an amount in the Hours accrued per hour paid field.

 

Please check this article on how to allow you to either give a lump sum at the beginning of the year, or choose between two types of paid time off accruals (sick and vacation time) that can be used when paying employees: Set up and pay sick and vacation time.

 

Please know that you're always welcome to post if you have any other concerns. Wishing you and your business continued success.

November 16, 2023

We notice a issues here where Quickbooks accrued time was not matching T-Sheets (AKA Quickbooks time)

What we found is very alarming. Quickbooks will accrue on hours PAID where T-Sheets accrues on hours WORKED. 

 

The difference is that T-Sheets is not going to accrue sick or vacation time on sick and vacation hours as these are not hours worked BUT quickbooks will accrue PTO because these are hours paid.

 

QB and T-Sheets needs to each have a 3rd option so that all options are covered under both platforms.  Right now the only option covered under both platforms is accruals per pay period

 

1: Accrue PTO per pay period

2: Accrue PTO per hour worked

3: Accrue PTO per hour paid.

 

QB - can you please comment on this?  

 

Thanks!

November 16, 2023

I appreciate you taking the time to share information about the tracking features for Paid Time Off (PTO) accruals in QuickBooks Time and QuickBooks Payroll, vesacre55.

 

You're correct that there is a difference in how these platforms handle PTO accruals.

 

In QuickBooks Payroll, PTO accruals are typically based on hours paid. This means that PTO is accrued based on the hours for which employees are compensated, whether or not those hours were actually worked. This setup ensures that employees continue to accrue PTO even when they are not physically working, such as when they are on vacation or sick leave.

 

On the other hand, QuickBooks Time sets up PTO accruals based on hours worked. This means that PTO is accumulated based on the actual hours employees have worked. QuickBooks Time's main focus is tracking time worked for accurate payroll records.

 

As a result of the differences in the features and capabilities between the two services, PTO accruals may vary. This is why it is important to review and align your PTO policies and settings in both platforms in order to select the best setup to ensure consistency and accuracy in your PTO tracking.

 

For more information on setting up and tracking PTO, you may find the following articles helpful::

 

 

If you have any further concerns or questions, please feel free to share them in the comment section below. I'll be happy to assist you. Have a great day!