Commission Employees Report to show Hours Worked

priscilla1 · ‎February 02, 2021

2/2/2021

We pay some of our employees by Commission. We enter their hours worked when entering their payroll. However, as I was running reports, all of the Commission workers hours do not show up in the Payroll Details Report nor in the Worker Compensation Report. There is nothing shown at all in the Time Activities by Employee Detail Report.

Our 401K Company has us to annual reports and they want to see hours worked per employee. I had to go in to each employee's paycheck that was paid by Commission and add up the hours they worked, because QBO was unable to help me find a report to do this. What a pain!

In Payroll I have selected Commission for the pay method. Does anyone have any ideas how to make the hours worked show up? Is there a better way of handling the Commission Employees?

Thank you.

Rubielyn_J · ‎February 04, 2021

Thanks for posting back in the Community, @priscilla1.

Let me provide some information about the difference between the two reports.

The Payroll Summary by Employee report is a comprehensive report of wages, deductions, and tax info, totaled by employee or period. The Payroll Summary report shows your employee's total wages, deductions, contributions, and taxes. In this case, the Payroll Summary will show the worked hours per employee.

For more details, feel free to check this article: Run payroll reports.

You can also check this article to guide you to save its current customization settings: Memorize reports in QuickBooks Online.

Don't hesitate to comment down below if you have other QuickBooks concerns. I'll be around to assist you. Have a great day ahead.

View solution in original post

ReyJohn_D · ‎February 02, 2021

Being able to see the commission hours worked in your payroll reports is a brilliant idea, @priscilla1!

Currently, you can only see the hours worked for salaried or hourly employees when running your payroll reports. I'd agree that having the same option for your commission employees can make your task easy.

For now, you're on the right track in reviewing their paychecks to see the total commission hours worked.

Meanwhile, I recommend visiting our QuickBooks Blog page to get you in the loop about the current news and product developments.

Also, you'll want to know the different ways to pay your employees. This way, you can manage your payroll efficiently and effectively.

You can lean on me anytime if you have more payroll concerns. I'll be here to back you up.

priscilla1 · ‎February 02, 2021

Thank you.

priscilla1 · ‎February 04, 2021

In doing my own research and running various reports, I have found that the Payroll Summary Report by itself worked for see all hours, including those paid by commission. If you want the hours per employee for a set amount of time, you need to customize your date(s) and then select that particular employee. Doing them one by one takes a while, but it works and is faster then trying to add them up.

I did try running a Payroll Summary by Employee Report, but that did not show the hours.

Rubielyn_J · ‎February 04, 2021

Thanks for posting back in the Community, @priscilla1.

Let me provide some information about the difference between the two reports.

The Payroll Summary by Employee report is a comprehensive report of wages, deductions, and tax info, totaled by employee or period. The Payroll Summary report shows your employee's total wages, deductions, contributions, and taxes. In this case, the Payroll Summary will show the worked hours per employee.

For more details, feel free to check this article: Run payroll reports.

You can also check this article to guide you to save its current customization settings: Memorize reports in QuickBooks Online.

Don't hesitate to comment down below if you have other QuickBooks concerns. I'll be around to assist you. Have a great day ahead.

priscilla1 · ‎February 04, 2021

Thank you.

Topics

Training

Community

Resources

Commission Employees Report to show Hours Worked