Hey there, vedwards.
Good to see you here in the thread. I'm here to get you pointed in the right direction for finding your paycheck and timesheet information.
If you need to view your time sheet, then I would recommend that you use a different report instead. Since, the Summarized Payroll Data in Excel will show you the total number of hours, instead of the timesheet.
That said, you can pull up the Payroll Detail Review report for the paycheck information. Meanwhile, you can pull up the Time by Name report for the timesheet. The steps below will guide you on how to pull them up:
Payroll Data Review
Time by Name
That should get you going in the right direction. Please don't hesitate to reach out to me again if you're referring to something else, I want to make sure you're taken care of. Have a great day!
Hello there, Audit911.
For now, you can rollback your Excel to the older version to ensure you'll not encounter any error for the payroll data. Due to some updates, the compatibility of Excel 2019 or Office 365 occurs some problem.
I've sent my feedback as well regarding this concern to our internal product enhancement. I also recommend sending your suggestion through these steps:
Please remember I'm always available here whenever you have additional questions or concerns related to the payroll data. The Community is always available to lend a hand.
Working on very same problem with a client. I'll just subscribe to thread until more progress is made. Hopefully Office 365 can resolve what it broke in Nov. 2018 with opening up this QB Excel file.
Thank you for reaching out to the Community, @dustymactx.
I can definitely see how this feature would be useful. Rest assured, our Product Development Team is aware of this and are still working on the resolution to fix the problem.
Also, I want to ensure you're updated with this issue. Aside from checking the updates in this thread, I would recommend contacting our QuickBooks Care specialists. They can add you to the affected users' list to get live email updates as soon as they become available.
Here's how you can reach them:
That should point in the right direction today. Thank you for your patience. If there's anything else that I can help you with QuickBooks, please let me know. I'll be happy to help out. Wishing you and your business success.
Thanks for letting me know, @StephC1.
Allow me to step in and help provide some update about using Summarize Payroll Data in Excel issue in QuickBooks.
I understand it can get frustrating to have your issues at repeated occurrences. I've checked the investigation status about this issue, and it still in progress. Rest assured that our engineers are investigating and working on an immediate fix.
While we're continuing to work on resolving this issue, as a workaround, let's run the payroll report from previous quarters. Then, when asked to update select Yes, and it is able to pull all the data correctly.
If that does not work, let's process troubleshooting steps which to clean install of QuickBooks and Excel for possible fixes. To do this, you can follow the detailed steps in these articles:
I also encourage you to get in touch with our Customer Support 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 customer support:
I appreciate your patience as we work through this. If you have other questions about exporting reports, please let me know. I'll be around to help you out.
So it is now APRIL 2019 and QB has had time to come up with a solution.
IF there is one please email it to [email address removed] asap.
I've been seeing error messages a few months but just now need this payroll summary for my state UI quarterly payments for our three branch offices.
ADVISE ASAP. Have tried every fix mentioned here. This is very very inconvenient.
To the other user who mentioned SAGE, how is their software? Do they charge half a grand just to update subscriptions each year?
Thanks for joining this conversation, Pam TEC.
We would like to get to the bottom of this as much as you do.
First, I want to thank you for trying the recommended troubleshooting. Knowing so will help us isolate the problem.
We're still on the process of looking for the permanent resolution for this. I’m not privy as to when we can resolve 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 you an email notification about the investigation, I suggest reaching out to our QuickBooks Desktop Payroll Team. Please follow the steps shared by my colleague above.
Our Community Contributors and Established Community Backers might also be able to share their best practices and experience for using Sage.
That information should get you on the right track. It's my priority that this is resolved for you, so please let me know how it goes. I'll be keeping an eye out for your response. Have a good one.
We are having the same problem. We are using QB Enterprise and our information is on the cloud with Right Networks. We also had to get a Microsoft 365 license through Right Networks in order to allow us to summarize the payroll data in excel. As such, we CANNOT go back to a former version of Microsoft 365, nor can we re-download Quickbooks. We are paying over $16,000 a year on QB licenses, Right Networks & another 2 licenses for Microsoft 365 through Right Networks (since all of our computers already had Microsoft Office) We had to purchase 2 additional Microsoft 365 licenses through Right Networks JUST TO ALLOW US TO SUMMARIZE THE PAYROLL DATA IN EXCEL....AND NOW THAT DOESN'T WORK CORRECTLY. In addition, I spent over 2 hours with QB support this morning regarding a TOTALLY DIFFERENT PROBLEM with payroll. To say I am frustrated is an understatement.
I know this can be quite frustrating but rest assured, this will be fixed in no time. I want to personally let you know that we strive hard to always get you back to business efficiently.
Our engineers are still investigating this ongoing issue about user unable to summarize their payroll data in excel. We are yet to hear from them on July 9, 2019 for the possible fix.
In the meantime, you can follow the workaround provided by my colleague above.
Also, if you haven’t been added to the list of affected users of this investigation. You can follow the steps below in contacting them:
Once you’re on the list, you’ll be receiving email updates about its progress.
We appreciate your patience with us as we resolve this. Please let me know if you have any other questions or concerns.
I just spent an hour +- with my IT specialist following the exact steps that are supposed to correct this problem. Sad that after a year of trying and waiting to correct this error, it is still not fixed!!
I hear you @Anonymous,
I know how this feature would be useful for your business. Rest assured our engineering team is working hard to investigate and fix the issue.
Currently, there's an ongoing investigation about being unable to run the Summarize Payroll Data in Excel.
In the meantime, I'd suggest contacting our QuickBooks Support team. This way, they can list your details as one of the affected users and you’ll be able to get notifications once there's an update.
Here's how you can reach our Desktop Specialist:
If you need some references in the future, you can also check out our site: Help articles for QuickBooks Desktop.
You may check this resource page for future reference in case you want to learn more about exporting reports from QuickBooks Desktop to Excel.
Thanks for your patience and understanding. If you need further assistance with the workaround, just let me know. I'm here whenever you need more help.
I, too, am having this problem. It' so ridiculous and time consuming for us to do it manually (unemployment calculations), because QuickBooks export doesn't work. This is across 65 client files.
I have tried everything and nothing is working for me. Others mentioned that they have Excel 2019 or Office 365, but I am using the Microsoft Officer Professional Plus 2016 and it still does not work.
All I can say is, "WTH, Intuit?" Xero may be in my future, because Intuit customer service has gone down hill approximately a year ago. Thanks for outsourcing your customer service overseas (Sarcastically).
Hey there, @EmKh.
I understand how the exporting feature to Excel is beneficial to you and your business. Please know that our engineers are all hands on deck to get the option working again.
To make sure you’re in the loop about the resolution status, sign up to the investigation list. Since providing personal details in this forum is prohibited for security reasons, I recommend contacting our Payroll Support Team.
One of them will be taking over and add the account in a safe environment. The data collected provides essential information our engineers can use to roll out the permanent solution.
Here’s how to get in touch with them:
Stay in touch whenever you have questions or concerns while working in QuickBooks Desktop. I’ll be right here to assist further. Have a good one.
A couple of months ago, after waiting for a year while Intuit hasn't fixed this, I decided to look at it.
It was easy enough to fix and took a couple of hours, including testing the fixes and then creating a page for downloading.
The fixed version is almost the same as the original, though a couple of the reports had to be rebuilt. They don't look quite the same, but show the same results.
Download a free fixed version of the workbook template from our site here: Summarize Payroll Data In Excel « Big Red Consulting
Hi there, @kiwi2const.
I know how important it's to your business that everything is on track.
You can contact our support thru this link provided below and continue as a guest.
I've also added screenshots for you.
Please come back to the Community if you have other questions in QuickBooks. Have a great day!