Payroll Summary Reports

Hello, Lisa Galvin.

I'll give a quick overview on the Payroll Summary report. I'll also suggest a method to help you get the employees' payroll data sorted by their account number. 

QuickBooks Desktop will only display the employee's name on the payroll summary report. Instead of using the summary report, i would suggest pulling up the Payroll Item Detail report.

You'll have the ability to add the account (or employee) number on it then sort it by number. Here's how to pull it up: 

1. Go to the Reports menu.
2. Hover on Employees & Payroll. 
3. Choose Payroll Item Detail.
4. Click the Customize Report button.
5. In the Display tab, type in Account in the Columns search field. 
6. Check Name Account #, then click OK. 
7. On the report, select Name Account # on the on the Sort By drop-down menu. 

For more details about the summary report, you can check this article: Create a payroll summary report. 

If you need help running payroll or managing your employees, feel free to browse our guides. You can find them in our articles list page. Simply search for an article to help you accomplish your tasks. 

I'll address any other concerns you might have for QuickBooks Desktop and the payroll module. 

I have already done this - does not solve the issue, I need to be able to check behind someone's work, check hours entered, withholding, deductions, etc - everything that is on the payroll summary - just need to be able to sort the payroll summary or a check journal showing each employee by employee number.  You would think this would be something that a lot of users would want - another simple issue that intuit cannot do.

You're in the right place, @Lisa galvin. Let me help you create the report you need.

We can export both the Payroll Summary and Item Detail report to Excel. From there, you can combine the two reports and sort them based on your business needs.

Let me show you how:

1. Go to the Reports menu and then select Employees and Payroll.
2. Choose the Payroll Summary report.
3. Select the date.
4. Click the Excel dropdown menu. 
5. Select Create New Worksheet.
   
   
   

Then do the same process in exporting your Payroll Item Detail report.

For more insights, please see this article: Customize reports in QuickBooks Desktop.

Finally, you can memorize reports if you want the same customized report settings available for future use.

Keep me posted if you need a hand in managing your reports. I am here to ensure your success. Stay safe and take care.

How to combine the reports?  This is a lot of work for what should be a very simple task, surely I can't be the only person who needs to sort by employee number.  Also, QB does not play well with Office 365 - when I go to summarize payroll in excel from reports, I get  a message that there is a problem with the content in QB_Payroll_link.xlt - asks if I want to recover after I say yes the dialogue box says Excel opened the file by removing unreadable content.  On the state wage listing tab we used to have a drop down menu pick from SUTA and FUTA, etc now it shows the default to Medicare Additional Tax and no drop down.  I have seen this complaint in other threads for a while now.  I just want to be able to work efficiently and seem to spend a lot of time fooling around in QB - it is getting worse have been using this product for over 25 years.

Nice to see you again, @Lisa galvin.

To merge the two reports, you can use the Consolidate command in Excel. To decide which type of consolidation to use, you can look at the sheets you are combining. There are two ways to aggregate data, either by position or category.

For detailed information, please see this article: Consolidate data in multiple worksheets.

You'll want to learn how to set up and modify scheduled reports in QuickBooks. This will help you send reports at a regular and recurring scheduled time.

Know that we're open 24/7 to help you. Just click the Reply button if you have other QuickBooks concerns. Keep safe and good day.

I have tried all the suggestions above and can not get a report that looks like the Payroll Summary report to sort by employee number.

Any other suggestions?  I wouldn't think this would be too hard of a program fix for a competent computer programer.

Were you ever able to get QB to print a payroll summary report and sort by employee number?

I am in the same situation, I have a payroll with 70+ employees that I have to sort by department and employee number.  The Payroll Summary by department is not an issue, but sorting by employee number instead of name is a big issue.

I would think a competent computer programmer could easily remedy this issue.

Kim

Hello there, @Kimberri.

I'll share details about running and printing the Payroll Summary report by employees' number in QuickBooks Desktop (QBDT) and guide you in sending product recommendations.

For the time being, the Payroll Summary report will only display employees' names. Instead, I'd recommend pulling up and exporting both the Payroll Summary and Payroll Item Detail report to Excel and then merging them to get the data you need (sort by employee number).

On the other hand, I can see how the benefit of being able to run and print the Payroll Summary report by employee number would aid you in managing your transactions with QBDT. With this, I would encourage you to send suggestions or product recommendations. We take them as opportunities to improve the various features of our products.

Your valuable feedback will be forwarded and reviewed by our Product Development team to help improve your experience while using the program. Here's how:

1. Go to the Help menu.
2. Choose Send Feedback Online.
3. Click on Product Suggestion.
4. Click on the drop-down for Type of Feedback and select Product Suggestion.
5. Select the Product Area.
6. Then enter your thoughts and suggestions.
7. Once done, select Send Feedback.

Also, you may want to check out one of our Help pages as your reference in pulling up payroll reports and managing employees using QBDT: Payroll reports and forms help for QuickBooks Desktop.

Let me know if you have other reporting concerns or questions about managing employees in QBDT. Please don't hesitate to drop a comment below, and I'll gladly help. Take care, and I wish you continued success,