Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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! Go to Solution.
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:
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:
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.
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
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:
Let me know if you have further questions in managing your payrolls in QBO, I’m only a post away from you.
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
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.
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?
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.
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
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
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.
Hi,
Is there any more progress on this thread?
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:
Is there any update to the 52 week average payroll?? If its law surely should be available?
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?
HI - How do you calculate a 52 week average pay on advance payroll?
Hi - we are using advanced payroll - how do we do this?
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.
Hi, this sounds like exactly what I need but I don't have a setting for include for the 52 week AL?
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:
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!
Hi, im using the essentials. Do i assume there isn't an easier way as sounds a nightmare
Hello JuJus, no there is no other way to do it im afraid.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.