cancel
Showing results for 
Search instead for 
Did you mean: 
accuratemetal
Level 1

Vacation accrual

Hello, 

 

I am using enhanced desktop payroll. Our employees accrue 1 hour of vacation time for every 51 hours they work. I have been unsuccessful in setting up this type of accrual in QB. Can you please help?

 

13 Comments 13
MadelynC
Moderator

Vacation accrual

I’m here to help set up vacation accrual in QuickBooks, @accuratemetal.


In QuickBooks Desktop, vacation accrual depends on your paid time off policy. That means you need to set up a policy first before your employees can take time off. 

 

Here's how:

 

  1. Go to the Lists menu, then Payroll Item List.
  2. Select Payroll Item ▼ dropdown, then New.
  3. Choose Custom Setup, then Next.
  4. Pick Wage, then Next.
  5. Choose Annual Salary or Hourly Wages, then Next.
  6. Click Vacation Pay, then Next.
  7. Enter a name for the item, then Next.
  8. Choose the expense account you want for the item, then Finish.


You can use this information to set up and track time off for your employees in QuickBooks Desktop Payroll.


Please know that your employee's PTO calculation depends on how you set it up in the program or how it will accrue.


Let’s say 40 hours which is the most common hours of work per week. You can refer to the steps below on how it's calculated in the program:

 

  1. Figure out how many hours your employee works in a year.
  2. Multiply it with the number of weeks in a year.
    • 40 hours (Hours in 1 work week) x 52 weeks = 2,080 hours   
  3. Subtract the number of hours amount allocated for PTO.
    • 2080 hours – 40 hours (Allocated PTO) = 2,040 hours
    • 2,040 hours – 40 hours (5 paid vacation days off = 40 hours) = 2,000 hours per year
  4. Divide the number of allocated vacation hours by the total hours per year.
    • 40 hours (Hours in 1 work week) ÷ 2,000 yearly hours worked = .02 hours


By using the following calculation, it means your employee will earn .02 hours of PTO per day.


I’ve attached some resources that provide more information about vacation time:

 


Let me know if you have any additional payroll questions or concerns. I'm always here to help you out. Have a great day!

accuratemetal
Level 1

Vacation accrual

This does not help me. Our employees earn 1 hour of paid time off for every 51 hours they work. We pay weekly. Some employees work full time, some work overtime, some are part time. 

Kristine Mae
Moderator

Vacation accrual

Let me help you from here, Accuratemetal.

 

First, you'll have to set up Every hour on paycheck as the accrual period to achieve your goal. Next, decide how many hours you would want your employees to get each year if they will be working a regular full-time schedule. Then, we'll have to figure out how many hours your employees would work in a year if they'll be working full time. 

 

Feel free to check the articles provided by my colleague at the top to guide you better.

 

If there's anything else that you need, don't hesitate to let us know. We'll reply as soon as we can.

accuratemetal
Level 1

Vacation accrual

I guess i am not understanding. 

 

Our employees do not have a cap on overtime. They work as little or as much as they want. Some employees work 60 hours per week. Some only 38. Our companies accrual policy is 1 hour of paid time off for every 51 hours the employee works. It is completely up to the employee on how much pto they get. They can work as many hours as they want and accrue pto faster. 

DebSheenD
QuickBooks Team

Vacation accrual

Hello, accuratemetal.

I appreciate your time in sharing your concern here in the Community.

Let me share some insights about vacation accrual. 
Vacation accrual depends on your accrual policy, you've mentioned that your companies policy is 1 hour of PTO for every 51 hrs. of employee works. That means you need to set up a policy before your employee can take the PTO.

Here's how:
 

  1. Click Lists, then Payroll Item List.
  2. Select Payroll Item ▼ dropdown, then New.
  3. Click Custom Setup, then Next.
  4. Choose Wage, then Next.
  5. Select Annual Salary or Hourly Wages, then Next.
  6. Click Vacation Pay, then Next.
  7. Enter a name for the item, then Next.
  8. Choose the expense account you want for the item, then Finish.


You can use this link for additional information on how to set up and track time off in payroll in QuickBooks Desktop.


