Skip to main content
G
geeljir
July 1, 2022
Question

Payroll report with hourly wages

  • July 1, 2022
  • 2 replies
  • 0 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.

2 replies

S
SarahannC
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.

M
Maxpsillc
April 22, 2024

Is this the same way for Quickbooks online? 

S
SirielJeaB
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
BigRedConsulting
July 1, 2022

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

G
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
BigRedConsulting
July 5, 2022

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

Terms & ConditionsAccessibility statement