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

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

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

10 Comments
qbteachmt
Level 15

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

sarsar
Level 3

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
CAN YOU PLEASE ADVISE HOW TO PRINT 1 EMPOLYEE FROM THIS LIST WITH HEADERS....
qbteachmt
Level 15
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

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

is this available on Desktop Pro version?

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

 

hhanson
Level 1

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

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 1

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

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!

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up