FFCRA payroll hours report

Hello there, @JeanG, 

I appreciate you for letting me know the changes you've made on the Payroll Detail Review report. 

Currently, we're unable to total the Qty column for each employee in the said report. I've got two alternative methods to help achieve your goal. 

First, I'd suggest exporting the report to Excel so you can manually calculate the total amounts under the Qty column. This way, you'll see how close they are to the 80 hour limit for those with COVID-19. I'll guide you how.  

1. Open the Payroll Detail Review report again. 
2. Choose Create New Worksheet from the Excel drop-down list. 
3. Click Export. 
4. Manually calculate the total amounts under the Qty column for each employee. 

The screenshot below shows you the second to third steps. For your reference, check out this article: Exporting Reports To Excel From QuickBooks Desktop (QBDT). 

Here's a sample screenshot of the result: 

The second option is to run the Payroll Item Detail report. Then, follow the same customization settings you've performed above. Here's what it looks like: 

In the meantime, I recommend checking out this website to learn more about our product improvements: What's New. Just go to the QuickBooks Enterprise section. For the latest payroll news, visit this link: Updates. 

Aside from the two payroll reports above, you can run and customize other ones in QBDT. These will help you manage payroll and keep track of your employee expenses. You can also memorize them for easy access in the future. 

I'll be right here to help if you need anything else. Keep safe always. 

Thank you Raymond. I knew I could export the report to Excel, but that is laborious to do every time I need the report. It ended up that a manager from Intuit called me and we came up with another solution.

Run the Payroll Item Detail

Modify report

      add the column QTY to show the hours

      filter Payroll Item to only National Paid Leave EE

Then to see the information by employee with total hours for each, change Total by button to Employee.

That makes just the report I was looking for. :)

Hey there, @JeanG.

Thanks for following up with us. 

I'm happy to see you've found the right report for you. You can reach out to the Community any time you need a helping hand. Take care and have a great weekend!