cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
taniaharve
Level 1

Holiday pay and holiday entitlement

My staff are allow the standard 28 days holiday (pro-rata for part-timers) plus we give them an additional day's holiday for their birthday.  My staff have minimum hours contracts but their hours vary every week above that minimum.  How do I calculate holiday pay given that we have to calculate holiday pay based on average pay from the previous 52 weeks.

 

I have QBO Advanced payroll

Solved
Best answer February 01, 2022

Accepted Solutions
GeorgiaC
QuickBooks Team

Holiday pay and holiday entitlement

Hi Martin, this feature is not yet available, we'd strongly recommend leaving feedback as developments are based in part on customer-demand, so it would be great to get all the input we can for this - you can leave this by selecting the settings wheel > feedback within your account. 🙇‍:female_sign:

View solution in original post

21 REPLIES 21
MaryLandT
Moderator

Holiday pay and holiday entitlement

A pleasant day, taniaharve,

 

I'm here to help add a holiday pay type for your employee in QuickBooks Online Advanced Payroll.

 

You'll want to set up a separate rate of pay as holiday on a payslip. This is the workaround while the system isn't able to accrue holidays at the moment.

 

To do this, you'll want to go to the employee section and find the employee you wish to add holiday pay for. Here's how:

  1. Go to the Employees tab.
  2. Find the employee you wish to add holiday pay for
  3. Choose (at the bottom of the page), then select Other pay.
  4. Select or search for the pay type you want to add. If you can’t find the pay type you’re looking for, you can add it.
  5. Choose an option you will have the ability to rename this as 'Holiday pay' or however you wish to record this.
  6. Save your changes.

Check out the QuickBooks Online Advanced Payroll Hub page to help manage your payroll settings, employees, and processing pay runs.

 

Keep me posted if there's anything else you need concerning payroll. I'm always right here to help.

Accounts Axminster
Level 1

Holiday pay and holiday entitlement

Hi there,

 

I am interested in the same topic. Does QB provide any report with 52 weeks average which could be used for holiday pay calculation?

 

Thanks

Kind Regards

 

Miriam

JasroV
QuickBooks Team

Holiday pay and holiday entitlement

Great to have you hear in the Community, @Accounts Axminster.

 

Currently, there isn’t a report that generates the calculation of holiday pay base on the average pay from the previous 52 weeks. However, if you have set up a separate payslip rate for holiday pay as shared by my colleague above, I got a workaround that you can consider.

 

You’ll want to go to the Employees menu and run the Pay Categories Report. This report shows the rates that employees are paid. Let me guide you how to pull up the report in your QuickBooks Online (QBO) account.

 

Here’s how:

  1. Go to the Employees menu.
  2. Click the Reports tab.
  3. Select Pay Categories Report under the PAYROLL section.
  4. Adjust the date range if necessary and click Run Report.

Let me know if you have further questions in managing your payrolls in QBO, I’m only a post away from you.

DebOK
Level 3

Holiday pay and holiday entitlement

I also have this question and the previous replies don't actually answer the question.

 

How do we create a report that will give the average hours over the last 52 weeks.  Can one be built by the support team?

 

many thanks

Ashleigh1
QuickBooks Team

Holiday pay and holiday entitlement

Hello DebOK, 

 

Thanks for commenting on this thread, 

 

we have taken on board your feedback and we will pass it on to our developers and it might be something that comes out in the future. 

Alicja G
Level 1

Holiday pay and holiday entitlement

Hi,

 

I also have the same question. Has the QB team already done the report that allows me to check the average hours over the 52 week period? 

ShiellaGraceA
QuickBooks Team

Holiday pay and holiday entitlement

Thanks for joining us here today, @Alicja G.

 

As mentioned by my colleague above, this report is currently unavailable. We will take note of this and submit it to our developers so they can consider this adding it in the future update.

 

Meanwhile, these are the available reports you might want to check:

 

 

Additionally, here's a guide that covers all tasks you can do when using the payroll feature: QuickBooks Online Advanced Payroll hub.

 

