Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowYes, it works, Julesp. I was able to export the Payroll Summary report to Excel.
Let's ensure your Excel is updated to meet the system requirements.
Check the articles about system requirements depending on your version:
If your Excel is updated, let's go ahead and export the report. Here's how:
If you need something else, please let us know. We're here to help you.
Actually those are the steps to run a report in quickbooks and then export it to Excel. What is not working is the "Summarize Payroll Data in Excel" drop down. It has not been working for a year now but QB has done nothing about it.
We're receiving reports that other users are getting an error as well, pipeman.
We would like to inform you that this has already been escalated to our engineering team. I’d encourage you to contact our phone agents and have them attach your case to INV-24874, so they can add your account information to the list of affected users. That way, our engineers can send you updates via email when they are available.
As a workaround, try 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. Once done, let's try to run Payroll Reports in Excel.
For more Excel-based reports, check out these resources:
I appreciate your patience while this is being worked on. Please know that I'm just a post away should you need anything else. Wishing you a wonderful week ahead.
It's been three years now. Still no fix from Intuit. I'm sure the "engineers are diligently work on it", though. Right? Sure.
If you're tired of waiting for a fix, see BRC Summarize Payroll Data In Excel – Fixed!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.