cancel
Showing results for 
Search instead for 
Did you mean: 
aroon_baksh
Level 1

paycheque history report that includes reg hours worked

I am QBO user with Payroll and trying to understand how hours worked per pay period has fluctuated for some employees over the past 3 years. They say there hours have been reduced -- we are quite certain that they have increased! 

 

Paycheque History does not include hours worked - while payroll summary on sums hours for the whole period chosen. The manual option would be to export the former and divide by the hourly rate. Not ideal but do-able if I have to . 

 

Are there any other options?  

 

Thanks, 

 

AB

4 Comments 4
MirriamM
Moderator

paycheque history report that includes reg hours worked

You can run the Payroll Details report, aroon_baksh

 

It is the best report you can pull up in QuickBooks Online (QBO) to show all the paychecks you've created, including the regular hours of work, amount, taxes, and deductions. 

 

To run the report, let me guide you through the steps.

  1. Sign in to your QuickBooks Online (QBO) account.
  2. In the left menu, click Reports.
  3. Search for Payroll Details report.
  4. Select the pay period you want to show. 
  5. Click Apply.

 

After the steps, you'll be able to see the changes in the hours worked per pay period for some employees.

 

To learn more about the other payroll reports in QBO, see this article: Run payroll reports.

 

Additionally, QuickBooks offers a variety of reports that offers details about your company. If you wish to know the available reports for your version, kindly visit this link: Reports included in your QuickBooks Online subscription.

 

Should you need additional assistance running payroll reports in QBO, I'm available here to help any time! Wishing you all the best, aroon_baksh

aroon_baksh
Level 1

paycheque history report that includes reg hours worked

Hi Mirriam, 

 

Thanks for the prompt response.

 

This is helpful, but I am trying to create a graph so that I can compare the trend in hours over time with each staff member as a different line on the graph (i.e. column in the spreadsheet) . Similar to the paycheque history report, after exporting the data to excel there a significant amount of manual effort to get each employee's data into separate columns and the dates lined up for  comparison. In addition, when running the payroll details report, I am unable to sort in date order as neither Excel or Sheets can recognize the date format. 

 

Let me know if you have any additional suggestions. 

 

Thanks, 

 

Aroon

JasroV
QuickBooks Team

paycheque history report that includes reg hours worked

I appreciate you for getting back to us and for sharing additional details, Aroon.

 

Having the option to create a graph report isn't available in QuickBooks Online (QBO). I can see having this feature is beneficial to your business.

 

As a way around, you'll want to utilize a third-party app that has this feature. Simply go to the Apps menu inside your QBO and look for an app from there.

 

In regards to sorting the date of your payroll detail report, the date is based on your employees' payday. I recommend working with an IT expert to help you in sorting out the data through MS Excel. 

 

We always value our users' opinion as this can help us make QuickBooks better for your business. I recommend sending your feedback to our development team. This way, they can review your suggestion and might consider adding it in future updates. 

 

Here's how:

 

  1. Go to the Gear icon.
  2. Select Feedback.
  3. Enter your comments or product suggestions. 
  4. Then select Next to submit feedback.

 

You can also see this resource for more details: How do I submit feedback?

 

Additionally, I got here an article that can guide you in seamlessly managing your reports. This contains details on how to memorize and export your reports in QBO: Run reports in QuickBooks Online

 

If you need more help with your payroll reports and QBO, you can always get back to me. You're always welcome in the Community. Have a good one!

aroon_baksh
Level 1

paycheque history report that includes reg hours worked

JasroV, 

 

Thanks for getting back to me. 

 

On your suggestion, I only took a quick look through the apps but did not notice anything that would work for current issue, but I will definitely keep that in mind for my future needs. 

 

On the issue with dates provided in the report, I would like to suggest that you check with your development team on this as I believe the issue lies in the conversion to export it to a spreadsheet. As mentioned both spreadsheet applications were not able correctly sort on this field. For example, Excel was sorting it first by  DAY and lastly by year -- where dates are always sorted by year first. That issue did not happen when i sorted the paycheque history report by date

FEEDBACK function (while I might try that again especially to suggest the option to have each employee in a separate column would likely be a useful feature for many users) -- I am quite disappointed that I am still stuck without a solution to an issue I had in January, where the  suggestion from support was to provide my input via FEEDBACK to get a response. We are well over 10 weeks now on that. 

 

Please let me know if you have any further suggestions for any of the above. 

 

Thanks, 

Aroon

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us