Creating State SUI E file

I have reported this problem on the regular phone help and was transferred also to your engineering department back in February 2019.  Both departments took over my screen and could not make the Excel spreadsheet work.  A "ticket" was submitted.

I do not have enhanced payroll.  I am in Georgia which is not one of the states with eFile listed.  To get SUI information before I upgraded to QB Pro 2019, all I had to do was summarize payroll data in Excel.  Under State Wage Listing tab, there was a dropdown menu where I could select SUI.  The drop down function is not there any more. 

For my 1st quarter 2019 report, I had to manually determine the figure for Excess Wages.  Do you have another work around I could use?

Thank you for taking the time posting in Community, @Ho. 

I'm here to help you create the State Wage Listing report to determine the Excess Wages. Let me guide you how:

1. From the Reports menu, select Employees & Payroll.
2. Choose Summarize Payroll Data in Excel.
3. Select the State Wage Listing tab. 
4. From the Payroll Item drop-down, select GA- Unemployment Company. 
5. Click OK. 

I've also attached an article and screenshot for additional reference: Excel-based payroll reports.

That should take care of it. I believe that you'll have the SUI excess wages information you need in just a few clicks.

Drop me a comment below if you have any other questions about QuickBooks. I'll be happy to help you out.

That's exactly the way I've gotten the data for SUI for many, many years.  With QB 2019, there is NO drop-down arrow to scroll down to SUI.  Neither your regular online help or the engineering department could get that drop-down menu to appear when they took over my screen.  I tried sending my file to our CPA to see if she could produce the SUI, but she had no drop-down menu either.

The only report I can get is the Medicare Additional Tax that it opens up with.  I don't have any use for that.  I'm sure it would take years to get a software change, but a work around the lack of the drop-down would be to have it open up with SUI.  It did that for years.

Please help solve this issue!  I shouldn't have to calculate excess wages by hand when I'm paying $670 a year for payroll!!

Thanks!

Thanks for letting me know about this, @Ho.

Allow me to share some clarifications about the missing drop-down menu in the State Wage Listing tab when exporting a report to Excel. 

I've tried pulling this report on my end using Microsoft Excel 2010, and the drop-down menu comes up. For now, you can try checking out your Excel version if it meets the QuickBooks Desktop system requirements. 

If it meets the requirements, I'd suggest reaching out to your IT professional for further assistance. This way they'll be able to check the functionality of your excel or may roll back some updates. If there's no identified problem on your Excel, you may contact Microsoft directly so they can further investigate what's causing the issue. 

Keep me posted if you have any other questions about this concern. I want to make sure you're taken care of. Have a good one!

I simply want to know if Quickbooks 2019 supports Louisiana... Can I create a file in excel and upload... I used to be able to do this, but my 2017 version says Louisiana (obsolete) when I try to retrieve the data... PLEASE LET ME KNOW before I purchase Quickbooks 2019...

Thanks for taking the time to visit the Community, NLPCA.

QuickBooks supports processing payroll, filing tax forms, and paying taxes for the state of Louisiana. However, creating an Excel for the SUI is unavailable at this time.

When filing the tax return, you’ll have to process it electronically.

Additionally, the Louisiana Payroll Tax Compliance article provides more details about tax forms, withholdings, unemployment, and other tax. To learn more about the employer filing requirements for your state, just choose Unemployment Tax and proceed directly to the Tax Payment Frequency Detail section. 

Stay in touch if you have any clarifications for concerns while working in QuickBooks. I’ll get back to you as soon as possible to help. Have a great rest of your day.

How do I process electronically from quickbooks?  Will quickbooks generate the report?  

It's nice to hear from you again, @NLPCA.

I can share with you the details on how you can submit your SUI forms to your agency and what is the process to be made in QuickBooks to make this possible.

QuickBooks will generate a report for you so you'll be able to gather all SUI details. After that, you can submit the forms straight to your agency's website.

Below are the steps that you'll need to perform. Let's start with creating the SUI file.

Here's how:

1. From the Employees menu, select Payroll Tax Forms and W-2s, and select Create State SUI E-file.
2. In the Welcome window, select Continue.
3. In the QuickBooks Payroll State SUI File window, select Continue.
4. Select your state from the Select State drop-down list.
5. Select Get QuickBooks Data.
6. In the QuickBooks Payroll State SUI E-file - Updated window, select OK.
7. Make any corrections to any errors or add missing information into the file. On the Add-Ins tab, locate the QuickBooks Payroll State SUI E-file drop-down arrow, and select Start Interview.
8. Select the I understand that I must review my data and answer the following questions option and click Next.
9. Note that the file name and location. This is the file you send to the state. It is critical that you accurately note the file name and location for this file.
10. Select Next. 

Right after, answer the questions and verify any auto-populated information on the screen. Then, select Next until you reach the End of Interview window, and the Create State File. In the State File Created prompt, choose OK.

Once done, you can now submit the file that you made to your state. You'll need to log into the Louisiana Internet Wage & Tax Reporting Website and follow the submission instructions from there.

Here's a link that you can visit, for complete details about these procedures: E-file or submit state unemployment filings.

For additional insights about filing forms with QuickBooks, please see these links:

• Louisiana Payroll Tax Compliance
• E-file state forms & e-pay state taxes separately
• Louisiana state W-2 e-file help

Lastly, if you need further help with these steps, you can reach out to our Customer Care Team. They have tools that can walk you through with this matter.

I want to ensure that this gets taken care of for you, so please feel free to update me by posting a comment below. Cheering you to continued success in all of your endeavors.

I don't think this has been updated to work with Louisiana since 2014. Shows Obsolete

It looks like you get the same thing after following the steps provided by my colleague, David-B. 

With this I suggest reaching out to our Customer Support Team so they'd further look into why updates aren't showing. To reach them:

1. Click the Help menu.
2. Select QuickBooks Desktop Help. 
3. Click the Contact us link.
4. Enter a brief description about the updated Louisiana SUI form. 
5. Click Continue. 
6. Choose to either Message an agent or Talk to a Specialist. 

Always know the Community is around to help you if you have further questions.

I am in total agreement - once I updated to Windows 10, I can no longer get the drop down menu to work for state wages either.  I am now trying to e-file my NC state SUI report and when I do the export there is no employee name, SSN on the excel file that is created and the amounts are per paycheck, not for the quarter.  This is really unacceptable.  Intuit needs to coordinate with Office 365 - not only do I need to waste time with this on payroll, but the statement writer only works with Excel 2013!  Why am I paying to be a ProAdvisor when I can't get what I need?  If I find another accounting program that I could suggest to my clients to use, I would, this is getting very difficult to handle. 

Your link for Desktop requirements does not work.  In any case, it is 2019, why would we be using a 2010 version of QB, or a 2013 version!  In the technology world we live in that is from the dark ages.  Intuit requires us to update every three years to get payroll and continued support, yet you don't keep updated.

Not a good practice.

Hello there, Lisa galvin. 

For now, QuickBooks is still integrating Office 365 if you're using it through cloud. I suggest installing the program in your computer so it can work with QuickBooks Desktop. 

Also, I have attached articles with regards to our system requirements:

• System requirements for QuickBooks 2019 and Enterprise Solutions 19.0
• System requirements for QuickBooks 2020 and Enterprise Solutions 20.0
•  

You can always drop by the Community if you need anything else. 

This does not work if you are from Nebraska.  I had to go tot he Calculated % and scroll to the Nebraska Unemployment.  Under the Payroll item tab, there is no drop down menu to choose from. 

Any Help with South Carolina Reporting?

Glad to have you here in the Community, @dempseykev.

At this time, submitting your SUI forms for South Carolina isn't available.

The South Carolina agency is updating its website portal for filing and now requires Corporate Officer data that is not available in QuickBooks Desktop's payroll data records.

The agency filing designations ask whether the employee is a Corporate Officer for Corporate Officers not registered as exempt (exempt Corporate Officers are not reported on the wage lists). The payroll data does not record the Corporate Officer status registered with the state agency, and the file will be rejected if this data is incorrect.

