Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
July 1, 2022
Question

Payroll report with hourly wages

  • July 1, 2022
  • 4 replies
  • 65 views

Need some help making a payroll summary report that includes both the total amount each employee was paid as well as their hourly wage. Ideally the report would include the paycheck date, employee name, Job title, hourly, and total paid. It would also have to include all employees paid on that date.

4 replies

Level 9
July 1, 2022

Hello there, kalkaal.

 

You can customize the Payroll Summary report to get the details you want to include in this report. You can customize it for Employees. Then, set the date range correctly and set Columns on how you pay your employees. 

 

Also, you can run the Payroll Detail Review report to get other details you need. Here's how:

 

  1. Go to Reports at the top menu bar.
  2. Select Employees & Payroll, then choose Payroll Detail Review Report.
  3. Click on the Customize Report button.
  4. Choose Display.
  5. Under Columns, an enter Name and Date.
  6. Go to the Filters tab, enter Payroll Item in the Choose Filter box. 
  7. Include all the details you need.
  8. Click on OK.

 

You can export two reports to combine the information from Excel or add some information you want. Here's how:

 

  1. Find and open the appropriate report.
  2. Click your Excel option on the toolbar.
  3. Choose Create New Worksheet

 

For additional reference, you can check these articles to learn more about the payroll report:

 

 

Comment below if you have additional questions about the payroll report, kalkaal. Stay safe always.

April 22, 2024

Is this the same way for Quickbooks online? 

Moderator
April 22, 2024

Hello there, Maxpsillc. I'll walk you through the process to help you get the payroll data you need in QuickBooks Online (QBO).

 

May I know what specific details you want to display in your report? You can run a Payroll Summary report to see the hours worked by your employee and its equivalent pay. Here's how:

 

  1. Go to the Reports menu.
  2. Enter Payroll Summary in the Search field.
  3. Click the Customize option to personalize the information you need to show.
  4. Select Run report.

 

You'll want to generate the Payroll Tax and Wage Summary report to show total subject wages, excess wages, and taxable wages by tax type. 

 

Moreover, you may memorize a report to save it with its current customization settings.

 

I'll be sure to be around any time if you have other topics in mind. Kindly leave a comment below for a prompt response. Have a good one.

BigRedConsulting
Level 15
July 1, 2022

There are several reports that might work for this. What is it you need the report for?

geeljirAuthor
July 5, 2022

I want my report to include the Hourly/Annual rate which is found under Payroll Info when editing employee information. Whenever I customize the report and include the Hourly payroll item it seems to show only zeros regardless of who the employee is. 

BigRedConsulting
Level 15
July 5, 2022

What report are you customizing?  What will you use the results for?

June 23, 2026

I am using QB Enterprise desktop.  I need a report that shows: date, employee name (Source Name),  payroll items, class, qty, amount & The HOURLY WAGE !  I have memorized and customized a payroll item detail report, but I cannot get the HOURLY WAGE to show in this report.  

Moderator
June 23, 2026

Thanks for getting involved with this thread, CLaSala.

 

I can certainly understand how an ability to add an hourly wage section to reports could be useful and have submitted a suggestion about it as of today.

 

You can also submit your own feedback while using QuickBooks.

 

Here's how:
 

  1. In the top menu bar, go to Help, then Send Feedback Online.
  2. Choose Product Suggestion.
  3. Enter your feedback.
  4. Select Send Feedback.

 

Your feedback's definitely valuable to Intuit. It will be reviewed by our Product Development team and considered in future updates. You can stay up-to-date with the latest news about your product by reviewing Intuit's Product Updates page.

 

As a workaround, you can export reports and customize them further outside of QuickBooks. Another option is checking your QuickBooks Desktop Marketplace for apps which may be able to help you achieve what you're looking to accomplish.

 

Please feel welcome to send a reply if there's any questions. Have a wonderful Tuesday!