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.

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:

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.

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:

• P32 Report 
• Generate P60s
• Submit Employment Payment Summary (EPS)
• Submit Full Payment Summary (FPS)
• Pension scheme setup
• Manual pension scheme setup

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?

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:

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!

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.