Question

Illinois monthly unemployment csv reporting

Forum|Forum|5 years ago
December 19, 2020
8 replies
54 views

How can we file monthly Illinois unemployment reports in csv format. Looks like it is not supported in latest update to QuickBooks Desktop 2021?

MichelleBh

Level 8

Hi there, @Fred35.

The monthly Illinois unemployment reports in CSV format is still supported in QuickBooks Desktop (QBDT). I'll share the steps on how to get and file the said report.

But before doing that, ensure that your payroll tax table is on the 22101 to 22016 date released. So you're able to generate the report. For more details, check out this article: Latest payroll news and updates.

Once verified, you can follow the steps below.

Go to the Employees menu at the top.
Choose Payroll Tax Forms and W-2s.
Select Process Payroll Forms.
Locate the form or report and follow the on-screen instructions.

But if you're unable to submit it in the system, you have an option to create a file, then manually upload it to the state. Let me guide you how:

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

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

Also, if the issue persists, I'd suggest communicating with our QuickBooks expert. They have tools to access your account in a safe atmosphere and investigate the root cause.

Here's how:

Go to this link: https://help.quickbooks.intuit.com/prechats/offerings/QB-Desktop-ProPremier-CHAT/22240/view.
Complete the required details.
Hit Submit.

Please make sure to contact our support within business hours to address your concern promptly.

Additionally, please browse through these articles about taxes and state compliance.

Let me know if you have another concern by clicking the Reply button. I'm always here for you. Keep safe!

F

fba_

None of this works. It is not listed under forms at all and if you try and create State SUI file it says (Not Available) for Illinois. If you try and do it anyways it say, "IMPORTANT: Illinois is no longer supported when using this feature." It won't allow me to go any further. When I close the window it asks me for a "QBPayrollStateEFile Password" which I have to cancel out of. I have the newest payroll update and am still on 2020 desktop version.

S

strubedoo

I am on with support currently with the same issue!

B

burresscpa2

When is the monthly report to send to Illinois SUI going to be fixed? It was disabled with the

release 1.23 and can not be filed. Employers will over 25 employees have to file this report the

first two months of each quarter and time is running out to file the November report on time. There is a fine for not doing this on time, so is Intuit going to reimbursement my client for the fine? MyTaxIllinois does not allow me to manually go in and type the information it has to be imported using a cvs file which Intuit did provide until some programmer deleted it.

MaryLurleenM

Level 6

We're unable to provide details on when this will be resolved, burresscpa2.

For now, you can manually create the CSV file to upload on your state's website. You can run the Payroll Summary report and use it as a reference in creating the data you need.

Here's how:

Select Reports, then Employees and Payroll.
Select Payroll Summary.
Adjust the date range appropriately.

To run more reports in QuickBooks Desktop, see: Customize payroll and employee reports.

Let me know if you have other questions.

M

mblake9278

Well this is just ridiculous intuit. Intuit customer service is useless!

B

burresscpa2

I am having the same problem and after sending an email to MyTaxHelp I got a response from

them telling me to contact IDES at 800-247-4984 or email at [email address removed] and request an extension until Intuit fixes this mess. I would advise emailing and explaining that a CSV file format can not be created for November because of an Intuit programmers error. Good luck, I am hoping this will work.

BigRedConsulting

Level 15

@burresscpa2

Or you could use my solution, posted on this thread, which is to use the prior release of the feature that still works fine.

Here's the link again: Illinois State SUI Fix « Big Red Consulting

J

justjim

to make things even easier navigate yourself to the following folder (replace the Quickbooks reference with your version)

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

find the State_SUI.xlt file at the bottom

rename State_SUI.xlt to State_SUI v1-23.xlt

now copy the referenced ver 1.22 State_SUI.xlt file from the .zip file and paste it in the above directory.

close file manager

in QuickBooks you may now select "Create State SUI E-file just as you had done previously.

BE SURE TO CHECK THE ACCURACY of the data as our data has not matched the Employee Earnings Summary reports generated within QB, you can change the individual row information prior to saving the .csv file.

Hope this helps - i cant post the zip file so go back up in the thread and find the solution by Big Red Consulting and download that zip file then follow my instructions above

Here's the link again: Illinois State SUI Fix « Big Red Consulting

I just finished filings for 9 companies and it worked perfectly

T

tchconstruction1

Has anyone solved this issue yet? I am having the same problem.

MarsStephanieL

Level 6

