Payroll report with hourly wages

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:

• Create a payroll summary report.
• Customize reports in QuickBooks Desktop.

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

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

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. 

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

Is this the same way for Quickbooks online? 

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.

Employee name, job description, period end, regular, overtime, wage rate, total wages

I appreciate your reply with additional details about what you need in the report, Maxpsillc. Allow me to provide some guidance on how to gather the information you're looking for.

While there isn't a single pre-built report in QBO that'll display all the details you mentioned (employee name, job description, work period, wage items and rates, and total wages), we can combine a few different reports to compile the necessary data.

You can start by running the Employee Details report. This will show you a snapshot of each employee including name, wage items, pay rate, and other related information.

Here's how to open the report:

1. Go to the Reports menu.
2. Look for Employee Details under the Payroll Section.

Next, open the Payroll Details report. This will provide the pay period details, regular hours, overtime hours, as well as gross and net pay. Here's how:

1. Go back to the Reports menu.
2. Click Payroll Details under the Payroll Section.

Aside from that, you can also use these other reports to get similar information: 

• Total Pay - Provides a summary of total wages paid to each employee.
• Total Payroll Cost - Shows the total payroll costs, including wages, taxes, and deductions.
• Time Activities by Employee Detail - Displays the regular and overtime hours worked by each employee.
• Employee Directory - Shows comprehensive employee profile

Please note that all these reports can be exported to Excel so you can easily combine them. Just click the Export button in the upper-right-hand corner and select Export to Excel. 

This way, you'll be able to gather all the details you need to create a comprehensive employee hourly pay and compensation report.

Let me also share these articles for additional guidance and information when running reports in QBO:

• Combine Reports From Multiple Companies Using Spreadsheet Sync 
• Reports Included In Your QuickBooks Online Subscription

Please let me know if you have any other questions, Maxpsillc. I'd be happy to jump right back and provide further guidance on how to best utilize the QuickBooks reporting features.