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?
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.
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.
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.
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.
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!
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.