Showing results for 
Search instead for 
Did you mean: 
Level 2

State SUI xls Error

Background: Indiana SUI filer for multiple companies.


All company QB files while using the "Create State SUI E-file" return no names or SSN's on the Excel spreadsheet. Please advise.


Also, where do you enter the SOC codes for each employee in QB? I was not successful using the Payroll Setup as suggested on QB support site.



3 Comments 3
QuickBooks Team

State SUI xls Error

Hi @jgrooms5,


I'll share some steps you can take to resolve these issues you have with your QuickBooks Desktop (QBDT) Payroll. 


For any missing information on the SUI, I suggest you ensure you update your QBDT to the latest version. The same goes for your payroll tax table version. You can proceed to generate the Excel file again at this point. 


If the issue persists, see this article: Fix incorrect state unemployment (SUI) or withholding (SIT)


As for the SOC codes, follow the steps below:


  1. Go to the Employees menu.
  2. Select Payroll Setup.
  3. Choose Employee Setup, then Employee List.
  4. Pick an employee from the Review our Employee list window, then tap Edit.
  5. Hit Next, until you see the Setup occupational information window.
  6. Enter the appropriate Occupational code.
  7. When done, press Finish.

Drop a comment below if you have other questions about QBDT. I'll be sure to answer them for you. 

Level 2

State SUI xls Error

Thanks for all of the info. I was able to determine that the output I am receiving on the SUI report is in detail format (ie. multiple lines for each employee). Is there a setting to collapse this detail to a 1-line summary?


FYI, both QBDT & payroll tax table are on the most current versions.




QuickBooks Team

State SUI xls Error

Hello there, @jgrooms5.


Currently, the option to customize this specific report is unavailable. Although, you can run Payroll Summary or export the report to Excel and modify it from there.


Here's how to get the Payroll Summary report:


  1. Go to the Reports menu, then Employees and Payroll.
  2. Select Payroll Summary.
  3. Adjust the date range appropriately. 


I've added an article to know more about modifying reports in QuickBooks Desktop: Customize payroll and employee reports.


You may consider checking this reference page to help you with your year-end tasks: QuickBooks Desktop Year End Prep and Resources.


I'll be here if you have other questions or concerns. Let me know in the comment section below. Take care.

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us