Hello there, @tchconstruction1.

You may convert the report to a .CSV file after exporting the report into an Excel file. Then, you can file it through the Illinois Tax Net web application. I'll show you the way on how to do that.

Go to the Reports menu, then Employees and Payroll.
Select Payroll Summary.
Set up the date range, or customize it according to your needs.
Click the Export button and choose Create New Worksheet.
Save the file to the location that is easy to find such as the Desktop or Downloads folder.

Once done, the Excel program will open. You may refer to the steps to see how to convert excel file to CSV.

In the Excel spreadsheet, go to the File menu and select Save as.
Set up the File type to CSV (Comma delimited).
Save this file to the area where it's easy to locate. This is how it looks like:

Once done, you can check out this reference page to know more about the Illinois State Form Filing: Monthly Wage Reporting.

I've added this article about modifying your reports in QuickBooks Desktop: Customize payroll and employee reports.

You may also speak to one of our Customer Care Team if you need further assistance about the process. They can perform a screen share and help you get to the bottom of this.

I'll be around if you have other questions. Don't hesitate to let me know in the comment section, It would be my pleasure to help. Take care.

B

bbroyster

This is completely unacceptable. Quickbooks needs to fix this issue and restore the ability to create the mandatory State SUI E-file for Illinois!!!

J

jstabler

Here we are in February and this is clearly still a problem. I just sent 45 minutes on chat in order to be told that as a Basic user, I should never have had access to this report in the first place. This is after the first 15 minutes, where she kept trying to get me to buy a different version of QuickBooks. I want the one we paid for to work.

Has anyone gotten a better answer since this topic was first posted?

J

JeanneI

I spent 2 hours with customer service reps yesterday. In the end, they admitted that this functionality was removed for Illinois, but could not find any documentation or information as to why it was done. I work for two different employers, one running Desktop Pro and one running Desktop Enterprise. Don't let anyone tell you that upgrading to a more expensive version will get you the functionality back. At the end, the support agent agreed to submit feedback for me and I submitted feedback myself.

I think that the change was made after the majority of people already filed their November CSV file, so Intuit has been dismissing those who complained as people who don't know what they are doing. I'm thinking that every user in Illinois is going to have to call support in order for them to actually look into why they made this mistake and then rectify the problem.

M

mtaylor15

I can't believe this still hasn't been fixed / addressed or whatever they plan to do with this. I have a client with 100s of employees and don't want to have to create my own file each month. I'm also shocked that you still can't just submit directly from QBD. You're able to with the quarterly report.

For now I just create the Tax Forms Worksheet for IL for Last Month and then copy and past what I need to new Excel and save as a CSV. It's not the best for efficiency, but I guess it's better than nothing.

Please fix this Intuit!!

F

Fevief

I can attest that the file that Big Red Consulting shared worked exactly the way it always works via QB and it could not have been any easier to use. Sorry, not sure how to map this directly to the entry so I copied and pasted.

@burresscpa2 @Fred35 @strubedoo

Here's a solution: Illinois State SUI Fix « Big Red Consulting

Jessica_young

Level 4

Hello all!

Thank you for your patience while we investigated this issue. In the latest QuickBooks build, the SUI filing process was upgraded so that it no longer requires the CSV. To access filing now:

From the Payroll Center go to the file forms tab.
Scroll down and select UI-3/40-Employers Contribution and Wage Report.

Please let me know if you run into any snags when filing for Illinois. We'll be on standby to help with any questions!

R

rascomasonry

I am on right networks and cannot use the Big Red Consulting fix since I cannot download onto their network. This MUST be fixed this month or I will be fined for not uploading this file. If anything, I rather go back to an earlier version where it is still working! PLEASE FIX THIS!

W

WM6140

This is not acceptable in any way. QB support team is about as useful as a white crayon at this point. Not one single time have they been able to fix an issue and by the looks of it I'm not alone. I'm not looking for a third party to generate what QB should generate. This has been a requirement in Illinois for quite some time now. Nothing new.

Please describe what actions are being taken and when this will be resolved! This is absolutely ridiculous. Another due date is approaching.

C

campshaw1

Agreed, not acceptable at all!!! We are a small non-profit camp and could not operate in 2020 - it makes it very hard to justify what we pay for Quickbooks on a yearly basis when we are unable to use a feature which has been available and required for quite a long time. Waiting impatiently for a solution.

Sign up

Login with SSO

Let's get you signed in

Login with SSO