Just to clarify, are you trying to summarize the payroll data in excel? If so, QuickBooks Desktop Enterprise has an on-going issue where users are getting those errors.

As a workaround, you can run the report from previous quarters and then when asked to update select Yes to pull all the data. If that doesn't work, I suggest a clean install of QB and Excel.

But if you're trying to do something aside from summarizing the payroll data, you'll need to update your payroll tax table. Let me guide you how:

Go to the Employees menu, then select Get Payroll Updates.
Put a check in the Download Entire Update checkbox.
Select Download Latest Update.

After updating the tax table, a window will appear when the download is complete. Here's an article you can read for the detailed steps and information: Download the Latest Payroll Tax Table.

Also, I recommend scheduling a callback with our QuickBooks Customer support so they can add your account to the list of affected users. This way, you'll receive an email regarding the issue once updates become available.

Here's how you can schedule a callback:

Log in to your QuickBooks account.
Click on Help.
Select Contact Us.

Thank you for your patience as we work for a fix.

A

Anonymous

Just and FYI, I did all the steps you suggested. Even updated/repaired Excel. Nothing! I was able to pull reports I can use for my quarterly reporting but this report is the one that gives me all the information I need and I would like to have it!! I see this has been going on for some time now.

JaneD

Level 6

Good day, Tracey1960.

I appreciate you joining us in this thread. I've got some information about the error that you're getting.

I was able to confirm that there's an ongoing issue with summarizing Payroll Data in the Excel files from QuickBooks Desktop. For now, you may want to give us a call to receive updates. When you do, provide this investigation number: 24847.

Here's how:

Sign in to your QuickBooks Online (QBO) account.
Go to Help.
Click on Contact us.
Enter your concern and click on Let's talk.
Choose either Start a chat or Get a callback.

From there, one of our agents will be able to pull up your account securely and add you to our notification list. I'll also personally reach out to them and gather some information on this, so I can update you once this has been fixed

Thanks for your patience and understanding. Please know that this issue is being treated with utmost urgency. Leave a message below if you have any other concerns. I'll be around.

M

Mc2019

I was on the phone with QuickBooks technical support yesterday for almost an hour. We tried all the avenues to get the State Wage Listing report in Summarize payroll in excel. I have had this problem now for about a year and have tried numerous time to get a fix. All the other tabs on this summarize excel sheet are correct except the one I need for unemployment reporting purposes. I do not know why we cannot get this fixed??

M

Mc2019

I have QuickBooks 2019 Pro. I have been getting this message now for about a year. I have tried numerous time with QuickBooks technical support to get it corrected. Nothing works. Odd thing is all the other tabs in Summarize payroll data in excel report have the correct figures. Why can't we get this fixed?? We use these figures to file online unemployment reports.

Adrian_A

Level 8

I appreciate all the steps you've done to resolve this issue, Mc2019.

As of now, there's till an ongoing investigation about error message you've got. Rest assured, our engineers are diligently working to fix this one. But, I have a workaround for you.

You can run the report from the previous quarters then, when asked to update select Yes. This way, it will pull up all the data.

I also recommend getting in touch to our Phone Support team. They'll get your company info and add it to the list of affected users.

We appreciate your patience while waiting for the permanent fix.

N

NAU2020

Is anyone know how to fix this? I was on the phone over 3 hours and didn't get resolved by quickbook support team. I need to get the summary payroll report ASAP

BigRedConsulting

Level 15

This issue is more than a year old now.

I got motivated a couple of months ago and noted the error still exists in QB 2020, so I checked it out to see what was going on.

I found several issues with the workbook and fix them. The fixes were easy and took a couple of hours to find, fix, and test.

Then I published an updated version for people that need it. Start here to get it: Summarize Payroll Data In Excel « Big Red Consulting

W

Wats1414

Thanks for the fix Big Red Consulting. This was a great fix.

Sign up

Login with SSO

Let's get you signed in

Login with SSO