cancel
Showing results for 
Search instead for 
Did you mean: 
Marlyce
Level 1

Summarize Payroll Data in Excel issue

I try the fix as well, and it didn't work.  

ReymondO
QuickBooks Team

Summarize Payroll Data in Excel issue

Hi there, @Marlyce.

 

As of this moment, our engineers are still working on the error about the summarize payroll data. We'll be thankful for your patience while they're doing there best to resolve this as soon as they can. 

 

If you haven't contacted our QBO Support yet, I'd recommend reaching out to them. This way, they can pull up your account in a secure environment and sign you up to receive email updates as soon as they become available.

 

Let's connect with them by following these steps below:
 

  1. Go to the Help icon and select QuickBooks Desktop Help.
  2. Select Contact Us.
  3. Give a brief description of your issue, then select Continue.
  4. We’ll provide you a few support options. Select which one is best for you.

 
For more contact details, you can visit our support website.
 
As we assess this opportunity, I encourage you to visit our QuickBooks Online Blog to stay current with our news and updates.


Let me know if you need anything else. I'll be around to help however I can. Have a good one.

sjensen
Level 2
BigRedConsulting
Community Champion

Summarize Payroll Data in Excel issue

@ReymondO 

RE: As of this moment, our engineers are still working on the error about the summarize payroll data. We'll be thankful for your patience while they're doing there [sic] best to resolve this as soon as they can. 

 

Intuit reps have been saying this for over a year now regarding this issue.  15 months, I think. It would be refreshing if you just admitted that they're not actually working on this.

 

It took me two hours to figure out the issues and fix them and publish an update on my site.  Maybe Intuit should pay me to fix these issues...  Just a thought.

permagreen
Level 1

Summarize Payroll Data in Excel issue

THANK YOU SO MUCH! I contacted customer support and tried a bunch of other recommendations but this was the only way I was able to get it work! 

BigRedConsulting
Community Champion

Summarize Payroll Data in Excel issue

@Mindella61 

RE: I followed the steps exactly, ...

 

What steps?

 

The original complaint is about issues in Excel, not locking up QB, so you may be experiencing something else.

jmeyer4RVC
Level 2

Summarize Payroll Data in Excel issue

Can anyone tell me if they ever found a resolution to this problem? I am still having issues with pulling the payroll report into Excel. The State Wage Listing report is no longer working and that's the main one I use.

Rose-A
Moderator

Summarize Payroll Data in Excel issue

Hi, jmeyer4RVC.

 

Allow me to step in and provide some update regarding generating the State Wage Listing report via QuickBooks Desktop.

 

Our Payroll Team is actively working to resolve this issue. I’d encourage you to contact our QuickBooks Desktop Support and have them attach your case to INV-24874, so they can add your account information to the notification list. That way, our engineers can send you updates via email when they are available.

 

To ensure we address your concern on time, check out our support hours.

 

As a workaround, you can run the report from previous quarters, and then when asked to update select "yes" and it can pull all the data correctly. If that does not work clean install of QuickBooks and Excel are possible fixes. Or, you can delete the 'QB_Payroll_Link.xlt' and re-download it.

 

Here's how:

 

  1. Close QuickBooks.
  2. On your computer, go to your C Drive. Then 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, try opening the report again.

The following resources are good references. It contains information about exporting feature limitations as well as on what other Excel reports that are available in QuickBooks Desktop. Also, this will provide you steps on how to save reports as Excel Workbooks:

 

Export reports as Excel workbooks in QuickBooks Desktop

Excel-based payroll reports

 

Please extend your patience while we're working for the permanent fix. Don't hesitate to drop me a line if you have other questions. Have a good one.

bamado
Level 2

Summarize Payroll Data in Excel issue

Hello Big Red, 

Have you discovered any fixes for this issue?

quickbooks.intuit.com/learn-support/en-us/install/quickbooks-file-manager/00/516082

 

Hope so!!

 

Beth

Dan_Gott
Level 1

Summarize Payroll Data in Excel issue

Having a similar issue.  The report that actually loads is 3 sample people with made up social security numbers. They are not even related to the company file. Very odd.  Let me know if there is a fix in the pipeline.  

 

 

Ryan_M
Moderator

