cancel
Showing results for 
Search instead for 
Did you mean: 
ssmaupin
Level 2

Summarize Payroll Data in Excel issue

You guys are awesome. Thank you for fixing QuickBooks problem.

Blake64
Level 1

Summarize Payroll Data in Excel issue

Why did you say thank you for fixing the problem? No one gave a solution, and the Summarize Payroll Data in Excel workbook still shows three dummy names on several tabs. If anyone has a solution for this years-long bug, thank you for posting it.

boed1
Level 3

Summarize Payroll Data in Excel issue

QB doesn't do anything in 2023 with all the current updates when trying to run the tool.

MM203
Level 1

Summarize Payroll Data in Excel issue

I'm very frustrated that Quickbooks can't/won't fix the State Wage Listing feature in Summarize Payroll Data in Excel.  I have QB 2023 and the latest Excel version and it still populates with unknown names.  This has now been an ongoing problem for several years.

CharleneMaeF
QuickBooks Team

Summarize Payroll Data in Excel issue

I know this hasn't been an easy process for you, MM203.

 

Let me make it up to you by ensuring you'll get detailed steps to resolve this.

 

First, let's run the report from the previous quarters. Then, click Yes when asked to update. Doing so helps you pull all the data correctly. 

 

If it doesn't work, a clean install of QuickBooks and Excel are possible fixes. 

 

Then, let's delete the 'QB_Payroll_Link.xlt' template. After that, re-download it. Here's how:

 

  1. Close QuickBooks.
  2. On your computer, go to your C Drive. The Program files (86x),
  3. Find Intuit, then Quickbooks20xx,
  4. Click Components and then Templates.
  5. Find the QB_Payroll_Link.xlt and delete it.
  6. Reopen QuickBooks and get a full payroll update.
  7. After updating, run the report.

 

Also, make sure QuickBooks Desktop is updated to the latest release. This way, you'll have the latest features and fixes.

 

If the issue persists, I recommend contacting our QuickBooks Support Team. They have tools to check the cause. It'll also allow them to submit a ticket to our engineering team to alert them about the issue if necessary.

 

Additionally, I've added these articles that'll help you learn more about personalizing and memorizing various reports in QuickBooks Desktop to ensure you can easily access modified data:

 

 

I appreciate your understanding on this matter. Please know we're always here to assist if you have any other questions or concerns.

lfgordon9151
Level 2

Summarize Payroll Data in Excel issue

I have no idea why Intuit cannot implement the fix this person has provided for years:  This works like a charm:

 

https://bigredconsulting.com/products/summarize-payroll-data-in-excel-fixed/ 

lfgordon9151
Level 2

Summarize Payroll Data in Excel issue

This solution provided by a QB user works:  

 

https://bigredconsulting.com/products/summarize-payroll-data-in-excel-fixed/

 

 

WildFish
Level 2

Summarize Payroll Data in Excel issue

Did you get a dangerous maco message when you downloaded the file from BigRed?  If so how did you fix it?

 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us