In case you need help with other tasks in QBO, click this link to go to our general topics with article.

 

Please let me know if you still have questions or concerns with payroll. I'll be around for you. Take care and have a nice day ahead.

Wriatelf
Level 1

Holiday pay and holiday entitlement

 

The change in the reference period to 52 weeks was last April. Nearly a year ago. 

 

Advanced Payroll still does not support this, neither is there a manual report available? 

 

Sort it out Intuit 

Becci6
Level 1

Holiday pay and holiday entitlement

Is there any news on if/when a report will be available to show an employees average earnings over the last 52 weeks? 

 

Thanks

 

Becci

TFDB
Level 1

Holiday pay and holiday entitlement

I have found a sort of workaround if your staff use timesheets.

 

In the reports section  you can generate a report for each person based on their timesheets submitted/paid.  Unfortunately for me it only goes back to the last 9 weeks - irrespective of what dates I ask it to give me - but as our staff are paid leave on their previous 12 weeks' average, I can manually add the difference.  You can export this to excel and then calculate the average daily pay.

 

So typical of QB not to have sorted this out yet.  They really do not comprehend how people pay their staff.

Martin Dobson
Level 1

Holiday pay and holiday entitlement

Hi,

 

Is there any more progress on this thread?

 

GeorgiaC
QuickBooks Team

Holiday pay and holiday entitlement

Hi Martin, this feature is not yet available, we'd strongly recommend leaving feedback as developments are based in part on customer-demand, so it would be great to get all the input we can for this - you can leave this by selecting the settings wheel > feedback within your account. 🙇‍:female_sign:

JuJuS
Level 1

Holiday pay and holiday entitlement

Is there any update to the 52 week average payroll?? If its law surely should be available?

GeorgiaC
QuickBooks Team

Holiday pay and holiday entitlement

Hi JuJuS, the 52 week average is able to be calculated for annual leave taken by employees on weekly, two weekly (fortnightly), four weekly and monthly pay schedules. Are you using the standard or advanced version of payroll in QuickBooks? 

Martin Dobson1
Level 1

Holiday pay and holiday entitlement

HI - How do you calculate a 52 week average pay on advance payroll?

Martin Dobson1
Level 1

Holiday pay and holiday entitlement

Hi - we are using advanced payroll - how do we do this?

 

GeorgiaC
QuickBooks Team

Holiday pay and holiday entitlement

Hi Martin, to set this up, update the settings of the pay categories to be included by navigating to Payroll Settings > Pay Run Settings > Pay Categories > Update the 52-week average field to "Include for the purpose of 52-week average calculations" - next, update the leave category in Payroll Settings > Pay Run Settings > Leave Categories > Select the Leave Category that you would like the system to base this on and tick the 52-week average calculation box.

Martin Dobson1
Level 1

Holiday pay and holiday entitlement

Hi, this sounds like exactly what I need but I don't have a setting for include for the 52 week AL?

JonpriL
Moderator

Holiday pay and holiday entitlement

Appreciate the timely response and thank you for the update, @Martin Dobson1.

 

Since you're still unable to update the pay categories from the pay run settings even after following the suggestions shared by my colleague above, I'd recommend contacting our Customer Care Support.

 

With their tools, one of our specialists can pull up your account on file and share how you can update your payroll settings. To do so:

 

  1. Go to Help.
  2. Select Contact Us.
  3. Enter a few words describing how you wish to accomplish your goal for today in the What can we help you with? field.
  4. Click Continue.
  5. Choose a channel where you wish to connect with our support.

 

I've also included this reference so you can read the articles needed while working with your payroll account with us: QuickBooks Online Advanced Payroll.

 

If there's anything else that I can help you with, please let me know in the comments below. I'll be here to lend a hand. Stay safe!

JuJuS
Level 1

Holiday pay and holiday entitlement

Hi, im using the essentials. Do i assume there isn't an easier way as sounds a nightmare

Ashleigh1
QuickBooks Team

Holiday pay and holiday entitlement

Hello JuJus, no there is no other way to do it im afraid. 

Need to get in touch?

Contact us