Accordingly, you can file directly with the state agency. Employers with least than 100 employees can file by paper, but the agency prefers you to file on their new website, https://www.scbos.sc.gov/

For more information, you can read through the article: E-file or submit state unemployment filings.

You might want to check out these articles to learn more about filing forms in QuickBooks Desktop: 

• South Carolina state W-2 e-file help.
• E-file state forms & e-pay state taxes separately.

Please keep in touch if there's anything else I can do to help you succeed with QuickBooks. I've got your back. Have a great day and keep safe.

is there a way to do this on the Online version? How can I set it up to submit my unemployment tax automatically?

Thank you for joining the thread, @otisbane.

I'm glad to share some insights about paying and filing taxes in QuickBooks Online (QBO).

Usually, Intuit submits your payroll taxes and forms automatically with the Full-Service versions of payroll. This is to ensure your business processes taxes on time. For the enhanced version for QBO, you can either file/pay your taxes manually or electronically.

With regards to the State Unemployment Taxes (SUI), you can locate your state from our Payroll Tax Compliance Links and review the supported filing method under the Unemployment Tax section.

You can as well check out this link to learn more on how to easily file and pay taxes to the federal and state agency using the E-File & Pay feature in your Online Payroll.

If you have any other QuickBooks or payroll questions, please let me know by adding a comment below. I'm more than happy to help. Keep safe!

Why can I no longer create the Illinois SUI Efile for my monthly upload?  It just worked last week.  When I go thru the normal steps, it states that Illinois no longer supports this.  Why would they stop it in the middle of a quarter?

Hello there, @jane56.

This e-filing service is available for employers that report for 25 or more employees. Have you made any edits on the previous year's payroll that may have caused the eligibility for the quarterly reporting to be removed?

If you have in fact reported for 25 or more employees, you'll want to reach out to QuickBooks Support to investigate further.

Check out this article on getting in touch with our team: Contact QuickBooks products and services Support.

Let me know if you have additional questions on this, I'm here to help! 

The new release 1.23 that we just did yesterday shows where it disabled SUI filing for Illinois.  I process payroll for several different clients and have encountered this same issue.  

 Hello there, @Pam1964.

Since you're having the same issue where the SUI filing for Illinois is disabled, I'd suggest reaching out to our Customer Support Team. They have tools such as screen-sharing that can double-check why it's happening and able to create an investigation ticket.

Here's how to reach them:

1. Go to Help.
2. Select QuickBooks Desktop Help.
3. Click Contact Us.
4. Enter QuickBooks Crashes in the Tell us more about your question: field.
5. Select Search.
6. Click Start a Message.

In the meantime, you have an option to create a file and manually upload it to the state. Let me guide you how: 

1. From the Employees menu, choose Payroll Tax Forms and W-2s.
2. Select Create State SUI E-file. 
3. Hit Continue in the Welcome and QuickBooks Payroll State SUI File window. 
4. Pick Illinois in the drop-down arrow. 
5. Elect Get QuickBooks Data.
6. Review the information and choose  QuickBooks Payroll State SUI E-file drop-down arrow in the Add-Ins tab. 
7. Hit Start Interview. 
8. Hit the I understand that I must review my data and answer the following questions and tap Next.
9. Enter a file name and hit Next. 
10. Answer the various questions and click Next until the End of the Interview. 
11. Click OK in the State file Created. 
12. Tap Yes in the Save Workbook. 

Once done, go to the Illinois website to get the registration instructions. For complete details, you may refer to this article: E-file or submit state unemployment filings.

You can also check out this article to be updated with the latest tax information for Illinois: Illinois Payroll Tax Compliance.

Stay in touch if you have any other questions. I'll be happy to help you out. 

In a recent release 1.23 It disabled SUI filing for IL, so when you do the above steps it will not work as IL is no longer supported when using that feature.  What report can I run that will give me social security #'s , First, Last Name and Gross Wage for a specific month, (Nov) , if we can get that in excel file we can manually upload that to IL.