Summarize Payroll Data in Excel issue

Hi @Dan_Gott,

 

I appreciate you for joining the thread and sharing an update on your situation.

 

As my peers stated above, we have an investigation of this exact issue. If you haven't contacted our Technical Support team yet, please do so. They can add you to the list of affected users, and you'll receive an email notification whenever there's an update.

 

Here's how:

 

  1. On your QuickBooks homepage, go to the Help menu.
  2. Choose QuickBooks Desktop Help.
  3. Tap the Contact us button.

I suggest you view this article as well: Customize reports in QuickBooks Desktop. It has a detailed list of what you can edit with the reports of QuickBooks Desktop. 

 

Post a reply if there's anything else that I can assist you with. I'll be sure to get back to you. 

thebcdub
Level 1

Summarize Payroll Data in Excel issue

We also have a client with this issue. I am unable to comprehend that this issue still exists from January of 2019 in October of 2020. Please update me when this has been patched.

IamjuViel
QuickBooks Team

Summarize Payroll Data in Excel issue

I understand how much work this on-going concern with the payroll report had caused you, @thebcdub.

 

This is a reported issue. Currently, our Product Engineers are working diligently on an investigation to determine the root cause of this error and released a permanent resolution.

 

In the meantime, you can run the report from the previous quarters. Then, when asked to update select "yes" and it is able to pull all the data correctly. If that does not work clean install of QB and Excel are possible fixes. Here's how:

  1. Close QuickBooks.
  2. On your computer, go to your C Drive. Then 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, try opening the report again.

Also, I'd recommend contacting our Technical Support team so your client will be added to the affected user's list. Once updates are available, you'd be notified through an email. Just make sure to provide your name, updated email, and the investigation number INV-49928. 

 

Here's how you can contact us:

  1. Go to the Help menu.
  2. Choose QuickBooks Desktop Help.
  3. Click the Contact Us button.
  4. Enter a short description of your concerns under the Ask a question field.
  5. Click Continue.
  6. Select how'd you like to contact us:
    •  Get a callback
    • Start a chat.

Thank you for your patience while we're working on this. If you have any other questions, feel free to comment below. Have a great day.

Lisa galvin
Level 4

Summarize Payroll Data in Excel issue

Same problem here - has been happening for over a year - do not see why Intuit can't resolve this issue as well as other issues related to Excel (for example the Statement Writer only works with Excel 2013 or earlier).  This continuing lack of support and fixing of an issue that has been going on for so long is quite unacceptable.  The fixes do not now or have ever worked for me.  Cuts down on efficiency and quite honestly, if I could find a different accounting program that was easily accessible to clients I would do it.  As a ProAdvisor I am finding it difficult to recommend this product.   We really need better updating and compatibility with Microsoft.  Nothing like having customers be in the middle of issues between software giants.

bamado
Level 2

Summarize Payroll Data in Excel issue

Hi Lisa, I totally agree that it is unacceptable that there is no fix. However Big Red Consulting has a perfect work around that is very simple to apply.  Click on the link below.  See my earlier post and you'll see my reply and thank you to Big Red for solving this issue. 

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

 

Good Luck!

Beth

 

lfgordon9151
Level 2

Summarize Payroll Data in Excel issue

I was able to solve my problem by doing these steps:

 

  1. I went into EXCEL

File

Options

Trust Center

Trust Center Settings

Trusted Locations

Add new location

C:\Program Files (x86)\Intuit\QuickBooks Enterprise Solutions 20.0\Components\Templates\ 

Description: Quickbooks 20 Templates

Checked: Subfolders of this location are also trusted

OK

OK

 

 

Retry -    If still having issues, then use the Windows Programs "Repair Office" and then try again.

KLAINC
Level 2

Summarize Payroll Data in Excel issue

I have tried all suggestions to no avail.  I have been experiencing this same problem for well over a year; since we upgraded to Windows 10.  We have hired out IT company to and they were able to temporarily fix it with a macro to Excel but that does not work with the newer versions of Excel.

 

This has been a great disappointment to me and this can be a game changer if this issue does not get resolved.

KLAINC
Level 2

Summarize Payroll Data in Excel issue

