Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Limited time. 50% OFF QuickBooks for 3 months.
Buy now & saveI am trying to efile NC SUI reports. I have done this for years. I go through the process and when the excel file fills in there are no names or SSN in any of the columns and there is a very long list of amounts that have no bearing on the client file. This has occurred in both 2019 and 2020 versions of Accountant QB. We are (and have been) using Office 365 (locally installed). We filed the fourth quarter of 2020 with no issues. Further, when we summarize payroll in excel, on the state tab there used to be a working drop down menu to show SUTA, FUTA - now the default is extra medicare withholding (which is useless for most people I would think) and there is no drop down menu. This is really unacceptable. The integration between QB and Excel is getting worse. BTW - the statement writer will only work with Excel 2013 or older - another waste of time using an ancient laptop with that version on it. How to we fix this and why do I want to continue to be a ProAdvisor and recommend a product to my clients that does not work.
This isn’t what I want to you experience with QuickBooks, Lisa.
I'll make it up to you by making sure you'll be able to e-file your state SUI NC seamlessly
I recommend updating your QuickBooks Desktop (QBDT) and payroll tax table to the latest release. Outdated software can cause issues within your file resulting in poor performance. Updating it is the quick fix as this installs the latest features and fixes.
Let me walk you through the steps:
You can also check this link for more details: Update QuickBooks Desktop to the latest release.
Then to update your payroll tax table, you can refer to the steps provided in this article: Get the latest payroll tax table update.
If this is not the case, I suggest running the Verify Rebuild tool. This scans your company file for issues and resolves them right away.
Once everything is all set up, you can now efficiently E-file your state SUI NC.
You can always get back to me if you have other concerns filing your taxes. I’m always around ready to help.
Hi @Lisa galvin,
I appreciate you for getting back and providing a screenshot here in the Community. Let me share some updates about this unexpected behavior.
Currently, we're receiving reports from other users about an error when using Summarize Payroll Data in Excel feature. Rest assured that our product engineers are actively working to get this issue resolved.
In line with this, I'd suggest contacting our Customer Care Team. They can add your company to the list of affected users.
This ensures you're in the loop about the investigation's status and its fix. Our Customer Support Team for Basic, Enhanced or Standard Payroll is available from 6 AM - 6 PM PT (Monday - Friday) and any time, any day for Assisted Payroll.
Here's how you can reach them:
For future reference, I'm leaving the following articles which you can use to learn what to do if you exceed 65,536 detail lines for the Excel report export feature: Excel based payroll reports.
I'm always here to help if there's anything else you need regarding the payroll reports. Take care always, @Lisa galvin.
It has been about four years now and Intuit has still not fixed the issue. I'm sure they're still working hard on it as promised here multiple times.
A couple of years ago I decided to look at the issue and fixed it in a couple of hours, and then put the fix on our site. Recently I updated fixed it again for QuickBooks 2022 and Enterprise 22.0 because it has to be a different template for 64-bit QuickBooks versions.
You can download the fix from our site no charge. 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.
For more information visit our Security Center or to report suspicious websites you can contact us here