Thanks for getting back to us in the Community, @Lori831.
I'm happy to know that you can now run your payroll reports to Excel.
Feel free to visit us again here in the Community should you have any other concerns. I'm always here if you need further assistance. Wishing you and your business continued success!
Hi there, @The Copy Shop.
I'm here to provide some update the Summarize Payroll Data in Excel issue.
The INV-24874 was closed last 1/25/2019. However, some customers are still experiencing the same issue, and our engineers decided to re-open the investigation to dig deeper as to what’s causing the error to reoccur.
For the meantime, I encourage you to reach out to our Customer Care Team to add your account to the list of affected users. This way, you'll be notified of any updates on the progress on the investigation via email.
Here's how you can contact our phone support:
We appreciate your patience. Please check in with us if there’s something else you need help with. I’ll be around to help.
I am now having issues with Office 2007 excel. We already had issues with this in office 2016 and that still has not been resolved.
Can you advise when this issue will be fixed?
Thanks for joining the thread, Infrastructures.
I'm here with some insight to provide regarding the ongoing investigation about the Summarized Payroll Data in Excel issue.
The engineers are continuing to investigate why users are receiving an error message when running the Summarized Payroll Data. This team hopes to soon have more information on this and get this resolved.
In the meantime, I've found that running the report from previous quarters and then selecting Yes when asked to update helps pull up the data correct. However, if that doesn't work clean install of QuickBooks and Excel are possible fixes.
Should you continue to experience this unexpected behavior, I encourage you to contact the Phone Support Team so they can add you to the list of affected users. This will list will also sign you up to receive email updates as soon as they become available.
Please let me know if you have any questions or I can be of additional support. Have a wonderful weekend.
I'm having the same issue with Desktop Pro Plus 2019. This has been going on since last fall, ridiculous to pay for this product and not have full functionally! I'm already getting love letters from the SS Admin, which I believe is directly correlated to this QB issue, questioning some of my employee data Its time to reconcile this issue.
Hey there, three3aday.
I'm here to help you run the payroll reports in Excel via QuickBooks Desktop.
Repairing QuickBooks can to fix program-related issues or errors.
You can get more information in this article: https://quickbooks.intuit.com/community/Help-Articles/Fix-QuickBooks-Desktop-Windows/m-p/201490.
Also, you can check this article for detailed steps and instruction on how to repair the Excel: https://support.office.com/en-us/article/repair-an-office-application-7821d4b6-7c1d-4205-aa0e-a6b40c....
Once done, let's try to run Payroll Reports in Excel.
You may find this article helpful: Excel-based payroll reports.
If you need more help running payroll reports in Excel, please let me know. I'll be around to help you further.
I am an accountant and I am having the same problem with Summarize Data in Excel.
When I call quickbooks technical support, they say they are working on the issue. It was reported over 3 months ago! We cannot do our state quarterly reports without this report. We have to do manual calculations for hundreds of our client's employees which is a total waste of time, using excel of course. This report is the only one that shows excess wages when an employee has reached the maximum amount for SUI. The report worked fine for years now and the ENGINEERS can't figure out the problem! QUICKBOOKS THIS IS TOTALLY UNACCEPTABLE.
Everyone who is having problems should inundate technical support with calls until they fix it.
Hello there, @vrancourt.
Please allow me to join the thread and help share additional information about the Summarized Payroll Data in Excel issue.
I understand how it can get frustrating when something isn't working the way you need it to. Yes, we have reported this issue and our engineering team is currently investigating what may be causing this. As of now, you can follow the steps provided by my colleague AdrinS, to run the report from previous quarters and then select Yes when asked to update helps pull up the data correct.
As soon as we receive updates from our engineering team, me or one of my colleague will update this thread.
On the other hand, to stay updated with the latest QuickBooks news and updates, you may visit our QuickBooks Blog.
Please keep posted if you have any other QuickBooks or payroll reports questions, I'll be right here to help you. Have a great day ahead!
All I know is that we are using Windows 7 and Office 2007 and we can get the reports in QB 2018 and 2019. Yet we have a client that has Windows 10 and office 2016 and she cannot get her reports. We got them for the 4th quarter and then nothing. It appears that it is a glitch in office 2016 along with windows 10. QB needs to get with Microsoft and get this worked out. Engineers need to look at the codes. There has to be a coding error somewhere.
Thanks for coming back to the Community, Infrastructures.
We would like to get to the bottom of this as much as you do.
First, I want to thank you for sharing your versions of Windows and Excel.
We're still on the process of looking for the permanent resolution for this. I’m not privy to when we can fix it, but I can tell you that there are a lot of eyes on this one. We should see a fix soon.
To make sure we can send an email notification about the investigation, I suggest reaching out to our QuickBooks Desktop Payroll Team.
Here's how to contact us:
The information above will help you get pointed in the right direction. I'm always here if you need anything else. Please leave a comment below if you need any further information. Have a good day.
Why is it taking so long to get this fixed? We started complaining in January and it will be May in a couple more days. To continually say thank you and we are working on it hasn't fixed it in 4 months. Come on Quickbooks!
For me, this problem disappeared about 2 or 3 months ago, and the reports started working again. I have assumed that a Windows 7 update or a MS Office Update might have helped correct the problem, since QuickBooks doesn't seem to have any idea what is going on. Perhaps you need to update Windows or Office?
Hi there, @Jeanne1213,
I know this wasn't an easy process for you and this is not the kind of process we want you to experience.
While waiting for a fix, you can run the report from previous quarters, then select YES when asked to update. This will pull up the data correctly.
No worries. We'll update this post once we receive an update from our engineering team.
I appreciate your patience and understanding while we look into this.
Hi there, @cgrcpa.
Thanks for turning to Community in looking for updates about the Summarize Payroll Data in Excel feature. Let me share some clarification about its workaround.
You'll need to run the Summarize Payroll Data in Excel report, then change the date Last Quarter. If asked to update, select Yes. If you get the same result, another workaround you can try is to run clean install QuickBooks and Excel to fix this unexpected behavior.
Our engineers are continuously working to provide a solution as soon as we can. While we don't have a definite time as to when the resolution will come out, rest assured we're actively working to deliver one that'll prevent this from happening again.
I also recommend contacting our Customer Care Team to add you to the list of affected users. By doing so, you'll be notified via email about the status of the investigation.
We appreciate your patience as we look into this for you. Let me know if there's anything else you need help with. I'm only a comment away.