cancel
Showing results for 
Search instead for 
Did you mean: 
joyl
Level 1

What report gives gross wages per check for a specified time period for one employee?

I'm using enterprise solutions and have searched and searched but cannot find a report to give me a total breakdown of wages by paycheck for a single employee.

Solved
Best answer December 10, 2018

Best Answers
qbteachmt
Level 15

What report gives gross wages per check for a specified time period for one employee?

Payroll Summary report will do this.

Filter for the one employee and set the date range and set Columns BY Week, if you pay weekly, or by Month, if you pay monthly.

View solution in original post

18 Comments 18
qbteachmt
Level 15

What report gives gross wages per check for a specified time period for one employee?

Payroll Summary report will do this.

Filter for the one employee and set the date range and set Columns BY Week, if you pay weekly, or by Month, if you pay monthly.

sarsar
Level 3

What report gives gross wages per check for a specified time period for one employee?

Hello there, joyl.

I'm here to help. We can pull up the Summarize Payroll Data in Excel and customize the report from there. Here's how:

  1. Go to Reports at the top.
  2. Select Employees & Payroll.
  3. Click Summarize Payroll Data in Excel. A QuickBooks Payroll Reports Workbook window will open.
  4. Select the date and click Get QuickBooks Data. An Excel Worksheet will open.
  5. Select the name of the employee and date.

Let me know if there's anything else you need. Thank you.

precesionfinning
Level 1

What report gives gross wages per check for a specified time period for one employee?

CAN YOU PLEASE ADVISE HOW TO PRINT 1 EMPOLYEE FROM THIS LIST WITH HEADERS....
qbteachmt
Level 15

What report gives gross wages per check for a specified time period for one employee?

You asked twice and are answered here:
<a rel="nofollow" target="_blank" href="https://community.intuit.com/questions/1361635-how-to-print-a-report-showing-employee-gross-deductio...>
And this topic has the explanation that you Filter this report.
hhanson
Level 1

What report gives gross wages per check for a specified time period for one employee?

is the SUMMARY PAYROLL DATE IN EXCEL only available on QBO? or can I get this info on Desktop version too (Pro)

hhanson
Level 1

What report gives gross wages per check for a specified time period for one employee?

is this available on Desktop Pro version?

I can't seem to get a report that gives me this important data

 

hhanson
Level 1

What report gives gross wages per check for a specified time period for one employee?

can you get a "bi-weekly" report in the Desktop version Pro?

I'm reading your instructions to set the columns by pay period....and I don't have that option

JanyRoseB
QuickBooks Team

What report gives gross wages per check for a specified time period for one employee?

Hi there, @hhanson.

 

Good to see you here in the QuickBooks Community. I'm here to help guide you on how to pull up the report you need in QuickBooks Desktop Pro version.

 

To show the gross wages of your employee's paycheck bi-weekly, you can pull up the Payroll Summary report. Let me walk you through the steps:

  1. At the top menu bar, select Reports.
  2. Go to Employees & Payroll.
  3. Choose Payroll SummaryCapture.PNG
  4. On the Show Columns drop-arrow, select Two week option to appear the bi-weekly information. Capture1.PNG
  5. Click Refresh

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

This will get you on the right track. Feel free to leave a comment below if you have additional questions about the payroll summary report. I'm always here to help you out. Have a good one. 

_mt
Level 2

What report gives gross wages per check for a specified time period for one employee?

Clearly, you don't understand the question. He wanted a detailed report for ONE specific employee. Not ALL employees in a summary.

AlexV
QuickBooks Team

What report gives gross wages per check for a specified time period for one employee?

Thanks for joining us here, _mt.

 

You can use the report Payroll Summary report to see the gross wages and the total breakdown. What I'm going to show you now is how to filter it per employee.

 

Please follow these steps:

  1. Go to Reports Employees & Payroll Payroll Summary
  2. Click the Customize Report button and select Filters.
  3. From the Search Filters field, search and select Name.
  4. Under the Name drop-down, select the employee's name.
  5. Tap OK.Capture.PNG

 

Additionally, you can export reports in an Excel file. Here's the link for the detailed steps in customizing reports: Customize payroll and employee reports.

 

Please comment again here if you need more help. Stay safe and healthy!

PauloP
Level 1

What report gives gross wages per check for a specified time period for one employee?

Hi. I jump on this wagon. 