I have tried all suggestions to no avail.  I have been experiencing this same problem for well over a year; since we upgraded to Windows 10.  We have hired out IT company to and they were able to temporarily fix it with a macro to Excel but that does not work with the newer versions of Excel.

 

This has been a great disappointment to me and can be a game changer if this issue does not get resolved.

IamjuViel
QuickBooks Team

Summarize Payroll Data in Excel issue

Hello, @KLAINC.

 

I understand the impact of any delay in resolving this on-going issue. Let me route you to the best available support so we can further assist you with generating the payroll report.

 

Since you already performed all the troubleshooting steps, I'd recommend contacting our Technical Support team. This way, you'd be added to the affected users' list. Once updates are available, you'd be notified through an email. Just make sure to provide your name, updated email, and the investigation number INV-49928. 

  1. Go to the Help menu.
  2. Choose QuickBooks Desktop Help.
  3. Click the Contact Us button.
  4. Enter a short description of your concerns under the Ask a question field.
  5. Click Continue.
  6. Select how'd you like to contact us:
    •  Get a callback
    • Start a chat.

You can refer to this article to learn more detailed information about the support we offer at Intuit and its availability: Support hours and types

 

I appreciate your patience while we're working on this. If you have any other questions, feel free to comment below. Have a great day.

soneill
Level 1

Summarize Payroll Data in Excel issue

I hope ALLLLLL QB people replying realize that reposting the same response with a pat on the back and we are working on it or call our team doesn't help people who are unimaginably frustrated that this doesn't work, QB support has no fixes and it is disrupting business. It makes Quickbooks sounds stupid and infuriates end users.

 

I have been put on the imaginary list and received nothing . . . the program is still broken and I'm still paying a TON of hard earned money for it, not to mentioned the money in my time and energy but our IT guy.

 

fix that.

cmccuddy
Level 1

Summarize Payroll Data in Excel issue

I honestly can't believe that they don't have this fixed yet. The fact that I am still required to use a workaround from a consulting company that resolved the issue in 2 hours, but Intuit can't figure it out is a joke. 

cmccuddy
Level 1

Summarize Payroll Data in Excel issue

It's pretty wild that we are STILL waiting on QuickBooks to fix this issue when Big Red Consulting was able to resolve it in under two hours. I am required to overwrite QuickBooks template file with Big Red's every time if I want to run this report. Get it together QuickBooks. There is literally a person in this thread that has resolved the issue. Contact him and pay the man to fix this for you. 

John_A_D
Level 3

Summarize Payroll Data in Excel issue

I am so disheartened with Intuit. This problem has been hear for YEARS and Big Red fixed it for free, in a few hours. Between this and the having to sign into Intuit to open a company file, updates that you can't seem to get turned off, etc. it is amazing we keep giving them our money. I do not know what they are doing with it but they are NOT improving QuickBooks with it..

plw1
Level 1

Summarize Payroll Data in Excel issue

I just want you to know that we contacted our IT guy today because I am thoroughly fed up with this issue and Quickbooks slow response to the issue.  We are using Office 365 Online.  Our Summarize Payroll in Excel did not work either.  I had another issue with my computer today and while he was resolving that issue, I mentioned this to him.  He said he thought he could take care of it.  He went into the computer and went into some of the Intuit files and was able to remedy the issue.  He stated that someone on a forum had discussed how to do it.  I have looked through the forums, but I don't see anything.  I am assuming, though, that any IT person would know about it.  If not, you may want to contact Wendell Wilson Consultinig, LLC in Richmond, KY and see if he can resolve your issue.  It was a 15 minute fix at the most.

plw1
Level 1

Summarize Payroll Data in Excel issue

My company has been going through this same issue.  I was speaking with my IT person today regarding a different issue and told him since they upgraded a couple of my computers to Office 365Online that our Summarize Payroll in Excel feature will not work properly.  While he was correcting my other issue he went in and resolved this issue.  I wish I could tell you what he did, but it was so quick that I could not catch it all.  It took him all of possibly 15 minutes.  

Maybe if you contact an IT person they may know what he did.  If not, please feel free to contact Wendell Wilson Consulting, LLC in Richmond, KY to see if they can help you.  I really hope they can because this is truly frustrating.

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

Need to get in touch?

Contact us