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.
Thank you for posting here in the Community. I'm here to help provide information about the error message when exporting payroll data to Excel.
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.
Thanks for your quick response.
If found a work around for obtaining my UI quarterly tax numbers.
Under Payroll Tax Forms, Tax Form Worksheets In Excel
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.