How do i select employee individually? 

I'm selecting Name in Filter section but cannot seem to get employees individually. 

A prompt response would be greatly appreciated 

Rubielyn_J
QuickBooks Team

What report gives gross wages per check for a specified time period for one employee?

Thanks for joining this thread, @PauloP. Allow me to chime in and help select employees individually in the Filter section.

 

We simply need a few more steps so you can choose your employee when customizing the report. 

 

Here's how:

 

  1. From the Search Filters field, look for and choose Name.
  2. Under the Name drop-down, select Multiple names.
  3. In the Search field, find and click your employees individually.
  4. Once done, click OK.
  5. Lastly, select OK to complete the process. 

 

In addition to that, I'll be sharing these articles that you may find relevant for future tasks in managing your reports in QuickBooks:

 

 

Don't hesitate to leave a comment below if you have other questions about this matter. I'm always here to help you. Keep safe!

Lisalu
Level 3

What report gives gross wages per check for a specified time period for one employee?

This report is for the paycheck date.  I need one for the pay period that includes all employees. 

ReymondO
QuickBooks Team

What report gives gross wages per check for a specified time period for one employee?

Hi there, @Lisalu.

 

Can you share more details about the payroll report you're trying to get? That way, I can provide you with the right response to accomplishing your task.

 

Any further info would be much appreciated. Please add them to this thread and I'll get back to you.

Lisalu
Level 3

What report gives gross wages per check for a specified time period for one employee?

When you pull a payroll summary, you have to use the paycheck date,  I need a report that will show the pay period with the breakdown of hours/overtime/rate of pay, gross/net pay.  

I can pull a payroll register (excel report) but it does not break down over time hours and rate/pay.

ChristieAnn
QuickBooks Team

What report gives gross wages per check for a specified time period for one employee?

Hi there, Lisalu.

 

I appreciate you coming back to the thread and adding extra details about your concern. With this, I'll ensure you'll be able to get a report that appears what you need by following the steps below.

 

There are several Excel reports available in QuickBooks to show all payroll data. That said, I recommend running the Summarize Payroll Data in Excel report. This contains Pay Type for earnings items, such as Regular and Overtime, Sick, and Vacation. Also, the pay period with the breakdown of hours, overtime, etc.

 

  1. Under Reports from the QuickBooks menu, choose Employees & Payroll. Then, select Summarize Payroll Data in Excel.
  2. If prompted by the Excel security warning, follow the directions to enable macros in Excel.
  3. From the QuickBooks Payroll Workbook - Welcome screen, choose OK.
  4. Enter a date range and select Get QuickBooks Data.
  5. Choose the State Wage Listing tab at the bottom. Then, you can now see the data you need.

 

Furthermore, you can open this article to see additional information about the report: Excel based payroll reports.

 

Lastly, you may refer to this article to see steps on how you can customize any report in QBDT to personalize the font and style of the page: Customize reports in QuickBooks Desktop.

 

Please get back to the thread if you need anything else about Reports. I'll be more than happy to help you, Lisalu. Have a great day!

HNN
Level 1

What report gives gross wages per check for a specified time period for one employee?

I have Quickbooks Desktop for Mac without payroll.  How do I get a gross wage report?

Kurt_M
QuickBooks Team

What report gives gross wages per check for a specified time period for one employee?

Thanks for joining the thread, @HNN. I've got you covered, and I'll help you customize your report to show the gross wage data in your QuickBooks Desktop (QBDT) company.

 

Know that in QBDT, you can customize a report to include other columns containing the data you need for your business. I'll gladly input the steps below so you can proceed. To begin, here's how:

 

  1. Access your QuickBooks Desktop company.
  2. Run the report you're using for your employees.
  3. On the report window, Click Customize.
  4. From the customize window, choose the tab you'd like to update.

 

Feel free to visit this page for more information on how you can customize a report in QBDT: Customize reports in QuickBooks Desktop for Mac.

 

In addition, I've got you this article in case you'd like to automatically email reports or save them to your computer on a repeating schedule: Set up Scheduled Reports for QuickBooks for Mac.

 

@HNN, if you need further assistance with this. Feel free to get back to me by clicking the REPLY button below. You can also post here again if you have any additional QuickBooks-related concerns. I'll be more than happy to help you out again. Take care, and have a good one.

Need to get in touch?

Contact us