cancel
Showing results for 
Search instead for 
Did you mean: 
LizaG
Level 2

We started using the Holiday pay code and I need a report showing the hours used. It doesn't show under the PTO report. I definitely need an hours not dollars report

 
Solved
Best answer August 13, 2020

Best Answers
JasroV
QuickBooks Team

We started using the Holiday pay code and I need a report showing the hours used. It doesn't show under the PTO report. I definitely need an hours not dollars report

You’re always welcome, @LizaG.
 
And thanks for the clarification. Allow me to share some insights about running payroll reports in your QuickBooks Online (QBO) account. You can run the Payroll Details report. This report provides detailed information about your employee’s payroll. Since holiday pay is an added item when you run payroll, it’ll show you the holiday hours into dollar translation.
 
However, having a holiday category column in the Vacation and Sick Leave report is not possible. But, I got a workaround that you can consider. You can export your Vacation and Sick Leave report to Excel and add a holiday column from there. Once done, run the Payroll Details report as a reference in entering the holiday hours of your employees.
 
To export the report to Excel, you can follow the steps provided by my colleague MadelynC above. Also, to learn more about your payroll reports check out this article for reference: Run Payroll reports.
 
Lastly, I’ve collected some of our resources that you can use for future reference. These links can guide you on how to personalized reports and save its current settings. This way, you’ll get the information you need and open it anytime:

I’m more than happy to help you out again if you have follow-up questions about running reports in your QBO account, @Liza. Leave a reply in this thread with the details and I’ll be here to answer them for you. Have a great day!
 

View solution in original post

5 Comments
Charies_M
Moderator

We started using the Holiday pay code and I need a report showing the hours used. It doesn't show under the PTO report. I definitely need an hours not dollars report

Thanks for coming here, LizaG.

 

I appreciate you for providing details about your concern. 

 

The Holiday pay code feature in QuickBooks Online (QBO) is based percentage of pay or by rate and not hours. Thus, the PTO report will also show dollar amounts instead of hours. 

 

Find out more about managing payroll time off in QBO through this article: Set up and track time off in payroll.

 

I can see the importance of being able to customize the payroll reports based on your preference. While we find ways on how we can expand and improve this option, I want you to be update with the latest QuickBooks news and product release through our QuickBooks blog.

 

Feel free to drop me a reply below if there's anything I can help you with. Wishing you all the best!

LizaG
Level 2

We started using the Holiday pay code and I need a report showing the hours used. It doesn't show under the PTO report. I definitely need an hours not dollars report

Hi Charies,

 

I appreciate the quick response. Let me show you the PTO report so you can better understand what I'm asking. The attached report is the QBO Vacation/Sick Time Report directly out of QBO. As you can see the PTO is shown in hours not dollars since it's banked (accrued). I need the exact same report showing the hours used under the Holiday code which is how it's entered into the system when you run payroll. You don't enter a dollar amount. The only time you see the hours into dollars translation is on the Payroll Summary by Employee. If I can't get an hours report is there another report with a column showing holiday dollars so I can back into the hours used?

 

Thanks!!

MadelynC
QuickBooks Team

We started using the Holiday pay code and I need a report showing the hours used. It doesn't show under the PTO report. I definitely need an hours not dollars report

You’re most welcome, @LizaG.


I appreciate you for giving us additional details. I’m here to share information on how to get the report you need in QuickBooks Online.


You can run a Vacation and Sick Leave report. This report shows PTO available, description, and YTD that exactly looks like to the report you’ve attached.


Let me walk you through the steps:

 

  1. Navigate to the Reports menu.
  2. Enter/select Vacation and Sick Leave in the field.
  3. You can select specific or all active employees.
  4. Click Run Report.

You can also share, export, and print them if you prefer. Just select the Share drop-down on your top right to do so.

 


This article explains and provides knowledge on how to customize a report and mark them as your favorite. With this, you can easily access them as it will show up in the Favorites section: Run payroll reports.


Leave a comment below should you have other questions regarding reports in QBO. I’ll be around to help. Keep safe.

LizaG
Level 2

We started using the Holiday pay code and I need a report showing the hours used. It doesn't show under the PTO report. I definitely need an hours not dollars report

Hi Madelyn,

 

Thank you as well for your response. My original attachment is exactly what you are showing which is perfect. We use this report all the time. So what I'm asking is how can I get the Holiday Category as a column showing the Used YTD? Doesn't it pull from the pay codes table just like Vacation/PTO/Sick does?

 

Thanks!!

 

Liza

JasroV
QuickBooks Team

We started using the Holiday pay code and I need a report showing the hours used. It doesn't show under the PTO report. I definitely need an hours not dollars report

You’re always welcome, @LizaG.
 
And thanks for the clarification. Allow me to share some insights about running payroll reports in your QuickBooks Online (QBO) account. You can run the Payroll Details report. This report provides detailed information about your employee’s payroll. Since holiday pay is an added item when you run payroll, it’ll show you the holiday hours into dollar translation.
 
However, having a holiday category column in the Vacation and Sick Leave report is not possible. But, I got a workaround that you can consider. You can export your Vacation and Sick Leave report to Excel and add a holiday column from there. Once done, run the Payroll Details report as a reference in entering the holiday hours of your employees.
 
To export the report to Excel, you can follow the steps provided by my colleague MadelynC above. Also, to learn more about your payroll reports check out this article for reference: Run Payroll reports.
 
Lastly, I’ve collected some of our resources that you can use for future reference. These links can guide you on how to personalized reports and save its current settings. This way, you’ll get the information you need and open it anytime:

I’m more than happy to help you out again if you have follow-up questions about running reports in your QBO account, @Liza. Leave a reply in this thread with the details and I’ll be here to answer them for you. Have a great day!
 

View solution in original post

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up