I've also added this article that can help you on how to fix sick and vacation time incorrect or not accruing on paychecks.

Let me know if you have additional concerns in managing your employees. I'm one post away.
 

IM13
Level 1

Vacation accrual

I will divide the one hour vacation by the 51 work time needed to accrue the one hour, then on the Create Vacation Pay Policy will set on the space for Hours accrued “per hour worked” on the hours per hour worked “the number you got, which is .0196.   That’s  what I will do, I don’t know if you already solve this issue, if you do, let me know your way, I can learn something. 

WYO2021
Level 3

Vacation accrual

Just go to Edit (top bar)
Preferences
Scroll down to "Payroll & Employees
Click "Company Preferences" at the top
Click "Sick and Vacation Time" on the right
Choose Every Hour on Paycheck in the Accrual period dropdown list

Put 00:02:00 in the Hours Accrued per Paycheck box
Put your Maximum if you have one or leave blank - if it makes you put something put 2080 hours
Make sure to check the Sick and vacation hours paid box at the bottom so employees aren't accruing vacation time on vacation time.
Click OK on the top right.

That's it! 😁 I attached a pic to help you.

lwilkerson
Level 2

Vacation accrual

Did anyone ever resolve this?  The answers given here were not based on time, but fractions of hours.  Based on what I see, you would need to enter 1 minute 11 sec (0:01:11) accrual per hour to get the 1 hour (plus 21 seconds) per 51 hours of vacation time.

lwilkerson
Level 2

Vacation accrual

From what I see you select to accrue per hour.  You would need to enter 1 minute 11 sec (0:01:11) accrual per hour to get the 1 hour vacation time (plus 21 seconds) per 51 hours worked.  Be sure to check the box to accrue for overtime hours.

Hollygirl1
Level 1

Vacation accrual

So I pay my staff 1 vacation hour for every 40 hours worked. This could be in a single week or more. How do I calculate the hours accrued for every hour paid?

Carneil_C
QuickBooks Team

Vacation accrual

Thanks for chiming in on this thread, @Hollygirl1.

 

I know a couple of procedures to calculate the hours accrued for every hour paid in QuickBooks Desktop.

 

To calculate it from the payroll information, you can follow the steps below on how to do so:

 

  1. Go to the Employees menu, then Employee Center.
  2. Select the employee's name.
  3. Click Payroll Info, then select Sick/Vacation.
  4. From the section, tap the Accrual period ▼ dropdown menu and choose Every paycheck.
  5. In the Hours Accrued field, enter the number of hours that will be accrued.
  6. Enter the date that sick time should begin accruing.
  7. Hit OK to record your changes.

 

For a more detailed step-by-step procedure for this process, you can visit this article: Set up and track time off in payroll.

 

Additionally, I'll share this resource about fixing incorrect vacation accruals: Fix incorrect sick and vacation accruals in QuickBooks Desktop Payroll.

 

Keep me posted if you have any additional payroll questions or concerns. I'm always here to help you out. Keep safe always.

Tracy_K
Level 2

Vacation accrual

Thank you, this works for Minnesota's new Earned Sick and Safe Time which states employees must earn 1 hour per every 30 hours accrued.  For QB hours accrued per hour paid: the calculation is 1 hour worked divided by 30 hours earned = .3333 decimal hours, then covert this to time: .3333 = 00:02:00 hours so to verify the calculation will work, 2 minutes earned for every 1 hour worked is 2 minutes x 30 hours (MN ESST) = 60 minutes (1 hour) earned. In QuickBooks desktop Sick and Vacation, enter 00:02:00 in the hours accrued per hour paid field.

Tracy_K
Level 2

Vacation accrual

Thank you, this works for Minnesota's new Earned Sick and Safe Time which states employees must earn 1 hour per every 30 hours accrued.  For QB hours accrued per hour paid: the calculation is 1 hour worked divided by 30 hours earned = .3333 decimal hours, then covert this to time: .3333 = 00:02:00 hours. So to verify the calculation will work, 2 minutes earned for every 1 hour worked is 2 minutes x 30 hours (MN ESST) = 60 minutes (1 hour) earned. In QuickBooks, enter 00:02:00 in the hours accrued per hour paid field.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us